The following new Dynamic performance views for 12c has been described as below by Glenn Fawcett
- V$IO_OUTLIER : tracks the attributes of an IO. The size, latency as well as ASM information is recorded.
- V$LGWRIO_OUTLIER : tracks information specifically on Log writer IO.
- “V$KERNEL_IO_OUTLIER” : This table dives into the KERNEL to provide information about Kernel IO. This table uses my old friend Dtrace to provide information about where the waits are occurring when Kernel IO is in-play. This shows the time for every step involved in the setup and teardown Kernel IO. This information allows us to more easily debug anomalies in the IO stack.