My Oracle Support Banner

The Binary Filter is Causing a Hang of ctx_ddl.sync_index (Doc ID 2406423.1)

Last updated on JANUARY 10, 2023

Applies to:

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


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 and 12.1.
However, no delay occurs in 12.2.


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.