Oracle DBA Handbook

ORACLE DBA Handbook, 7.3 Edition. the Essential Guide to database
Management in the Real World. Forget theories and hypotheses.
Managing a database in the real world is a tricky business that
casts the DBA in the difficult role of architect, juggler, and
troubleshooter all in one. Completely revised and updated to cover
Oracle7 RElease 7.3, the Oracle DBA Handbook, 7.3 Edition is here
to make your life as database administrator easier and more
productive. It provides the information you need to effectively
manage a networked or stand-alone Oracle database system. In this
official handbook authorized by Oracle, expert Kevin Loney shows
you how to set up a database for maximum efficiency, monitor it,
tune it, and maintain security. You'll find tips on networking
Oracle7 Release 7.3 with SQL*Net on UNIX, as well as tips on using
Oracle's distributed database and client-server capabilities. And
you'll learn about supporting tools, including Oracle CASE, Oracle
Financials, and Oracle utilities, as well as third-party tools. A
command reference, configuration guidelines, and scripts are also
included to help get you started in setting up your Oracle
database. Whether you're a new or experienced DBA, you can master
the many nuances and intricacies of this complex and powerful
database system. The Oracle DBA Handbook, 7.3 Edition will prove
to be your crucial guide to developing a top-performing database
for today's real-world information needs.

Table of contents

Part I: Database Architecture.

The Oracle Architecture.

Hardware Configurations and Considerations.

Logical

Database Layouts.

Physical Database Layouts.

Part II: Database Management.

Managing the Development Process.

Monitoring Multiple Databases.

Managing Rollback Segments.

Database Tuning.

Database Security and Auditing.

Optimal Backup and Recovery Procedures.

Part III: Supporting Packages.

Supporting Oracle CASE.

Supporting Oracle Financials.

Supporting Oracle Utilities.

Supporting Third-Party Tools.

Part IV: Networked Oracle.

SQL *Net V1 and V2.

Networking in Unix.

Managing Distributed Databases.

Part V: Appendices:

A: Database Creation Procedures.

B: Database Installation Guidelines.

C: SQL Reference for DBA Commands.

D: Configuration Guidelines for Client-Server Environments.