My Oracle Support Banner

ORA-07445 [kxsxsi] Error Reported From Sql Tuning Advisor (Doc ID 2256570.1)

Last updated on AUGUST 04, 2018

Applies to:

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

Symptoms

+ Following error is being encountered:

ORA-07445: exception encountered: core dump [kxsxsi()+450] [SIGSEGV] [ADDR:0x0] [PC:0xCC1B602] [SI_KERNEL(general_protection)] []

 

+ Trace file shows that the internal error comes from stats gathering part of Sql Tuning Advisor:

----- Current SQL Statement for this session (sql_id=69kw09jxt0nda) -----
/* SQL Analyze(1) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring xmlindex_sel_idx_tbl no_substrb_pad */to_char(count("SYS_STSRUZ_MY5WL22XPY4J57Z_1SZ")),substrb(dump(min("SYS_STSRUZ_MY5WL22XPY4J57Z_1SZ"),16,0,64),1,240),substrb(dump(max("SYS_STSRUZ_MY5WL22XPY4J57Z_1SZ"),16,0,64),1,240),to_char(count("SYS_STSQVBNRT3UF8CUQ#R7DDZLTUF")),
substrb(dump(min("SYS_STSQVBNRT3UF8CUQ#R7DDZLTUF"),16,0,64),1,240),substrb(dump(max("SYS_STSQVBNRT3UF8CUQ#R7DDZLTUF"),16,0,64),1,240),to_char(count("SYS_STSPML4HJYEW3ECOU4#PJRUH6M")),....................
..from "GLOVIA_PROG40"."PO" t /* TOPN,NIL,NIL,TOPN,NIL,NIL,TOPN,NIL,NIL,TOPN,NIL,NIL,TOPN,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,TOPN,NIL,NIL,TOPN,NIL,NIL,NDV,NIL,NIL,TOPN,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL...
[TOC00005]
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x1ac7108f8 145 package body SYS.DBMS_SQLTUNE_INTERNAL
0x1ac7108f8 13094 package body SYS.DBMS_SQLTUNE_INTERNAL
0x1ac7108f8 13730 package body SYS.DBMS_SQLTUNE_INTERNAL
0x1ac7108f8 18936 package body SYS.DBMS_SQLTUNE_INTERNAL
0x1c04a1dc8 9340 package body SYS.DBMS_STATS_INTERNAL
0x1b57633b0 30293 package body SYS.DBMS_STATS
0x1b57633b0 31451 package body SYS.DBMS_STATS
0x1b57633b0 33137 package body SYS.DBMS_STATS
0x1b57633b0 34029 package body SYS.DBMS_STATS
0x1b57633b0 34972 package body SYS.DBMS_STATS
0x1b57633b0 44193 package body SYS.DBMS_STATS
0x1b57633b0 44256 package body SYS.DBMS_STATS

+ Call stack shows:

... kxsxsi opiexe kpoal8 opiodr kpoodrc rpiswu2 kpoodr upirtrc kpurcsc kpuexec OCIStmtExecute qksanExecSql qksanAnalyzeSqlConCbk qksanAnalyzeSql qksanAnalyzeSegSql kestsGatherSqlStatistics kestsProcessSql kestsProcessSqlCallout ...


+ Analyzing the table with cascade option fails with ORA-1499:

SQL> analyze table GLOVIA_PROG40.C_ITEM validate structure cascade;
*
ERROR at line 1:
ORA-01499: table/index cross reference failure - see trace file

- and the analyze statement runs successfully without cascade:

mm2gp1 SQL> analyze index GLOVIA_PROG40.PK_C_ITEM validate structure;

Index analyzed.


+ There is a PK index on table:


mm2gp1 SQL> select owindex_name from dba_indexes where table_name='C_ITEM';

INDEX_NAME
--------------------------------------------------------------------------------
PK_C_ITEM


+ After performing 'alter table move', there were duplicate records found in the table and the primary key turned to unusable status.

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
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.