ORA-600 [qksvcReplaceVC0] From SQL Analyze Using EBS (Doc ID 1633693.1)

Last updated on APRIL 01, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
Generic UNIX

Symptoms

Alert log reports:

...
Mon Feb 11 22:38:27 2013
Errors in file /oradba/trace/db/diag/rdbms/ftmartd1/FTMARTD1/trace/FTMARTD1_j001_32090.trc (incident=48302):
ORA-00600: internal error code, arguments: [qksvcReplaceVC0], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oradba/trace/db/diag/rdbms/ftmartd1/FTMARTD1/incident/incdir_48302/FTMARTD1_j001_32090_i48302.trc
Mon Feb 11 22:38:30 2013
Sweep [inc][48302]: completed
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
...

 
The incident detail trace file shows current sql, PL/SQL stack and call stack functions like:

*** 2013-02-11 22:38:27.668
*** SESSION ID:(1777.28587) 2013-02-11 22:38:27.668
*** CLIENT ID:() 2013-02-11 22:38:27.668
*** SERVICE NAME:(SYS$USERS) 2013-02-11 22:38:27.668
*** MODULE NAME:(DBMS_SCHEDULER) 2013-02-11 22:38:27.668
*** ACTION NAME:(ORA$AT_SQ_SQL_SW_2794) 2013-02-11 22:38:27.668
 
Dump continued from file: /oradba/trace/db/diag/rdbms/ftmartd1/FTMARTD1/trace/FTMARTD1_j001_32090.trc
ORA-00600: internal error code, arguments: [qksvcReplaceVC0], [], [], [], [], [], [], [], [], [], [], []

========= Dump for incident 48302 (ORA 600 [qksvcReplaceVC0]) ========

*** 2013-02-11 22:38:27.668
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)

----- Current SQL Statement for this session (sql_id=88b7n59z18kkm) -----
/* SQL Analyze(1777,1) */ /* e81cf909 */
select distinct D1.c2 as c2,
...
...
order by c8, c9, c2, c6, c10

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
  object line object
  handle number name
0x143fe0d8e0 11816 package body SYS.DBMS_SQLTUNE_INTERNAL
0x13efcd49e8 7 SYS.WRI$_ADV_SQLTUNE
0x143fe1b8e8 587 package body SYS.PRVT_ADVISOR
0x143fe1b8e8 2655 package body SYS.PRVT_ADVISOR
0x142fdf4a68 241 package body SYS.DBMS_ADVISOR
0x13efdfe000 821 package body SYS.DBMS_SQLTUNE
0x141fa85270 4 anonymous block

----- Call Stack Trace -----

... qksvcDoReplace qksvcReplaceIndexExpr kkoixo kkoiqb kkooqb kkoqbc apakkoqb apaqbdDescendents apaqbdList apaqbd ...

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