Oracle Database 10g: New Features for Oracle8i DBAs

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

course content details

	Planning Your Upgrade to Oracle Database 10g

	Supported upgrade paths to Oracle Database 10g
	Planning the upgrade

	Installing 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