Oracle 视图 V$KERNEL_IO_OUTLIER 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图V$KERNEL_IO_OUTLIER是一个动态视图,用于查看节点上存在IO I/O异常活动的操作。这个视图显示了节点上非常长的IO操作,这些操作可能导致性能问题。
该视图显示的列有:实例名称、用户会话ID、活动的实例操版本号和 SQL-ID、执行时间、 IO输出大小。
使用这个视图可以得到关于激活操作占用IO系统资源最多的信息,从而改善性能。 系统管理人员可以使用该视图识别DBA中潜在的可能存在性能问题的 IO操作,并进行相应的优化和管理。
官方英文解释
V$KERNEL_IO_OUTLIER
contains entries corresponding to I/Os that have taken a long time (more than 500 ms) to complete.
Use this view to see the individual kernel components of I/Os for which there are any occasional delays in serving disk I/O requests by the storage subsystem.
Note:
Although this view exists on all platforms in Oracle Database 12c, it is only populated on the Solaris platform.
Column | Datatype | Description |
---|---|---|
|
|
Number of seconds elapsed since 00:00 UTC, January 1, 1970 |
|
|
Size of the I/O, in KB. |
|
|
Offset into the device of the I/O |
|
|
Name of the device to which the I/O was targeted |
|
|
Name of the process that issued the I/O |
|
|
Total time the I/O spent in the kernel (in milliseconds) |
|
|
Time spent during initial I/O setup before sending to SCSI target device driver (in milliseconds) |
|
|
Time spent in the SCSI target device driver before being sent to the Host Bus Adaptor (in milliseconds) |
|
|
Time spent in the Host Bus Adaptor and physically transferring the I/O to the storage device (in milliseconds) |
|
|
Time spent freeing resources used by the completed I/O (in milliseconds) |
|
|
Process ID that issued the I/O |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
-
“V$IO_OUTLIER”
-
“V$LGWRIO_OUTLIER”