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...
-
In order to configure and install goldengate we have to enable Minimum Supplemental logging at database level. Supplemental logging ...
-
When goldengate process is unable to process transaction it generates a discard and makes process abended. When ever a discard is gene...
-
Hybrid Columnar Compression enables us to implement different levels of data compression and provides cost-savings at storage le...