ORA-600 [17114] Followed By ORA-600 [kghrcdepth:size0] When Analyze Tables (Doc ID 1453943.1)

Last updated on APRIL 28, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 21-Jan-2014***

Symptoms

Errors like the following are reported in the alert.log:

Fri Feb 10 01:31:23 2012
Errors in file /home/oracle/diag/rdbms/wsb2t/wsb2t/trace/wsb2t_ora_5292036.trc  (incident=43545):
ORA-00600: internal error code, arguments: [17114], [0x110698E00], [], [], [], [], [], [], [], [], [], []
Incident details in: /home/oracle/diag/rdbms/wsb2t/wsb2t/incident/incdir_43545/wsb2t_ora_5292036_i43545.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /home/oracle/diag/rdbms/wsb2t/wsb2t/trace/wsb2t_ora_5292036.trc  (incident=43546):
ORA-00600: internal error code, arguments: [kghrcdepth:size0], [0x110698E00], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17114], [0x110698E00], [], [], [], [], [], [], [], [], [], []
Incident details in: /home/oracle/diag/rdbms/wsb2t/wsb2t/incident/incdir_43546/wsb2t_ora_5292036_i43546.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /home/oracle/diag/rdbms/wsb2t/wsb2t/incident/incdir_43545/wsb2t_ora_5292036_i43545.trc:
ORA-00039: error during periodic action
ORA-00600: internal error code, arguments: [kghrcdepth:size0], [0x110698E00], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17114], [0x110698E00], [], [], [], [], [], [], [], [], [], []


The incident trace file shows the current sql and PL/SQL stack like:

----- Current SQL Statement for this session (sql_id=5hajs402v7dqg) -----
select i.obj# from ind$ i where i.bo#=:1 order by i.obj# desc
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
70000004e21b2d0        13  procedure WS_OWNER.SPANALYZEALLTABLES
70000004ddbb7c8         1  anonymous block

 
The call stack from the trace file is like:

... kgherror kghrcdepth kghrcdepth kghrcappl kghfrempty_ex qesmmIPgaFreeCb ksu_dispatch_tac sorgetqbf qersoFetch opifch2 opifch opiodr rpidrus skgmstack
rpidru rpiswu2 rpidrv rpifch kdasti kdasts kkndgd kknls kkndrv opiexe opiosq0 opipls opiodr rpidrus skgmstack rpidru rpiswu2 rpidrv psddr0 psdnal pevm_EXIM
pfrinstr_EXIM pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real ssthrdmain main start

Changes


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