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
Skills Gained
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
Who Can Benefit
Database Administrators
Prerequisites
Working knowledge of Oracle 8i
Code:
10gDB-NEW-OR8-DBA
Length:
5 days
Type:
Instructor-Led
Certified By:
Oracle
Tuition:
$3,000 / contact for GSA GOV.
This course is taught by Certified Oracle instructors. There is a difference. Learn More
This course is in the following categories. Click the categories to find similar courses and topics of interest.
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below. We can also contact you when the course is scheduled in your area.
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
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
When you take a certified course with ExitCertified, you are learning from
the creators of the products you use. Our commitment to your IT
community, along with our authorization to deliver certified courses,
ensures you receive a premium training experience.
