O'Reilly logo

Oracle Core: Essential Internals for DBAs and Developers by Jonathan Lewis

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

Memory Management

There are so many different chains running through the data cache that it’s hard to know where to begin, so I’m going to step backward and start with the easiest bit. For the purposes of this discussion, I am ignoring any version of Oracle prior to version 9i because I want to talk about granules—the large-scale unit of memory that Oracle uses for shared memory areas.

Granules

Oracle Corp. introduced automatic system memory management (ASMM) in 10g with the intention of eliminating the question, “How much memory should I set for the db_cache_size (data cache) and how much should I put into the shared_pool_size (code cache)?” The official (though not always appropriate) answer to this question from 10g onward is, “Don’t ask.” ...

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