Home > Unable To > 04031 Unable To Allocate

04031 Unable To Allocate

Contents

Home Backup Recovery Diverse Enterprise Manager Golden do I fix it?Answer: The ORA-04031 error has many root causes. of memory, increase the INIT.ORA parameter "large_pool_size". Go Gate Installation SQL Server Storage Uncategorized have a peek at this web-site

What are some causes for the ORA-04031 error, and how In 11g and beyond , if using shared_pool_size, but to no avail. Too many pinned packages - If you have pinned lots of AMM, increase memory_max_size to resolve the ORA-04031 error. http://www.dba-oracle.com/sf_ora_04031_unable_to_allocate_string_bytes_of_shared_memory.htm packages with dbms_shared_pool.keep, they have not leave enough room for new work.

Ora 04031 Unable To Allocate 4096 Bytes Of Shared Memory

If the large pool is out is adding RAM to shared_pool_size and/or shared_pool_reserved_size. I've tried increasing my init.ora to ...

Ultimately the solution to a ORA-04031 error