Fernandez Beginning Oracle Database 11g Administration

From Novice to Professional
1. ed
ISBN: 978-1-4302-0628-6
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 464 Seiten

This book, written by veteran Oracle database administrator Iggy Fernandez, a regular on the Oracle conference circuit and the editor of NoCOUG Journal, is a manageable introduction to key Oracle database administration topics including planning, installation, monitoring, troubleshooting, maintenance, and backups, to name just a few. As is clear from the table of contents, this book is not simply a recitation of Oracle Database features such as what you find in the reference guides available for free download on the Oracle web site. For example, the chapter on database monitoring explains how to monitor database availability, database changes, database security, database backups, database growth, database workload, database performance, and database capacity. The chapters of this book are logically organized into four parts that closely track the way your database administration career will naturally evolve. Part 1 gives you necessary background in relational database theory and Oracle Database concepts, Part 2 teaches you how to implement an Oracle database correctly, Part 3 exposes you to the daily routine of a database administrator, and Part 4 introduces you to the fine art of performance tuning. Each chapter has exercises designed to help you apply the lessons of the chapter. Each chapter also includes a list of reference works that contain more information on the topic of the chapter. In this book, you'll find information that you won't find in other books on Oracle Database. Here you'll discover not only technical information, but also guidance on work practices that are as vital to your success as technical skills. The author's favorite chapter is 'The Big Picture and the Ten Deliverables.' If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible.

Iggy Fernandez has a rich history of working with Oracle Database in many capacities. He is the author of Beginning Oracle Database 11g Administration (Apress, 2009) and teaches Oracle database administration at University of Washington Professional & Continuing Education. He was the president of the Northern California Oracle Users Group (NoCOUG), the longest running and most active Oracle users group in the world. He writes regularly for the NoCOUG Journal and has been its editor for many years. Iggy's favorite topics are database performance and SQL performance, and he regularly speaks on these topics at Oracle conferences. He has a lot of opinions but is willing to change them when confronted with fresh facts. His favorite quote is 'A foolish consistency is the hobgoblin of little minds, adored by little statesmen and philosophers and divines - Speak what you think now in hard words, and to-morrow speak what to-morrow thinks in hard words again, though it contradict every thing you said to-day.' - Ralph Waldo Emerson. You can follow him online at http://iggyfernandez.wordpress.com/.

Autoren/Hrsg.

Fernandez, Ignatius

Inhaltsverzeichnis

1;Contents at a Glance;5
2;Contents;7
3;Foreword;17
4;About the Author;18
5;About the Technical Reviewer;19
6;Acknowledgments;20
7;Introduction;21
7.1;Who This Book Is For;22
7.2;How This Book Is Structured;22
7.3;Source Code and Updates;27
7.4;Errata;27
7.5;Contacting the Author;27
8;Database Concepts;28
8.1;Relational Database Management Systems;29
8.1.1;What Is a Database?;30
8.1.2;What Is a Relational Database?;31
8.1.3;What Is a Database Management System?;40
8.1.4;What Makes a Relational Database Management;44
8.1.5;System Relational?;44
8.1.6;Summary;45
8.1.7;Exercises;45
8.1.8;Further Reading;46
8.2;SQL and PL/SQL;47
8.2.1;Railroad Diagrams;49
8.2.2;Types of SQL;51
8.2.3;Embedded SQL;55
8.2.4;SQL*Plus and SQL Developer;56
8.2.5;Criticisms of SQL;59
8.2.6;Introduction to PL/SQL;64
8.2.7;Summary;72
8.2.8;Exercises;74
8.2.9;Further Reading;74
8.3;Oracle Architecture;76
8.3.1;Database vs. Instance;78
8.3.2;Database;78
8.3.3;Instance;81
8.3.4;Life Cycle of a Database Session;84
8.3.5;Summary;85
8.3.6;Exercises;87
8.3.7;Further Reading;87
9;Database Implementation;88
9.1;Planning;89
9.1.1;Licensing;89
9.1.2;Architectural Choices;94
9.1.3;Sizing;97
9.1.4;Summary;101
9.1.5;Exercises;102
9.1.6;Further Reading;103
9.2;Software Installation;104
9.2.1;Oracle Technology Network;104
9.2.2;The Forgotten Manuals;105
9.2.3;Prerequisites and Preinstallation Requirements;105
9.2.4;Client Installations;106
9.2.5;Server Installations;110
9.2.6;Oracle Database Examples;114
9.2.7;Perl;114
9.2.8;Summary;115
9.2.9;Exercises;116
9.2.10;Further Reading;116
9.3;Database Creation;117
9.3.1;Next-Next-Next; Click Finish;118
9.3.2;Configuring a Listener;119
9.3.3;Creating and Configuring a Database;123
9.3.4;Post-Creation Tasks;142
9.3.5;Other Methods of Database Creation;142
9.3.6;Basic Database Administration Tasks;145
9.3.7;Summary;151
9.3.8;Exercises;151
9.3.9;Further Reading;152
9.4;Physical Database Design;153
9.4.1;Indexes;154
9.4.2;Partitions;159
9.4.3;Denormalization and Materialized Views;166
9.4.4;Clusters;167
9.4.5;Summary;169
9.4.6;Exercises;170
9.4.7;Further Reading;171
9.5;User Management and Data Loading;173
9.5.1;Schemas;173
9.5.2;User Management;180
9.5.3;Data Loading;190
9.5.4;Summary;201
9.5.5;Exercises;202
9.5.6;Further Reading;203
10;Database Support;204
10.1;Taking Control;205
10.1.1;Enterprise Manager;206
10.1.2;SQL Developer;209
10.1.3;Remote Diagnostic Agent;212
10.1.4;Dictionary Tables and Views;214
10.1.5;Third-Party Tools;218
10.1.6;Summary;219
10.1.7;Exercises;219
10.1.8;Further Reading;220
10.2;Monitoring;221
10.2.1;Monitoring Database Availability;222
10.2.2;Monitoring Changes;224
10.2.3;Monitoring Security;225
10.2.4;Monitoring Backups;227
10.2.5;Monitoring Growth;227
10.2.6;Monitoring Workload;229
10.2.7;Monitoring Performance;233
10.2.8;Monitoring Capacity;236
10.2.9;Summary;239
10.2.10;Exercises;240
10.2.11;Further Reading;240
10.3;Fixing Problems;242
10.3.1;Systematic Five-Step Problem-Solving Method;243
10.3.2;The Book We All Want and Best Practices for;245
10.3.3;Problem Management;245
10.3.4;Real-Life Example—Unresponsive Listener;246
10.3.5;Incident Management vs. Problem Management;250
10.3.6;Internet Resources;251
10.3.7;Working with Oracle Support;255
10.3.8;Error Codes;259
10.3.9;Four Errors;261
10.3.10;Summary;271
10.3.11;Exercises;272
10.3.12;Further Reading;273
10.4;Backups;274
10.4.1;Why Do You Need Backups?;275
10.4.2;Horror Stories;276
10.4.3;Types of Backup;277
10.4.4;Practical Demonstration: Physical Backups;280
10.4.5;Practical Demonstration: Logical Backups;286
10.4.6;Common RMAN Commands;288
10.4.7;The “Easy” Button;292
10.4.8;Summary;295
10.4.9;Exercises;295
10.4.10;Further Reading;296
10.5;Recovery;298
10.5.1;Horror Stories;298
10.5.2;Types of Recovery;299
10.5.3;Flashback Technology;302
10.5.4;LogMiner;308
10.5.5;Data Recovery Advisor;310
10.5.6;Recovery Using Enterprise Manager;317
10.5.7;Documentation and Testing;320
10.5.8;Summary;320
10.5.9;Exercises;321
10.5.10;Further Reading;322
10.6;Database Maintenance;324
10.6.1;The Maintenance Plan;324
10.6.2;Backups;325
10.6.3;Statistics;327
10.6.4;Archiving and Purging;329
10.6.5;Log File Maintenance;332
10.6.6;Auditing;335
10.6.7;User Management;338
10.6.8;Capacity Management;338
10.6.9;Patching;344
10.6.10;Summary;347
10.6.11;Exercises;348
10.6.12;Further Reading;349
10.7;The Big Picture and the Ten Deliverables;350
10.7.1;An Instructive Job Interview;351
10.7.2;How I Became a DBA;353
10.7.3;ITIL;355
10.7.4;Start with the End in Mind: The Ten Deliverables;361
10.7.5;The Book You Really Need and the Art of the SOP;363
10.7.6;Summary;371
10.7.7;Exercises;372
10.7.8;Further Reading;373
11;Database Tuning;374
11.1;Instance Tuning;375
11.1.1;Using a Systematic Five-Step Tuning Method;375
11.1.2;Analyzing DB Time;378
11.1.3;Understanding the Oracle Wait Interface;383
11.1.4;Mining the Statspack Repository;384
11.1.5;Using the Statspack Report;393
11.1.6;Summary;394
11.1.7;Exercises;395
11.1.8;Further Reading;398
11.2;SQL Tuning;399
11.2.1;Defining Efficiency;399
11.2.2;Identifying Inefficient SQL Statements;400
11.2.3;Understanding the Causes of Inefficient SQL;402
11.2.4;Ways to Improve SQL;403
11.2.5;Tuning by Example;409
11.2.6;Summary;431
11.2.7;Exercises;433
11.2.8;Further Reading;433
12;Index;435