ORA-600 [4883] during Index Rebuild (Doc ID 1391880.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

During index rebuild an ORA-00600 [ 4883 ] is reported:

SQL > ALTER INDEX "ITBIS" ."ITBIS_FS_TB_FIN_VOL_CURR" REBUILD SUBPARTITION "P_20111229_VOL_ACT_PN" ;

ERROR at line 1:
ORA-00600: internal error code, arguments: [4883], [0x260B8630], [0x25A7D34C], [], [], [], [], [], [], [], [], []


The alert log also reports the same:

Fri Dec 30 19:01:14 2011
Errors in file /cs/oracle/PZHDM99/admin/diag/rdbms/pzhdm99/PZHDM99/trace/PZHDM99_ora_8180.trc (incident=185927):
ORA-00600: internal error code, arguments: [4883], [0x7EEE8FDB8], [0x75E15FB60], [], [], [], [], [], [], [], [], []
Incident details in: /cs/oracle/PZHDM99/admin/diag/rdbms/pzhdm99/PZHDM99/incident/incdir_185927/PZHDM99_ora_8180_i185927.trc
Non critical error ORA-48913 caught while writing to trace file "/cs/oracle/PZHDM99/admin/diag/rdbms/pzhdm99/PZHDM99/incident/incdir_185927/PZHDM99_ora_8180_i185927.trc"
Error message: ORA-48913: Writing into trace file failed, file size limit [10000000] reached
Writing to the above trace file is disabled for now on...


The call stack during the time of the error:

ksedst1 <- ksedst <- dbkedDefDump <- dbgexPhaseII <- dbgexProcessError <- dbgePostErrorKGE <- 1128 <- kgeade <- kgeriv_int <- kgesiv <- ksesic2 <- kqrCacheHit <- kqrpre1 <- kdicfurc_fragment_u <- pdate_row_cache <- kdicrws <- pdate_row_cache <- kdicdrv <- opiexe <- opiosq0 <- opiodr <- rpidrus <- skgmstack <- rpidru <- rpiswu2 <- rpidrv <- rpisplu <- atbrulip_rbld_unusb <- l_lidx_frags <- atbdrv <- l_lidx_frags <- 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 <- main <- start

Changes

Here is a simple testcase to reproduce this problem:


SQL> alter session set "_optimizer_multiple_cenv" = '11.2.0.2';

SQL> alter session set "_qa_control" = 1536;

SQL> alter session set "_optimizer_multiple_cenv_stmt" = 'ddl';

SQL> create table t (a int);

SQL> create index ia on t(a);

SQL> alter index ia rebuild;
          --> ORA-600: internal error code, arguments: [4883]

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