My Oracle Support Banner

Oracle TEXT : ctx_ddl.sync_index のバイナリフィルタ処理でハングすることがある (Doc ID 2426485.1)

Last updated on APRIL 22, 2019


Oracle Text - バージョン 以降
  本文書は英語の文書 <Document 2406423.1> (最終メジャー更新日: 2018年07月06日) の日本語翻訳版です。


CTX_DDL.SYNC_INDEX は、複数ページの Excel を同期する際に、"Disk file operations I/O" によって、性能劣化することがあります。

SYSTEM STATE (level=10) トレースを下記に記載します。:
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


この問題は、 および 12.1 で確認されています。
しかし、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!


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