Database DataWarehousing (MOSC)

MOSC Banner

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center