ORACLE

  The “Cursor Mutex S” wait event occurs when two different sessions try to make hard or soft parsing on the same query. As a …

  The global cache service (LMSn) processes copy consistent copies of blocks in the buffer cache to the requesting instance’s foregound process. LMS also performs …

To configure Automatic Memory Management(AMM) in databases that do not use AMM, it is necessary to change the required parameters and restart the database. When …

  It is possible to find the privileges granted to a user with the data dictionary views. The main views that can be used are …

  We can set a parameter in the Oracle database to its default value. The reset process is only performed in the spfile. The parameter …

  During the insert operation to the tables, ORA-600 [ktspfhsp-9] error is received due to various bugs and corruption in the segments of the table. …

  Partitioned table cannot be moved like a normal table. Therefore, partitions need to be moved separately. In order to prevent the table from creating …

  During the drop operation of the event records on the Exadata cell node, when we try to delete individual records created for the problem, …

  Events that are automatically recorded when a problem occurs on the Exadata cell node must be cleared when the problem is corrected. The cleaning …

  After installing Oracle clusterware, we often ask the following question. What is my Oracle Cluster Name? In RAC systems, we can query the cluster …