Ctxsys.syncrn Commit Callback Running For Hours Generating Millions Of Direct Path Reads And Writes
Last updated on FEBRUARY 09, 2018
Applies to:Oracle Text - Version 188.8.131.52 to 184.108.40.206 [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.
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