Tài liệu Expert Oracle9i Database Administration

Table of Contents
Expert Oracle9i Database Administration
Introduction
Part One - Database Basics, Data Modeling, and UNIX/Linux
Chapter 1 - The Oracle DBA's World
Chapter 2 - Relational Database Modeling and Database Design
Chapter 3 - Essential Unix (and Linux) for the Oracle DBA
Part Two - The Oracle RDBMS
Chapter 4 - Installing the Oracle9i RDBMS
Chapter 5 - Introduction to the Oracle9i Architecture
Chapter 6 - Using SQL*Plus and i SQL*Plus
Chapter 7 - Schema Management in Oracle9i
Chapter 8 - Oracle Transaction Management
Part Three - Database Creation, Connectivity, and User Management
Chapter 9 - Creating an Oracle Database
Chapter 10 - Connectivity and Networking
Chapter 11 - User Management and Database Security
Part Four - Data Loading, Backup, and Recovery
Chapter 12 - Loading and Transforming Data
Chapter 13 - Using the Export and Import Utilities
Chapter 14 - Backing up Databases
Chapter 15 - Database Recovery
Part Five - Managing the Operational Oracle Database
Chapter 16 - Managing the Operational Database
Chapter 17 - Using Oracle9i Enterprise Manager
Part Six - Performance Tuning and Troubleshooting the Production Database
Chapter 18 - Improving Database Performance: SQL Query Optimization
Chapter 19 - Performance Tuning: Tuning the Instance
Chapter 20 - The Oracle Data Dictionary and the Dynamic Performance Views
Chapter 21 - Using Oracle PL/SQL Packages
Chapter 22 - Managing Oracle Databases on Windows and Linux Systems
Appendix A - Brief Oracle9i SQL and PL/SQL Primer
Index
List of Figures
List of Tables
List of Listings
List of Sidebars