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

TIMESTAMP

NUMBER

Number of seconds elapsed since 00:00 UTC, January 1, 1970

IO_SIZE

NUMBER

Size of the I/O, in KB.

IO_OFFSET

NUMBER

Offset into the device of the I/O

DEVICE_NAME

VARCHAR2(513)

Name of the device to which the I/O was targeted

PROCESS_NAME

VARCHAR2(64)

Name of the process that issued the I/O

TOTAL_LATENCY

NUMBER

Total time the I/O spent in the kernel (in milliseconds)

SETUP_LATENCY

NUMBER

Time spent during initial I/O setup before sending to SCSI target device driver (in milliseconds)

QUEUE_TO_HBA_LATENCY

NUMBER

Time spent in the SCSI target device driver before being sent to the Host Bus Adaptor (in milliseconds)

TRANSFER_LATENCY

NUMBER

Time spent in the Host Bus Adaptor and physically transferring the I/O to the storage device (in milliseconds)

CLEANUP_LATENCY

NUMBER

Time spent freeing resources used by the completed I/O (in milliseconds)

PID

NUMBER

Process ID that issued the I/O

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

See Also:

  • “V$IO_OUTLIER”

  • “V$LGWRIO_OUTLIER”


数据运维技术 » Oracle 视图 V$KERNEL_IO_OUTLIER 官方解释,作用,如何使用详细说明