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 11.2.0.3 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Symptoms

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.

Cause

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