: Ignatius Fernandez
: Beginning Oracle Database 11g Administration From Novice to Professional
: Apress
: 9781430206286
: 1
: CHF 53.00
:
: Allgemeines, Lexika
: English
: 464
: Wasserzeichen/DRM
: PC/MAC/eReader/Tablet
: PDF

This book, written by veteran Oracle database administratorIggy Fernandez, a regular on the Oracle conference circuit and the editor ofNoCOUG 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.wordpres .com/.
Contents at a Glance5
Contents7
Foreword17
About the Author18
About the Technical Reviewer19
Acknowledgments20
Introduction21
Who This Book Is For22
How This Book Is Structured22
Source Code and Updates27
Errata27
Contacting the Author27
Database Concepts28
Relational Database Management Systems29
What Is a Database?30
What Is a Relational Database?31
What Is a Database Management System?40
What Makes a Relational Database Management44
System Relational?44
Summary45
Exercises45
Further Reading46
SQL and PL/SQL47
Railroad Diagrams49
Types of SQL51
Embedded SQL55
SQL*Plus and SQL Developer56
Criticisms of SQL59
Introduction to PL/SQL64
Summary72
Exercises74
Further Reading74
Oracle Architecture76
Database vs. Instance78
Database78
Instance81
Life Cycle of a Database Session84
Summary85
Exercises87
Further Reading87
Database Implementation88
Planning89
Licensing89
Architectural Choices94
Sizing97
Summary101
Exercises102
Further Reading103
Software Installation104
Oracle Technology Network104
The Forgotten Manuals105
Prerequisites and Preinstallation Requirements105
Client Installations106
Server Installations110
Oracle Database Examples114
Perl114
Summary115
Exercises116
Further Reading116
Database Creation117
Next-Next-Next Click Finish
Configuring a Listener119
Creating and Configuring a Database123
Post-Creation Tasks142
Other Methods of Database Creation142
Basic Database Administration Tasks145
Summary151
Exercises151
Further Reading152
Physical Database Design153
Indexes154
Partitions159
Denormalization and Materialized Views166
Clusters167
Summary169
Exercises170
Further Reading171
User Management and Data Loading173
Schemas173
User Management180
Data Loading190
Summary201
Exercises202
Further Reading203
Database Support204
Taking Control205
Enterprise Manager206
SQL Developer209
Remote Diagnostic Agent212
Dictionary Tables and Views214
Third-Party Tools218
Summary219
Exercises219
Further Reading220
Monitoring221
Monitoring Database Availability222
Monitoring Changes224
Monitoring Security225
Monitoring Backups227
Monitoring Growth227
Monitoring Workload229
Monitoring Performance233
Monitoring Capacity236
Summary239
Exercises240
Further Reading240
Fixing Problems242
Systematic Five-Step Problem-Solving Method243
The Book We All Want and Best Practices for245
Problem Management245