AWR report shows wait time is high but OS shows wait time as normal
965676Oct 2 2012 — edited Oct 2 2012Hi,
We have a Oracle 10g database with RAC and Dataguard. When we look at the AWR report, the wait time shown by Oracle for this database is very high.
Service Time : 15.36%
Wait Time : 84.64%
This would imply Oracle is waiting for resources 85% of the time and only processing SQL queries during 15% of its non-idle time.
However when we check the OS (RHEL), the iowait is only about 10% and the CPU is 80% idle. This means that that processing horsepower is available.
As such, the results between the OS and Oracle database (AWR report) seems contradictory. OS says we have CPU/IO capacity, however Oracle says we don't.
Any ideas on how on where to start the investigation? We have stared to look at the timed events in the AWR report.
Thanks in advance.
Regards
Faiz