Hi Team,
We are getting “Unable to allocate 130184 bytes of shared memory (Shared Pool) error. Currently we are using APPS9UPD14
Kindly check the screenshot below:
Can you please help to resolve this issue ?
Thank you.
Unable to allocate shared memory error - Urgent
Userlevel 4
+8
This topic has been closed for comments
The Oracle documentation has these notes on the ORA-04031 error:
ORA-04031: unable to allocate nn bytes of shared memory
Cause: More shared memory is needed than was allocated in the shared pool.
Action: If the shared pool is out of memory, either use the dbms_shared_pool package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the INIT.ORA parameters "shared_pool_reserved_size" and "shared_pool_size". If the large pool is out of memory, increase the INIT.ORA parameter "large_pool_size".
The ORA-04031 error also happens when you are using automatic memory management (sga_max_size), and the memory specific is too small.
Userlevel 7
+16
Hi
If it is possible check after restarting the database. Notices several cases solved by this.
Userlevel 7
+30
Hi
Appreciate if you could confirm if above suggestion from Dumeesha (restarting the database) resolved the issue or if any other steps resolved it kindly update since it would be valuable for others as well.
Thanks & Best Regards,
Yasas
Userlevel 4
+8
Hi
Thank you so much for the suggestion. We have restarted our DB servers and increased share memory pool as well. Users have not reported same error message so far. I will confirm once again before EOD today.
Thank you for your help.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.