Oracle-L: RE: Library Cache wait -- Who is holding this latch

From: Diego Cutrone <dcutrone_at_afip.gov.ar>
Date: Tue, 19 Feb 2002 08:28:21 -0800
Message-ID: <F001.004131A3.20020219082821@fatcity.com>

Messageyou'll have to take a library cache dump and look for the latch number displayed in the P1 Field of your query.

HTH
Greetings
Diego Cutrone

Original Message ----- From: Gupta, Brijesh To: Multiple recipients of list ORACLE-L Sent: Friday, February 15, 2002 12:08 PM 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: Diego Cutrone
INET: dcutrone_at_afip.gov.ar

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). Received on Tue Feb 19 2002 - 10:28:21 CST