|
ora10g204-ver4
Oracle Database 10g R1 & R2: New Features For Administrators (5 day)
Description
This Oracle 10g courseware training guide book will review all of the major administration features and improvements introduced with Release 1 and Release 2 of the Oracle database version 10g. 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.
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.
Prerequisites
The mandatory prerequisite for this course is extensive experience administering an Oracle database using version Oracle9i. Those who lack such experience would be better served by completing the curriculum for new database administrators comprising the following Sideris course modules:
• The Sideris course ORACLE DATABASE 10G: ADMINISTRATION I
• The Sideris course ORACLE DATABASE 10G: ADMINISTRATION II
Those who have experience administering Oracle databases prior to Oracle9i should at least obtain and read the following course before proceeding onto this course:
• The Sideris course ORACLE 9i NEW & ADVANCED FEATURES FOR ADMINISTRATORS
Suggested Next Courses
Administrators may wish to obtain additional experience in the operating system platform on which their Oracle databases have been deployed. This is available from the Sideris curricula for MS Windows Server, Linux and UNIX. As alluded to above, the following Oracle courses are suggested to follow this course:
• The Sideris course ORACLE DATABASE 10G: SQL TUNING
• The Sideris course ORACLE DATABASE 10G: DATA WAREHOUSES
• The Sideris course ORACLE DATABASE 10G: IMPLEMENT PARALLEL SQL & PARTITIONING
Certification
This course covers information necessary to complete the following certification test:
• EXAM #1Z0-040 ORACLE DATABASE 10G: NEW FEATURES FOR ADMINISTRATORS
Objectives
Within this course, students will learn how 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.
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
|
|
|
|
