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.
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
For Oracle ASM, the name of the first disk to which the I/O was issued
Latency seen on the first disk
For Oracle ASM, the name of the second disk to which the I/O was issued
Latency seen on the second disk
For Oracle ASM, the name of the third disk to which the I/O was issued
Latency seen on the third disk
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