Oracle RDBMS Version: 19c
Enterprise Manager Cloud Control version: 13c Release 5
OS : RHEL 8.9
I understand that disk latency is not a metric covered under ASH/AWR as it outside the DB.
But, from AWR reports, you can deduce that the storage tier was not doing good. For example, screenshot of AWR report shows that an average wait of 99.98 milliseconds for each "log file sync" wait . And this is a clear indication of slow storage.
I would like to know if there is a similair way to know disk latency from ASH Analytics page of OEM (in real time)?
I mean from this page ?
Or can I ascertain disk latency from Linux level ?