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

Understanding Memory Advisor

The Memory Advisor helps you tune the size of your memory structures. You can use the Memory Advisor only when automatic memory tuning is disabled in the database. When ASMM is disabled, the Memory Advisor is responsible for optimizing system memory for the database instance. Using the Memory Advisor, you can let Oracle tune the memory according to the database needs or use the SGA Advisor or the PGA Advisor to set the total size of the SGA or PGA and optimal values for their components.

The Memory Advisor consists of three advisors to give you recommendations on shared pool (SGA), buffer cache (SGA), and PGA. The main components of the shared pool are the library cache and the dictionary cache. The library cache ...

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