1 Introduction
    * About Oracle Database
    * Common Oracle DBA Tasks
    * Tools for Administering the Database

2 Installing Oracle Database and Creating a Database
    * Overview of Installing Oracle Database Software and Creating a Database
          o Checking Prerequisites
          o Installation Choices
                + Basic Installation
                + Advanced Installation
    * Installing Oracle Database Software
    * Creating and Managing a Database with DBCA
          o Starting DBCA
          o Creating a Database Using DBCA
          o Changing the Configuration of a Database Using DBCA
          o Deleting a Database Using DBCA
          o Managing Templates with DBCA
    * Configuring Automatic Storage Management Using DBCA
    * Installation: Oracle By Example Series

3 Getting Started with Database Administration
    * Managing Your Database: A Roadmap
    * Introduction to Oracle Enterprise Manager Database Control
          o Database Management Features
          o Database Home Page
          o Online Help
          o Navigational Features
    * Starting and Stopping the Database Control Console Process
    * Accessing the Database Home Page
    * Granting Access to Database Control for Nonadministrative Users
    * Creating Database Control Administrative Users
    * Setting Database Control Preferences
          o About Database Control Preferences
          o Defining Blackout Periods
          o Setting Preferred Credentials
    * About SQL and SQL-Based Management Tools
          o About SQL*Plus
          o Starting SQL*Plus and Connecting to the Database
          o About SQL Developer
    * Getting Started with Oracle Enterprise Manager: Oracle By Example Series

Expand this chapter 4 Configuring the Network Environment
    * Understanding Network Configuration
          o Oracle Net Listener Configuration
          o Connect Descriptors
          o Connection Requests
          o Naming Methods
          o Tools for Network Configuration
    * Viewing Listener Configuration
    * Starting and Stopping the Listener
    * Connecting to an Oracle Database from a Client Computer
    * Networking: Oracle By Example Series

5 Managing the Oracle Instance
    * Overview of the Oracle Instance and Instance Management
          o About Initialization Parameters
          o About Background Processes
          o About Server and Client Processes
          o About Instance Memory Structure
          o About Instance Startup and Shutdown
    * Shutting Down and Starting Up the Oracle Instance
          o Shutting Down and Starting Up Using Oracle Enterprise Manager Database Control
          o Shutting Down and Starting Up Using the Windows Services Program
    * Viewing and Modifying Initialization Parameters
    * Managing Memory
          o About Memory Management
          o Enabling Automatic Memory Management
          o Modifying Memory Settings – Automatic Memory Management
          o Modifying Memory Settings – Automatic Shared Memory Management
          o Modifying Memory Settings – Automatic PGA Memory Management
    * Instances: Oracle By Example Series

 6 Managing Database Storage Structures
    * About Database Storage Structures
          o About Control Files
          o About Online Redo Log Files
          o About Archived Redo Log Files
          o About Rollback Segments
          o About Datafiles
          o About Tablespaces
          o About Other Storage Structures
    * Viewing Database Storage Structure Information
          o Viewing Control File Information
          o Viewing Online Redo Log File Information
          o Viewing Archive Log Information
          o Viewing Datafile Information
          o Viewing Tablespace Information
    * Performing Common Database Storage Tasks
          o Creating a Tablespace
          o Modifying a Tablespace
          o Dropping a Tablespace
          o Reclaiming Unused Space
   * Managing the Redo Log
          o Multiplexing the Redo Log
          o Switching a Log File
    * Managing Undo Data
          o About Undo Data
          o About Managing Undo Data
          o Viewing Undo Information
          o Computing the Minimum Undo Tablespace Size Using the Undo Advisor
          o Changing the Undo Tablespace to a Fixed Size
    * Storage: Oracle By Example Series

7 Administering User Accounts and Security
    * About User Accounts
    * About User Privileges and Roles
    * About Administrative Accounts and Privileges
          o SYS and SYSTEM Users
          o SYSDBA and SYSOPER System Privileges
    * Administering Roles
          o Viewing Roles
          o Example: Creating a Role
          o Example: Modifying a Role
          o Deleting a Role
    * Administering Database

User Accounts
          o Viewing User Accounts
          o Example: Creating a User Account
          o Creating a New User Account by Duplicating an Existing User Account
          o Example: Granting Privileges and Roles to a User Account
          o Example: Assigning a Tablespace Quota to a User Account
          o Example: Modifying a User Account
          o Locking and Unlocking User Accounts
          o Expiring a User Password
          o Example: Deleting a User Account
    * Setting the Database Password Policy
          o About Password Policies
          o Modifying the Default Password Policy
    * Users: Oracle By Example Series

8 Managing Schema Objects
    * About Schema Objects
    * About Schema Object Management Privileges
    * Managing Tables
          o About Tables
          o Viewing Tables
          o Viewing Table Data
          o Example: Creating a Table
          o Modifying Table Attributes
          o Example: Loading Data into a Table
          o Deleting a Table
    * Managing Indexes
          o About Indexes
          o Viewing Indexes
          o Example: Creating an Index
          o Example: Deleting an Index
    * Managing Views
          o About Views
          o Displaying Views
          o Example: Creating a View
          o Example: Deleting a View
    * Managing Program Code Stored in the Database
          o About Program Code Stored in the Database
          o Validating (Compiling) Invalid Schema Objects
    * Working with Other Schema Objects
    * Schemas: Oracle By Example Series

 9 Performing Backup and Recovery
    * Overview of Database Backup and Recovery
    * Database Backup and Recovery Concepts
          o Consistent and Inconsistent Backups
          o Media Recovery
          o Flash Recovery Area
          o RMAN Repository
    * Configuring Your Database for Basic Backup and Recovery
          o Specifying Credentials for Backup and Recovery Using Database Control
          o Planning Space Usage and Location for the Flash Recovery Area
           o Configuring Recovery Settings
          o Monitoring Flash Recovery Area Usage
          o Configuring Backup Settings
       * Backing Up Your Database
          o RMAN Backup Concepts
          o Performing and Scheduling Backups Using Database Control
          o Validating Backups and Testing Your Backup Strategy
    * Displaying Backup Reports
    * Managing Backups
          o About Backup Management
          o Cross-Checking Backups
          o Deleting Expired Backups
          o Marking Backups as Available or Unavailable
          o Deleting Obsolete Backups
    * Performing Oracle Advised Recovery
          o About Data Recovery Advisor
          o Using Data Recovery Advisor
    * Performing User-Directed Recovery
          o Rewinding a Table Using Oracle Flashback Table
          o Recovering a Dropped Table Using Oracle Flashback Drop
          o Rewinding a Database Using Oracle Flashback Database
          o Restoring and Recovering the Database
    * Backup and Recovery: Oracle By Example Series

10 Monitoring and Tuning the Database
    * Proactive Database Monitoring
          o About Alerts
          o Performance Self-Diagnostics: Automatic Database Diagnostic Monitor
          o Monitoring General Database State and Workload
          o Managing Alerts
    * Diagnosing Performance Problems Using ADDM
          o Viewing a Summary of ADDM Performance Findings
          o Responding to ADDM Performance Findings
          o Running ADDM Manually
          o Modifying AWR Snapshot Frequency and Retention
    * Using Advisors to Optimize Database Performance
          o About Advisors
          o About the SQL Advisors
          o About the Automatic SQL Tuning Advisor
          o Configuring the Automatic SQL Tuning Advisor
          o Viewing Automatic SQL Tuning Results
          o Running the SQL Tuning Advisor
          o Running the SQL Access Advisor
          o Using the Memory Advisors
     * Monitoring and Tuning: Oracle By Example Series

11 Investigating, Reporting, and Resolving Problems
    * About Database Problems and Incidents
    * Investigating, Reporting, and Resolving a Problem
    * Viewing Problems Using the Enterprise Manager Support Workbench

12 Managing Oracle Database Software
    * About Software Management and Patch Releases
    * Patching the Oracle Software
          o Determining Your Oracle Database Software Environment
          o Setting Your OracleMetaLink Credentials
          o Staging and Applying Patches and Patch Sets
    * Viewing Critical Patch Advisories
    * Upgrading a Database
          o Overview of Database Upgrade Assistant
          o Database Versions Supported by DBUA
          o Starting DBUA
          o Upgrading a Database Using DBUA
    * Managing Oracle Software: Oracle By Example Series

13 Administering Automatic Storage Management