title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Oracle Database 11g R1 & R2: New Features For Administrators
Duration
5 Days
Course
DBOR-927
Available Formats
Classroom Training, Online Training
Course Description
Overview
This Oracle Database 11g R1 & R2: New Features For Administrators course is designed to assist experienced Oracle database administrators with 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.Objectives
Upon completion of the Oracle Database 11g R1 & R2: New Features For Administrators course, students will be able to:
- Discuss changes, enhancements and new features within the database architecture, the database parameters and the utilities and facilities used by administrators.
- Utilize 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.
- Manage security enhancements include encryption of data, database security attack countermeasures, enhanced default security settings, and the SecureFiles storage mechanism.
- Handle backup and recovery enhancements provided through the RMAN framework.
- Duplicate and clone databases for the creation of test platforms, standby
- database installations and application workload replay.
- Guide recovery of database failures and corruption using the Data Recovery Advisor.
- Use the Automatic Storage Management (ASM) enhancements and other 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.
- 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.
Audience
- Database administrators
- Web server administrators
- System administrators
- Implementation specialists
- Data center support engineers
- Senior application designers and developers
Prerequisites
-
The mandatory prerequisite for this course is experience administering an Oracle database using version Oracle 10g. Those who lack such experience should complete the curriculum for new database administrators comprising the following course modules:
- ORACLE DATABASE 11G: ADMINISTRATION I (DBOR 923)
- ORACLE DATABASE 11G: ADMINISTRATION II (DBOR 924)
- ORACLE DATABASE 11G: BACKUP & RECOVERY
Topics
- 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
- START the installation
- DESKTOP class installation 11g r2
- POST-installation configuration
- DATABASE upgrade
- NETCA
- DBUA
- ONLINE patching
- ORACLE deinstaller
- ORACLE advanced compression
- HIGH-CAPACITY disks & the redo files
- COMPRESSED tables
- HYBRID columnar compression
- DEFERRED segment creation
- NEW instance background processes
- ORACLE exadata storage server
- EDITIONS & online redefinition
- MISCELLANEOUS parameter changes
- UNDO_MANAGMENT
- ABOUT memory management
- AUTOMATIC memory management
- MEMORY_TARGET
- MEMORY_MAX_TARGET
- USING EM & the memory advisors
- THE database smart flash cache
- ABOUT the result cache
- Configuring the result cache
- RESULT_CACHE_MAX_SIZE
- RESULT_CACHE_MOD
- RESULT_CAHCE_MAX_RESULT
- RESULT_CACHE_REMOTE_EXPIKRATION
- 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$RESLUT_CACHE_DEPENDENCY
- TRANSPARENT data encryption
- MANAGING TDE
- IMPLEMENTING column encryption
- LOB concepts & terminology
- BASICFILES LOB
- ALTER table
- SECUREFILES LOBS
- USING EM
- MONITORING securefiles performance
- MIGRATING basicfiles to securefiles
- DATA pump encryption
- BACKUP set encryption
- EM backup encryption
- DECRYPT during recovery
- TABLESPACE encryption
- SQL create tablespace with encryption
- ENHANCED default security settings
- ENHANCED security options
- DIAGNOSING database problems
- LOCKING enhancements
- DDL_LOCK_TIMEOUT parameter
- INVISIBLE indexes
- AUTOMATIC maintenance tasks
- WHAT is grid infrastructure?
- IDENTIFY system requirements
- MANAGING Linux devices
- MANAGING MS Windows devices
- CONFIGURE Linux installation
- GRID infrastructure installation
- VERIFY the installation
- SUBSEQUENT database installation
- ADMINISTERING the ASM instance
- ASM migration using EM
- ORACLE 11g ASM enhancements
- COMPATIBLE.ASM and compatible.rdbms
- DISK_REPAIR_TIME
- ASM_PREFFERED_READ_FAILURE_GROUPS
- ADMINISTRATION using EM
- 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()
- CONFIGURING the flash recovery area
- PERFORMING database flashback
- MONITORING flashback performance
- FLASHABCK database considerations
- CONFIGURE flashback data archive
- VIRTUAL private catalogs
- MANAGE VPC rights
- MANAGE a VPC
- BULIDING dynamic scripts
- BACKUP optimization
- ENHANCED parallelism & selection sizes
- ARCHIVAL backups
- WHY perform database duplication?
- RMAN duplicate database
- RMAN duplicate
- DATABASE cloning
- 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
- UNDERSTANDING the application architecture
- SYSTEMS infrastructure changes
- CHANGE management lifecycle
- PREPARING the capture database
- WORKLOAD capture using the EM wizard
- WORKLOAD capture using the API
- REQUIREMENTS of a replace database
- RMAN duplicate
- PREPROCESS captured workload
- REPLAY prerequisites
- REPLAY workload
- MONITOR the replay operation
- LAUNCH replay analysis
- CONDUCT configuration chance analysis
- USE the PL/SQL API
- 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
- SQL PERFORMANCE ANALYSIS-4
- SQL PERFORMANCE ANALYSIS-5
- SQL PERFORMANCE ANALYSIS-6
- SQL PERFORMANCE ANALYSIS-7
Related Courses
-
Oracle Database 11g R2 Administration I
DBOR-923- Duration: 5 Days
- Delivery Format: Classroom Training, Online Training
- Price: 3,500.00 USD
-
Oracle Database 11g R2 Administration II
DBOR-924- Duration: 5 Days
- Delivery Format: Classroom Training, Online Training
- Price: 3,500.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart