|
select hladdr,
obj,
b.sid,
b.sql_id,
(select object_name
from dba_objects
where (data_object_id is null and object_id = x.obj)
or data_object_id = x.obj
and rownum = 1) as object_name,
dbarfil,
dbablk,
tch,
TIM
from x$bh x,
(select P1RAW, sql_id, sid
from v$session
where wait_class <> 'Idle'
and event = 'latch: cache buffers chains') b
where HLADDR = b.p1raw
order by tch desc; |
|