User feedback database server disk space usage exhausted. View after logging in to the server, discovering that the database generated a large number of trace logs and found ora-600 errors in the alert log
Alert Log Information:
Fri Jul - .: -: + -ErrorsinchFile D:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_53832.trc (incident=35764): ORA-00600: Internal error code, parameters: [17059], [0xdd7e984d0], [0xdd7e98d68], [0xe17ad9658], [], [], [], [], [], [], [], []fri Jul - .: -: on -Sweep [inc][39570]: completedsweep [inc][39568]: completedsweep [inc][39466]: completedsweep [inc][35764]: Completedfri Jul - .: -:Ten -Dde:problem Key'ORA [17059]'was completely flood controlled (0x6) Further messages for ThisProblem key would be suppressed forUp toTenMinutes
Trace file Contents:
*** -- -- - .: *:20.058SESSION ID: (42.1215) -- -- - .: *:20.058CLIENT ID: (server#thread- the) -- -- - .: *:20.058SERVICE NAME: (sys$users) -- -- - .: *:20.058MODULE NAME: (JDBC Thin Client) -- -- - .: *:20.058ACTION NAME: () -- -- - .: *:20.058libraryhandle:address=17ad9658 hash=931b2cd4 lockmode=n pinmode=0Loadlockmode=0status=Vald objectname:name=select Invokedid, Timeconfig, Lasttime, Nexttime, NextTime2, handlerclz from Bi_schd_timer WHERE nvl (To_char (nexttime ), :"Sys_b_0") = :"sys_b_1"or (Nexttime >=:"sys_b_2"and Nexttime <:"Sys_b_3") Fullhashvalue=EE068DCFA54C7CEA1FF5ED5C931B2CD4 Namespace=sql Area (xx) Type=cursor (xx) identifier=2468031700owneridn= theStatistics:invalidationcount=0Executioncount=32768Loadcount=32769activelocks=1Totallockcount=43844Totalpincount=1Counters:brokencount=1Revocablepointer=1keepdependency=32768keephandle=32768Bucketinuse=43841Handleinuse=43841Concurrency:dependencymutex=17ad9708 (0,11073,0,0) mutex=17ad9780 ( the,1409403,3395054,6) Flags=ron/pin/tim/pn0/dbn/[10012841] Waiterslists:lock=17ad96e8[17ad96e8,17ad96e8] Pin=17ad96f8[17ad96c8,17ad96c8] Timestamp:current= -- the- - A: -: tolibraryobject:address=d7e984d0 heapmask=0000-0001-0001flags=exs[0000] Flags2=[0000] Publicflags=[0000] Datablocks:block: #='0'NAME=PCUR^931B2CD4 pins=0Change=NONE Heap=17ad95a0 pointer=d7e985b8 extent=d7e98450 flags=i/-/p/a/-/-freedlocation=0Alloc=1.515625Size=4.000000Loadtime=17207577371childtable:size='32768'Child:id='0'table=d7e99380 Reference=d7e98e20 handle=17ad9248 Child:id='1'table=d7e99380 reference=d7e99188 handle=17ad8558 Child:id='2'table=d7e99380 reference=d7e869b0 handle=17ad7868 ... Child:id='32767'Table=31d8e5e8 reference=31d624c0 handle=163589d8 namespacedump:parent cursor:sql_id=1zxgdbk9jqb6n Parent=0000000dd7e985b8 maxchild=32769Plk=y ppn=n kgx Cleanup ...*** -- -- - .: *:20.885KGX Atomic Operation Log 0000000e16076e40 Mutex 0000000e17ad9780 ( the,0) IDN 931b2cd4 oper EXCL Library Cache uid theEfd5Whr102Slp0Oper=0pt1=17ad9658 pt2=0pt3=0Pt4=0pt5=0ub4=0Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_12308.trcOracle Database 11g Enterprise Edition Release11.2.0.1.0-64bit Productionwith The partitioning, OLAP, Data Mining and Real application testing optionslibraryhandle:address< /c7>=17ad9658 hash=931b2cd4 lockmode=n pinmode=0Loadlockmode=0
Login Database View:
Found Cursor_sharing is set to Smilar, modified to exact after error elimination
sql> Show parameter cursorname TYPE VALUE---------------------------------------------------- -------------------------cursor_sharing string similarsqlset cursor _sharing=exact scope=both; System altered. SQL>
Other similar errors can be referenced in the MOS documentation:
Understanding and diagnosing ORA-600 [17059] Errors (Doc ID 1683417.1)
Bug 9689310-excessive child Cursors/high version_count/ora-600 [17059] due to bind mismatch (Doc ID 9689310.8)
Database report ORA-00600: Internal error code, parameter: [17059], and generate a large number of trace log files