Oracle Text index

From: Michael Calisi <oracle455_at_gmail.com>
Date: Wed, 9 Sep 2015 09:46:49 -0400
Message-ID: <CAJkYCMFmA=mFXyAwoeO5x_JmD9wybz9ysmFkqOKj9tQc7KV8fg_at_mail.gmail.com>

Starting to notice row lock contention when using my Oracle Text indexes. This appears in my AWR reports all the time. Any idea how I can stop this locking when the text index is being used?

      Elapsed                  Elapsed Time
        Time (s)    Executions  per Exec (s)  %Total   %CPU    %IO    SQL Id
---------------- -------------- ------------- ------ ------ ------

---

         4,376.7 206 21.25 12.7 .1 52.3 f1xfww55nj0xp
begin ctxsys.syncrn(:idxownid, :idxoname, :idxid, :ixpid, :rtabnm, :flg, :smallr
); end;

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 09 2015 - 15:46:49 CEST