Hi All,
My Manager is repeatedly asking me to come up with top 5 to 10 key aspects I need to analyze from the AWR report. I'm not an expert in this area, I have shared the below couple of points, but he is not satisfied, he is looking for something really informative and helps in decision making.
1) Look out for the missing Variable Binding in the SQL queries.
2) Check the Top SQLs by Elapsed Time, compare the snapshots, make changes in the expensive queries, tune them and see whether they make any difference. I have tried the insert query with and without APPEND hint in an iteration. One with APPEND hint took more processing time, though the cost of the query is pretty less for this, it takes a lot of Redo operation and Physical IO.
He is giving a scenario, after our project deployment in the Database server, performance goes down and he wants to find out why it is so and what went wrong? What are all the factors caused this issue? I need to get this information from the AWR report only.
Kindly share all your comments, inputs and any useful links, I'm ready to work on this with your support, kindly help, thank you so much!!