How to run SQL Tuning Advisor in SQL Developer

Home/Oracle/How to run SQL Tuning Advisor in SQL Developer

How to run SQL Tuning Advisor in SQL Developer

 

Required grants to run the SQL Advisor

  • Login as SYSDBA and grant the below privileges to the user who is going to run the SQL ADVISOR

 

 

Run SQL Tuning Advisor

 

  • Open SQL Developer >> Write the SQL >> Right Click & Select

 

052217_0432_HowtorunSQL1 How to run SQL Tuning Advisor in SQL Developer

 

  • The SQL Tuning Advisor will come to the bottom of the page. Click on each tab and review the SQL tuning advisor output

 

052217_0432_HowtorunSQL2 How to run SQL Tuning Advisor in SQL Developer

pgn How to run SQL Tuning Advisor in SQL Developer

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply 🙂
pgn How to run SQL Tuning Advisor in SQL Developer
By | 2017-05-21T23:55:35+00:00 May 21st, 2017|Categories: Oracle|Tags: , |0 Comments
Like us on Facebook.
Connect!