Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page
Go to next page
View PDF


V$DB_CACHE_ADVICE contains rows that predict the number of physical reads for the cache size corresponding to each row. The rows also compute a "physical read factor," which is the ratio of the number of estimated reads to the number of reads actually performed by the real buffer cache during the measurement interval .

See Also:


Column Datatype Description
ID NUMBER Buffer pool identifier (ranges from 1 to 8)
NAME VARCHAR2(20) Buffer pool name
BLOCK_SIZE NUMBER Block size in bytes for buffers in this pool. Possible values: the standard block size, the power of 2 non-standard block sizes, 2048, 4096, 8192, 16384, 32768.
ADVICE_STATUS VARCHAR2(3) Status of the advisory. ON indicates it is currently running; OFF indicates it is disabled (in this case the estimates are historical and calculated when last enabled).
SIZE_FOR_ESTIMATE NUMBER Cache size for prediction (in megabytes)
SIZE_FACTOR NUMBER Size factor with respect to the current cache size
BUFFERS_FOR_ESTIMATE NUMBER Cache size for prediction (in terms of buffers)
ESTD_PHYSICAL_READ_FACTOR NUMBER Physical read factor for this cache size, which is the ratio of the number of estimated physical reads to the number of reads in the real cache. If there are no physical reads in the real cache, the value of this column is null.
ESTD_PHYSICAL_READS NUMBER Estimated number of physical reads for this cache size
ESTD_PHYSICAL_READ_TIME NUMBER Estimated disk read time
ESTD_PCT_OF_DB_TIME_FOR_READS NUMBER Estimated disk time as a percentage of the total time