SCM0 process Consumes High CPU in 12.2 RAC Databases

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 service (GCS). This process works if DLM statistics collection is enabled in a database.

In order to solve the problem, either the DML statistics collection must be disabled or the scm0 process should be stopped and restarted automatically.

You can stop the DML statistics collection by setting the value “_dlm_stats_collect” to 0 (zero).

You can see the current value of the parameter as follows.

The parameter change requires the database to be restarted.

Another way is to determine the process ID of the relevant scm0 process and to terminate it with kill -9. The process will restart automatically after it is killed.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *