Oracle9i DBA Handbook

Kevin Loney, Marlene Theriault

  • 出版商: McGraw-Hill Education
  • 出版日期: 2001-12-19
  • 售價: $2,173
  • 貴賓價: 9.5$2,064
  • 語言: 英文
  • 頁數: 1008
  • 裝訂: Paperback
  • ISBN: 0072193743
  • ISBN-13: 9780072193749
  • 相關分類: Oracle




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


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

     Appendix A: SQL Reference