Monday, March 9, 2015

Moving sql profiles with SQLT in oracle database

How to Move SQL Profiles from One Database to Another (Including to Higher Versions) (Doc ID 457531.1)

First create and accept a profile

create a staging table

pack the profile in table

move staging table using datapump from one database to other

import table

unpack staging table

SQLTXPLAN
SQLT Diagnostic Tool (Doc ID 215187.1)

Install sqltplan unzip sqlt
cd sqlt/install

sqdrop.sql
sqcreate.sql

Give details

Once completes

Goto cd sqlt/utl

@coe_xfr_profile.sql

enter sql id

run it before once so it will be cached

select hash

file will be created in same folder

move file to database you want and  execute it

No comments:

Post a Comment

Featured Post

Apply Patch 22191577 latest GI PSU to RAC and DB homes using Opatch auto or manual steps

Patch 22191577: GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.4.160119 (JAN2016) Unzip the patch 22191577 Unzip latest Opatch Version in or...