DBMS_STATS.GATHER_DATABASE_STATS Job Fails with ORA-7445[qesaMSR2SorRecMerge()+481]
(Doc ID 1492729.1)
Last updated on MARCH 07, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.2.0 [Release 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
HP-UX PA-RISC (64-bit)
Linux x86-64
Symptoms
The following error occurs from the dbms_stats.gather_database_stats Job :
ORA-07445: exception encountered: core dump [qesaMSR2SorRecMerge()+481] [SIGSEGV] [ADDR:0xFFFFFD2D73200030] [PC:0x4000000008D8CE01] [Address not mapped to object] []
----- Current SQL Statement for this session (sql_id=cvzuvf7jj25gt) -----
/* SQL Analyze(0) */ select /*+ full(t) parallel(t,24) parallel_index(t,24) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */to_char(count("SYS_NC00332$")),to_char(substrb(dump(min("SYS_NC00332$"),16,0,32),1,120)),to_char(substrb(dump(max("SYS_NC00332$"),16,0,32),1,120)),
to_char(count("OLDFREETEXT6")),to_char(substrb(dump(min("OLDFREETEXT6"),16,0,32),1,120)),to_char(substrb(dump(max("OLDFREETEXT6"),16,0,32),1,120)),
to_char(count("SYS_NC00326$")),to_char(substrb(dump(min("SYS_NC00326$"),16,0,32),1,120)),to_char(substrb(dump(max("SYS_NC00326$"),16,0,32),1,120)),
to_char(count("SYS_NC00333$")),to_char(substrb(dump(min("SYS_NC00333$"),16,0,32),1,120)),........
from "DSMP"."SERVICEORDERDETAIL" t /* NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,.....
*/
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
c000000a3dd68110 145 package body SYS.DBMS_SQLTUNE_INTERNAL
c000000a3dd68110 12085 package body SYS.DBMS_SQLTUNE_INTERNAL
c000000a3dd68110 12719 package body SYS.DBMS_SQLTUNE_INTERNAL
c000000a3dd68110 17400 package body SYS.DBMS_SQLTUNE_INTERNAL
c0000009f150cb18 6764 package body SYS.DBMS_STATS_INTERNAL
c000000a3c93c438 20153 package body SYS.DBMS_STATS
c000000a3c93c438 21081 package body SYS.DBMS_STATS
c000000a3c93c438 22271 package body SYS.DBMS_STATS
c000000a3c93c438 22974 package body SYS.DBMS_STATS
c000000a3c93c438 23418 package body SYS.DBMS_STATS
c000000a3c93c438 24055 package body SYS.DBMS_STATS
c000000a3c93c438 24268 package body SYS.DBMS_STATS
c000000a3c93c438 24224 package body SYS.DBMS_STATS
c0000009d115f910 1 anonymous block
ObjectName: Name=BEGIN dbms_stats.gather_database_stats(degree=>dbms_stats.auto_degree); END;
Child: id='0' Table=c0000009f7800ab8 Reference=c0000009f78004f8 Handle=c0000009d115f910
============
Plan Table
============
--------------------------------------------------
| Id | Operation | ...
--------------------------------------------------
| 0 | SELECT STATEMENT | ...
| 1 | SORT AGGREGATE | ...
| 2 | PX COORDINATOR | ...
| 3 | PX SEND QC (RANDOM) | ...
| 4 | SORT AGGREGATE | ...
| 5 | APPROXIMATE NDV AGGREGATE | ...
| 6 | PX BLOCK ITERATOR | ...
| 7 | TABLE ACCESS FULL | ...
--------------------------------------------------
Stack Trace similar to:
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 |