How to create sql tuning set (STS)manually from a sql statement/query
Hi,
Database : 10gR2
I have one statement running fine in TEST db but not in PROD db, so I am planning to transfer execution plan of one of my query from TEST db to PROD db.
For this I am reffering 'Import/Export SQL Tuning Sets and SQL Profiles' of following page : http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_sqltun.htm
Database : 10gR2
I have one statement running fine in TEST db but not in PROD db, so I am planning to transfer execution plan of one of my query from TEST db to PROD db.
For this I am reffering 'Import/Export SQL Tuning Sets and SQL Profiles' of following page : http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_sqltun.htm
I want to create one SQL Tuning Set(STS) for the statement running in TEST db.I looked at the package DBMS_SQLTUNE but could not find the proedure/funtion to create STS manually from a query.
0