16 lines
633 B
SQL
16 lines
633 B
SQL
select
|
|
la.addr laaddr,dc.kqrstcid CACHE#, dc.kqrsttxt PARAMETER,
|
|
decode(dc.kqrsttyp, 1,'PARENT','SUBORDINATE') type,
|
|
decode(dc.kqrsttyp, 2, kqrstsno, null) subordinate#,
|
|
dc.kqrstgrq rcgets, dc.kqrstgmi rcmisses, dc.kqrstmrq rcmodifications,
|
|
dc.kqrstmfl rcflushes, dc.kqrstcln,
|
|
la.gets lagets, la.misses lamisses, la.immediate_gets laimge
|
|
from
|
|
x$kqrst dc
|
|
, v$latch_children la
|
|
where
|
|
dc.inst_id = userenv('instance')
|
|
and la.child# = dc.kqrstcln
|
|
and la.name = 'row cache objects'
|
|
and la.ADDR like '%33A1E7330'; <==== change the latch address to hex value of p1 for latch: row cache objects event
|