Oracle 视图 V$IOSTAT_FILE 官方解释,作用,如何使用详细说明
本站中文解释
Oracle中的视图V$IOSTAT_FILE是一个状态视图,显示I/O状态信息,包括每个文件写入和读取发出的数据视图。它用来检查指定文件的写操作和读操作是否正常,并评估数据库系统的I/O性能。
使用V$IOSTAT_FILE,需要先打开定义的计数器,可以使用OEM的Cloud Control或以下的命令:
alter system setstatistic_level=ALL;
要查看某个文件的I/O状态,可以使用如下查询:
SELECT * FROM V$IOSTAT_FILE WHERE FILE#=;
或者指定数据库文件:
SELECT * FROM V$IOSTAT_FILE WHERE FILENAME=’/’;
官方英文解释
V$IOSTAT_FILE
displays information about disk I/O statistics of database files (including data files, temp files, and other types of database files).
I/O statistics for Data files and Temp files are provided for each file. All other file types (for example, control files, log files, archive logs, and so on) have their statistics consolidated into one entry in the view.
Column | Datatype | Description |
---|---|---|
|
|
File identification number |
|
|
Type of file (for example, log file, data file, and so on) |
|
|
Name of the file, in the case of a data file or temp file. For all other files, a corresponding string to be displayed (for example, |
|
|
Number of single block megabytes read |
|
|
Number of single block megabytes written |
|
|
Number of multiblock megabytes read |
|
|
Number of multiblock megabytes written |
|
|
Number of single block read requests |
|
|
Number of single block write requests |
|
|
Number of synchronous single block read requests |
|
|
Number of multiblock read requests |
|
|
Number of multiblock write requests |
|
|
Total service time (in milliseconds) for single block read requests |
|
|
Total service time (in milliseconds) for single block write requests |
|
|
Latency for single block synchronous reads (in milliseconds) |
|
|
Total service time (in milliseconds) for multiblock read requests |
|
|
Total service time (in milliseconds) for multiblock write requests |
|
|
Indicates whether asynchronous I/O is available for the file ( |
|
|
I/O library used to access the file. Possible values include:
|
|
|
Number of read retries on error |
|
|
The ID of the container to which the data pertains. Possible values include:
|