OReilly.Oracle.SQL Tuning Pocket Reference

《OReilly.Oracle.SQL Tuning Pocket Reference》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、OracleSQLTuningPocketReferenceByMarkGurryPublisher:O'ReillyPubDate:January2002ISBN:0-596-00268-8Tableof•Pages:108Contents•Index•ReviewsReader•Reviews•ErrataCopyrightChapter1.OracleSQLTuningPocketReferenceSection1.1.IntroductionSection1.2.TheSQLOptimizersSection1.3.Rule-BasedOptimizerP

2、roblemsandSolutionsSection1.4.Cost-BasedOptimizerProblemsandSolutionsSection1.5.ProblemsCommontoRuleandCostwithSolutionsSection1.6.HandySQLTuningTipsSection1.7.UsingSQLHintsSection1.8.UsingDBMS_STATStoManageStatisticsSection1.9.UsingOutlinesforConsistentExecutionPlansIndexChapter1.Ora

3、cleSQLTuningPocketReferenceSection1.1.IntroductionSection1.2.TheSQLOptimizersSection1.3.Rule-BasedOptimizerProblemsandSolutionsSection1.4.Cost-BasedOptimizerProblemsandSolutionsSection1.5.ProblemsCommontoRuleandCostwithSolutionsSection1.6.HandySQLTuningTipsSection1.7.UsingSQLHintsSect

4、ion1.8.UsingDBMS_STATStoManageStatisticsSection1.9.UsingOutlinesforConsistentExecutionPlans1.1IntroductionThisbookisaquick-referenceguidefortuningOracleSQL.ThisisnotacomprehensiveOracletuningbook.Thepurposeofthisbookistogiveyousomelightreadingmaterialonmy"realworld"tuningexperiencesan

5、dthoseofmycompany,MarkGurry&Associates.WetunemanylargeOraclesites.Manyofthosesites,suchasbanks,largefinancialinstitutions,stockexchanges,andelectricitymarkets,areincrediblysensitivetopoorperformance.Withmoreandmoreemphasisbeingplacedon24/7operation,thepressuretomakeSQLperforminproduct

6、ionbecomesevenmorecritical.WhenanewSQLstatementisintroduced,wehavetobeabsolutelysurethatitisgoingtoperform.Whenanewindexisadded,wehavetobecertainthatitwillnotbeusedinappropriatelybyexistingSQLstatements.Thisbookaddressestheseissues.Manysitesarenowutilizingthird-partypackagessuchasPeop

7、lesoft,SAP,OracleApplications,Siebel,Keystone,andothers.TuningSQLfortheseapplicationsmustbedonewithoutplacinghintsonSQLstatements,becauseyouareunauthorizedtotouchtheapplicationcode.Obviously,forsimilarreasons,youcan'trewritetheSQL.Butdon'tloseheart;therearemanytipsandtricksinthisrefer

8、encet