On-line training course catalogue

Oracle Database 10g: New Features for Oracle8i DBAs

Type of course: Classroom

Course details

Fee	£2750
Days	5
Course code	OR10GNFDBA

We currently do not have public dates scheduled for this course.
If you have a requirement for this course, please contact us for the latest course information.

Print this page | Download as Word document |

Overview

Please note that Oracle courses running at London training centres are subject to a 5% surcharge.

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.

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.

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 Outline

• Planning Your Upgrade to Oracle Database 10g
• Installing Oracle Database 10g
• Upgrading Your Database to Oracle Database 10g
• Performing Post-Upgrade Steps
• Using Enterprise Manager: Database Control
• Controlling the Instance and Access to the Database
• Managing Oracle Net Services
• Proactively Maintaining the Database
• Managing Resources
• Automating Tasks with the Scheduler
• Managing Memory Structures
• 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)
• Managing Undo
• Administering Users and Database Security
• Managing Schema Objects
• Accessing and Loading Data
• Performing Backup and Recovery Operations
• Recovering From User Errors
• Managing Performance