Oracle Database 10g: New Features for Oracle8i DBAs

 Oracle University provides a downloadable eKit containing the training materials for this course.

您将学到什么内容:

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.

时间表/定购	培训形式	价格	持续时间	培训课程教材	使用说明语言
查看课程时间表	教师指导的课堂培训	CNY 10925	5 天	英文
查看课程时间表	Live Virtual Class	CNY 10925	5 天	英文
在线购买	自学光盘	CNY 10233	不存在	英文

 

注意: 享受更多个性化体验, 我们邀请您到: 登录!

先决条件:

必要的先决条件:

• Working knowledge of Oracle 8i

课程目标:

• 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

课程主题:

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

相关课程 :

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