With the power of
Oracle8i comes considerable complexity.
Mastering Oracle8i guides you through this complexity so
you can take full advantage of the product's power and
newest
features. Inside, you'll find everything you need to
know to make your work as an
Oracle DBA as headache-free as
possible—including step-by-step coverage of common
and not-so-common administrative tasks, plus expert advice
on avoiding most problems and solving others as quickly as
they arise. Coverage includes:
- Migrating, upgrading, and creating Oracle8i
databases
- Understanding and setting up partitioning and parallel
processing
- Backing up and recovering data
- Understanding and using the data dictionary
- Tuning your database and Oracle SQL statements
- Monitoring database activity and performance
- Detecting and solving database problems
- Securing your database with Virtual Private Database
and other features
- Designing an Oracle object-oriented database
- Loading external data with Oracle SQL*Loader
- Managing replication tasks
- Using Oracle's high-availability features
- Moving data with transportable namespaces
Contents
Introduction
PART I. ORACLE ESSENTIALS
1. Elements of Oracle Database Management
2. Installing, Upgrading, and Migrating Oracle
3. Creating Oracle Databases
4. The Data Dictionary
PART II. ORACLE DATABASE ADMINISTRATION
5. Understanding Oracle8i Architecture
6. Oracle Schema Object Management
7. Oracle Database Maintenance
8. Oracle Object-Oriented Features
9. Oracle Networking
10. Physical Backup and Recovery
11. Oracle Logical Backup and Recovery
12. Using Transportable Tablespaces
13. Oracle8i Recovery Manager
14. Oracle8i LogMiner
PART III. BEYOND SIMPLE DATABASE MANAGMENT
15. Oracle8i Performance Monitoring and Database-Level
Tuning
16. Oracle8i SQL Performance Monitoring and Tuning
17. Monitoring and Tuning Latches, Locks, and Waits
18. Oracle8i Parallel Processing
19. Oracle8i Data Warehousing Features
20. Oracle8i Supplied Packages
21. Oracle8i Database Security
22. SQL*Loader
PART IV. ORACLE8i DISTRIBUTED DATABASE
23. Oracle Database Links
24. Database Partitioning
25. Simple and Advanced Replication
26. High Availability
27. Oracle8i and the Internet
Index