OracleSQL tuning script

00_01_prepare.sql
00_01_prepare_11g.sql
00_02_plusheader.sql
00_03_peekmem.sql
00_04_sgavars.sql
00_05_dump_block.sql
02_01_SQL_Explain_10g.sql
02_01_SQL_Explain_11g.sql
04_01_hist_test.sql
05_01_FTS_IOCost_Cal.sql
05_02_deduce_cpucycles_01.sql
05_03_FTS_Cost_Demo.sql
05_04_Parallel_IOCost_Cal.sql
05_05_Parallel_IOCost_Cal_2.sql
05_06_Parallel_CPUCost_Cal.sql
05_07_IRS_IOCost_Cal.sql
05_08_TABIR_IOCost_Cal.sql
05_09_IRS_Cost_Demo.sql
05_10_Sort_Cost_Demo.sql
05_11_NLJ_FTS_IOCost_Cal.sql
05_12_NLJ_IUS_IOCost_Cal.sql
05_13_NLJ_IRS_IOCost_Cal.sql
05_14_NLJ_IRS_Cache_IOCost_Cal.sql
05_15_NLJ_IRS_TA_IOCost_Cal.sql
05_16_SMJ_Cost_Demo.sql
05_17_HJ_Cost_Demo_11g.sql
05_18_Parallel_HJ_Cost_Demo_11g.sql
05_91_10053_FTS(T_Objects)_demo.trc
05_92_10053_IRS(T_OBJECTS_IDX1)_DEMO.trc
05_93_10053_SORT_DEMO.trc
05_94_10053_HJ_Demo_11gr2.trc
05_95_10053_JOIN_Parallel_Demo.trc
06_01_mon_stats.sql
06_02_dump_seg_header.sql
06_03_countftscr.sql
06_04_dba_seg_info.sql
06_05_dba_seg_buff.sql
06_06_bufflist.sql
06_07_managesql.sql
06_08_cr_trace_log.sql
06_09_cache_tab_blocks.sql
06_10_cursorheaps_10g.sql
06_11_cursorheaps_11g.sql
06_12_GetSQLStats.pl
06_13_MultiCursors.pl
06_14_OracleNewSort.pl
06_15_Hash.pl
06_16_RecursiveCall_Demo.sql
06_17_BufferChain.pl
07_01_all_sql_features.sql
07_02_all_sql_hints.sql
07_03_dump_cursorheap.sql
07_04_CreateStoredOutline_01.sql
07_05_Trace_CreateStoredOutline.sql
07_06_CreateStoredOutline_02.sql
07_07_CreateStoredOutline_03.sql
07_08_StoredOutline_Reparse.sql
07_09_UseStoredOutline.sql
07_10_DiableStoredOutline_Reparse.sql
07_11_SPM_AutoCapture.sql
07_12_SPM_AutoCapture_Cont.sql
07_13_SPM_ManualLoad.sql
07_14_SPM_ManualSQLTune.sql
07_15_SPM_ImportFromStroredOutline.sql
07_16_SPM_EvaluatePlan.sql
07_17_SPM_NotFoundPlanbase.sql
07_18_AutoTune_StatisticsMissed.sql
07_19_AutoTune_StatisticsStale.sql
07_20_AutoTune_NewIndex.sql
07_21_AutoTune_IndexOverlap.sql
07_22_AutoTune_RestructeSQL.sql
07_23_AutoTune_Parallel.sql
07_24_AutoTune_AlternativePlan.sql
07_25_AutoTune_SQLProfile.sql
07_26_SPA_OptimizerChange.sql
07_27_SPA_UsingSQLProfile.sql
07_28_SQLAccessAdvisorDemo.sql
07_29_report_sqlaccess_task.sql
08_01_all&ses&my_optimizer_env_10g.sql
08_02_all&ses&my_optimizer_env_11g.sql
08_03_shared_cursor.sql

• We are an exchange download platform that only provides communication channels. The downloaded content comes from the internet. Except for download issues, please Google on your own.
• The downloaded content is provided for members to upload. If it unintentionally infringes on your copyright, please contact us.
• Please use Winrar for decompression tools
• If download fail, Try it againg or Feedback to us.
• If downloaded content did not match the introduction, Feedback to us，Confirm and will be refund.
• Before downloading, you can inquire through the uploaded person information

Nothing．