Oracle Database Discussions

Dear All,

I am having some performance issue on my one application. That application runs excellent under MS Windows 2003 32-bit on Sun Blade Server with Intel processor while same application with same Database Oracle 11g on HP Server of same specification Quad Core 3 GHz CPU with 8 GB RAM is slower, front end of the same application responses most of the time slower and for some screens on that server it takes too long to appear from menu. AWR report has been generated which shows following result. Any suggestions to improve this please at Oracle or Operating System level would highly be appreciated.


Operating System Statistics - Detail
Snap Time Load %busy %user %sys %idle %iowait

14-Apr 01:00:02 0.00 0.12 0.04 0.09 0.00 99.88
14-Apr 02:00:42 0.00 0.13 0.04 0.09 0.00 99.87
14-Apr 03:00:18 0.00 0.12 0.04 0.09 0.00 99.88
14-Apr 04:00:54 0.00 0.17 0.08 0.10 0.00 99.83
14-Apr 05:00:30 0.00 0.12 0.04 0.09 0.00 99.88
14-Apr 06:00:07 0.00 0.12 0.03 0.09 0.00 99.88
14-Apr 07:00:43 0.00 0.12 0.03 0.09 0.00 99.88
14-Apr 08:00:19 0.00 0.12 0.03 0.09 0.00 99.88
14-Apr 09:00:58 0.00 0.15 0.04 0.11 0.00 99.85
14-Apr 10:00:37 0.00 0.15 0.04 0.11 0.00 99.85
14-Apr 11:00:17 0.00 0.12 0.03 0.09 0.00 99.88

%iowait is always 99.8%. What does that mean?

Thanks