Oracle Database 11g Release 2: General New Features of Patch Set 1 - NEW
Currently, no providers in North America have scheduled a date for this course. We can schedule a class at one of our regional offices or on-site at your location.
- Vendor:
- Oracle Corporation
- Course:
- D71318GC10
- Start Date:
- Unscheduled
- Length:
- 1 Day
- Location:
- Expired Class Date
- Tuition:
- $650
No Dates
Scheduled
Course Description
This course gives students the opportunity to learnabout the general new features of the Oracle Database11g (11.2.0.2). Students examine the benefits and useof the new features in managing storage and space,strengthening resource management and databasemanageability.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 environmentsIdentify technical advantages and business benefits associated with these technologiesProceed towards the adoption and implementation of Oracle Database 11g Patch Set 1 with greater confidenceA Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.
Skills Gained
- 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
Who Can Benefit
- Data Warehouse Administrator
- Database Administrators
- Database Designers
- Support Engineer
- Technical Consultant
Syllabus
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
