Row cache Lock on DC_USERS
Can some one explain what is actually Row cache Lock on DC_USERS is,
During the session execution i noticed the waitevent as Row cache lock which is frequently getting blocked by another session (this generates every few secs and then expires) doing nothing with a waitevent(Cursor:pins s wait on X) ,
SQL> select PARAMETER ,COUNT ,GETS ,GETMISSES ,MODIFICATIONS from v$rowcache whe
re cache#=7;
PARAMETER COUNT GETS GETMISSES MODIFICATIONS
-------------------------------- ---------- ---------- ---------- -------------
dc_users 102 4687 361 0
dc_users 333 93574 918 0
dc_users 0 0 0 0
i just need an explanation on what actions we need to take if we see high count in (Row cache Lock on DC_USERS),
0