ORA-04031: unable to allocate 61536 bytes of shared memory (“shared pool”,”GGS_DDL_TRIGGER_BEFORE”)

While register the golden gate extract process causing the following error in alert log file.

Integrated Extract need memory if 3 process running then 3 GB memory it needed.

$register extract ext01 database

Error OGG-00221 cannot register or unregister Extract ext01 because of the following SQL error: OCI Error 4,031.

-- On checking the alert log getting the following error:
ORA-04031: unable to allocate 61536 bytes of shared memory ("shared pool","GGS_DDL_TRIGGER_BEFORE")

Cause: Error occurred due to less size allocated to streams pool in SGA.

Solution: Check the memory parameter first. Increase the memory parameter first. Then Increase the memory of stream pool.

SQL> show parameter memory

— Increase the memory target and max parameter

SQL> show parameter sga

— Increase the sga target and max parameter

SQL>alter system set streams_pool_Size =500m;

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply