Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to find v$session_wait object names ?

RE: How to find v$session_wait object names ?

From: VIVEK_SHARMA <vivek_sharma_at_inf.com>
Date: Wed, 23 Aug 2000 09:45:10 +0530
Message-Id: <10597.115314@fatcity.com>


The name of one script please ?

> -----Original Message-----
> From: Steve Adams [SMTP:steve.adams_at_ixora.com.au]
> Sent: Wednesday, August 23, 2000 4:50 AM
> To: J. Laurindo Chiappa; DBAs - TeleLists; LazyDBA/Quickdocs -;
> Oracle-Linux
> Subject: 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
>
>
> --------
> 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
>
>
> --------
> 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 - 23:15:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US