Automatic SQL Tuning can be invoked through a server utility called SQL Tuning Advisor using Oracle Enterprise Manager. The following details step by step instructions on how to get to SQL Tuning Advisor.
-
Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!
Tuning poor performing sql’s using oracle 10g enterprise manager’s automatic sql tuning advisor 2011-09-27
Tuning poor performing sql’s using oracle 10g enterprise manager’s automatic sql tuning advisor