Home    |    Instructor-led Training    |    Online Training     
         
 
Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle Database 11g : New Features For Administrators
Oracle Training Overview

This Oracle 11g courseware training guide book will assist 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.

Oracle Training Course Objectives

Among the specific subjects we will consider are:
  • Install and initially configure, or upgrade the Oracle 11g database software.
  • Work within the structure of the changed Enterprise Manager (EM) interface and the database control.
  • Discuss changes, enhancements and new features within the database architecture, the database parameters and the utilities and facilities used by administrators.
  • Implement comprehensive Oracle 11g automatic memory management.
  • The Fault Diagnosability Infrastructure now included within the database and the first-failure data capture capabilities which enhance problem troubleshooting, diagnosis and resolution. Components include the Health Monitor, Support Workbench and Incident Packaging subsystem.
  • Security enhancements include encryption of data, database security attack countermeasures, enhanced default security settings, and the SecureFiles storage mechanism.
  • Backup and recovery enhancements provided through the RMAN framework.
  • Duplicating and cloning databases for the creation of test platforms, standby database installations and application workload replay.
  • Guided recovery of database failures and corruption using the Data Recovery Advisor.
  • Automatic Storage Management (ASM) enhancements.
  • Storage improvements including advanced compression techniques and algorithms.
  • Consider both the challenge and the necessity of changes to the systems infrastructure and how these can disrupt production applications.
  • Review the goals of change management, change assurance and how these are implemented with Real Application Testing technology available with the Oracle 11g database. An entire volume has been dedicated to Real Application Testing
  • 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.
Oracle Training Audience

The target audience for this course is database administrators with experience using earlier versions of the Oracle database server who wish to learn about the new and modified features introduced in Oracle 11g.

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
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.


Certification Examination

This course covers information necessary to upgrade ones Oracle Certified Professional (OCP) certification and complete the test EXAM #1Z0-050 ORACLE DATABASE 11G: NEW FEATURES.

Oracle Training Course duration

5 Days

Oracle Training Course outline

DATABASE INSTALLATION & UPGRADE
  • IDENTIFY SYSTEM REQUIREMENTS
  • THE OPTIMAL FLEXIBLE ARCHITECTURE (OFA)
  • ORACLE_BASE
  • ORACLE_HOME
  • CONFIGURE THE INSTALLATION ENVIRONMENT
  • ENTERPRISE EDITION INSTALLATION
  • DBCA
  • DATABASE UPGRADE PROCESS
  • DBUA
  • PATCHING OVERVIEW
DATABASE ARCHITECTURE CHANGES
  • REVIEW THE ORACLE ENTERPRISE ARCHITECTURE
  • MORE ABOUT THE ORACLE 11G DATABASE
  • UNDO_MANAGEMENT
AUTOMATIC MEMORY MANAGEMENT
  • ABOUT MEMORY MANAGEMENT
  • AUTOMATIC MEMORY MANAGEMENT
  • MEMORY_TARGET
  • MEMORY_MAX_TARGET
  • USING EM & THE MEMORY ADVISORS
DIAGNOSING DATABASE PROBLEMS
  • ABOUT THE FAULT DIAGNOSABILITY INFRASTRUCTURE
  • USING THE ALERT LOG
  • ABOUT THE TRACE FILES
  • DATABASE INSTANCE HEALTH SNAPSHOT
  • USING THE SUPPORT WORKBENCH
  • ENABLE ORACLE CONFIGURATION MANAGER
SECURITY ENHANCEMENTS
  • TRANSPARENT DATA ENCRYPTION
  • COLUMN ENCRYPTION
  • TABLESPACE ENCRYPTION
  • DATA PUMP ENCRYPTION
  • BACKUP SET ENCRYPTION
  • ENHANCED DEFAULT SECURITY SETTINGS
  • ENHANCED SECURITY OPTIONS
ORACLE SECUREFILES
  • LOB CONCEPTS & TERMINOLOGY
  • BASICFILES LOB
  • ALTER TABLE
  • SECUREFILES LOBS
  • MIGRATING BASICFILES TO SECUREFILES
  • MONITORING SECUREFILES PERFORMANCE
MISCELLANEOUS NEW FEATURES
  • LOCKING ENHANCEMENTS
  • AUTOMATIC MAINTENANCE TASKS
  • COMPRESSION
  • ASM ENHANCEMENTS
  • ASM_PREFERRED_READ_FAILURE_GROUPS
  • COMPATIBLE.ASM and COMPATIBLE.RDBMS
  • DISK_REPAIR_TIME
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 TRANSACTION BACKOUT
FLASHBACK DATABASE
  • ABOUT 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
  • BUILDING DYNAMIC SCRIPTS
  • BACKUP OPTIMIZATION
  • ENHANCING PARALLELISM WITH 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
  • DB_BLOCK_CHECKING
  • DB_BLOCK_CHECKSUM
  • DB_LOST_WRITE_PROTECT
  • DB_ULTRA_SAFE
  • RECOVERY USING THE DATA RECOVERY ADVISOR
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
REPLAY ANALYSIS
  • LAUNCH REPLAY ANALYSIS
  • CONDUCT CONFIGURATION CHANGE ANALYSIS
  • USE THE PL/SQL API
SQL PERFORMANCE ANALYZER
  • ABOUT SQL PERFORMANCE ANALYSIS
  • MANAGING SQL TUNING SETS
  • SQL PERFORMANCE ANALYZER TASKS
  • SQL PERFORMANCE ANALYSIS


Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved