My Oracle Support Banner

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 FEBRUARY 26, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.4 [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.

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 <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_8928.trc (incident=189595):
ORA-07445: exception encountered: core dump [qerandvRop()+203] [SIGSEGV] [ADDR:0x0] [PC:0x933C8DF] [SI_KERNEL(general_protection)] []
Incident details in:<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_189595/<instname>_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: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_189595/<instname>_p019_8928_i189595.trc
ORA-07445: exception encountered: core dump [qerandvRop()+203] [SIGSEGV] [ADDR:0x0] [PC:0x933C8DF] [SI_KERNEL(general_protection)] []

Changes

This is the exact index creation statement done:


CREATE UNIQUE INDEX <INDEX_NAME> ON <TABLE_NAME>
(SYS_OP_C2C("<COL1>"), SYS_OP_C2C("<COL2>"))
LOGGING
TABLESPACE <TABLESPACE_NAME>
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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.