Move SQL Tuning Sets between Oracle instances

October 1, 2008

STS is a part of Oracle 10g's SQL Tuning Advisor feature. Each tuning set contains one or more SQL statements, plus the context information needed to interpret them correctly. A tuning set is used as input to the SQL Tuning Advisor, which examines the statements and makes recommendations for improving them.

The article continues at http://www.builderau.com.au/program/oracle/soa/Move-SQL-Tuning-Sets-between-Oracle-instances/0,339028441,339292232,00.htm