8.25 V$KERNEL_IO_OUTLIER
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: