ORA-7445 [PFRGNC()] ERROR WHEN EXECUTING GATHER_STATS_JOB (Doc ID 785913.1)

Last updated on APRIL 10, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 12.2.0.1 [Release 10.2 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 28-Feb-2012***


Symptoms

The GATHER_STATS_JOB job fails with the following error :

Unix process pid: xxxxx, image: oracle@xxxx(J001)

*** ACTION NAME:(GATHER_STATS_JOB)
*** MODULE NAME:(DBMS_SCHEDULER)
*** SERVICE NAME:(SYS$USERS)

ORA-07445: exception encountered: core dump [pfrgnc()+] [SIGSEGV] [Address not mapped to object]

Current SQL statement for this session:
BEGIN
BEGIN
IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner,
sys.dictionary_obj_name, sys.dictionary_obj_owner)) THEN
xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name);
END IF;
EXCEPTION
WHEN OTHERS THEN
null;
END;
BEGIN
IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner,
sys.dictionary_obj_name, sys.dictionary_obj_owner, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN
xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name);
END IF;
EXCEPTION
WHEN OTHERS THEN
null;
END;
END;

----- PL/SQL Call Stack -----
object line object
handle number name
0x19311b4f0 562 package body SYS.DBMS_STATS_INTERNAL
0x3571bcda0 19085 package body SYS.DBMS_STATS
0x3571bcda0 19191 package body SYS.DBMS_STATS
0x176e19e08 1 anonymous block

The process memory dump shows the presence of the following errors:

ORA-27403: scheduler stop job event
ORA-06512: at "SYS.DBMS_STATS", line 9601
ORA-06512: at "SYS.DBMS_STATS", line 10157



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