Oracle Database 10g R1 & R2: New Features For Administrators
Oracle Training Overview
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.
Oracle Training 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 course modules:
Those who have experience administering Oracle databases prior to Oracle9i should at least obtain and read the following course before proceeding onto this course:
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 curricula for MS Windows Server, Linux and UNIX. As alluded to above, the following Oracle courses are suggested to follow this course:
Oracle Training Objectives
Within this course, students will learn how to:
Oracle Training 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
Oracle Training Certification Examination
This course covers information necessary to complete the following certification test:
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
Oracle Training Course duration
5 Days
Oracle Training Course outline
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
