ORA-600 [17059] From multiple Child Cursors after dropping schemas in 11.2.0.1 (Doc ID 1292013.1)

Last updated on FEBRUARY 07, 2014

Applies to:

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

Symptoms

1) You are on 11.2.0.1

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)
Flags=RON/PIN/TIM/PN0/DBN/[10012841]
WaitersLists:
Lock=5553b7d0[5553b7d0,5553b7d0]
Pin=5553b7e0[5553b7b0,5553b7b0]
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,
 TO_CHAR(CAST(begin_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD
 HH24:MI:SS TZD') time,
 TO_CHAR(CAST(end_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD
 HH24:MI:SS TZD') time,
 intsize_csec,
  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



Changes

None known

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