Oracle Database 11gR2 Performance Tuning Cookbook

V$DB_CACHE_ADVICE

This view contains predictions on the number of physical reads obtained when varying the cache size.

Fields

The most relevant view fields are as follows:

• ID: The buffer pool identifier
• NAME: The buffer pool name
• BLOCK_SIZE: The size of the database block for this pool
• SIZE_FOR_ESTIMATE: The cache size for prediction in megabytes
• BUFFERS_FOR_ESTIMATE: The cache size for prediction in number of buffers
• ESTD_PHYSICAL_READS: The estimated number of physical reads for the cache size evaluated
• ESTD_PHYSICAL_READ_FACTOR: The estimated physical read factor for the cache size evaluated, a ratio to the number of reads in the cache

See also

• The V$BUFFER_POOL_STATISTICS and V$DB_OBJECT_CACHE sections in this appendix