Oracle Database 10g: New Features for Oracle8i DBAs

Performing Post Migration Tasks. Managing the Database with Enterprise Manager Database Control. Controlling the Instance. Maintaining the Database. Managing Resources. Automating Tasks using the Scheduler. Managing Memory Structures. Managing Database Storage Structures. Using Automatic Storage Management (ASM). Managing Undo. Administering Users. Managing Schema Objects. Backing Up and Recovering the Database. Planning the Upgrade. Installing Oracle Database 10g. Upgrading the Database


Planning Your Upgrade to Oracle Database 10g

Supported upgrade paths to Oracle Database 10g
Planning the upgrade

Installing Oracle Database 10g

Installing Oracle Database 10g software
Use the Database Configuration Assistant to create a database

Upgrading Your Database to Oracle Database 10g

Using Database Upgrade Assistant (DBUA)
Using the manual upgrade method
Using Export and Import to upgrade

Performing Post-Upgrade Steps

Upgrading Server Manager scripts to work in SQL*Plus
Performing additional upgrade tasks

Using Enterprise Manager: Database Control

Starting the Enterprise Manager dbconsole process
Accessing Enterprise Manager Database Control
Navigating in Enterprise Manager Database Control
Granting Enterprise Manager Administrative Privileges

Controlling the Instance and Access to the Database

Using the Server Parameter file (SPFILE) to Configure Initialization Parameters
Quiescing the Database
Dropping the Database

Managing Oracle Net Services

Using New Tools to Manage Oracle Net Services
Connecting using the easy connect method
Exporting Directory Naming Entries
Using New Features of the Shared Server Configuration

Proactively Maintaining the Database

Defining AWR Snapshot Baselines
Subscribing Applications to Server-Generated Alerts
Using the Automatic Database Diagnostic Monitor (ADDM)

Managing Resources

Using New Features of the Database Resource Manager

Automating Tasks with the Scheduler

Using the Scheduler to Perform Database Administration Tasks
Creating a Job, Program, Schedule, and Window
Reusing Scheduler Components for Similar Tasks
Viewing Information about Job Executions

Managing Memory Structures

Using Automatic Shared Memory Tuning
Configuring Automatic PGA Memory Management
Modifying Initialization Parameters for Memory Components

Managing Database Storage Structures

Specifying a Default User Tablespace
Creating Bigfile Tablespaces
Creating a Default Temporary Tablespace
Creating Temporary Tablespace Groups
Renaming Tablespaces
Using the Redo Logfile Sizing Advisor

Implementing Automatic Storage Management (ASM)

Creating ASM Instance
Setting Up Initialization Parameter Files for ASM
Executing SQL Commands with ASM File Names
Starting up and shutting down ASM instances
Administering ASM disk groups
Using RMAN to Migrate the Database to ASM

Managing Undo

Configuring the Database for Automatic Undo Management
Monitoring Undo Usage
Converting from Manual Rollback to Automatic Undo
Using the Undo Advisor

Administering Users and Database Security

Unlocking Default User Accounts
Setting a Single Password for System Users
Using fine-grained auditing
Auditing Administrative Users

Managing Schema Objects

Configure Automatic Segment-Space Management
Estimating Table and Index Size
Performing Online Redefinition of Tables
Enabling Automatic Statistics Collection
Using the Segment Advisor
Enabling Resumable Space Allocation

Accessing and Loading Data

Using Data Pump to Import and Export Data
Create External Tables for Data Population
Transport Tablespaces across Different Platforms

Performing Backup and Recovery Operations

Using Automatic Checkpoint Tuning
Using New Features of Recovery Manager (RMAN)
Create Change-Aware Incremental Backups
Performing Trial Recovery
Performing Database Flashback

Recovering From User Errors

Using Flashback Query
Retrieving Row History
Auditing and Recovering Transactions
Recovering Table Data
Recover Dropped Tables

Managing Performance

Using the SQL Tuning Advisor
Using the SQL Access Advisor