Expert Oracle Practices: Oracle Database Administration From The Oak Table

E-Book Information

• Year: 2,010

• Pages: 593

• Pages In File: 593

• Language: English

• Topic: 86

• Library: rutracker.org

• Issue: 2010-03

• Identifier: 9781430226680,1430226684

• Org File Size: 5,444,991

• Extension: pdf

• Toc: Prelim......Page 1 Contents at a Glance......Page 5 Contents......Page 7 Foreword......Page 21 Randolf Geist......Page 25 Connie Green......Page 26 Niall Litchfield......Page 27 Jože Senega......Page 28 Jeremiah Wilton......Page 29 Graham Wood......Page 30 Peter Sharman......Page 31 Guess Hunting......Page 33 Why Do We Guess?......Page 35 Understanding a Problem......Page 37 Logical Conclusions vs. Historical Observations......Page 38 Knowledge Is Power......Page 40 RTFM......Page 41 Paradigm Shifts......Page 43 Experience Is Danger......Page 44 Fixing the Root Cause?......Page 45 Best Practices and Myths......Page 46 BattleAgainstAnyGuess.com......Page 47 What Is Cloud Computing?......Page 49 Infrastructure as a Service (IAAS)......Page 50 Google......Page 51 Running Oracle on Amazon’s Cloud......Page 52 Making the Cloud Concrete......Page 53 AWS Management Console......Page 55 Elasticfox......Page 56 Perl/Java/Ruby Libraries......Page 57 Starting Out: Getting a Suitable Operating System Running......Page 58 Simple Storage Service (S3)......Page 60 EBS Performance for Oracle......Page 61 Attaching and Configuring EBS Storage......Page 63 Method A: Generic AMI and EBS File System......Page 64 Oracle Backup on EC2: The OSB Cloud Module......Page 65 Summary......Page 66 The Early Days......Page 67 Performance Strategy......Page 68 Design and Development......Page 69 Common Design Pitfalls......Page 70 Testing for Performance......Page 71 Set Up and Verify Monitoring......Page 72 Know Your Hardware......Page 73 Verify Statistics Collection......Page 74 Post Installation or Upgrade......Page 75 Reactive Tuning......Page 76 Step 1: Define the Problem......Page 77 The User Experience......Page 78 An Agreed-Upon Problem Definition......Page 79 Hardware and Database Data......Page 80 Sanity Check......Page 81 Scope: Instance-Wide......Page 82 Step 3: Formulate a Theory......Page 84 Step 4: Implement and Verify the Solution......Page 85 Diagnostic Tools......Page 86 Using and Interpreting ADDM......Page 87 Using and Interpreting the ASH Report......Page 89 Top Event P1/P2/P3 Values......Page 90 Top SQL with Top Events......Page 91 The Report Layout......Page 92 Elapsed Time......Page 93 Timed Events and Time Model......Page 94 Load Profile......Page 96 Sanity Check OSStat......Page 97 Drill into Relevant Details......Page 98 Time-Based Statistics......Page 99 % Activity and Average Active Sessions......Page 100 Wait Classes......Page 101 Execution Plan Stability and Profiles......Page 102 Summary......Page 103 The DBA as Designer......Page 105 Be Approachable......Page 106 Attend Code Reviews......Page 107 Partnership Between DBAs and Developers......Page 108 Be Open to New Ideas......Page 109 Design-First Methodologies vs. Agile Techniques......Page 110 Design-First Approach......P