How to map v$session

From: Bass Chorng <bass_at_octel.com>
Date: 1997/07/02
Message-ID: <5pedhb$7uk$1@news.eng.octel.com>#1/1

Does anybody know how to relate column p2 of v$session_wait ? I know p2 points to an object when p2text shows 'BLOCK#' and event like 'db file%' - just like p1 maps to file_id of dba_data_files.

I tried to map p2 to dba_extents but it does not seem to match either the block_id or extent_id there. Nor could I find any close relation to dba_segments.

This relation is essential to find out
which object is currently being accessed by whom. And I am sure there is a way to map it.

Thanks for any input.

-Bass Chorng
Octel Communications Received on Wed Jul 02 1997 - 00:00:00 CDT

How to map v$session_wait ?