O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required