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.<\/p>\n
In order to solve the problem, either the DML statistics collection must be disabled or the scm0 process should be stopped and restarted automatically.<\/p>\n
You can stop the DML statistics collection by setting the value “_dlm_stats_collect” to 0 (zero).<\/p>\n
SQL> alter system set \"_dlm_stats_collect\" = 0 scope = spfile sid = '*';<\/pre>\nYou can see the current value of the parameter as follows.<\/p>\n
SQL> select * from (\nselect x.ksppinm param, y.ksppstvl value\nfrom x$ksppi x , x$ksppcv y\nwhere x.indx = y.indx\nand x.ksppinm like '\\_%' escape '\\'\norder by x.ksppinm\n) where param ='_dlm_stats_collect'; 2 3 4 5 6 7\n\nPARAM\n--------------------------------------------------------------------------------\nVALUE\n--------------------------------------------------------------------------------\n_dlm_stats_collect\n1<\/pre>\nThe parameter change requires the database to be restarted.<\/p>\n
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.<\/p>\n
[root@orcldb01 ~]# ps -ef|grep scm\noracle 112092 1 0 May22 ? 00:02:28 ora_scm0_ORCL1<\/pre>\n[root@orcldb01 ~]# kill -9 112092<\/pre>\n\n<\/div>\n