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 identifierNAME
: The buffer pool nameBLOCK_SIZE
: The size of the database block for this poolSIZE_FOR_ESTIMATE
: The cache size for prediction in megabytesBUFFERS_FOR_ESTIMATE
: The cache size for prediction in number of buffersESTD_PHYSICAL_READS
: The estimated number of physical reads for the cache size evaluatedESTD_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
andV$DB_OBJECT_CACHE
sections in this appendix
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.