My Oracle Support Banner

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

Last updated on FEBRUARY 25, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Generic UNIX

Symptoms

Alert log reports:

...
Mon Feb 11 22:38:27 2013
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_j001_32090.trc (incident=48302):
ORA-00600: internal error code, arguments: [qksvcReplaceVC0], [], [], [], [], [], [], [], [], [], [], []
Incident details in:<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_48302/<instname>_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 ...

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.