René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

dbms_sqltune

.... Yet to be finished ....
This package is new with Oracle 10g and can be used to tune SQL Statements.
dbms_sqltune is sort of a command line interface for tuning operartions, while Oracle Enterprise Manager can do the same thing (and much more) with a GUI.
In order to set up an automatic SQL tuning environment, the following three procedures in this package are used: create_tuning_task, execute_tuning_task and report_tuning_task

create_tuning_task

execute_tuning_task

execute_tuning_task