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

The results will then be found in dba_advisor_tasks, dba_advisor_findings, dba_advisor_recommendations and dba_advisor_rationale