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.
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 SupportAlso, 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
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 BlogORA-04031: unable to allocate nn bytes of shared