Tuesday, March 22, 2016
GoldenGate ERROR OGG-00665 OCI Error describe for query (status = 4031-ORA-04031
Problem Summary & Problem Description
Developers started to perform DML operation on Huge Volume tables,
Oracle Goldengate Extract Abended with Error OGG-00665.
Errors in Report File as follows
2016-03-21 09:44:31 ERROR OGG-00665 OCI Error describe for query (status = 4031-ORA-04031: unable to allocate 4000 bytes of shared memory ("shared pool","SELECT banner FROM v$version","sga heap(1,0)
","kglsim heap")), SQL<Not available>.
2016-03-21 09:44:31 ERROR OGG-01668 PROCESS ABENDING.
Resolution:
we increased memory structure "SGA" for database, issue is resolved
--Nikhil Tatineni--
--Oracle GoldenGate--
Querys to monitor RAC
following few Query's will help to find out culprits- Query to check long running transaction from last 8 hours Col Sid Fo...
-
How to kill blocking session on object ? STEP1: Initially we need to find out blocking session on object SELECT o.owner, o...
-
Hey Guys, Tested handlecollisions parameter in replicat and performed DML on source database Results as follows --- scenari...
-
If the replicat or pump is abended on the trail with seqno and RBA with error message " ERROR OGG-01028 Incompatible recor...