Oracle专家高级编程+(清晰).pdf

3星(超过75%的资源)
所需积分/C币:50 2018-03-17 16:59:00 14.38MB PDF
87
收藏 收藏
举报

着重调优的好书,非常经典,其中对于tkprof,autotrace等有很深刻的讲解
About the Author Although I've been working for Oracle since version 7.0.9(that's 1993 for people who don' t mark time by Oracle versions), I've been working with Oracle since version 5.1.5c (a $99 single-user version for dos that came on 360K floppy disks). Before starting at OracIe, I worked tor over six years as a systems integrator building large-scale, heterogeneous databases and applications, mostly for military and government customers These days, I spend a great deal of iime working with the Oracle database and, more specifically working with people who are working with the Oracle database. I interact directly with customers, specifying and building their systems or, more frequently helping them rebuild(or tune)them. In addition i am the tom behind the"AskTom"column in Oracle magazine, answering people' s questions about the oracle database and its tools. On a typical day, I receive and answer 30 to 40 questionsathttp://a a special best of" installment in the magazine (all of the questions are available on the Web and are stored naturally enough in an (racle database). As I mentioncd carlier, I'm also the author of Expert One on One Oracle( Wrox Press, 2001), a book about generai use of the database and how to develop successful Oracle appl ications Basically, I spend a lot of time helping people be successful with the Oracle database. During free moments, I build applications and develop ftware within Oracle Corporation itself About the Tech editors Connor McDonald has 1 I years of Oracle expertise specializing ir performance tuning ranging from Oracle 6 to Oracle 10. In 2002, he won the worldwide Bmc SmartDBA competition, and was voted one of the best speakers at the annual U. K. Oracle conference. Like Tom, he is a member of the Oak Table networka collection of approximately 40 world professionals with a passion for getting the best out of the oracle takase Mogens Norgaard was the first. Oracle Support manager to standardize his group's performance optimization methods exclusively upon Oracle's response time statistics. He is one of the original founders of the oaktable Network, a founder of Miracle A/s, and is a frequent contributor to the 〔 racle-L|is Anjo Kofk, Chief Oracle Technologist, P:eGibe Software Solutions, Inc, has er 16 years of Oracle expcrience. le has-paitnered with ISVs and customers all over the wor d te improve the implernentation and perfOrmance of their systems. Draw ing, on this experience, Anja developed a tuning methodology called Y APB (Yet Another Performance Profiling methodology) that is currently used by the oraperf com web site nathan Lewis is know'n internationally as the author of Practical Oracle &i Building Efficient Databases(Addison. esley, 2001) and as the presenter of the seminar Optimising Oracle - ferformance by Design. He is one of the leading independent, specialists in the U.K., with more than 17 years experience designing, implementing and troubleshooting Oracle-based systems Mark A. Williams is a production DBA in indianapolis, where he lives with his wife Lynda and their two children, David and Elizabeth He holds Oracle Certified Professional: credentials as an Oracle Certified DBA for Oracle, Oracle OradleBi, and Oracle i. he has been working with Oracle since release 7. 0.1. i 6 of the database and is an avid advocate of both Oracle the product and the company He would like to thank Tom for providing such great matcrial to k with on ACKNOWLEDGMENTS INIRODUCTION The Right APproach to Building Application It's a Team effort DBA and developer roles Read the documentation A Guide io the guides Road Maps to reading 10 Avoid the black Box Syndrome Database Independence versus Database dependence ers of Black Box Syndrome it's a database Not a dala dr Use Primary and Forcign Keys Test the Overhead of Referential Integrity Middle Tier Checking Is not a panacea 26 Build a test environmant 9 Test Against Representative Data t Test with a single use 33 Don't Test in a dust-Free I ab 33 Design to Perfor; Don' t Tunc to perform 34 Don't use generic Data Models ign Your Data Mudel for Effi 37 Deline Your Performance Goals fram the start Work to Clear, Specific 41 Collect and l og metrics over Time Don't Do It Because" Everyone Knows You Should 42 Benchmark benchmark. Be rk 43 44 Big remarking Instrument the systor Trace from asktom, oracle. com t for remote Debugging vili Effective Oracle by Design Use Dbms^PPLC∧ TION_INFO. Everywhere,…",.…- 52 Use DEBUG.F in PL/SQL 53 Turn an SOL TRACE in Yo 54 Use Industry-Standard APIs..:**,…… Build Audit Is Not a Four-Letter Word . ·:; 56 Question Authority 57 Beware of Universal Bests aspect Ratios and other myths 58 Don't Look for Shortcuts 60 Keep It Simpl 61 Consider Alternate approaches 62 Let the database do what It does Be Use Supplied Functionality We Heard Featurc X Is sto 66 We Heard Feature X is complicated 69 We don’ t Want to 69 We Didnt KI We Want Database Independence 2 Your Performance Toolk 75 Plu 76 Set Up SQL*plus Customize the SQl*plus Environment 78 Read the documentation l 80 EXPLAIN PLAN Setup for EXPLAIN PLAN 8 Use EXPLAIN PLAN Read a Query pl 84 Avoid the EXPLAIn plan 87 Use DBMS_XPLAN and VSSQL_PLAN 90 AUTOTRACE 92 Set Lp AUTOTRACE 92 Use AUTOTRACE 93 Format the autotRaCe Output 93 Understand the AUTOTRACE Output What Are You Looking for in AUTOTRACE Output TKPROF ,,.,,,120 Enable TKPROF 21 Run tKPRoF 122 d a tkPROF Rep TKPROF for the masses 128 Runstats 135 Set Up Runstats 136 Use runstats 140 Contents i Statspack 144 el Up statspack Use Statspack 146 What People Do wrong with Statspack 147 Statspack at a Glance T48 DBMS PROFILE 153 Why You want to Use the profiler Profiler rest 160 3 Architectural decisions 161 How Do Dedicated Server Connections Work? ons Understand Shared Server vs. Dedicated Server connectio 162 163 I low Do shared Server Connections Work? 165 Common Misconceptions about Shared Server Connections 169 Dedicated Server vs Shared Server Wrap-Up 170 Take Advantage of Clustering How Does RAC Work? What Are the benefits of rAC? 76 Clustering Wrap-Up Know When to Use Partitioning Partitioning C 178 tioning Myth 180 Why∪ se Partitioning?. 18 Partitioning Wrap∪p Know w Use parallel Operation 187 I he Parallel myth 188 Parallel Administration .,...,... 191 Parallel Query 193 Parallel dml 195 llel Processing Wrap-Up Summary 199 4 Effective Administration jse SPFILEs t( Start Your Database The prohlems with PFILEs 202 How SPFILes Work Convert a Database to use spfile Save System Parameter Changes 204 Are PFILEs obsolete? 204 Help, My SPFILE Is Broken and I Cannot Start 205 SPFILE Wrap-Up ,,,,.,207 Iet Oracle Manage Your Datafiles When Is OMF Useful? ,208 X ER Oracle by Design How OMF Works 2 OMF 211 Bulletproof Your rec 212 Backup guidelin 21 Backup and Recovery Wrap-U 216 Use Locally Manager Tablespaces 216 Why Arc OMTs Obsolete 216 Use System-Managed LMTs When You Do Not Know How Big Your Objects will Recome Use Uniform Extent Sizes When You Know the Ultimate Size of an object . 220 Some lmt caveat LMT and dMT Wrap-L 226 Let Oracle Manage Your Scgment Space ∪ nderstand Freelists and Freelist Groups;…∵ How PCtFREE and PCTUsed Control freelistis 231 ap-Lp 34 Let oracle manage Your R 235 Set UNDO RETENTION 236 An UND) Tablespace Caveat 238 UNDO Tablespace Wrap-Up 239 Summary 239 5 Statement Processing Types of SQL Stat How Are Statements Executed? 242 Parsing Optimization and row-Source Generation ...",.. 249 Statement Execution WrapUp 252 Queries from Start to Finish A Quick-Return QLleI A Slow-Return Query 23 Consistent Reads 257 Modification DML from Start to Finish 261 DDL Proces Use Bind variabl 264 What Are the Advantages of (sing Bind Variables? 265 Use bind variables with Java and VB There Are Exceptions to Every Ru Bind variable Peeking 283 Parse as Little as possible 87 The Cost of parsing 287 Use Pl/sqL to reduce Parses 290 QL Out of Triggers to Reduce Parsing 298 Prepare Once; Execute Mar 301 Contents xi 6 Getting the Most Out of the Cost-Based Optimizer 303 Why the rbo ls dead 304 Make the cbo do its bcst Adjust the OP TIMIZER INDEX CACHING and OPTIMIZLR_INDEX_ COST_ AD Parameters J07 Use SYS「 EM Statistic 311 Optimize the Co Set COMPATIBLE for Upgrades 320 Set db file multiblock read count to Reduce Full-Scan Costs .. 321 Set HASh JOin ENAbled to Control Hash joins 326 Set OPTIMIZER_DYNAMIC._ SAMPLING to Gather Statistics dynamically .. 326 Set OPTIMIZER_FEATURES ENABLE to Control Feature Choices 333 Set optimizer MAX PERmutations to Control Permutations 335 Set OPTIMIZER MODE to Pick a Mode Rewrite Queries with QUERY_REWRITE_ENABLED and QUERY_REWRITE_INTEGRITY Control PGA Memory with BITMAP_MERGE_ AREA_ SiZE SORT AREA SIZE, and HASH AREA SIZe Use StAr traNSFORMatION_ ENAbLED for Star Queries 359 Set others p rs paramete ters that affect the opti Use the 10053 Event to trace cBc choices 361 Summary ectve Schema Design 鲁 Fundamental Schema Design Principles 368 Let the Database Enforce Data Integr 368 ∪ se the Correct Datatyp 371 Optimize to Your Most Frequently Asked Qucstions 379 f Table ty ypes 380 B*Tree Index Clustered Tables 382 383 386 Clusters Wrap-U 397 Index-Organized Tables(oTs 398 Use IOTs as a Spacc-Saving Alternative to Association Tables Use IOTs to Colocate Randomly Inserted Data 400 tOTs Wrap-Up External tables ..404 Set Up External tables Modify External Tables ..,..408 Use External Tables for Direct-Path Loading 409 External Tables for Parallel Direct-Path Loading 411 Use External Tables for Merging 411 Handle Errors with External Tables 413 Inde Use fbls--Think Outside the Box 416 Use domain indexes 422 XII Effective Oracle by Design Compression 425 Use Index Key compression Use Table Compression for Read-Only/Read-Mostly Tables 432 Compression Wrap-Up Summa 442 8 ERective SQL 445 What You Need to write Efficient SQL 446 Understand Access Paths 447 Full Scans 447 ROWID Access 454 Cluster Scans 465 Understand j Nested loo Hash Joins ,甲P 468 Sort-M 471 Cartesian oins 473 Anti-oins 477 l Outer Joi 481 chema Matters (Physical) 484 Really Know SOL 487 The ROWNUM Pseudo Column 490 Scalar Subqueries Analytics 514 ont Tu 535 Understand the Qr 535 A Proof-of-Concept Example 536 f Other SQL Techniqu 540 Summar 9 Effective PLSQL Programming Why PL/SQL? 544 PL/SQL Is the Most Efficient Language for Data manipulation PL/SQL Is Portable and reusable 546 Write as Little as You Ca 548 Not Doing It Procedurally Fit your ode on the screen 552 Lse packs 553 antage Break the dependency chain 553 55 Use StatiC SQL Advantages of Static SQ 559 Loak for Opportunities to replace dynamic SoL 560 Static SQL Wrap-Up Bulk Processing Use bulk ssing When It Has D 56了

...展开详情
试读 127P Oracle专家高级编程+(清晰).pdf
立即下载 身份认证后 购VIP低至7折
一个资源只可评论一次,评论内容不能少于5个字
爬窗腐尸 英文的,清晰度一般
2018-10-06
回复
您会向同学/朋友/同事推荐我们的CSDN下载吗?
谢谢参与!您的真实评价是我们改进的动力~
关注 私信
上传资源赚钱or赚积分
最新推荐
Oracle专家高级编程+(清晰).pdf 50积分/C币 立即下载
1/127
Oracle专家高级编程+(清晰).pdf第1页
Oracle专家高级编程+(清晰).pdf第2页
Oracle专家高级编程+(清晰).pdf第3页
Oracle专家高级编程+(清晰).pdf第4页
Oracle专家高级编程+(清晰).pdf第5页
Oracle专家高级编程+(清晰).pdf第6页
Oracle专家高级编程+(清晰).pdf第7页
Oracle专家高级编程+(清晰).pdf第8页
Oracle专家高级编程+(清晰).pdf第9页
Oracle专家高级编程+(清晰).pdf第10页
Oracle专家高级编程+(清晰).pdf第11页
Oracle专家高级编程+(清晰).pdf第12页
Oracle专家高级编程+(清晰).pdf第13页
Oracle专家高级编程+(清晰).pdf第14页
Oracle专家高级编程+(清晰).pdf第15页
Oracle专家高级编程+(清晰).pdf第16页
Oracle专家高级编程+(清晰).pdf第17页
Oracle专家高级编程+(清晰).pdf第18页
Oracle专家高级编程+(清晰).pdf第19页
Oracle专家高级编程+(清晰).pdf第20页

试读结束, 可继续阅读

50积分/C币 立即下载