| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to find v$session_wait object names ?
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
 |
 |