How to Transport a SQL Tuning Set (STS)
(Doc ID 456019.1)
Last updated on MAY 19, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Goal
The Purpose of this Document is to Show the Steps needed to Transport a SQL Tuning Set (STS) from One Database server to another Database Server.
This is illustrated by moving information from 10g to 11g, but this could equally apply to information from 11g to 11g or any later version.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| Create the Staging Table ON THE SOURCE SYSTEM ( IN this case 10.2 ) |
| Populate the table TEST using DBMS_SQLTUNE.PACK_STGTAB_SQLSET THE SOURCE SYSTEM (IN this case 10.2 ) |
| Export the table table test on THE SOURCE SYSTEM ( IN this case 10.2.) |
| Move the Export file to the Destination Server |
| Import on the Destination system ( IN this CASE it was 11.2) |
| Unpack the table using DBMS_SQLTUNE.UNPACK_STGTAB_SQLSET on the Destination system ( IN this CASE it was 11.2) |