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