Units for application_wait_time, cpu_time, elapsed_time in logs provided by Oracle DB extensions

[abhijitmorye]

Hello Community,

I was working on creating a dashboard using data provided by Oracle DB monitoring extension and I have one doubt regarding the units of metrics provided in logs by extension. Oracle DB extension fetched the the logs from all oracle instance with metrics like, application_wait_time, cluster_wait_time, DB_time, for each executed query on instance. Please find the below snapshot of the data fetched by extension.

As you can see in the snapshot, for first query, elapsed time is very high however rows fetched by the query are in thousands only. This is where I am getting confused as even though i consider it as microseconds value, it is giving me very high value which looks unreasonable.

Can you help me on this to understand what is the exact unit value of all these time metrics.

Thanks