Database Administration (MOSC)

MOSC Banner

how to run SQL tuning adviser manually, instead of through OEM?

edited Apr 5, 2023 4:39PM in Database Administration (MOSC) 12 commentsAnswered ✓

hi


how to run SQL tuning adviser manually, instead of OEM?


I can run the SQL tuning adviser via OEM and most of the time I use the below options.


How to run this manually using exact same options below.




In OEM




1) go to menu: Performance > SQL > SQL Tuning Adviser

press next



2) Click "SQL Tunning Sets" on right side of the screen

press next



3) The clicking "Create" button on left side of the screen

press next



4) Then I enter name for the SQL Tunning Set, and specify Owner (like a SYS user), then I click next

press next



5) Then I choose option: "Load SQL statements one time only", and I choose Data Source as "Cursor Cache"

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