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

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.

Learn To:

• Describe the key new capabilities in Oracle Database 11g (11.2.0.2)
• Identify how these new features can be applied in your own environments
• Identify technical advantages and business benefits associated with these technologies
• Proceed towards the adoption and implementation of Oracle Database 11g Patch Set 1 with greater confidence

Audience

• Database Administrators
• Data Warehouse Administrator
• Support Engineer
• Database Designers
• Technical Consultant

Course Topics 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

Course Objectives

• Describe the key new capabilities in Oracle Database 11g (11.2.0.2)
• Install and upgrade a database to Oracle Database 11g Release 2 Patch Set 1
• Use the Oracle ASM and ACFS enhancements
• Manage space with the enhanced segment management
• Strengthen your resource management
• Use the capabilities of the enhanced database manageability