Jonathan Lewis - articles http://www.jlcomp.demon.co.uk/ind_misc.html Index on Miscellaneous Items (JL Comp) Mon, 30 May 2011 01:41:30 -0400 240 Ponyfish - http://www.ponyfish.com Trouble-shooting http://www.jlcomp.demon.co.uk//trouble_shooting_i.html http://www.jlcomp.demon.co.uk//trouble_shooting_i.html Buffer Flag http://www.jlcomp.demon.co.uk//buf_flag.html http://www.jlcomp.demon.co.uk//buf_flag.html It’s the data http://www.jlcomp.demon.co.uk//the_data_i.html http://www.jlcomp.demon.co.uk//the_data_i.html Trouble http://www.jlcomp.demon.co.uk//snap_trouble.html http://www.jlcomp.demon.co.uk//snap_trouble.html Statistics http://www.jlcomp.demon.co.uk//stats_i.html http://www.jlcomp.demon.co.uk//stats_i.html Reporting Workloads http://www.jlcomp.demon.co.uk//snapshots2.html http://www.jlcomp.demon.co.uk//snapshots2.html Dual http://www.jlcomp.demon.co.uk//dual.html http://www.jlcomp.demon.co.uk//dual.html Kiddy Scripts http://www.jlcomp.demon.co.uk//kiddy_scripts.html http://www.jlcomp.demon.co.uk//kiddy_scripts.html Not Proof http://www.jlcomp.demon.co.uk//not_proof.html http://www.jlcomp.demon.co.uk//not_proof.html x$kcbsw http://www.jlcomp.demon.co.uk//buffer_usage.html http://www.jlcomp.demon.co.uk//buffer_usage.html Using 10053 http://www.jlcomp.demon.co.uk//using_10053.html http://www.jlcomp.demon.co.uk//using_10053.html Workarea Sizing http://www.jlcomp.demon.co.uk//untested.html http://www.jlcomp.demon.co.uk//untested.html Function-based indexes http://www.jlcomp.demon.co.uk//no_fbi.html http://www.jlcomp.demon.co.uk//no_fbi.html How many Tables http://www.jlcomp.demon.co.uk//how_many.html http://www.jlcomp.demon.co.uk//how_many.html Pushing Predicates http://www.jlcomp.demon.co.uk//push_pred.html http://www.jlcomp.demon.co.uk//push_pred.html Autotuning http://www.jlcomp.demon.co.uk//autotune_i.html http://www.jlcomp.demon.co.uk//autotune_i.html Optimizer Enhancements http://www.jlcomp.demon.co.uk//opt_enhance_i.html http://www.jlcomp.demon.co.uk//opt_enhance_i.html Trending Statspack http://www.jlcomp.demon.co.uk//statspack_trend.html http://www.jlcomp.demon.co.uk//statspack_trend.html Uniqueness http://www.jlcomp.demon.co.uk//unique_constraint.html http://www.jlcomp.demon.co.uk//unique_constraint.html Statistical problem http://www.jlcomp.demon.co.uk//stats_trouble.html http://www.jlcomp.demon.co.uk//stats_trouble.html Cost http://www.jlcomp.demon.co.uk//cost_calcs.html http://www.jlcomp.demon.co.uk//cost_calcs.html Hinted SQL http://www.jlcomp.demon.co.uk//hinted_sql.html http://www.jlcomp.demon.co.uk//hinted_sql.html Pipeline Functions http://www.jlcomp.demon.co.uk//pipelines.html http://www.jlcomp.demon.co.uk//pipelines.html Hash chains http://www.jlcomp.demon.co.uk//hash_chains.html http://www.jlcomp.demon.co.uk//hash_chains.html Analytics http://www.jlcomp.demon.co.uk//analytics.html http://www.jlcomp.demon.co.uk//analytics.html Statspack http://www.jlcomp.demon.co.uk//statspack_02.html http://www.jlcomp.demon.co.uk//statspack_02.html Subquery Factoring http://www.jlcomp.demon.co.uk//subq_factor.html http://www.jlcomp.demon.co.uk//subq_factor.html Trouble-shooting 101 http://www.jlcomp.demon.co.uk//tkprof_01.html http://www.jlcomp.demon.co.uk//tkprof_01.html Testing PX http://www.jlcomp.demon.co.uk//testing_03.html http://www.jlcomp.demon.co.uk//testing_03.html 2+2 = 5 http://www.jlcomp.demon.co.uk//testing_02.html http://www.jlcomp.demon.co.uk//testing_02.html MV non-bug http://www.jlcomp.demon.co.uk//MV_non_bug.html http://www.jlcomp.demon.co.uk//MV_non_bug.html Index usage http://www.jlcomp.demon.co.uk//index_usage.html http://www.jlcomp.demon.co.uk//index_usage.html Podcast http://www.dbazine.com/podcasts/podcast-lewis http://www.dbazine.com/podcasts/podcast-lewis Review http://www.dbazine.com/oracle/or-articles/foot14 http://www.dbazine.com/oracle/or-articles/foot14 Buffer Handles http://www.jlcomp.demon.co.uk//buffer_handles.html http://www.jlcomp.demon.co.uk//buffer_handles.html Buffer Busy Waits http://www.jlcomp.demon.co.uk//bbw.html http://www.jlcomp.demon.co.uk//bbw.html Meaning of errors http://www.jlcomp.demon.co.uk//oerr.html http://www.jlcomp.demon.co.uk//oerr.html Deterministic Functions http://www.jlcomp.demon.co.uk//deterministic.html http://www.jlcomp.demon.co.uk//deterministic.html Research http://www.jlcomp.demon.co.uk//snark.html http://www.jlcomp.demon.co.uk//snark.html 10gR2 Sorting http://www.jlcomp.demon.co.uk//hints_and_sorts.html http://www.jlcomp.demon.co.uk//hints_and_sorts.html V$rollstat http://www.jlcomp.demon.co.uk//snap_rollstat.html http://www.jlcomp.demon.co.uk//snap_rollstat.html 10g Plan table http://www.jlcomp.demon.co.uk//plan_table_hack.html http://www.jlcomp.demon.co.uk//plan_table_hack.html Outline Hacking http://www.jlcomp.demon.co.uk//outline_hack.html http://www.jlcomp.demon.co.uk//outline_hack.html Cache_advice http://www.jlcomp.demon.co.uk//Cache_advice.html http://www.jlcomp.demon.co.uk//Cache_advice.html Log issues http://www.jlcomp.demon.co.uk//log_file_writes.html http://www.jlcomp.demon.co.uk//log_file_writes.html Top 5 http://www.jlcomp.demon.co.uk//statspack_01.html http://www.jlcomp.demon.co.uk//statspack_01.html Partitioning Problems http://www.jlcomp.demon.co.uk//17_partition_problems.html http://www.jlcomp.demon.co.uk//17_partition_problems.html www.dbazine.com http://www.dbazine.com http://www.dbazine.com Rebuilding Indexes http://www.jlcomp.demon.co.uk//indexes_i.html http://www.jlcomp.demon.co.uk//indexes_i.html Workload audit http://www.jlcomp.demon.co.uk//evidence.html http://www.jlcomp.demon.co.uk//evidence.html