ORA11g204 - Oracle Database 11g: New Features For Administrators
Course
ORA11g204
Price:
$3,195.00
Software Assurance Value:
Not Eligible
Duration:
5 Days
SQLSoft Course ora11g204: Oracle Database 11g: New Features For Administrators
Table of Contents
Introduction
Audience
At Course Completion
Prerequisites
Certified Professional Exams
Student Materials
Course Outline
Introduction
The purpose of this course is to present some of the most advanced features available to database administrators which were either introduced with the Oracle 11g release or have been substantially improved with that release.
Return to Top
Audience
The primary target audience for this course is Oracle database administrators. Oracle web server and application server administrators, as well as others who must manage an embedded repository database using Oracle database technology will also find this information useful.
This course is also recommended for technical consultants, support engineers, project managers and other technical management and support personnel.
Return to Top
At Course Completion
Specific subject areas to be explored and objectives to be reached are:
- The Transparent Data Encryption (TDE) option for enhanced data security.
- Utilizing diagnostic sources in troubleshooting database problems and employing the Fault Diagnosability Infrastructure to capture fault data.
- Using Oracle flashback technology to recover from user errors, including flashback data archive and flashback transaction backout along with the Total Recall capability.
- Use advanced Enterprise Manager wizards and tools, including the integrated LogMiner, Flasback Transaction Backout wizard, database Recovery Wizard, and others.
- Review the goals of change management, change assurance and how these are implemented with Real Application Testing technology available with the Oracle 11g database.
- Learn how to perform the capture of a production database workload while not interfering with the applications or users involved.
- Learn how to replay the production workload on a test database configuration, providing a real-world test of how an actual application will function in an envisioned database configuration.
- Learn how to configure clients which will simulate the network interaction of real-world users in a test configuration.
- Perform a detailed analysis of application execution within proposed database configurations to assess whether the application performance will progress or regress as a result of the proposed change.
- Use the SQL Performance Analyzer tool to measure progression or regression of individual SQL statements under a proposed database configuration, providing a detailed level of change assurance before the change ever occurs.
- Learn the use the Result Cache for improved SQL performance
- Learn to use SECUREFILES LOBs and migrate from BASICFILES
Return to Top
Prerequisites
Experience Oracle 10g professionals
Return to Top
Certified Professional Exams
Currently no exams are associated with this course
Return to Top
Student Materials
The student kit includes a comprehensive workbook and other necessary materials
for this class.
Return to Top
Course Outline
ENTERPRISE EDITION INSTALLATION & UPGRADE
UPGRADING TO 11g USING DBUA
IDENTIFY SYSTEM REQUIREMENTS
CONFIGURE THE LINUX / UNIX INSTALLATION ENVIRONMENT
CONFIGURE THE MS WINDOWS INSTALLATION ENVIRONMENT
THE OPTIMAL FLEXIBLE ARCHITECTURE (OFA)
ORACLE_BASE
ORACLE_HOME
DBCA
MANAGING MEMORY
AUTOMATIC MEMORY MANAGEMENT
MEMORY_TARGET
MEMORY_MAX_TARGET
USING EM & THE MEMORY ADVISORS
DIAGNOSING DATABASE PROBLEMS
ABOUT THE 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
SECURITY ENHANCEMENTS
PASSWORD CASE-SENSITIVITY
LIMITING DATABASE ATTACKS
PREVENTING DENIAL-OF-SERVICE ATTACKS
DISCLOSURE OF VULNERABILITIES
ORACLE NET SERVICES USER NOTIFICATIONS
ORACLE BASICFILES & SECUREFILES
LOB CONCEPTS & TERMINOLOGY
BASICFILES LOB
TABLE DDL WITH LOBS
CONTROLLING LOB PHYSICAL STORAGE
INITIALIZE INTERNAL LOBS
INITIALIZE EXTERNAL LOBS
LOB COLUMNS & SQL
SECUREFILES LOBS
MIGRATING BASICFILES TO SECUREFILES
MONITORING SECUREFILES PERFORMANCE
ORACLE FLASHBACK TECHNOLOGY
ABOUT FLASHBACK TECHNOLOGY
FLASHBACK QUERY
SELECT...AS OF TIMESTAMP
SELECT...AS OF SCN
Using DBMS_FLASHBACK()
CONFIGURING UNDO MANAGEMENT FOR FLASHBACK
UNDO_RETENTION
FLASHBACK TABLE
FLASHBACK DROP
FLASHBACK VERSIONS QUERY
FLASHBACK TRANSACTION QUERY
FLASHBACK TRANSACTION BACKOUT
USING LOGMINER
FLASHBACK DATABASE
ABOUT FLASHBACK DATABASE
CONFIGURING THE FLASH RECOVERY AREA
DB_RECOVERY_FILE_DEST
PERFORMING DATABASE FLASHBACK
MONITORING FLASHBACK PERFORMANCE
FLASHBACK DATABASE CONSIDERATIONS
CONFIGURE FLASHBACK DATA ARCHIVE
CHANGE MANAGEMENT
UNDERSTANDING THE APPLICATION ARCHITECTURE
SYSTEMS INFRASTRUCTURE CHANGES
ABOUT ITIL
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
DATABASE REPLAY
PREPROCESS CAPTURED WORKLOAD
REPLAY PREREQUISITES
REPLAY WORKLOAD
MONITOR THE REPLAY OPERATION
Using The SQL API
REPLAY ANALYSIS
LAUNCH REPLAY ANALYSIS
CONDUCT CONFIGURATION CHANGE ANALYSIS
AWR Compare Period Report Setup
AWR Report
ASH Report
USE THE PL/SQL API
SQL PERFORMANCE ANALYZER
ABOUT SQL PERFORMANCE ANALYSIS
MANAGING SQL TUNING SETS
SQL PERFORMANCE ANALYZER TASKS
SQL PERFORMANCE ANALYSIS
USING THE DATABASE RESULT CACHE
CONFIGURING THE RESULT CACHE
USING THE RESULT CACHE
MANAGING & MONITORING THE RESULT CACHE
TRANSPARENT DATA ENCRYPTION & SECURITY
DATABASE WALLET
COLUMN ENCRYPTION
ENHANCED DATABASE SECURITY MODE
DATA RECOVERY ADVISOR
REPAIRING DATA FAILURES
USING THE DATA RECOVERY ADVISOR FROM EM
RMAN DATA RECOVERY FAILURE REPAIR
DETECTING CORRUPTION
USING RMAN
USING A VIRTUAL PRIVATE CATALOG
BACKUP SET ENCRYPTION
RMAN DUPLICATE DATABASE
Return to Top
