|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
.... 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