Includes index.

Defining Your World -- About Being an Oracle DBA -- How You "Talk" to a Database -- What Is an Oracle DBA, and What Does One Do? -- Types of DBAs -- Things You Need to Know About SQL*Plus -- Oracle Database Layout -- Logical vs. Physical Objects -- Oracle's "Physical" Composition -- Logical Database Objects -- How to Look at the Database -- The Data Dictionary Views -- The DBA%5FViews -- How to Look at the Database Using the V Views -- General V View Information -- The Static, Instance-Level V Views -- How to Protect the Database -- Views That Secure the Database -- How to Tune the Database -- Instance-Level Dynamic V Views Used for Tuning -- Managing Your World -- Oracle Installation, Configuration, and Build -- About Software Installation -- Software Installation Steps -- Creating a Database -- On the Number of Tablespaces and Their Layout -- Init.ora vs. SPFILE.ora -- Instance vs. Database -- Composition of the SGA -- About the Demo Tables -- General Database Considerations -- The Care and Feeding of Tablespaces -- Documenting Your Database -- Creating Objects in a Database -- What We Do Daily -- General Monitoring -- User Session Status -- Monitoring Object Modifications -- Protecting Your World -- Oracle Security and You -- Internal Database Security -- Application Security -- About Auditing -- External Database Security -- Availability -- Availability Concepts -- Just What Are We Protecting Against? -- Types of Recovery -- Types of Backups -- Database Features -- Data Guard/Standby Database -- Real Application Clusters (RAC) -- Real Application Clusters Guard -- Other Availability Features -- Tuning Your World -- Server Performance -- Understanding Performance Management -- Understanding the Critical Business Transactions -- Diagnosing a Problem -- Tuning to Change Overall Response Time -- Common Causes of Performance Problems -- Oracle-Supplied Tools -- Tuning SQL with Explain Plan, TKPROF, and Autotrace -- Using the Oracle Enterprise Manager (OEM) -- STATSPACK -- DBMS%5FSTATS -- Using Stored Outlines -- On Becoming a DBA -- About the Oracle Certified Professional Program -- MetaLink -- Technet -- A Few Useful Links.

Oracle9i DBA 101 explains, step-by-step, how to effectively administer an Oracle database. You'll get coverage of the key Oracle9i new features as well as details on the daily responsibilities of a DBA and tips on how to successfully accomplish those tasks. From the exclusive publishers of Oracle Press books, this is the ideal resource for the aspiring Oracle database administrator.