Oracle Database 10g: New Features for Oracle8i DBAs

What you will learn

This course introduces students to the new features of Oracle Database 10g and Oracle9i Database. Detailed information on upgrading from Oracle8i to Oracle Database 10g is included. In this course, Database Administrators learn how to perform typical tasks using the new features available with Oracle Database 10g including many of the Advisors. Students learn how to use features to increase database availability, simplify database management, and improve performance.

Hands-on practice sessions provide students with an opportunity to upgrade an Oracle8i database to Oracle Database 10g and use many of the new features.

  • Upgrade from 8i to 10g
  • Manage the database using Enterprise Manager
  • Use Advisors to proactivley manage the database

This course counts towards the Hands-on course requirement for the Oracle 9i Database Administrator and Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.
Audience
 Database Administrators

Prerequisites
 Working knowledge of Oracle 8i

Course Objectives
 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

Course Topics
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

Related Courses
 Oracle Database 10g New Features for Administrators Self-Study CD Course