4.315 DBA_HIST_DB_CACHE_ADVICE
DBA_HIST_DB_CACHE_ADVICE
displays historical predictions of the number of physical reads for the cache size corresponding to each row.
This view contains snapshots of V$DB_CACHE_ADVICE
.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
Buffer Pool identifier (ranges from 1 to 8) |
|
|
|
Cache size for prediction (in terms of buffers) |
|
|
|
Buffer pool name |
|
|
|
Block size in bytes for buffers in the pool (the standard block size, the power of 2 nonstandard block sizes, 2048, 4096, 8192, 16384, or 32768) |
|
|
|
Status of the advisory:
|
|
|
|
Cache size for prediction (in megabytes) |
|
|
|
Size factor with respect to the current cache size |
|
|
|
Physical reads for the cache size |
|
|
|
Base physical reads for the cache size |
|
|
|
Actual physical reads for the cache size |
|
|
|
Estimated physical read time for the cache size |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also: