My Oracle Support Banner

ORA-07445 [dreogParseHeader()+550] (Doc ID 1372190.1)

Last updated on JANUARY 06, 2020

Applies to:

Oracle Text - Version and later
Information in this document applies to any platform.


The following error is found in the alert.log:

ORA-07445: exception encountered: core dump [dreogParseHeader()+550] [SIGSEGV] [ADDR:0x2A9752B6F9] [PC:0x3D5A4CE] [Address not mapped to object] []

The incident trace file shows the current SQL statement as

select column_value from table(cast(ctxsys.drvparx.IndexOptimizeParFn(cursor(select /*+ parallel(t 1) */ t.num
from ctxsys.dr$number_sequence t), :1, :2, :3, :4, :5, :6, :7) as sys.odcivarchar2list))

Browsing through the incident trace file, we find DML's such as below revealing which Text index is involved:

select /*+ DYNAMIC_SAMPLING(0) */ nlt_docid from "<owner>"."DR$<index_name>$N" order by nlt_docid

Manually running OPTIMIZE_INDEX on this index generates errors:




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

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