object_name for p1,p2 from ash report.
eg:-
select
segment_name,
segment_type
from
dba_extents
where
file_id = 5228121616
and
122 between
block_id and block_id + blocks – 1;
This gives me no rows selected. How can i come to know what object is causing 21% latch:cache buffer chains in my database.
Pls advice.
Top Event P1/P2/P3 Values
-
Event% EventP1 Value, P2 Value, P3 Value% ActivityParameter 1Parameter 2Parameter 3
latch free24.95"1610761560","264","0"24.32addressnumbertries
latch: cache buffers chains20.82"5228121616","122","0"12.02addressnumbertries
"5231665816","122","0"2.15
"5232622016","122","0"1.34
latch: shared pool5.92"1611558928","213","0"2.91addressnumbertries
"1611559088","213","0"2.86
latch: row cache objects3.65"5101607408","199","0"3.47addressnumbertries
latch: library cache1.63"5090743936","214","0"0.80addressnumbertries