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
`FLASHFILE#`	`NUMBER`	The file number of the flash file
`NAME`	`VARCHAR2(513)`	Name and path of the flash file
`BYTES`	`NUMBER`	Size of the flash file, in bytes
`ENABLED`	`NUMBER`	Indicates whether this flash file is enabled or not
`SINGLEBLKRDS`	`NUMBER`	Number of reads to the flash file
`SINGLEBLKRDTIM_MICRO`	`NUMBER`	Cumulative latency of reading blocks from this particular flash file/device, in microseconds
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data