ORA-07445 [kxsxsi()+450] [SIGSEGV]
适用于:
Oracle数据库 - 企业版 - 12.1.0.1及更高版本
本文档中的信息适用于任何平台。
症状
+遇到以下错误:
ORA-07445: exception encountered: core dump [kxsxsi()+450] [SIGSEGV] [ADDR:0x0] [PC:0xCC1B602] [SI_KERNEL(general_protection)] []
+跟踪文件显示内部错误来自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
+调用堆栈显示:
... kxsxsi opiexe kpoal8 opiodr kpoodrc rpiswu2 kpoodr upirtrc kpurcsc kpuexec OCIStmtExecute qksanExecSql qksanAnalyzeSqlConCbk qksanAnalyzeSql qksanAnalyzeSegSql kestsGatherSqlStatistics kestsProcessSql kestsProcessSqlCallout ...
+使用级联选项分析表失败,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.
+表上有一个PK索引:
mm2gp1 SQL> select owindex_name from dba_indexes where table_name='C_ITEM'; INDEX_NAME -------------------------------------------------------------------------------- PK_C_ITEM
+执行'alter table move'后,表中找到重复记录,主键变为不可用状态。
原因
发现该表具有重复记录,并且主键变为不可用。
解
从表中删除重复记录并通过运行以下命令重新创建PK索引:
SQL> alter table <table_name> disable primary key; SQL> alter table <table_name> enable primary key;
(文档ID 2256570.1)