Home > Unable To > Ora 04031 Unable To Allocate 4096 Bytes Of Shared Memory

Ora 04031 Unable To Allocate 4096 Bytes Of Shared Memory

Contents

Go to ... The ORA-04031 error also happens when you are using automatic memory management (sga_max_size), and the memory specific is too small.

have a peek here

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 Search BC Oracle Sites HomeE-mail Us Oracle Articles New Oracle Articles Oracle TrainingOracle Tips Oracle ForumClass Catalog Remote DBAOracle TuningEmergency 911RAC SupportApps SupportAnalysisDesignImplementationOracle Support

Also, see MOSC notes 146599.1 and 396940.1 for more details for resolving the ORA-04031 error: Heavy fragmentation of the shared pool - This can be fixed by increasing the shared_pool_size or What are some causes for the ORA-04031 error, and how do I fix it?Answer: The ORA-04031 error has many root causes. http://www.dba-oracle.com/sf_ora_04031_unable_to_allocate_string_bytes_of_shared_memory.htm

Ora 04031 Unable To Allocate 4096 Bytes Of Shared Memory

Home Backup Recovery Diverse Enterprise Manager Golden Gate Installation SQL Server Storage Uncategorized

In 11g and beyond , if using AMM, increase memory_max_size to resolve the ORA-04031 error. Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog

ORA-04031: unable to allocate nn bytes of shared