(Doc ID 1372190.1)
Last updated on JANUARY 06, 2020
Applies to:Oracle Text - Version 22.214.171.124 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