How to read AWR to identify DB workload
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.
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.
0