Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Library Cache Lock - Sequence

874555Jul 18 2011 — edited Jul 19 2011
Hi,
In our 11.2.0.1 production database we are getting an ORA-00060 error Deadlock detected every day;
I know that the application must be tuned to solve this issue, but, I want to troubleshoot the errors to helps app guys. when looking into the error in the trace files,
I see ; LIBRARY OBJECT LOCK and the object is a sequence, any idea what is the cause of that?
SO: 0x5f3b460e8, type: 74, owner: 0x5fe7216e8, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
       proc=0x5ea473d38, name=LIBRARY OBJECT LOCK, file=kgl.h LINE:8349 ID:, pg=0

      LibraryObjectLock:  Address=f3b460e8 Handle=f5d8bd30 Mode=N CanBeBrokenCount=1 Incarnation=1 ExecutionCount=1

        User=fe7216e8 Session=fe7216e8 ReferenceCount=1 Flags=[0000] SavepointNum=4e244349
      LibraryHandle:  Address=f5d8bd30 Hash=e3516ae5 LockMode=N PinMode=0 LoadLockMode=0 Status=VALD
        ObjectName:  Name=        SELECT SQ_MON_08877.NEXTVAL FROM DUAL

          FullHashValue=62542638cb895b30579930c3e3516ae5 Namespace=SQL AREA(00) Type=CURSOR(00) Identifier=3813763813 OwnerIdn=51
        Statistics:  InvalidationCount=0 ExecutionCount=41554 LoadCount=2 ActiveLocks=7 TotalLockCount=16369 TotalPinCount=1
        Counters:  BrokenCount=1 RevocablePointer=1 KeepDependency=1 KeepHandle=1 BucketInUse=0 HandleInUse=0
        Concurrency:  DependencyMutex=f5d8bde0(0, 1, 0, 0) Mutex=f5d8be58(0, 68797, 0, 0)
        Flags=RON/PIN/TIM/PN0/DBN/[10012841]
        WaitersLists:
          Lock=f5d8bdc0[f5d8bdc0,f5d8bdc0]
This post has been answered by mbobak on Jul 19 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2011
Added on Jul 18 2011
18 comments
4,866 views