The Binary Filter is Causing a Hang of ctx_ddl.sync_index

(Doc ID 2406423.1)

Last updated on JULY 06, 2018

Applies to:

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

Goal

CTX_DDL.SYNC_INDEX is hanging on "Disk file operations I/O" when syncing excel documents with many pages.

A SYSTEM STATE (level=10) trace shows the following:
------------
System global information:
processes: base 0x00000010D0EF3DA0, size 300, cleanup 0x00000010D0EFAC90
allocation: free sessions 0x00000010E0E35ED0, free calls 0x0000000000000000
control alloc errors: 0 (process), 0 (session), 0 (call), 0 (transaction)
PMON latch cleanup depth: 0
seconds since PMON's last scan for dead processes: 59
system statistics:

(session) sid: 122 ser: 26223 trans: 0x0000000000000000, creator: 0x00000010F0F42C78
flags: (0x8000041) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
flags2: (0x40009) -/-/INC
DID: 0001-001E-0001CFD4, short-term DID: 0001-001E-0001CFD5
txn branch: 0x0000000000000000
edition#: 133 user#/name: 101/MINI_TM_SERVER2
oct: 170, prv: 0, sql: 0x0000000F896856C0, psql: 0x0000001119587AF8
stats: 0x00000010EFD15628, PX stats: 0x00007FF7CE6765DC
ksuxds FALSE at location: 0
service name: PLMDB
client details:
O/S info: user: ***\lcladmin, term: DVCDWDV01, ospid: 25108:12808
machine: ROOT\*** program: OblMtidx.exe
application name: OblMtidx.exe, hash value=677121619
Current Wait Stack:
Not in wait; last wait ended 7386 min 9 sec ago
Wait State:
fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1
Session Wait History:
elapsed time of 7386 min 9 sec since last wait
0: waited for 'Disk file operations I/O'
FileOperation=0x2, fileno=0x7, filetype=0x2
wait_id=77642 seq_num=12108 snap_id=1
wait times: snap=0.000130 sec, exc=0.000130 sec, total=0.000130 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 1.311804 sec of elapsed time
1: waited for 'Disk file operations I/O'
FileOperation=0x2, fileno=0x12, filetype=0x2
wait_id=77641 seq_num=12107 snap_id=1
wait times: snap=0.000112 sec, exc=0.000112 sec, total=0.000112 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.075303 sec of elapsed time

===================================================

This problem was confirmed in Ver 11.2.0.4 and 12.1.
However, no delay occurs in 12.2.

Solution

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