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.” ...
Get Oracle Core: Essential Internals for DBAs and Developers 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.
