Course Search:
Request more details:


Print Page

Oracle Database 11g R1 & R2: New Features For Administrators

Description:
This Oracle 11g courseware training course willassist experienced Oracle database administrators to quickly learn the new features and concepts associated with the 11g release of the Oracle database. Based upon this knowledge one will be able to utilize these features and realize the benefits they bring.
  • Cost: Price on application
  • Duration: 5 Days
  • This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
The mandatory prerequisite for this course is experience administering an Oracle database using version Oracle 10g. Those who lack such experience would be better served by completing the curriculum for new database administrators comprising the following course modules:
• ORACLE DATABASE 11G: ADMINISTRATION I
• ORACLE DATABASE 11G: ADMINISTRATION II
• ORACLE DATABASE 11G: BACKUP & RECOVERY

Those who only have experience administering Oracle databases prior to Oracle 10g should at least obtain and read the course ORACLE DATABASE: 10G NEW & ADVANCED FEATURES FOR ADMINISTRATORS before proceeding onto this course.
Volume 1:
CONFIGURING THE SERVER FOR INSTALLATION
IDENTIFY SYSTEM REQUIREMENTS
OPTIMAL FLEXIBLE ARCHITECTURE (OFA)
ORACLE_BASE
ORACLE_HOME
CONFIGURE LINUX INSTALLATION
ORACLE_HOSTNAME Environment Variable
CONFIGURE MS WINDOWS INSTALLATION
ORACLE_HOME Variable
ORACLE_HOSTNAME Variable
PREREQUISITE CHECKS & FIXUP UTILITY
ENTERPRISE EDITION INSTALLATION:
START THE INSTALLATION
DESKTOP CLASS INSTALLATION 11G R2
POST-INSTALLATION CONFIGURATION
UPGRADE, DEINSTALLATION & PATCHING:
DATABASE UPGRADE
NETCA
DBUA
ONLINE PATCHING
ORACLE DEINSTALLER
STORAGE ENHANCEMENTS:
ORACLE ADVANCED COMPRESSION
HIGH-CAPACITY DISKS & THE REDO FILES
COMPRESSED TABLES
HYBRID COLUMNAR COMPRESSION
DEFERRED SEGMENT CREATION
DATABASE ARCHITECTURE CHANGES:
NEW INSTANCE BACKGROUND PROCESSES
ORACLE EXADATA STORAGE SERVER
EDITIONS & ONLINE REDEFINITION
MISCELLANEOUS PARAMETER CHANGES
UNDO_MANAGEMENT
AUTOMATIC MEMORY MANAGEMENT:
ABOUT MEMORY MANAGEMENT
AUTOMATIC MEMORY MANAGEMENT
MEMORY_TARGET
MEMORY_MAX_TARGET
USING EM & THE MEMORY ADVISORS
THE DATABASE SMART FLASH CACHE
USING THE DATABASE RESULT CACHE:
ABOUT THE RESULT CACHE
CONFIGURING THE RESULT CACHE
RESULT_CACHE_MAX_SIZE
RESULT_CACHE_MODE
RESULT_CACHE_MAX_RESULT
RESULT_CACHE_REMOTE_EXPIRATION
USING THE RESULT CACHE
RELIES_ON Clause
MANAGING & MONITORING RESULT CACHE
Using V$RESULT_CACHE_STATISTICS
V$RESULT_CACHE_MEMORY
V$RESULT_CACHE_OBJECTS
V$RESULT_CACHE_DEPENDENCY
ENABLING TRANSPARENT DATA ENCRYPTION:
TRANSPARENT DATA ENCRYPTION
MANAGING TDE
IMPLEMENTING COLUMN ENCRYPTION
ORACLE SECUREFILES:
LOB CONCEPTS & TERMINOLOGY
BASICFILES LOB
ALTER TABLE
SECUREFILES LOBS
Using EM
MONITORING SECUREFILES PERFORMANCE
MIGRATING BASICFILES TO SECUREFILES
ADDITIONAL SECURITY ENHANCEMENTS:
DATA PUMP ENCRYPTION
BACKUP SET ENCRYPTION
EM Backup Encryption
RMAN Backup Encryption
Decrypt During Recovery
TABLESPACE ENCRYPTION
SQL Create Tablespace With Encryption
ENHANCED DEFAULT SECURITY SETTINGS
ENHANCED SECURITY OPTIONS
DIAGNOSING DATABASE PROBLEMS:
FAULT DIAGNOSABILITY INFRASTRUCTURE
ADR Highlights From EM
USING THE ALERT LOG
ABOUT THE TRACE FILES
DATABASE INSTANCE HEALTH SNAPSHOT
USING THE SUPPORT WORKBENCH
ENABLE ORACLE CONFIGURATION MANAGER
MISCELLANEOUS NEW FEATURES:
LOCKING ENHANCEMENTS
DDL_LOCK_TIMEOUT Parameter
INVISIBLE INDEXES
AUTOMATIC MAINTENANCE TASKS
Volume 2:
GRID INFRASTRUCTURE INSTALLATION
WHAT IS THE GRID INFRASTRUCTURE?
IDENTIFY SYSTEM REQUIREMENTS
MANAGING LINUX DEVICES
MANAGING MS WINDOWS DEVICES
CONFIGURE LINUX INSTALLATION
GRID INFRASTRUCTURE INSTALLATION
VERIFY THE INSTALLATION
SUBSEQUENT DATABASE INSTALLATION
AUTOMATIC STORAGE MANAGEMENT:
ADMINISTERING THE ASM INSTANCE
ASM MIGRATION USING EM
ORACLE 11G ASM ENHANCEMENTS
COMPATIBLE.ASM and COMPATIBLE.RDBMS
DISK_REPAIR_TIME
ASM_PREFERRED_READ_FAILURE_GROUPS
ADMINISTRATION USING EM
ORACLE FLASHBACK TECHNOLOGY:
FLASHBACK QUERY
SELECT...AS OF TIMESTAMP
SELECT...AS OF SCN
FLASHBACK TABLE
FLASHBACK DROP
FLASHBACK VERSIONS QUERY
FLASHBACK TRANSACTION QUERY
FLASHBACK TRANSACTION BACKOUT
Using DBMS_FLASHBACK()
FLASHBACK DATABASE:
CONFIGURING THE FLASH RECOVERY AREA
PERFORMING DATABASE FLASHBACK
MONITORING FLASHBACK PERFORMANCE
FLASHBACK DATABASE CONSIDERATIONS
CONFIGURE FLASHBACK DATA ARCHIVE
RMAN ENHANCEMENTS:
VIRTUAL PRIVATE CATALOGS
Manage VPC Rights
Manage A VPC
BUILDING DYNAMIC SCRIPTS
BACKUP OPTIMIZATION
ENHANCED PARALLELISM & SECTION SIZES
ARCHIVAL BACKUPS
DATABASE DUPLICATION & CLONING:
WHY PERFORM DATABASE DUPLICATION?
RMAN DUPLICATE DATABASE
RMAN DUPLICATE
DATABASE CLONING
RECOVERY WITH DATA RECOVERY ADVISOR:
DETECTING CORRUPTION
V$DATABASE_BLOCK_CORRUPTION View
DB_BLOCK_CHECKING
DB_BLOCK_CHECKSUM
DB_LOST_WRITE_PROTECT
DB_ULTRA_SAFE
RECOVERY USING DATA RECOVERY ADVISOR
RMAN Interface
Volume 3:
CHANGE MANAGEMENT
UNDERSTANDING THE APPLICATION ARCHITECTURE
SYSTEMS INFRASTRUCTURE CHANGES
CHANGE MANAGEMENT LIFECYCLE
WORKLOAD CAPTURE:
PREPARING THE CAPTURE DATABASE
WORKLOAD CAPTURE USING THE EM WIZARD
WORKLOAD CAPTURE USING THE API
CONFIGURE THE REPLAY DATABASE:
REQUIREMENTS OF A REPLAY DATABASE
RMAN DUPLICATE
DATABASE REPLAY:
PREPROCESS CAPTURED WORKLOAD
REPLAY PREREQUISITES
REPLAY WORKLOAD
MONITOR THE REPLAY OPERATION
SQL PERFORMANCE ANALYZER:
ABOUT SQL PERFORMANCE ANALYSIS
MANAGING SQL TUNING SETS
SQL PERFORMANCE ANALYZER TASKS
SQL PERFORMANCE ANALYSIS
SOLUTIONS
SQL PERFORMANCE ANALYSIS-1
SQL PERFORMANCE ANALYSIS-2
SQL PERFORMANCE ANALYSIS-3 •
QL PERFORMANCE ANALYSIS-4
SQL PERFORMANCE ANALYSIS-5
SQL PERFORMANCE ANALYSIS-6
SQL PERFORMANCE ANALYSIS-7
REPLAY ANALYSIS:
LAUNCH REPLAY ANALYSIS
CONDUCT CONFIGURATION CHANGE ANALYSIS
USE THE PL/SQL API


Dublin: 01 6627700 - Cork: 021 4319010 - Limerick: 061 311982

© Professional Training Solutions Limited 1996-2012
CRO No. 252390 - Unit 22, Westland Square, Pearse Street, Dublin 2, Ireland.