Course Description
The overall objective of this training module is to bring database administrators beyond a basic understanding of their duties and to transfer advanced skills needed to effectively administer an Oracle database installation within a large-scale enterprise. Important subject areas include advanced database configuration, performance monitoring and tuning, configuring for recovery, troubleshooting and fault diagnosis, and use of the extensive advisory framework.
Course Audience:
The primary target audiences for this course are:
• Database administrators
• Web server administrators
• System administrators
• Implementation specialists
• Data center support engineers
• Senior application designers and developers
Course Outline:
MANAGING MEMORY
• ABOUT ADVANCED ADMINISTRATION
• ABOUT MANUAL MEMORY MANAGEMENT
• AUTOMATIC MEMORY MANAGEMENT
• MEMORY_TARGET
• MEMORY_MAX_TARGET
• SGA_TARGET
• SGA_MAX_SIZE
• WORKAREA_SIZE_POLICY &
PGA_AGGREGATE_TARGET
• USING EM & THE MEMORY ADVISORS
• MONITOR IN MEMORY ACCESS MODE
MANAGING STORAGE & THE SEGMENT ADVISOR
• MONITOR TABLESPACES
• ABOUT RESUMABLE SPACE ALLOCATION
• TABLE STORAGE MANAGEMENT
• USE THE SEGMENT ADVISOR
GLOBALIZATION
• GLOBALIZATION SETTINGS
• NLS_LANG
• NLS_LANGUAGE & NLS_TERRITORY
• DATE & TIME LOCALIZATION
• LINGUISTIC INDEXES
• ABOUT LOCALE BUILDER
DIAGNOSING DATABASE PROBLEMS
• FAULT DIAGNOSABILITY INFRASTRUCTURE
• USING THE ALERT LOG
• ABOUT THE TRACE FILES
• DATABASE INSTANCE HEALTH SNAPSHOT
• USING THE SUPPORT WORKBENCH
• ENABLE ORACLE CONFIGURATION MANAGE
RECOVERY CONCEPTS
• THE BACKUP & RECOVERY STRUCTURES
• ORACLE SECURE BACKUP
• MANAGING REDO DATA
• MANAGING ARCHIVED REDO DATA
• CHECKLIST FOR SOUND RECOVERY
ORACLE FLASHBACK TECHNOLOGY