:

RSSDatabase Tuning

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 […]

Continue Reading

CPU Time in Top 5 Timed Events on Statspack/AWR Report

When I first take a look at a statspack or Automatic Workload Repository (AWR) report, and there have been no reported performance  problems, I home in on the Top 5 Timed Events section toward the top of the AWR report. It is from here that you are able to get clues as to which direction you should go in, and therefore […]

Continue Reading