CTXsys syncm

From: Michael Calisi <oracle455_at_gmail.com>
Date: Wed, 23 Sep 2015 15:32:28 -0400
Message-ID: <CAJkYCMESTTvVWeG6y30JohFG3yXBOtUSz2PeJ6QvQRd2HzpTpg_at_mail.gmail.com>



f1xfww55nj0xp

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

I are seeing a lot of performance impact due to the oracle text sync routines being called on each commit. Anyone know why every time my ctx sync is accessed it causes a enq: TX - row lock

Any suggestions where I can start looking?

Thanks

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 23 2015 - 21:32:28 CEST

Original text of this message