DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Urgent: Latch free increasing on latch#94

Threaded View

  1. #1
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620

    Urgent: Latch free increasing on latch#94

    Hi all,

    I am having issue right now on Production database. There are total latch free event show 16 latch free events and its increasing.

    It is having 94 in P2 column of v$session_wait, which is 'temp lob duration state obj allocation' event in v$latch.

    There is no note on metalink on this latch name.

    Also, there is no row in v$latchholder.

    What should I do? Its very urgent.

    Thanks in adv for any help.

    Update: Now even ORACLE.exe (type Background) is also waiting on this latch and I got foll. msg in PMON trace.

    *** 2003-07-17 09:18:09.421
    *** SESSION ID:(1.1) 2003-07-17 09:18:09.390
    PMON unable to acquire latch 13cd3b8 temp lob duration state obj allocation
    *** 2003-07-17 09:18:09.421
    *** 2003-07-17 09:28:10.765
    PMON unable to acquire latch 13cd3b8 temp lob duration state obj allocation
    *** 2003-07-17 09:28:10.765
    *** 2003-07-17 09:38:12.109
    PMON unable to acquire latch 13cd3b8 temp lob duration state obj allocation
    *** 2003-07-17 09:38:12.109
    *** 2003-07-17 09:48:13.453
    PMON unable to acquire latch 13cd3b8 temp lob duration state obj allocation
    *** 2003-07-17 09:48:13.453
    *** 2003-07-17 09:58:14.765
    PMON unable to acquire latch 13cd3b8 temp lob duration state obj allocation
    *** 2003-07-17 09:58:14.765
    *** 2003-07-17 10:08:17.109
    PMON unable to acquire latch 13cd3b8 temp lob duration state obj allocation
    *** 2003-07-17 10:08:17.109
    Last edited by samdba; 07-17-2003 at 10:18 AM.
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width