| |
| |
Introduction | |
| |
| |
Who Should Read This Book? | |
| |
| |
What Makes This Book Different? | |
| |
| |
| |
Role of the DBA | |
| |
| |
What Is a DBA? | |
| |
| |
Types of DBAs | |
| |
| |
Database Administration Principles | |
| |
| |
Database Administration Responsibilities | |
| |
| |
Roles Within the IT Organization | |
| |
| |
DBA Mindset | |
| |
| |
Summary | |
| |
| |
| |
Architecture of the Oracle Server | |
| |
| |
Oracle Products Relating to Database Servers | |
| |
| |
Database Versus Instance | |
| |
| |
Oracle File Types | |
| |
| |
Memory Structures | |
| |
| |
Oracle Processes | |
| |
| |
Transaction Control | |
| |
| |
Miscellaneous Database Files | |
| |
| |
Summary | |
| |
| |
| |
Planning a Database | |
| |
| |
System Architecture | |
| |
| |
Capacity Planning/Sizing | |
| |
| |
Optimal Flexible Architecture | |
| |
| |
Application and Database Considerations | |
| |
| |
Summary | |
| |
| |
| |
Machine Setup and Installation | |
| |
| |
Pre-Installation Setup | |
| |
| |
Installing Oracle | |
| |
| |
Summary | |
| |
| |
| |
Creating a Database | |
| |
| |
Generating Creation Scripts | |
| |
| |
Creating the Database | |
| |
| |
Post-Creation Activities | |
| |
| |
Configuring Net8 for the New Database | |
| |
| |
Customizing Your profile File | |
| |
| |
Summary | |
| |
| |
| |
Daily Activities | |
| |
| |
Database Views | |
| |
| |
Oracle Startup/Shutdown | |
| |
| |
User Management | |
| |
| |
Space Management | |
| |
| |
Monitoring | |
| |
| |
Summary | |
| |
| |
| |
GUI Management Products | |
| |
| |
Oracle Enterprise Manager | |
| |
| |
TOAD | |
| |
| |
Summary | |
| |
| |
| |
DBA Utilities | |
| |
| |
Export and Import | |
| |
| |
Common Export/Import Uses | |
| |
| |
Maintenance Benefits of Export/Import | |
| |
| |
Advanced Export and Import Techniques | |
| |
| |
Using SQL *Loader | |
| |
| |
Using LogMiner | |
| |
| |
Summary | |
| |
| |
| |
Backup and Recovery | |
| |
| |
Importance of Backups | |
| |
| |
Backup Types | |
| |
| |
Incurring Damage on the Database | |
| |
| |
Performing Backups and Recoveries | |
| |
| |
Comprehensive Planning and Testing | |
| |
| |
Summary | |
| |
| |
| |
When Things Go Wrong | |
| |
| |
Responding to Problems | |
| |
| |
File and Space Management | |
| |
| |
Locking | |
| |
| |
"Snapshot Too Old" Rollback Errors | |
| |
| |
Summary | |
| |
| |
| |
Oracle Server Tuning | |
| |
| |
Database Tuning Approach | |
| |
| |
Diagnostic Utilities: UTLBSTAT/UTLESTAT and STATSPACK | |
| |
| |
Tuning Memory Structures | |
| |
| |
Tuning Rollback Segments | |
| |
| |
Avoiding File Contention | |
| |
| |
Wait Events | |
| |
| |
Locally Managed Tablespaces | |
| |
| |
Tuning Tables | |
| |
| |
Indexes | |
| |
| |
Summary | |
| |
| |
| |
Unix Operation System Architecture | |
| |
| |
Imperative Concepts | |
| |
| |
Understanding the Kernel | |
| |
| |
Startup/Shutdown Processes in Unix | |
| |
| |
Understanding the Hardware Architecture | |
| |
| |
Summary | |
| |
| |
| |
Unix Server Monitoring | |
| |
| |
Need for Monitoring the Server | |
| |
| |
Overview of Monitoring the Server | |
| |
| |
Monitoring Memory Issues | |
| |
| |
Monitoring Disk I/O | |
| |
| |
Monitoring the CPU | |
| |
| |
Monitoring the Network | |
| |
| |
Summary | |
| |
| |
| |
Patches and Upgrades | |
| |
| |
What Are Patches and Upgrades? | |
| |
| |
When and How to Apply Patches | |
| |
| |
When and How to Upgrade | |
| |
| |
Additional Considerations | |
| |
| |
Summary | |
| |
| |
| |
Migrations | |
| |
| |
What Is a Migration | |
| |
| |
Reasons to Migrate Your Database | |
| |
| |
Preparation | |
| |
| |
Migration Methods | |
| |
| |
Using ODMA | |
| |
| |
Summary | |
| |
| |
| |
Java Inside the Database Server | |
| |
| |
Understanding the Role and Future of Java Inside Oracle | |
| |
| |
Java Overview | |
| |
| |
Supporting Java with Oracle | |
| |
| |
Managing Java Inside the Database | |
| |
| |
Summary | |
| |
| |
| |
WebDB/Oracle Portal | |
| |
| |
What Are WebDB and Oracle Portal? | |
| |
| |
WebDB/Oracle Portal Architecture | |
| |
| |
Installation | |
| |
| |
Basic WebDB Maintenance | |
| |
| |
Log into the Site | |
| |
| |
Key Differences between Oracle Portal and WebDB | |
| |
| |
Summary | |
| |
| |
| |
Internet Application Server (iAS) | |
| |
| |
Web Environment | |
| |
| |
Understanding and Using iAS | |
| |
| |
Installation | |
| |
| |
Configuration File Location and Apache Control | |
| |
| |
Summary | |
| |
| |
| |
9i Server New Features | |
| |
| |
Installing the 9i Server | |
| |
| |
Setting Up Security and Logging In | |
| |
| |
Creating a Server Parameter File (SPFILE) | |
| |
| |
Using Oracle-Managed Files | |
| |
| |
Using Dynamic Memory Parameters and Multiple Block Sizes | |
| |
| |
Using Undo Tablespaces | |
| |
| |
Comprehensive Sample Schemas | |
| |
| |
Miscellaneous Features and Changes | |
| |
| |
Summary | |
| |
| |
| |
Growth of the DBA | |
| |
| |
Growth of the DBA | |
| |
| |
Motivation | |
| |
| |
Continuing Your Education | |
| |
| |
Getting Certified | |
| |
| |
Networking with Other DBAs | |
| |
| |
Learning Systems Administration and Architecture | |
| |
| |
Learning Java | |
| |
| |
Summary | |
| |
| |
| |
Basic Unix Commands | |
| |
| |
| |
vi Editor | |
| |
| |
Cursor-Movement Commands | |
| |
| |
Entering Text | |
| |
| |
Editing Text | |
| |
| |
Saving and Exiting | |
| |
| |
Miscellaneous Commands | |
| |
| |
| |
Scripts | |
| |
| |
Hot Backup Script | |
| |
| |
| |
Glossary | |
| |
| |
Index | |