ORACLE

The following query can be used to determine the memory usage rates in Oracle databases. If there is an increase in the memory values ​​from …

In Oracle, you can find the open cursors with the following query. The following error occurs when the number of open cursors reaches the open_cursors …

The following queries can be used to determine when materialized views were last refreshed. For all times: [crayon-67d3890db5706328567437/] For a specific time interval: [crayon-67d3890db570a260557562/] or …

On Exadata database servers, it is also possible to set thresholds for metrics and send notifications when they reach these threshold values. With DBMCLI, we …

DBMCLI is the command-line management tool used for the Exadata storage server to configure Exadata database servers and manage objects in the server environment. With …

When a new griddisk is created over the celldisk, this error is received in the images before the 11.2.3.2 image version. This error can occur …

Hardware issues that occur in the Exadata db node and cell nodes need to be manually detected and cleaned in some cases. Even in temporary …

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 …