7.228 V$FLASHFILESTAT
V$FLASHFILESTAT
displays statistics about Database Smart Flash Cache.
By taking snapshots of SINGLEBLKRDS
and SINGLEBLKRDTIM_MICRO
, you can easily calculate the average latency of all the flash files in a given time period
Column | Datatype | Description |
---|---|---|
|
|
The file number of the flash file |
|
|
Name and path of the flash file |
|
|
Size of the flash file, in bytes |
|
|
Indicates whether this flash file is enabled or not |
|
|
Number of reads to the flash file |
|
|
Cumulative latency of reading blocks from this particular flash file/device, in microseconds |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
Oracle Database Administrator’s Guide for more information about configuring Database Smart Flash Cache