Performance Tuning - Approach
Hello Experts,
I have given task to tune DB but no details has been given( At lease for now with respect to SQL Tuning then move on to Instance/System Tuning when required)
I wonder where to start in order to reach my goal -if someone can help me.
-I would like to find TOP SQLs and Tune Queries one by one ( Please provide SQL query for this if anyone has handy).
-I do not want to take TOP SQL from AWR as it only picks TOp SQL only during given time (but I would like to see what was the most resource intensive queries in whole last week time which I cant pull in single AWR report)