Thanks indeed Rahul , Steve , ALL
> -----Original Message-----
> From: Rahul [SMTP:rahul_at_ratelindo.co.id]
> Sent: Wednesday, August 23, 2000 12:17 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: How to find v$session_wait object names ?
>
> select b.sid,
> substr(a.segment_name,1,25) OBJ_NAME,
> a.segment_type OBJ_TYPE,
> b.p2 BLOCKID,
> b.p3 BLOCKS,
> b.event
> from dba_extents a,
> v$session_wait b
> where b.p2 between a.block_id AND (a.block_id+a.blocks)
> and a.file_id = b.p1
> and b.p1text='file#'
> and b. event like 'db file%'
> /
>
> > ----------
> > From: VIVEK_SHARMA[SMTP:vivek_sharma_at_inf.com]
> > Reply To: ORACLE-L_at_fatcity.com
> > Sent: Wednesday, August 23, 2000 12:34 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: How to find v$session_wait object names ?
> >
> >
> > 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
> > --
> > Author: VIVEK_SHARMA
> > INET: vivek_sharma_at_inf.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Author: Rahul
> INET: rahul_at_ratelindo.co.id
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Aug 24 2000 - 11:49:39 CDT
