Oracle Administration and Management

Many databases are large and complex, making them very difficult to manage. In turn, data can become difficult to access, expensive to store, and even damaged or destroyed. Oracle 9i offers new functionality for the Oracle database system, ensuring that the database runs quickly, efficiently, and reliably.

• Shows the best techniques, tips, and tools for Oracle systems
• New edition focuses on the 9i version, but also covers releases 8 and 8i since many organizations still support these versions
• Companion Web site includes all of the software scripts to manage a database, plus links to lite and demo versions of database management software and other DBA tools

Autorentext
MICHAEL AULT is a Senior Technical Management Consultant for the Atlanta office of TUSC, Inc. He is also the systems operator for Quest-RevealNet Lab's DPAPipeline forum and writes articles regularly in Oracle Internals and Select. Previously, Ault was a senior consultant for the DBAGroup LLC and the corporate technical officer of DBMentors International, which he founded after four years as the associate director for the Oracle practice at DMR Consulting Group.

Klappentext
A complete guide to the best techniques, tips, and tools for managing Oracle databases

Oracle is the leading database worldwide, providing companies with fast access to critical business data. Oracle Administration and Management shows database administrators and managers how to keep Oracle databases running reliably and at peak performance. With the help of numerous real-world examples and scenarios, you'll gain valuable insight into all phases of Oracle database administration and management. From the initial installation and daily maintenance to backup and recovery procedures, you'll learn everything you need to know to become a successful Oracle DBA. Thoroughly updated for Oracle Release 9i, this book also provides complete coverage of Releases 8 and 8i, and shows you how to:

• Manage your Oracle database using best practices tested at operational Oracle sites
• Efficiently monitor and manage your Oracle8, 8i, or 9i database using more than 400 automated scripts
• Avoid pitfalls in the installation, upgrade, and migration to Oracle9i technology
• Utilize Oracle's undocumented parameters and events to more effectively manage your Oracle database
• Use Oracle Enterprise Manager to help monitor and manage your database
• Tune the database and troubleshoot problems using field-tested techniques

• Understand Oracle9i Real Application Clusters and their implementation

  The companion Web site includes all the scripts from the book, plus links to demo and lite versions of database management software and other DBA tools.

Inhalt
Acknowledgments.

Introduction.

Chapter 1. Installation of Oracle.

Chapter 2. Administration of Oracle (After the Bloom Is off the Rose...).

Chapter 3. Tablespace Admistration.

Chapter 4. Administration of Relational Database Tables.

Chapter 5. Administration of Oracle9i Object Tables.

Chapter 6. Administration of Indexes.

Chapter 7. Administration of Other Database Objects.

Chapter 8. Administration of Table Clusters.

Chapter 9. User and Security Administration.

Chapter 10. Monitoring Database Tables, Indexes, Clusters, Snapshots, and Objects.

Chapter 11. Monitoring Users and Other Database Objects.

Chapter 12. Oracle Tuning.

Chapter 13. Database Internals Tuning.

Chapter 14. Distributed Database Management.

Chapter 15. Backup and Recovery Procedures for Oracle.

Index.