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
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-lReceived on Wed Sep 23 2015 - 21:32:28 CEST