Oracle教程 2023-02-24

Oracle 视图 V$FLASHFILESTAT 官方解释，作用，如何使用详细说明

本站中文解释

1. Oracle视图V$FLASHFILESTAT：该视图是用于存储于数据库使用的闪存数据文件的统计数据，例如，文件的访问次数，最大的访问时间等。

2. 用途：该视图用于监控闪存数据文件的使用情况和状态，以及数据库是否正确地使用了闪存缓冲器，以及闪存缓冲器是否有益。

3. 如何使用：该视图可以使用以下SQL语句查看当前闪存数据文件的信息：
select * from v$flashfilestat; 或 select * from v$silostat;

官方英文解释

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

本站中文解释

官方英文解释

相关推荐