371 total views, 10 views today

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

govindan How to run SQL Tuning Advisor in SQL Developer
Connect me

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 šŸ™‚
govindan How to run SQL Tuning Advisor in SQL Developer
Connect me
By | 2017-05-21T23:55:35+00:00 May 21st, 2017|Categories: Oracle|Tags: , |0 Comments
Like us on Facebook.
Connect!