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://feedproxy.google.com/~r/JonathanLewisArticles/~3/FCDpgbiblfs/trouble_shooting_i.html http://www.jlcomp.demon.co.uk//trouble_shooting_i.html http://www.jlcomp.demon.co.uk//trouble_shooting_i.html Buffer Flag http://feedproxy.google.com/~r/JonathanLewisArticles/~3/QER5lWU7IKc/buf_flag.html http://www.jlcomp.demon.co.uk//buf_flag.html http://www.jlcomp.demon.co.uk//buf_flag.html It’s the data http://feedproxy.google.com/~r/JonathanLewisArticles/~3/ZE8qkLLjOag/the_data_i.html http://www.jlcomp.demon.co.uk//the_data_i.html http://www.jlcomp.demon.co.uk//the_data_i.html Trouble http://feedproxy.google.com/~r/JonathanLewisArticles/~3/vY07qkYzszI/snap_trouble.html http://www.jlcomp.demon.co.uk//snap_trouble.html http://www.jlcomp.demon.co.uk//snap_trouble.html Statistics http://feedproxy.google.com/~r/JonathanLewisArticles/~3/lg1PbU0rd4E/stats_i.html http://www.jlcomp.demon.co.uk//stats_i.html http://www.jlcomp.demon.co.uk//stats_i.html Reporting Workloads http://feedproxy.google.com/~r/JonathanLewisArticles/~3/OWdZoGlbPyI/snapshots2.html http://www.jlcomp.demon.co.uk//snapshots2.html http://www.jlcomp.demon.co.uk//snapshots2.html Dual http://feedproxy.google.com/~r/JonathanLewisArticles/~3/Q2lG1OMY02k/dual.html http://www.jlcomp.demon.co.uk//dual.html http://www.jlcomp.demon.co.uk//dual.html Kiddy Scripts http://feedproxy.google.com/~r/JonathanLewisArticles/~3/6eyh9frQFTU/kiddy_scripts.html http://www.jlcomp.demon.co.uk//kiddy_scripts.html http://www.jlcomp.demon.co.uk//kiddy_scripts.html Not Proof http://feedproxy.google.com/~r/JonathanLewisArticles/~3/ROGdzGJ55Yk/not_proof.html http://www.jlcomp.demon.co.uk//not_proof.html http://www.jlcomp.demon.co.uk//not_proof.html x$kcbsw http://feedproxy.google.com/~r/JonathanLewisArticles/~3/diSK92BXBmE/buffer_usage.html http://www.jlcomp.demon.co.uk//buffer_usage.html http://www.jlcomp.demon.co.uk//buffer_usage.html Using 10053 http://feedproxy.google.com/~r/JonathanLewisArticles/~3/61nprypyH2E/using_10053.html http://www.jlcomp.demon.co.uk//using_10053.html http://www.jlcomp.demon.co.uk//using_10053.html Workarea Sizing http://feedproxy.google.com/~r/JonathanLewisArticles/~3/Eehk3DcyNjs/untested.html http://www.jlcomp.demon.co.uk//untested.html http://www.jlcomp.demon.co.uk//untested.html Function-based indexes http://feedproxy.google.com/~r/JonathanLewisArticles/~3/JReQt5oSgGg/no_fbi.html http://www.jlcomp.demon.co.uk//no_fbi.html http://www.jlcomp.demon.co.uk//no_fbi.html How many Tables http://feedproxy.google.com/~r/JonathanLewisArticles/~3/ybYOXGk5E2w/how_many.html http://www.jlcomp.demon.co.uk//how_many.html http://www.jlcomp.demon.co.uk//how_many.html Pushing Predicates http://feedproxy.google.com/~r/JonathanLewisArticles/~3/Wi_BSNC5rTk/push_pred.html http://www.jlcomp.demon.co.uk//push_pred.html http://www.jlcomp.demon.co.uk//push_pred.html Autotuning http://feedproxy.google.com/~r/JonathanLewisArticles/~3/M0JY3tuQiYs/autotune_i.html http://www.jlcomp.demon.co.uk//autotune_i.html http://www.jlcomp.demon.co.uk//autotune_i.html Optimizer Enhancements http://feedproxy.google.com/~r/JonathanLewisArticles/~3/hH3wYYfBbUs/opt_enhance_i.html http://www.jlcomp.demon.co.uk//opt_enhance_i.html http://www.jlcomp.demon.co.uk//opt_enhance_i.html Trending Statspack http://feedproxy.google.com/~r/JonathanLewisArticles/~3/I11Q3CmG2mM/statspack_trend.html http://www.jlcomp.demon.co.uk//statspack_trend.html http://www.jlcomp.demon.co.uk//statspack_trend.html Uniqueness http://feedproxy.google.com/~r/JonathanLewisArticles/~3/qeEZhU6Dxds/unique_constraint.html http://www.jlcomp.demon.co.uk//unique_constraint.html http://www.jlcomp.demon.co.uk//unique_constraint.html Statistical problem http://feedproxy.google.com/~r/JonathanLewisArticles/~3/OMXbVkJP1Z0/stats_trouble.html http://www.jlcomp.demon.co.uk//stats_trouble.html http://www.jlcomp.demon.co.uk//stats_trouble.html Cost http://feedproxy.google.com/~r/JonathanLewisArticles/~3/-OZFXSDbKow/cost_calcs.html http://www.jlcomp.demon.co.uk//cost_calcs.html http://www.jlcomp.demon.co.uk//cost_calcs.html Hinted SQL http://feedproxy.google.com/~r/JonathanLewisArticles/~3/sT9Eh-QxT4o/hinted_sql.html http://www.jlcomp.demon.co.uk//hinted_sql.html http://www.jlcomp.demon.co.uk//hinted_sql.html Pipeline Functions http://feedproxy.google.com/~r/JonathanLewisArticles/~3/0JzDefXlbnw/pipelines.html http://www.jlcomp.demon.co.uk//pipelines.html http://www.jlcomp.demon.co.uk//pipelines.html Hash chains http://feedproxy.google.com/~r/JonathanLewisArticles/~3/EGdYbBg118c/hash_chains.html http://www.jlcomp.demon.co.uk//hash_chains.html http://www.jlcomp.demon.co.uk//hash_chains.html Analytics http://feedproxy.google.com/~r/JonathanLewisArticles/~3/2qCPESFHc1o/analytics.html http://www.jlcomp.demon.co.uk//analytics.html http://www.jlcomp.demon.co.uk//analytics.html Statspack http://feedproxy.google.com/~r/JonathanLewisArticles/~3/neDJHzeKlFg/statspack_02.html http://www.jlcomp.demon.co.uk//statspack_02.html http://www.jlcomp.demon.co.uk//statspack_02.html Subquery Factoring http://feedproxy.google.com/~r/JonathanLewisArticles/~3/nQfvqzGHOzU/subq_factor.html http://www.jlcomp.demon.co.uk//subq_factor.html http://www.jlcomp.demon.co.uk//subq_factor.html Trouble-shooting 101 http://feedproxy.google.com/~r/JonathanLewisArticles/~3/7okc9txdolc/tkprof_01.html http://www.jlcomp.demon.co.uk//tkprof_01.html http://www.jlcomp.demon.co.uk//tkprof_01.html Testing PX http://feedproxy.google.com/~r/JonathanLewisArticles/~3/dOfv_ZgfZaA/testing_03.html http://www.jlcomp.demon.co.uk//testing_03.html http://www.jlcomp.demon.co.uk//testing_03.html 2+2 = 5 http://feedproxy.google.com/~r/JonathanLewisArticles/~3/bLm2Kx3wSbg/testing_02.html http://www.jlcomp.demon.co.uk//testing_02.html http://www.jlcomp.demon.co.uk//testing_02.html MV non-bug http://feedproxy.google.com/~r/JonathanLewisArticles/~3/YUn6l1VooVQ/MV_non_bug.html http://www.jlcomp.demon.co.uk//MV_non_bug.html http://www.jlcomp.demon.co.uk//MV_non_bug.html Index usage http://feedproxy.google.com/~r/JonathanLewisArticles/~3/AV2VrOz_dP8/index_usage.html http://www.jlcomp.demon.co.uk//index_usage.html http://www.jlcomp.demon.co.uk//index_usage.html Podcast http://feedproxy.google.com/~r/JonathanLewisArticles/~3/ong1IgJ0Wao/podcast-lewis http://www.dbazine.com/podcasts/podcast-lewis http://www.dbazine.com/podcasts/podcast-lewis Review http://feedproxy.google.com/~r/JonathanLewisArticles/~3/KlSvoBWAuGA/foot14 http://www.dbazine.com/oracle/or-articles/foot14 http://www.dbazine.com/oracle/or-articles/foot14 Buffer Handles http://feedproxy.google.com/~r/JonathanLewisArticles/~3/ITv1gP6Wg3w/buffer_handles.html http://www.jlcomp.demon.co.uk//buffer_handles.html http://www.jlcomp.demon.co.uk//buffer_handles.html Buffer Busy Waits http://feedproxy.google.com/~r/JonathanLewisArticles/~3/2cKqobzfaAg/bbw.html http://www.jlcomp.demon.co.uk//bbw.html http://www.jlcomp.demon.co.uk//bbw.html Meaning of errors http://feedproxy.google.com/~r/JonathanLewisArticles/~3/8g8-A4AbTNQ/oerr.html http://www.jlcomp.demon.co.uk//oerr.html http://www.jlcomp.demon.co.uk//oerr.html Deterministic Functions http://feedproxy.google.com/~r/JonathanLewisArticles/~3/idYgQYkXFH8/deterministic.html http://www.jlcomp.demon.co.uk//deterministic.html http://www.jlcomp.demon.co.uk//deterministic.html Research http://feedproxy.google.com/~r/JonathanLewisArticles/~3/uJ4vXfje-9k/snark.html http://www.jlcomp.demon.co.uk//snark.html http://www.jlcomp.demon.co.uk//snark.html 10gR2 Sorting http://feedproxy.google.com/~r/JonathanLewisArticles/~3/m1ncm7uvTZM/hints_and_sorts.html http://www.jlcomp.demon.co.uk//hints_and_sorts.html http://www.jlcomp.demon.co.uk//hints_and_sorts.html V$rollstat http://feedproxy.google.com/~r/JonathanLewisArticles/~3/HslsgnPtcqA/snap_rollstat.html http://www.jlcomp.demon.co.uk//snap_rollstat.html http://www.jlcomp.demon.co.uk//snap_rollstat.html 10g Plan table http://feedproxy.google.com/~r/JonathanLewisArticles/~3/lzDEpfPJGDk/plan_table_hack.html http://www.jlcomp.demon.co.uk//plan_table_hack.html http://www.jlcomp.demon.co.uk//plan_table_hack.html Outline Hacking http://feedproxy.google.com/~r/JonathanLewisArticles/~3/ETd1cRNds4g/outline_hack.html http://www.jlcomp.demon.co.uk//outline_hack.html http://www.jlcomp.demon.co.uk//outline_hack.html Cache_advice http://feedproxy.google.com/~r/JonathanLewisArticles/~3/a17Gy52VotY/Cache_advice.html http://www.jlcomp.demon.co.uk//Cache_advice.html http://www.jlcomp.demon.co.uk//Cache_advice.html Log issues http://feedproxy.google.com/~r/JonathanLewisArticles/~3/A3p0LnW_0CI/log_file_writes.html http://www.jlcomp.demon.co.uk//log_file_writes.html http://www.jlcomp.demon.co.uk//log_file_writes.html Top 5 http://feedproxy.google.com/~r/JonathanLewisArticles/~3/0SX9yXICA4w/statspack_01.html http://www.jlcomp.demon.co.uk//statspack_01.html http://www.jlcomp.demon.co.uk//statspack_01.html Partitioning Problems http://feedproxy.google.com/~r/JonathanLewisArticles/~3/k8GeP9vKLgM/17_partition_problems.html http://www.jlcomp.demon.co.uk//17_partition_problems.html http://www.jlcomp.demon.co.uk//17_partition_problems.html www.dbazine.com http://feedproxy.google.com/~r/JonathanLewisArticles/~3/TghraZ4X5WI/ http://www.dbazine.com http://www.dbazine.com Rebuilding Indexes http://feedproxy.google.com/~r/JonathanLewisArticles/~3/b2vSVJSmFv4/indexes_i.html http://www.jlcomp.demon.co.uk//indexes_i.html http://www.jlcomp.demon.co.uk//indexes_i.html Workload audit http://feedproxy.google.com/~r/JonathanLewisArticles/~3/jiToNZus7rg/evidence.html http://www.jlcomp.demon.co.uk//evidence.html http://www.jlcomp.demon.co.uk//evidence.html