Oracle - Course Details

OraD11gR2:GNFPS1 Oracle Database 11g Release 2: General New Features of Patch Set 1

Oracle Course Description:
This course gives students the opportunity to learn about the general new features of the Oracle Database 11g (11.2.0.2). Students examine the benefits and use of the new features in managing storage and space, strengthening resource management and database manageability. New features in Real Application Cluster (RAC) are not covered in this seminar.
Oracle Course Duration:
1 DAY
Oracle Course Target Audience:
Data Warehouse Administrator,Database Administrators,Database Designers,Support Engineer,Technical Consultant
Oracle Course Prerequisite:
NONE
Course Content:
Introduction to Oracle Database 11.2.0.2  Course Objectives Lesson Roadmap Installing and Upgrading with Patch Sets Upgrading Out-of-Place Upgrading In-Place New Software Updates Option New Software Updates Option Oracle ASM Configuration After Installation Grid Infrastructure Configuration after Installation Upgrading Grid Infrastructure Oracle ASM Configuration Assistant Enhancements Oracle ASM and ACFS Enhancements  What You Already Know: ASM, ADVM and ACFS Securing Oracle ACFS Protecting Oracle ACFS with Encryption Using Oracle ACFS Replication Enhanced Segment Management  Allocating Space Creating a Range-Partitioned Table Viewing Partitions With and Without Segments Controlling Deferred Segment Creation Segments on Demand: Scope Managing Space for Schema Objects Additional Automatic Functionality Viewing Segment Information in Enterprise Manager Performance Enhancements  Creating and Enabling Resource Plans Limiting Resource Usage Monitoring Resource Usage Managing Query Workloads Parallel Statement Queuing Managing Parallel Execution of Workloads Using the PARALLEL_TARGET_PERCENTAGE Attribute Prioritizing Parallel Statement Queuing Configuring Automatic SQL Tuning Enhanced Real Application Testing  Realistic Testing with Real Application Testing When to Use What? Data Dictionary Changes for Integration Using Enterprise Manager to Access SQL Performance Analyzer Preprocessing a Database Workload Using the Workload Analyzer Controlling DB Replay with Timeout Using Remote SPA with Active Data Guard