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]