RE: How to find v$session_wait object names ?

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Wed, 23 Aug 2000 09:20:22 +1000
Message-Id: <10597.115307@fatcity.com>

Hi Chiappa,

I've been joining V$SESSION_WAIT to DBA_EXTENTS since Oracle 7.0. In fact, there are several scripts on my web site that illustrate how to do it.
Please forgive me. I did not realize that it was wrong. ;-)

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/

-----Original Message-----
From: J. Laurindo Chiappa [mailto:jlchiappa_at_uol.com.br] Sent: Wednesday, 23 August 2000 9:00
To: DBAs - TeleLists; LazyDBA/Quickdocs -; Lista DBA em Portugues; ODTUG Oracle DBA List; Oracle-Linux; VOUG - DBAs Virginia Subject: How to find v$session_wait object names ?

Hi, I'm trying to write a query to find the name of the objets related in the v$session_wait view. Searching in the P1, P2 and P3 raw columns I can say : SID x is waiting for the block Y in the file Z; how to find the name of the object ? And the session lockinh the object ? More seasoned DBAs tell me it's a matter of joining with the dba_extents, but it'ss plain wrong - this view don't have the necessary columns.
Some ideas to share ?

[]s

Chiappa

If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
to unsubscribe, send a blank email to
oracledba-unsubscribe_at_quickdoc.co.uk
to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk Received on Tue Aug 22 2000 - 18:20:22 CDT