What are important sections in AWR to understand Bottleneck
Hi,
I would like to understand that important key areas/sections of the AWR report to review to identify possible cause of performance bottlenecks?
What are Major information in AWR should be reviewed and considered for performance tuning?
I know this is generic question, we would start the TOP 5 events and drill down with each top IO and CPU consuming queries etc.,
However, I would like to learn to interpret the AWR in a better way to understand the major bottlenecks and sections needs more importance.
Any advise on AWR on practical world to understand the real problem in the database. Perf Tuning is really mystery where you see lot of information, but could not understand which piece of information is really critical/bottleneck and how to intrepret the details provided by AWR report
I would like to understand that important key areas/sections of the AWR report to review to identify possible cause of performance bottlenecks?
What are Major information in AWR should be reviewed and considered for performance tuning?
I know this is generic question, we would start the TOP 5 events and drill down with each top IO and CPU consuming queries etc.,
However, I would like to learn to interpret the AWR in a better way to understand the major bottlenecks and sections needs more importance.
Any advise on AWR on practical world to understand the real problem in the database. Perf Tuning is really mystery where you see lot of information, but could not understand which piece of information is really critical/bottleneck and how to intrepret the details provided by AWR report
0