Overview
Main description
This authorized guide from Oracle Press explains how implement all the new features of Oracle9i and manage a robust, high-performance Oracle database. You'll get new and revised material on installation, database creation, using STATSPACK, Recovery Manager, Oracle9i Application Server, external tables, flashback queries, and much more.
Table of 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
Back cover copy
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
