ORA-00600: [25027] While Running DBMS_SQLTUNE (Doc ID 1917139.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

 Following error in the alert log file while running sql tuning advisor :-

Thu Jul 17 22:34:32 2014
Errors in file
/u01/app/oracle/diag/rdbms/sexeu1/sexeu12/trace/sexeu12_j001_9628.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_SA_SPC_SY_20568"
ORA-01426: numeric overflow
ORA-06512: at "SYS.DBMS_ADVISOR", line 201
ORA-06512: at "SYS.DBMS_SPACE", line 2480
ORA-06512: at "SYS.DBMS_SPACE", line 2553
Thu Jul 17 22:41:14 2014
Errors in file
/u01/app/oracle/diag/rdbms/sexeu1/sexeu12/trace/sexeu12_j002_9630.trc  
(incident=607315):
ORA-00600: internal error code, arguments: [25027], [0], [8388970], [], [],
[], [], [], [], [], [], []
Incident details in:
/u01/app/oracle/diag/rdbms/sexeu1/sexeu12/incident/incdir_607315/sexeu12_j002_
9630_i607315.trc

 

Incident trace file shows the below sql caused the ora-600.

 

ORA-00600: internal error code, arguments: [25027], [0], [8388970], [], [], [], [], [], [], [], [], []

========= Dump for incident 607315 (ORA 600 [25027]) ========

*** 2014-07-17 22:41:14.925
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=8ywuahx9qmv3x) -----
SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) opt_param('parallel_execution_enabled', 'false')  result_cache
OPT_ESTIMATE(@"innerQuery", NLJ_INDEX_SCAN, "S#11", ("E#0", "O#8", "T#9", "U#13"), "I_FILE#_BLOCK#", SCALE_ROWS=346.6289668) OPT_ESTIMATE(@"innerQuery", NLJ_INDEX_FILTER, "S#11", ("E#0",
"O#8", "T#9", "U#13"), "I_FILE#_BLOCK#", SCALE_ROWS=346.6289668) OPT_ESTIMATE(@"innerQuery", JOIN, ("O#1", "O#8", "T#9", "U#13"), SCALE_ROWS=50.22426126) OPT_ESTIMATE(@"innerQuery", JOIN,
("O#1", "O#8", "U#13"), SCALE_ROWS=13.82809183) OPT_ESTIMATE(@"innerQuery", INDEX_FILTER, "O#8", "I_OBJ2", SCALE_ROWS=0.005445761492) OPT_ESTIMATE(@"innerQuery", JOIN, ("E#0", "O#1", "O#8",
"U#13"), SCALE_ROWS=0.002305817988) OPT_ESTIMATE(@"innerQuery", INDEX_SKIP_SCAN, "O#8", "I_OBJ2", SCALE_ROWS=15.77496371) OPT_ESTIMATE(@"innerQuery", JOIN, ("E#0", "O#1", "O#8", "T#9",
"U#13"), SCALE_ROWS=0.005437204031) OPT_ESTIMATE(@"innerQuery", JOIN, ("E#0", "O#8", "U#13"), SCALE_ROWS=0.0001049399918) OPT_ESTIMATE(@"innerQuery", INDEX_SKIP_SCAN, "O#8", "I_OBJ5",
SCALE_ROWS=15.77496371) */ COUNT(C1) FROM (SELECT /*+ qb_name("innerQuery") NO_INDEX_FFS( "S#11")  */ 1 AS C1 FROM "SYS"."SEG$" SAMPLE BLOCK(20.9589, 8) SEED(1)  "S#11", "SYS"."TAB$" "T#9",
"SYS"."DBA_OBJECTS" "O#1", "SYS"."OBJ$" "O#8", (SELECT "SYS_DBA_SEGS"."OWNER" "OWNER","SYS_DBA_SEGS"."SEGMENT_NAME"
"TABLE_NAME",ROUND(SUM(DECODE(BITAND("SYS_DBA_SEGS"."SEGMENT_FLAGS",131072),131072,"SYS_DBA_SEGS"."BLOCKS",DECODE(BITAND("SYS_DBA_SEGS"."SEGMENT_FLAGS",1),1,

"SYS"."DBMS_SPACE_ADMIN"."SEGMENT_NUMBER_BLOCKS"("SYS_DBA_SEGS"."TABLESPACE_ID","SYS_DBA_SEGS"."RELATIVE_FNO","SYS_DBA_SEGS"."HEADER_BLOCK","SYS_DBA_SEGS"."SEGMENT_TYPE_ID","SYS_DBA_SEGS"."BUFFER_POOL_ID","SYS_DBA_SEGS"."SEGM
ENT_FLAGS","SYS_DBA_SEGS"."SEGMENT_OBJD","SYS_DBA_SEGS"."BLOCKS"),"SYS_DBA_SEGS"."BLOCKS"))*"SYS_DBA_SEGS"."BLOCKSIZE")/1024/1024,2)
"SZ_SEG_MB",SUM(DECODE(BITAND("SYS_DBA_SEGS"."SEGMENT_FLAGS",131072),131072,"SYS_DBA_SEGS"."EXTENTS",DECODE(BITAND("SYS_DBA_SEGS"."SEGMENT_FLAGS",1),1,"SYS"."DBMS_SPACE_ADMIN"."SEGMENT_NUMBER
_EXTENTS"("SYS_DBA_SEGS"."TABLESPACE_ID","SYS_DBA_SEGS"."RELATIVE_FNO","SYS_DBA_SEGS"."HEADER_BLOCK","SYS_DBA_SEGS"."SEGMENT_TYPE_ID","SYS_DBA_SEGS"."BUFFER_POOL_ID","SYS_DBA_SEGS"."SEGMENT_F
LAGS","SYS_DBA_SEGS"."SEGMENT_OBJD","SYS_DBA_SEGS"."EXTENTS"),"SYS_DBA_SEGS"."EXTENTS"))) "EXTENTS" FROM  ( (SELECT NVL("U"."NAME",'SYS') "OWNER","O"."NAME" "SEGMENT_NAME","S"."TYPE#"
"SEGMENT_TYPE_ID","TS"."TS#" "TABLESPACE_ID","TS"."BLOCKSIZE" "BLOCKSIZE","S"."BLOCK#" "HEADER_BLOCK",NVL("S"."BLOCKS",0) "BLOCKS","S"."EXTENTS" "EXTENTS","S"."FILE#"
"RELATIVE_FNO",BITAND("S"."CACHEHINT",3) "BUFFER_POOL_ID",NVL("S"."SPARE1",0) "SEGMENT_FLAGS",DECODE(BITAND("S"."SPARE1",1),1,"S"."HWMINCR","O"."DATAOBJ#") "SEGMENT_OBJD" FROM "SYS"."USER$"
"U","SYS"."OBJ$" "O","SYS"."TS$" "TS", ( (SELECT 2 "OBJECT_TYPE_ID",5 "SEGMENT_TYPE_ID","T"."OBJ#" "OBJECT_ID","T"."FILE#" "HEADER_FILE","T"."BLOCK#" "HEADER_BLOCK","T"."TS#" "TS_NUMBER"
FROM "SYS"."TAB$" "T") UNION ALL  (SELECT 19 "OBJECT_TYPE_ID",5 "SEGMENT_TYPE_ID","TP"."OBJ#" "OBJECT_ID","TP"."FILE#" "HEADER_FILE","TP"."BLOCK#" "HEADER_BLOCK","TP"."TS#" "TS_NUMBER" FROM
"SYS"."TABPART$" "TP") UNION ALL  (SELECT 3 "OBJECT_TYPE_ID",5 "SEGMENT_TYPE_ID","C"."OBJ#" "OBJECT_ID","C"."FILE#" "HEADER_FILE","C"."BLOCK#" "HEADER_BLOCK","C"."TS#" "TS_NUMBER" FROM
"SYS"."CLU$" "C") UNION ALL  (SELECT 1 "OBJECT_TYPE_ID",6 "SEGMENT_TYPE_ID","I"."OBJ#" "OBJECT_ID","I"."FILE#" "HEADER_FILE","I"."BLOCK#" "HEADER_BLOCK","I"."TS#" "TS_NUMBER" FROM
"SYS"."IND$" "I") UNION ALL  (SELECT 20 "OBJECT_TYPE_ID",6 "SEGMENT_TYPE_ID","IP"."OBJ#" "OBJECT_ID","IP"."FILE#" "HEADER_FILE","IP"."BLOCK#" "HEADER_BLOCK","IP"."TS#" "TS_NUMBER" FROM
"SYS"."INDPART$" "IP") UNION ALL  (SELECT 21 "OBJECT_TYPE_ID",8 "SEGMENT_TYPE_ID","L"."LOBJ#" "OBJECT_ID","L"."FILE#" "HEADER_FILE","L"."BLOCK#" "HEADER_BLOCK","L"."TS#" "TS_NUMBER" FROM
"SYS"."LOB$" "L") UNION ALL  (SELECT 34 "OBJECT_TYPE_ID",5 "SEGMENT_TYPE_ID","TSP"."OBJ#" "OBJECT_ID","TSP"."FILE#" "HEADER_FILE","TSP"."BLOCK#" "HEADER_BLOCK","TSP"."TS#" "TS_NUMBER" FROM
"SYS"."TABSUBPART$" "TSP") UNION ALL  (SELECT 35 "OBJECT_TYPE_ID",6 "SEGMENT_TYPE_ID","ISP"."OBJ#" "OBJECT_ID","ISP"."FILE#" "HEADER_FILE","ISP"."BLOCK#" "HEADER_BLOCK","ISP"."TS#"
"TS_NUMBER" FROM "SYS"."INDSUBPART$" "ISP") UNION ALL  (SELECT DECODE("LF"."FRAGTYPE$",'P',40,41) "OBJECT_TYPE_ID",8 "SEGMENT_TYPE_ID","LF"."FRAGOBJ#" "OBJECT_ID","LF"."FILE#"
"HEADER_FILE","LF"."BLOCK#" "HEADER_BLOCK","LF"."TS#" "TS_NUMBER" FROM "SYS"."LOBFRAG$" "LF")) "SO","SYS"."SEG$" "S","SYS"."FILE$" "F") UNION ALL  (SELECT NVL("U"."NAME",'SYS')
"OWNER","UN"."NAME" "SEGMENT_NAME","S"."TYPE#" "SEGMENT_TYPE_ID","TS"."TS#" "TABLESPACE_ID","TS"."BLOCKSIZE" "BLOCKSIZE","S"."BLOCK#" "HEADER_BLOCK",NVL("S"."BLOCKS",0)
"BLOCKS","S"."EXTENTS" "EXTENTS","S"."FILE#" "RELATIVE_FNO",BITAND("S"."CACHEHINT",3) "BUFFER_POOL_ID",NVL("S"."SPARE1",0) "SEGMENT_FLAGS","UN"."US#" "SEGMENT_OBJD" FROM "SYS"."USER$"
"U","SYS"."TS$" "TS","SYS"."UNDO$" "UN","SYS"."SEG$" "S","SYS"."FILE$" "F") UNION ALL  (SELECT NVL("U"."NAME",'SYS') "OWNER",TO_CHAR("F"."FILE#")||'.'||TO_CHAR("S"."BLOCK#")
"SEGMENT_NAME","S"."TYPE#" "SEGMENT_TYPE_ID","TS"."TS#" "TABLESPACE_ID","TS"."BLOCKSIZE" "BLOCKSIZE","S"."BLOCK#" "HEADER_BLOCK",NVL("S"."BLOCKS",0) "BLOCKS","S"."EXTENTS"
"EXTENTS","S"."FILE#" "RELATIVE_FNO",BITAND("S"."CACHEHINT",3) "BUFFER_POOL_ID",NVL("S"."SPARE1",0) "SEGMENT_FLAGS","S"."HWMINCR" "SEGMENT_OBJD" FROM "SYS"."USER$" "U","SYS"."TS$"
"TS","SYS"."SEG$" "S","SYS"."FILE$" "F")) "SYS_DBA_SEGS" GROUP BY "SYS_DBA_SEGS"."OWNER","SYS_DBA_SEGS"."SEGMENT_NAME") "E#0", "SYS"."USER$" "U#13" WHERE ("U#13"."NAME"='SYS') AND
("E#0"."OWNER"="U#13"."NAME") AND ("O#8"."NAME"=' FGA_LOG$' OR "O#8"."NAME"='AUD$') AND ("E#0"."TABLE_NAME"="O#8"."NAME") AND ("O#8"."OWNER#"="U#13"."USER#") AND
(BITAND("O#8"."FLAGS",128)=0) AND ("O#1"."OBJECT_TYPE"='TABLE') AND ("O#8"."OBJ#"="T#9"."OBJ#") AND (BITAND("T#9"."PROPERTY",1)=0) AND ("T#9"."FILE#"="S#11"."FILE#"(+)) AND
("T#9"."BLOCK#"="S#11"."BLOCK#"(+)) AND ("T#9"."TS#"="S#11"."TS#"(+))) innerQuery
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x10994f8d0       137  package body SYS.DBMS_SPACE_ADMIN
0x11a7f5170     11829  package body SYS.DBMS_SQLTUNE_INTERNAL
0xc93efc00         7  SYS.WRI$_ADV_SQLTUNE
0x11a9a1df0       601  package body SYS.PRVT_ADVISOR
0x11a9a1df0      2678  package body SYS.PRVT_ADVISOR
0x11a7f9568       241  package body SYS.DBMS_ADVISOR
0x11a862618       821  package body SYS.DBMS_SQLTUNE
0x10fab7118         4  anonymous block 

 The query above shows call to DBMS_SPACE_ADMIN.

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