ORACLE

The DLM Statistics Collection and Management slave (SCM0) background process is responsible for collecting and managing statistics on global enqueue service (GES) and global cache …

The process is terminated as follows when running expdp in 12C databases. ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [ORA-04063: view “SYS.KU$_RADM_FPTM_VIEW” has errors The …

When an object is incorrectly compiled, it is necessary to determine what this error is and to correct the error. You can view this error …

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 …

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. …

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 …

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 …

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 …

Prior to the Oracle 12c version, droping an index was an offline process that put a lock on the original table in exclusive mode. Exclusive …

We often need to get information about existing sessions in databases. We can find the below details with the help of the following query. Which …