Ctxsys.syncrn Commit Callback Running For Hours Generating Millions Of Direct Path Reads And Writes
(Doc ID 2359384.1)
Last updated on FEBRUARY 09, 2018
Applies to:Oracle Text - Version 22.214.171.124 to 126.96.36.199 [Release 11.2 to 12.2]
Information in this document applies to any platform.
On a large partitioned table with a local Text index (of indextype CONTEXT), some partitions' rows are updated very frequently and it is noticed that after updating some of those partitions' Text index key columns, the commit on those updates takes a very long time (hours).
A trace on a session that updated 1 base table row showed that ctxsys.syncrn started running and performed millions of direct path reads and writes on the DR#IDXNAME<ixp_id>$R LOB segment and the DATA column length for ROWNO=0 had gotten up to 43 megabytes in size, and its LOB segment (the $R DATA column) had grown to 306 gigabytes while the base table had only about 2.4 million rows in it. The $R LOB segment had been defined as BASICFILE NOCACHE NOLOGGING RETENTION.
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