Awrautomatic workload repository oracle diagnostic pack. Each buffer pool uses the same lru replacement policy. Oracle database 2 day dba for information about using the memory advisor. If the pool is static, the value in this column is the same as the current size of the pool.
This pool manages olap data pages, which are equivalent to data blocks. Oracle database performance tuning guide to learn how to interpret buffer cache advisory. The goal of the keep buffer pool is to retain objects in memory, thus avoiding io operations. Oracle database performance tuning guide, 10g release 2 10. Lets start with the fact that the advisory always gives you the data based on the current size of your buffer cache with 10% increments starting with 10% and ending with 200% of the current cache size.
Im honestly not sure what value does it give you with regard to buffer cache advisory. Configuring and using the shared pool and large pool. Oracle database performance tuning guide oracle help center. Interpreting and using the buffer cache advisory statistics. In the following example, the shared pool advisory shows that the shared pool is sized to. Oracle database 10g automatic sga memory management.
Oracle maintains a default buffer pool for objects that have not been assigned to a specific buffer pool. If a resize is in progress, records new target size in terms of buffers. When sizing the buffer pool, avoid using additional buffers that do not contribute or. Any single segment that accounts for a substantial portion more than 10% of. Otherwise, the value in this column is the same as the current number of buffers. Oracle database performance tuning guide oracle docs. This chapter discusses the memory architecture of an oracle database. How to predict io reduction from a larger data cache. This chapter discusses the memory architecture of an oracle database instance. Product manager, oracle corporation arup nanda manager, db systems, starwood hotels. Oracle database maintains a default buffer pool for objects that are not assigned to a specific buffer pool.
460 762 1483 1270 685 995 275 97 173 1303 1287 218 551 1103 920 971 156 1355 426 80 349 1437 1071 1176 1175 1528 322 742 526 1177 1017 1369 964 341 1314 266 943 227 585 909