DBMS_STATS.GATHER_Database_STATS Job Generates ora-07445 [qesaMSR2SorRecMerge] (Doc ID 1492729.1)

Last updated on DECEMBER 02, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.2.0 [Release 11.2]
HP-UX PA-RISC (64-bit)
Information in this document applies to any platform.
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 | Name | Rows | Bytes | Cost | Time | TQ |IN-OUT|PQ Distrib |
-----------------------------------------------------------+-----------------------------------+-------------------------+
| 0 | SELECT STATEMENT | | | | 2807 | | | | |
| 1 | SORT AGGREGATE | | 1 | 714 | | | | | |
| 2 | PX COORDINATOR | | | | | | | | |
| 3 | PX SEND QC (RANDOM) | :TQ10000 | 1 | 714 | | |:Q1000| P->S |QC (RANDOM)|
| 4 | SORT AGGREGATE | | 1 | 714 | | |:Q1000| PCWP | |
| 5 | APPROXIMATE NDV AGGREGATE | | 1766K | 1231M | 2807 | 00:00:34 |:Q1000| PCWP | |
| 6 | PX BLOCK ITERATOR | | 1766K | 1231M | 2807 | 00:00:34 |:Q1000| PCWC | |
| 7 | TABLE ACCESS FULL | SERVICEORDERDETAIL| 1766K | 1231M | 2807 | 00:00:34 |:Q1000| PCWP | |
-----------------------------------------------------------+-----------------------------------+-------------------------+

Stack Trace similar to:

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