This error is received when trying to import a Data Pump export of the 12c r2 database to a lower version. The error content is …

With Compound Operators, we can make operations on variables more easily. For example, let’s assume that @a is a variable and we want to increase …

Index quality is a factor that directly affects all database performance. The quality of an index is measured by the rate of clustering_factor / num_rows. …

With User Defined Table Type, we can store the structure of a table. We can use the User Defined Table Typies by defining the table-valued …

If Tuning and Diagnostic Packs is installed, automatic snapshots can be created with AWR and we can get information about the database performance among the …

The Query Store is a feature that introduced in SQL Server 2016. In order to understand the Query Store, it is necessary to understand the …

OutOfMemoryError error may be received because of inadequate memory when running addnode.sh or during Oracle database installation. addnode.sh is terminated as follows when the error …

Database Engine Tuning Advisor (DTA) examines how queries are running in the database and provides us with suggestions. It has its own interface. You can …

When connecting to Oracle 12.2 databases from different databases with db link, reco process terminates unexpectedly. This problem is caused by bug 27544973. In order …

With SQL Server 2008, we can now easily uninstall Service Packs and Cumulative Updates from Control Panel, Programs and Features. Especially in case of a …