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 unlimited access to documents by upgrading to Premium Membership.
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