Oracle9i DBA Handbook

Implement Expert Administrative Solutions

Keep your mission-critical Internet and e-business systems flexible, secure, and available by using the exclusive information contained in this Oracle-authorized volume. Oracle9i DBA Handbook explains how to set up and maintain a high-performance database and maximize the all-new, powerful features of Oracle9i. Oracle insiders Kevin Loney and Marlene Theriault cover all the bases and provide real-world examples and techniques. A must-have resource for Oracle DBAs.

• Create and manage databases, using the Oracle9i Database Configuration Assistant
  
• Monitor and tune file usage, transactions, queries, and memory
  
• Implement rollback segments and system-managed undo
  
• Handle application migration and online table evolution
  
• Diagnose and optimize system performance with STATSPACK
  
• Implement state-of-the-art auditing and security procedures
  
• Automate backup and recovery operations, using RMAN
  
• Implement partitions to manage VLDBs
  
• Distribute computing power and share data across servers, using Oracle Net
  
• Use Oracle9iAS services to improve flexibility, scalability, and availability
  

Contents          

    Installing Oracle and Creating Databases
    Configuration Options
    Internal Configuration
    Managing Space
    Managing Database Changes
    Managing Transactions
    Monitoring - Space, Transactions, Memory, File Usage
    Tuning
    Using StatsPack
    Database Security
    Backup and Recovery
    Using Recovery Manager (RMAN)
    Oracle Net
    9iAS
    VLDBs
    Migrating Between Oracle Versions
    Maintaining OEM

   Appendices
     Appendix A: SQL Reference