Solution : https://service.sap.com/sap/support/notes/762808 (SAP Service marketplace login required)
Summary :
This SAP Note provides guidelines on managing Oracle's keep pool in the context of SAP environments. It details when and how to use the keep pool for buffering specific segments like tables and indexes to prevent their frequent unloading from the buffer cache. The note outlines the procedures for setting up and adjusting configurations for both keep and default pools in Oracle, and discusses performance monitoring techniques using various Oracle views and statistics. Solutions include adjusting Oracle parameters and tailoring buffer allocations to improve database performance by ensuring critical data remains in memory, optimizing access times for essential transactions.
Key words :
terms frequently asked questions, extremely fast response times, correct access path corrupt, maximum size - rough rule, additionally required main memory, recycle pool plays practically, minimum size - rough rule, 'oracle blocks'>db_block_lru_latches = <current, additional main memory requirements, table/index blocks buffered
Related Notes :
| 832343 | FAQ: Clustering factor |
| 766349 | FAQ: Oracle SQL optimization |
| 618868 | FAQ: Oracle performance |