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

What Is Automatic Shared Memory Management?

Until Oracle 9i, the Oracle server allotted the required memory for fixed SGA and other internal allocations. The common problems with improper SGA sizing are undersized memory, leading to poor performance and out-of-memory errors (ORA-4031); and oversized memory, leading to wasted memory and latch contention. This scenario has changed with the introduction of Automatic Shared Memory Management, which is described in the following paragraphs.

Automatic Shared Memory Management (ASMM) is the new manageability feature that enables Oracle Database 10g to automatically determine the appropriate values for SGA components within the total size limits of SGA. The commonly tuned SGA components are the database ...

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