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



Posluchači
Database Administrators

Předpoklady
Working knowledge of Oracle 8i

Cíle kurzu
Planning the Upgrade
Installing Oracle Database 10g
Upgrading the Database
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



Témata kurzu

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