Allocation of cursors
edited Jul 14, 2015 10:02AM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered
Hi,
We have several replicats over the past few days we have see the 'Replicat Fails With OGG-00869 , Ora-01000: Maximum Open Cursors Exceeded' error'. I added a new replicat recently so this is a tipping point perhaps
Can anyone shed light on how GoldenGate manages cursors, when are they opened and closed, this is a development databases so its not that busy, i wouldn't expect there to be a high number of cursors
SQL> select a.value, s.username, s.sid, s.serial#
from v$sesstat a, v$statname b, v$session s
where a.statistic# = b.statistic# and s.sid=a.sid
0