Hi All,
My DB is 11.1. RAC 4 nodes.
Our daily batch processing system worked very slowly for some days. So I generated the WORKLOAD REPOSITORY COMPARE PERIOD REPORT to compare DB status with the baseline (or a normal daily processing).
The report can show diffferent DB workload, but I am not sure which kind of data makes sense to management team or non DBA members.
In another word, I want to show them that our tuning to some SQLs works well, the reason is DB was overburdened at that time.
SGA or other hardwares have no change at all. I noticed DB time and DB CPU have huge differences. And so do active users.
Snapshot Set Begin Snap Id Begin Snap Time End Snap Id End Snap Time Avg Active Users Elapsed Time (min) DB time (min)
1st 47582 25-Apr-11 06:00:09 (Mon) 47591 25-Apr-11 15:00:17 (Mon) 3.53 540.13 1,905.85
2nd 47654 28-Apr-11 06:00:35 (Thu) 47665 28-Apr-11 17:00:08 (Thu) 61.36 659.54 40,469.47
%Diff 1,638.24 22.11 2,023.43
Statistic Name 1st 2nd Diff 1st 2nd %Diff 1st 2nd %Diff
DB time 100.00 100.00 0.00 114,350.97 2,428,168.25 2,023.43 4.87 14.48 197.33
DB CPU 61.40 17.78 -43.61 70,208.42 431,831.36 515.07 2.99 2.57 -14.05
But my question is whether these metrcis can convince the others of DB's heavy workload.
Can someone give me some help, please?
best regards,
Leon