:

AWR Report Shows High % and Wait Times

The Problem

I was using an AWR report in order to carry out some testing on a DEV environment. After generating the AWR report, I noticed that the percentage differences and wait times on the report looked wrong. None of the percentages tallied up to 100% and the numbers were huge for a lot of the sections in the report.

I was running Oracle 11g but I don’t think it matters what Oracle version you are running, as this is an OS setting issue.

The Cause

Right click My Computer -> Properties -> Advanced tab -> Startup and Recovery “settings” button, and you should see something similar to the below:

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS=”Windows Server 2003 Enterprise x64 Edition” /noexecute=optout /fastdetect

The problem is that the above line should contain “/usepmtimer”. After speaking with a guy from the systems admin team he advised that this was the cause.

The Solution

Change the setting in the above location to include the /usepmtimer command, as in the below:

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS=”Windows Server 2003 Enterprise x64 Edition” /noexecute=optout /fastdetect /usepmtimer

You will then need to restart the server in order for the changes to take affect, and then re-run your report.

If you are still seeing the CPU time in the top 5 timed events section this might be expected and nothing to worry about.

Like it, share it...

Category: Database Tuning


Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *