ORA-07445: exception encountered: core dump [qerandvRop()+203] in alert logs with parallelism N>1 when gathering statistics in parallel for table with virtual column/s

(Doc ID 1615360.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

The alert log shows :

Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x933C8DF, qerandvRop()+203] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/bidwd/BIDWD1/trace/BIDWD1_p019_8928.trc (incident=189595):
ORA-07445: exception encountered: core dump [qerandvRop()+203] [SIGSEGV] [ADDR:0x0] [PC:0x933C8DF] [SI_KERNEL(general_protection)] []
Incident details in: /u01/app/oracle/diag/rdbms/bidwd/BIDWD1/incident/incdir_189595/BIDWD1_p019_8928_i189595.trc

Trace files:

 

*** 2013-06-24 22:27:40.856
*** SESSION ID:(1678.41333) 2013-06-24 22:27:40.861
*** SERVICE NAME:(SYS$USERS) 2013-06-24 22:27:40.861
*** MODULE NAME:(DBMS_SCHEDULER) 2013-06-24 22:27:40.861
*** ACTION NAME:(ORA$AT_OS_OPT_SY_408) 2013-06-24 22:27:40.861

Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x933C8DF, qerandvRop()+203] [flags: 0x0, count: 1]
Incident 189595 created, dump file: /u01/app/oracle/diag/rdbms/bidwd/BIDWD1/incident/incdir_189595/BIDWD1_p019_8928_i189595.trc
ORA-07445: exception encountered: core dump [qerandvRop()+203] [SIGSEGV] [ADDR:0x0] [PC:0x933C8DF] [SI_KERNEL(general_protection)] []

ssexhd: crashing the process...
Shadow_Core_Dump = PARTIAL
ksdbgcra: writing core file to directory '/u01/app/oracle/diag/rdbms/bidwd/BIDWD1/cdump'

Changes

 this is the exact index creation statement done:
CREATE UNIQUE INDEX GDWADMIN.IA_CUST_GROUP_PK ON GDWADMIN.IA_CUST_GROUP
(SYS_OP_C2C("CUSTOMER_NUM"), SYS_OP_C2C("BUSN_ORG"))
LOGGING
TABLESPACE GDW_DATA
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
          INITIAL          8M
          NEXT             8M
          MINEXTENTS       1
          MAXEXTENTS       UNLIMITED
          PCTINCREASE      0
          BUFFER_POOL      DEFAULT
         )
PARALLEL ( DEGREE 32 INSTANCES 1 );

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