ORA-600 [17059] From multiple Child Cursors after dropping schemas in

(Doc ID 1292013.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2]
Information in this document applies to any platform.


1) You are on

2) You are encountering either huge trace files or single files hitting multiple GB

3)  In reviewing the trace files you find very simple queries generating the errors (over and over

Example Query


select inst_id, instance_name, host_name from gv$instance order by inst_id;

In reviewing the trace file you may find that the user issuing the query is for EM (DBSNMP) vs. an application user  

Errors in file /u01/app/oracle/diag/rdbms/....._123.trc (incident=197373):
ORA-00600: internal error code, arguments: [17059], [0x7CFA5BCA0], [0x7CFA5C538], [0x85553B740], [], [], [], [], [], [], [], []

---- Excerpt 2 from the trace file

SO: 0x6ccfaeac0, type: 74, owner: 0x85c9eedb0, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
proc=0x84483b380, name=LIBRARY OBJECT LOCK, file=kgl.h LINE:8348, pg=0

LibraryObjectLock: Address=ccfaeac0 Handle=5553b740 Mode=N CanBeBrokenCount=1 Incarnation=1 ExecutionCount=0

User=5c9eedb0 Session=5c9eedb0 ReferenceCount=1 Flags=CNB/[0001] SavepointNum=4d34ec3d
LibraryHandle: Address=5553b740 Hash=d67ad0ee LockMode=N PinMode=0 LoadLockMode=0 Status=VALD

ObjectName:  Name= select inst_id, instance_name, host_name from gv$instance order by inst_id

FullHashValue=694c080e69e1f300a6bab2e5d67ad0ee Namespace=SQL AREA(00)

Type=CURSOR(00)Identifier=3598373102 OwnerIdn=30       << Username = DBSNMP

Statistics: InvalidationCount=10 ExecutionCount=2909 LoadCount=65486 ActiveLocks=1 TotalLockCount=65491 TotalPinCount=2
Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=32768 KeepHandle=32768 BucketInUse=65489 HandleInUse=65489
Concurrency: DependencyMutex=5553b7f0(0, 1, 0, 0) Mutex=5553b868(9, 2158283916, 50962772, 6)
Timestamp: Current=12-27-2010 09:05:39
LibraryObject: Address=cfa5bca0 HeapMask=0000-0001-0001 Flags=EXS[0000] Flags2=[0000] PublicFlags=[0000]

ChildTable: size='32768'    <<<<<<

Child: id='0' Table=cfa5cb50 Reference=cfa5c5f0 Handle=2cfa0ef8    <<<<<


Child: id='1' Table=cfa5cb50 Reference=cfa5c910 Handle=556a2d50
Child: id='2' Table=cfa5cb50 Reference=6108ccf0 Handle=2d6e99b8

Child: id='32767' Table=a6329598 Reference=30424048 Handle=2f1fd050 <<<<<


<end extract>

Helpful Identification

If using Grid control / database control to monitor the database you can see CPU being grabbed by dbsnmp running causing cursor: mutex X and CPU large CPU hits.

SQL typically shows.....

SELECT mt.inst_id, service_name,
 HH24:MI:SS TZD') time,
 HH24:MI:SS TZD') time,
  group_id, cpupercall, dbtimepercall, callspersec, dbtimepersec
FROM gv$servicemetric_history mt , gv$active_services ast
WHERE service_name = :p1 AND end_time >= SYSDATE - 5/(60*24) AND
  group_id = 6 and mt.service_name = ast.name and mt.inst_id =ast.inst_id
ORDER BY mt.inst_id asc, end_time DESC


None known


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