you are getting the SID from the v$session_wait view.. just query the v$session and find our the session details of this SID !
> ---------- > From: Gupta, Brijesh[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Friday, February 15, 2002 10:08 PM > To: Multiple recipients of list ORACLE-L > Subject: Library Cache wait -- Who is holding this latch > > Hi All > I have a session which is waiting for Library Cache latch for 6 hours. > How can I find who is holding this latch. > This session is executing a pl/sql script ( Not package ). Latch# 60 is > library cache latch. > > > Here is from v$session_wait > > 1 select * from v$session_wait > 2* where sid=1005 > PROD>/ > Press Enter to Continue .... > > SID SEQ# EVENT P1TEXT > > ------- ----------- ------------------------------ > ------------------------------------------------- > P1RAW P2TEXT > P2 P2RAW > ---------------- > ---------------------------------------------------------------- > ----------- ------ > > Wait Sec in > P3TEXT > P3 P3RAW time Wait STATE > ---------------------------------------------------------------- > ----------- ---------------- ------ > 1005 5987 latch free address > @9925 > 07000001C0A5E228 number > 60 000000000000003C > tries > 0 00 -1 32,962 WAITED SHORT > > > > > Thanks > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Brijesh Gupta > Oracle Production DBA > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).