$Header: 215187.1 readme.txt 11.4.5.8 2013/05/10 carlos.sierra $
How to Migrate a Plan using SQL Plan Management (SPM)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Notes:
1. AWR requires a license of the Oracle Diagnostics Pack
2. SQL Tuning Sets require a license of the Oracle Tuning Pack
Options to migrate a plan from one system to another using SPM:
Option 1:
Steps:
1. Create SQL Plan Baseline (SPB) in Source
1.a From a Cursor; or
1.b From AWR (requires Tuning Pack license)
2. Package & Export SPB from Source
3. Import & Restore SPB into Target
pros: Simple
cons: Requires a SPB in Source system
Option 2: (requires Tuning Pack license)
Steps:
1. Create SQL Tuning Set (STS) in Source
1.a From a Cursor; or
1.b From AWR
2. Package & Export STS from Source
3. Import & Restore STS into Target
4. Create SPB from STS in Target
pros: No SPB is required in Source system
cons: Requires license for SQL Tuning Pack
Option 3: (requires Tuning Pack license)
Steps:
1. Use CoE Load SQL Baseline in Source
2. Use output of 1 in Target. Follow instructions in log
pros: Allows you to create SPB with plan from modified SQL (opt)
cons: Requires license for SQL Tuning Pack
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Oracle数据库监控检测的相关脚本
需积分: 0 34 浏览量
2023-05-10
15:36:34
上传
评论
收藏 151KB ZIP 举报
sqlhc.zip （42个子文件） 
sqlhc utl 
coe_load_sql_profile.sql 13KB pxhcdr.sql 75KB bde_chk_cbo.sql 85KB coe_gen_sql_profile.sql 5KB mvhcdr.sql 77KB coe_load_sql_baseline.sql 11KB coe_xfr_sql_profile_remote.sql 20KB spm pack_and_exp_sts.sql 1KB create_sts_from_cur.sql 2KB drop_cur.sql 756B create_spb_from_cur.sql 999B coe_load_sql_baseline.sql 11KB create_sts_from_awr.sql 3KB display_cur.sql 2KB pack_and_exp_spb.sql 2KB display_sts.sql 3KB create_spb_from_sts.sql 1KB evolve_spb.sql 2KB drop_spb.sql 1KB create_spb_from_awr.sql 4KB display_spb.sql 2KB imp_and_unpack_sts.sql 877B alter_spb.sql 3KB drop_sts.sql 1011B imp_and_unpack_spb.sql 603B
readme.txt 1KB display_awr.sql 1KB flush_cursor.sql 1KB planx.sql 59KB profiler.sql 23KB coe_xfr_sql_profile.sql 19KB coe_gen_sql_patch.sql 9KB mon 2_mon_capture.sql 1KB 1_mon_repository.sql 544B 0_mon_readme.txt 388B 3_mon_reports.sql 4KB readme.txt 512B util_planx.sql 59KB sqlhc_sta.sql 4KB sqlhc.sql 299KB sqldx.sql 48KB sqlhc_tcb.sql 2KB资源评论
