Skip to Content

Unable to allocate X bytes of shared memory

Nov 22, 2017 at 09:32 AM


avatar image

Hi everyone,

We're running several ERP+EWM systems on Oracle databases, which regularly die due to an ORA-00604 or ORA-04031 (unable to allocate 40 bytes of shared memory).

This seems to be a common problem and from what i could gather, extending the shared_pool_size Parameter in ora.ini accordingly usually solves it. We tried this several times (it's now way bigger than recommended), but all that accomplished was that the systems take longer to crash. They still do though.

The crashes usually occur at night when the jobs are running, but not at a specific job. All we can do ATM is restarting the system and wait for it to happen again.

Can someone maybe provide a solution? Or point me to where I should look?



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
James Zhang
Nov 23, 2017 at 12:42 AM

Hi Martin,

Would you please also check whether there is os memory limit on oracle user (oracle/ora<sid>) or oracle executable ?

Best regards,

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi James,

Thanks for your quick answer! The limit actually was way too low for our requirements. I upped it and that hopefully fixed it.

Thanks again!