How can I find a segment name from p1 and p2 value of v$session??
510293Oct 3 2007 — edited Oct 4 2007Hi, all.
A session is waiting with "gc cr request".
The pvalue of the session are as followings.
---------------------------------------------------------
p1text p1 p2text p2 p3text p3
---------------------------------------------------------
file# 15 block# 412 id# 33619969
---------------------------------------------------------
I issued the following sql statement to find the segment name.
select segment_name
from dba_extents
where file_id = 15
and 412 between block_id and (block_id + blocks -1)
/
However, No row returned.
Is there any mistake??
Thanks and Regards.