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