ORA-7445 [lxCmpStr()+215] During Automatic GATHER_STATS Job (Doc ID 1930237.1)

Last updated on OCTOBER 06, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 12.1.0.2 [Release 11.1 to 12.1]
Information in this document applies to any platform.

Symptoms

Using external tables, the database alert log could show next sequence of errors:

DBMS_STATS: GATHER_STATS_JOB encountered errors.  Check the trace file.
Errors in file /u01/app/oracle/diag/rdbms/test/test/trace/test_j006_2893.trc:
ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file test.txt in test_DNC not found
Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x25A48B7, lxCmpStr()+215] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/test/test/trace/test_j006_2893.trc  (incident=225372):
ORA-07445: exception encountered: core dump [lxCmpStr()+215] [SIGSEGV] [ADDR:0x0] [PC:0x25A48B7] [SI_KERNEL(general_protection)]
Incident details in: /u01/app/oracle/diag/rdbms/test/test/incident/incdir_225372/test_j006_2893_i225372.trc
Use ADRCI or Support Workbench to package the incident.


The call stack in the trace contains functions like:

... lxCmpStr kudmri kudmxo kpxsOpen qxxqOpen spefcpfa spefmccallstd pextproc pgmcetc_execute_tru sted_c pgmccc_call_c sted_c pciccc_call_c kkxmcexe kgmexcb kkxmswu ...

 

The Plan Table in the trace file shows access of an external table:

============
Plan Table
============
------------------------------------------------------------+-----------------------------------+
| Id  | Operation                     | Name                | Rows  | Bytes | Cost  | Time      |
------------------------------------------------------------+-----------------------------------+
| 0   | SELECT STATEMENT              |                     |       |       |    25 |           |
| 1   |  SORT AGGREGATE               |                     |     1 |    61 |       |           |
| 2   |   APPROXIMATE NDV AGGREGATE   |                     |  8168 |  487K |    25 |  00:00:01 |
| 3   |    EXTERNAL TABLE ACCESS FULL | EXT_XX              |  8168 |  487K |    25 |  00:00:01 |
------------------------------------------------------------+-----------------------------------+

 

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