Beginning Oracle Database 11g Administration

1. Front Matter

   Pages i-xxxi

   PDF

2. Database Concepts

   1. Front Matter

      Pages 1-1

      PDF

   2. Relational Database Management Systems

      Pages 3-20

   3. SQL and PL/SQL

      Pages 21-49

   4. Oracle Architecture

      Pages 51-62

3. Database Implementation

   1. Front Matter

      Pages 63-63

      PDF

   2. Planning

      Pages 65-79

   3. Software Installation

      Pages 81-93

   4. Database Creation

      Pages 95-130

   5. Physical Database Design

      Pages 131-150

   6. User Management and Data Loading

      Pages 151-181

4. Database Support

   1. Front Matter

      Pages 183-183

      PDF

   2. Taking Control

      Pages 185-200

   3. Monitoring

      Pages 201-221

   4. Fixing Problems

      Pages 223-254

   5. Backups

      Pages 255-278

   6. Recovery

      Pages 279-304

   7. Database Maintenance

      Pages 305-330

   8. The Big Picture and the Ten Deliverables

      Pages 331-354

5. Database Tuning

   1. Front Matter

      Pages 355-355

      PDF

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.

• 11g
• ITIL
• Oracle
• SQL
• control
• database
• database administration
• database design
• management
• performance
• relational database
• technology

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/.

Policies and ethics