'latch: row cache objects'

lanseguhun

1.db=11.2.0.4.4
2.测试发现数据库大量'latch: row cache objects' 等待事件
3.parse阶段等待还能理解，但是为什么在执行时候，执行后也会存在这个等待？
=====================
PARSING IN CURSOR #11529215044981970680 len=88 dep=0 uid=88 oct=3 lid=88 tim=176938452745 hv=2317429255 ad='c00000207fd49450' sqlid='f4wv3j2522ah7'
select rule_id from BS_SERVICERULE_REL where service_name='s3864Qry' order by rule_order
END OF STMT
PARSE #11529215044981970680:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=802526088,tim=176938452743
EXEC #11529215044981970680:c=0,e=101,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=802526088,tim=176938452909
WAIT #11529215044981970680: nam='SQL*Net message to client' ela= 2 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=176938452949
FETCH #11529215044981970680:c=0,e=85,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=1,plh=802526088,tim=176938453059
WAIT #11529215044981970680: nam='SQL*Net message from client' ela= 604 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=176938453721
STAT #11529215044981970680 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=3 pr=0 pw=0 time=87 us cost=4 size=75 card=3)'
STAT #11529215044981970680 id=2 cnt=2 pid=1 pos=1 obj=92311 op='TABLE ACCESS FULL BS_SERVICERULE_REL (cr=3 pr=0 pw=0 time=51 us cost=3 size=75 card=3)'
CLOSE #11529215044981970680:c=0,e=84,dep=0,type=1,tim=176938453889
WAIT #11529215044979066000: nam='latch: row cache objects' ela= 42 address=13835058192656840664 number=309 tries=0 obj#=-1 tim=176938454272

lanseguhun

PARSING IN CURSOR #11529215044979067888 len=254 dep=0 uid=88 oct=3 lid=88 tim=176950492855 hv=1325595600 ad='c00000208fc116e0' sqlid='0d3fzst7h5yyh'
SELECT A.LOGIN_NO,A.POPEDOM_CODE,A.FAVOUR_RATE,A.AUTH_REASON FROM BS_LOGINPOPEDOM_REL A,BS_POPEDOM_DICT B  WHERE A.POPEDOM_CODE=B.POPEDOM_CODE AND B.POPEDOM_TYPE='05'  AND B.USE_FLAG='Y'  and a.BEGIN_DATE<=sysdate AND END_DATE>=SYSDATE AND RELA_TYPE='1'
END OF STMT
PARSE #11529215044979067888:c=0,e=53,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=3259699927,tim=176950492853
EXEC #11529215044979067888:c=0,e=53,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=3259699927,tim=176950493005
WAIT #11529215044979067888: nam='SQL*Net message to client' ela= 2 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=176950493059
WAIT #11529215044979067888: nam='latch: row cache objects' ela= 2976 address=13835058192656840664 number=309 tries=0 obj#=-1 tim=176950496222
WAIT #11529215044979067888: nam='latch: row cache objects' ela= 49 address=13835058192656840664 number=309 tries=0 obj#=-1 tim=176950496432
FETCH #11529215044979067888:c=0,e=9763,p=0,cr=36,cu=0,mis=0,r=1,dep=0,og=1,plh=3259699927,tim=176950502872
WAIT #11529215044979067888: nam='SQL*Net message from client' ela= 740 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=176950503779
STAT #11529215044979067888 id=1 cnt=1 pid=0 pos=1 obj=0 op='HASH JOIN  (cr=36 pr=0 pw=0 time=9750 us cost=56 size=134838 card=2497)'
STAT #11529215044979067888 id=2 cnt=1698 pid=1 pos=1 obj=92258 op='TABLE ACCESS BY INDEX ROWID BS_POPEDOM_DICT (cr=17 pr=0 pw=0 time=10375 us cost=6 size=2400 card=240)'
STAT #11529215044979067888 id=3 cnt=1699 pid=2 pos=1 obj=92846 op='INDEX RANGE SCAN IDX_BS_POPEDOM_POPEDOM_TYPE (cr=5 pr=0 pw=0 time=4040 us cost=1 size=0 card=480)'
STAT #11529215044979067888 id=4 cnt=4 pid=1 pos=2 obj=92269 op='TABLE ACCESS FULL BS_LOGINPOPEDOM_REL (cr=19 pr=0 pw=0 time=70 us cost=50 size=306636 card=6969)'
CLOSE #11529215044979067888:c=0,e=257,dep=0,type=1,tim=176950504112
=====================

Maclean Liu(刘相兵

看到的2个游标

PARSING IN CURSOR #11529215044981970680 len=88 dep=0 uid=88 oct=3 lid=88 tim=176938452745 hv=2317429255 ad='c00000207fd49450' sqlid='f4wv3j2522ah7'
select rule_id from BS_SERVICERULE_REL where service_name='s3864Qry' order by rule_order


PARSING IN CURSOR #11529215044979067888 len=254 dep=0 uid=88 oct=3 lid=88 tim=176950492855 hv=1325595600 ad='c00000208fc116e0' sqlid='0d3fzst7h5yyh'
SELECT A.LOGIN_NO,A.POPEDOM_CODE,A.FAVOUR_RATE,A.AUTH_REASON FROM BS_LOGINPOPEDOM_REL A,BS_POPEDOM_DICT B  WHERE A.POPEDOM_CODE=B.POPEDOM_CODE AND B.POPEDOM_TYPE='05'  AND B.USE_FLAG='Y'  and a.BEGIN_DATE<=sysdate AND END_DATE>=SYSDATE AND RELA_TYPE='1'


一个是 11529215044981970680 和 11529215044979067888


对应等待的是11529215044979066000

Maclean Liu(刘相兵

此类问题至少上传完整的10046 trace