V$LGWRIO_OUTLIER
contains entries corresponding to Log Writer (LGWR) process I/Os that have taken a long time (more than 500 ms) to complete. Use this view to see if there any occasional delays in serving disk I/O requests by the storage subsystem.
Column | Datatype | Description |
---|---|---|
|
|
I/O function name of the delayed I/O |
|
|
Size of the I/O in bytes |
|
|
Wait event name that was used to track the I/O |
|
|
Name of the file to which the I/O was targeted |
|
|
Time taken to complete the I/O (in milliseconds) |
|
|
For Oracle ASM, the name of the first disk to which the I/O was issued |
|
|
Latency seen on the first disk (in milliseconds) |
|
|
For Oracle ASM, the name of the second disk to which the I/O was issued |
|
|
Latency seen on the second disk (in milliseconds) |
|
|
For Oracle ASM, the name of the third disk to which the I/O was issued |
|
|
Latency seen on the third disk (in milliseconds) |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also: