Skip to main content
Question

Unable to allocate shared memory error - Urgent


RajanKhatri7
Sidekick (Customer)
Forum|alt.badge.img+8

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.

 

This topic has been closed for replies.

4 replies

Forum|alt.badge.img+10
  • Hero (Customer)
  • 48 replies
  • March 18, 2021

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.


Dumeesha Wanigarathna
Superhero (Partner)
Forum|alt.badge.img+16

Hi @RajanKhatri7 ,

 

If it is possible check after restarting the database. Notices several cases solved by this.

 

 


Yasas Kasthuriarachchi
Superhero (Employee)
Forum|alt.badge.img+30

Hi @RajanKhatri7,

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 


RajanKhatri7
Sidekick (Customer)
Forum|alt.badge.img+8
  • Author
  • Sidekick (Customer)
  • 57 replies
  • March 19, 2021

Hi @Dumeesha Wanigarathna , @dmanuele   @Yasas_AK,

 

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.

 

 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings