Scaling for Database Expansion
When your large database application needs to allocate a large piece of contiguous memory in the shared pool for the batch job or updates, Oracle has to flush all unused objects from the memory pool and merge the resulting free memory chunks. The unavailability of a large piece of memory would result in ORA-04031 errors. This could still happen with Oracle Database 10g if the database cannot allocate enough free memory for the shared pool or large pool as needed. If you have sufficient physical memory on the server and enable automatic memory management, the database can get rid of most of the ORA-04031 errors.
In an ASMM-enabled database, when the database wants to allocate a large object into the shared pool but ...
Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
