Buffer Pool Performance Analysis
Beyond the Basic Hit Ratio…..
- What Data is Necessary?
– Detailed Access Information
– Meaningful Period
– Meaningful Elapsed Time
» A few Minutes is NOT Meaningful
– Must be for the Entire System
– High volume of trace records
» SMF or GTF not viable options