ORA10g204 - Oracle Database 10g R1 and R2: New Features For Administrators

Course ORA10g204

Table of Contents

Introduction
Audience
At Course Completion
Prerequisites
Certified Professional Exams
Student Materials
Course Outline

Introduction

This 5-day course reviews all of the major administration features and improvements introduced with version 10g of the Oracle database. Students will be able to apply their experience with previous releases of the Oracle database to this new release, which offers numerous productivity and manageability improvements.

Return to Top

Audience

The target audience for this course is database administrators with experience using Oracle9i, wanting to learn about the new and modified features introduced in Oracle10g.

Return to Top

At Course Completion

At the end of this course, the student will be able to:

• Install and initially configure, or upgrade an Oracle10g database.
• Load and unload data between databases using the Data Pump architecture.
• Enable and configure automatic database management.
• Utilize advanced self-tuning and self-management capabilities, including the use of the database Advisors and other components of the Management Framework.
• Take advantage of the new recovery features available from flashback, flashback database, the flash recovery area and RMAN enhancements.
• Enable and use general storage management enhancements and incorporate the powerful new automatic storage management (ASM) option.
• Work within the changed Enterprise Manager (EM) interface and the database control.

Return to Top

Prerequisites

Before attending this course, students should have experience administering production databases using Oracle9i.

Students with experience in Oracle8i or earlier are required to read the course book Oracle9i New & Adavanced Features For Administrators as a prerequisite to this course.

Return to Top

Certified Professional Exams

This course covers information necessary to complete the certification test EXAM #1Z0-040, ORACLE DATABASE 10G: NEW FEATURES FOR ADMINISTRATORS

Oracle Corporation has recommended that students have approximately 6-months hands-on production experience before attempting a given certification test, although this may not be necessary for all professionals

Return to Top

Student Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

Return to Top

Course Outline

INSTALLING ORACLE 10G DATABASE SOFTWARE
• THE OPTIMAL FLEXIBLE ARCHITECTURE (OFA)
• ORACLE_BASE
• ORACLE_HOME
• CONFIGURE THE INSTALLATION ENVIRONMENT
• INSTALLATION USING THE UNIVERSAL INSTALLER
• MORE ABOUT ENTERPRISE MANAGER
• REGISTER FOR SECURITY UPDATES
CREATING AN ORACLE DATABASE
• CREATE A DATABASE
• CONFIGURE & DROP A DATABASE
• MANAGE DBCA TEMPLATES

CONTROLLING THE DATABASE ENVIRONMENT
• STARTING & STOPPING DATABASE CONTROL
• STARTING & STOPPING ISQL*PLUS
• DATABASE LISTENER CONFIGURATION USING EM
• STARTING & STOPPING THE DATABASE
• HANDLING PARAMETER FILES & PARAMETER SETTINGS

MANAGING DATA: EXPORTING & IMPORTING DATA
• CREATE DIRECTORY OBJECTS
• ABOUT THE DATA PUMP ARCHITECTURE
• DATA PUMP EXPORT
• DATA PUMP IMPORT
• DATA PUMP DATA DICTIONARY VIEWS
• USING THE EM INTERFACE

STORAGE STRUCTURES: TABLESPACES, DATA FILES & TEMP FILES
• ABOUT ORACLE 10G TABLESPACES
• TABLESPACE MANAGEMENT
• MORE ABOUT PERMANENT TABLESPACES
• About DATABASE_PROPERTIES
• MORE ABOUT TEMPORARY TABLESPACES
• MORE ABOUT BIGFILE TABLESPACES
• MORE ABOUT THE SYSAUX TABLESPACE
• MANAGING DATA FILES

UNDO MANAGEMENT
• ABOUT UNDO SPACE MANAGEMENT
• CONFIGURE UNDO MANAGEMENT
• UNDO_MANAGEMENT
• UNDO_TABLESPACE
• UNDO_RETENTION
• GUARANTEE UNDO RETENTION
• MONITOR UNDO SPACE
• USE THE UNDO ADVISOR

PERFORMANCE MONITORING & PROACTIVE MAINTENANCE
• THE MANAGEMENT & ADVISORY FRAMEWORK
• MANAGING THE AUTOMATIC WORKLOAD REPOSITORY
• AUTOMATIC DATABASE DIAGNOSTIC MONITOR
• METRICS & ALERT THRESHOLDS
• USING THE SEGMENT ADVISOR
• MTTR ADVISOR & TUNING CHECKPOINTS
• LOG_CHECKPOINTS_TO_ALERT
• REDO LOG FILE SIZE ADVISOR
• ISOLATING PERFORMANCE PROBLEMS
• AUTOMATIC OPTIMIZER STATISTICS COLLECTION
• GATHER_STATS_JOB

ORACLE FLASHBACK TECHNOLOGY
• ABOUT FLASHBACK TECHNOLOGY
• FLASHBACK QUERY
• SELECT...AS OF TIMESTAMP
• SELECT...AS OF SCN
• FLASHBACK TABLE
• FLASHBACK DROP
• FLASHBACK VERSIONS QUERY
• FLASHBACK TRANSACTION QUERY

FLASHBACK DATABASE
• ABOUT FLASHBACK DATABASE
• CONFIGURING THE FLASH RECOVERY AREA
• MONITORING FLASHBACK DATABASE PERFORMANCE
• FLASHBACK DATABASE CONSIDERATIONS

RMAN ENHANCEMENTS
• RMAN & DATABASE RECOVERY ENHANCEMENTS
• INCREMENTAL CUMULATIVE MERGE BACKUPS
• CROSS-PLATFORM TRANSPORTABLE TABLESPACES

MANAGING RESOURCES
• DATABASE RESOURCE MANAGER ARCHITECTURE
• CONSUMER GROUPS
• RESOURCE PLANS
• AUTOMATIC & ADAPTIVE CONSUMER GROUP MAPPING
• ENABLING & MONITORING THE RESOURCE MANAGER
• EXPLICIT CONSUMER GROUP SWITCHING

AUTOMATING TASKS WITH THE DATABASE SCHEDULER (BASIC)
• SCHEDULER ARCHITECTURE
• MANAGE PROGRAMS
• MANAGE SCHEDULES
• MANAGE JOBS

AUTOMATING TASKS WITH THE DATABASE SCHEDULER (ADVANCED)
• MANAGE JOB CLASSES
• MANAGE WINDOWS & WINDOW GROUPS
• MANAGE CHAINS
• ABOUT EVENTS & THE SCHEDULER

MONITORING & MANAGING MEMORY
• AUTOMATIC SHARED MEMORY MANAGEMENT
• USING EM & THE MEMORY ADVISORS
• MONITOR IN MEMORY ACCESS MODE

AUTOMATIC STORAGE MANAGEMENT
• ASM & THE BROADER DATABASE ARCHITECTURE
• DEFINING AN ASM INSTANCE
• CONFIGURING STORAGE IN THE ASM INSTANCE
• ASM & THE ORACLE UNIVERSAL INSTALLER
• ASM & THE DBCA
• USING ASMCMD
• MIGRATING AN EXISTING DATABASE TO ASM

MISCELLANEOUS ENHANCEMENTS
• MANAGING THE REDO LOG BUFFER
• LOGMINER ENHANCEMENTS
• RESUMABLE SPACE ALLOCATION ENHANCEMENT
• AUDIT DATABASE ACTIVITY OPTIONS
• THE PRINCIPLE OF LEAST PRIVILEGE
• REGULAR EXPRESSIONS

Return to Top