Enable small_r_row feature for Oracle Text index

(Doc ID 2328575.1)

Last updated on DECEMBER 19, 2017

Applies to:

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

Symptoms

On : 12.1.0.2 version, Creating/Maintaining context indexes

ACTUAL BEHAVIOR
---------------
enq: TX - row lock contention

INST_ID SID SERIAL# USERNAME EVENT BLOCKING_SESSION BLOCKING_INSTANCE STATUS SQL_ID
---------------- ----------------- ------------------------- -------------------------------------------------------------------------------------------------------------------------------------- 2 34 33527 ERWIN_WEB_PORTAL enq: TX - row lock contention 184 2 ACTIVE gwr578vq39gcw

SQL Details: gwr578vq39gcw

SQL Text:--

SELECT OBJID_RECORD(MODEL_ID, CLASS_ID)
FROM MIR_META_CLASS
WHERE MODEL_ID=:B1 AND EXISTS
(SELECT /*+ DYNAMIC_SAMPLING (o, 5) */ *
FROM TABLE(:B2 ) O
WHERE O.COLUMN_VALUE=CLASS_ID) FOR UPDATE

SQL Details: f1xfww55nj0xp

begin ctxsys.syncrn(:idxownid, :idxoname, :idxid, :ixpid, :rtabnm, :flg, :smallr); end;

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