Frequently Getting ORA-600 [kglLockOwnersListAppend-ovf] Or ORA-600 [kglLockOwnersListDelete] (Doc ID 1318902.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 29-Apr-2013***

Symptoms

ORA-600 [kglLockOwnersListAppend-ovf] error is encountered from application.

- <Patch 10126094> is already applied.
- Issue occurs regardless CURSOR_SHARING value
- SESSION_CACHED_CURSORS and PROCESSES have large values (1200 respectively 5000)
- The incident file shows the error is occurring when there are more than 65535 locks. For example:

LibraryHandle: Address=1a7fbe2e08 Hash=9d1660bd LockMode=N PinMode=0
LoadLockMode=0 Status=VALD
ObjectName: Name=update seq$ set
increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache=:7,highwater=:
8,audit$=:9,flags=:10 where obj#=:1
FullHashValue=3d5d234d25a38dc4499e60c99d1660bd Namespace=SQL AREA(00)
Type=CURSOR(00) Identifier=2635489469 OwnerIdn=0
Statistics: InvalidationCount=0 ExecutionCount=955396 LoadCount=3
ActiveLocks=65535 TotalLockCount=813344 TotalPinCount=1 << --- here

 

Alternatively PMON may crash with an ORA-600 [kglLockOwnersListDelete] error when cleaning up a session, and hence crash the instance.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms