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

Total time

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

Oracle University
Logo Oracle University
Provider rating: starstar_borderstar_borderstar_borderstar_border 2 Oracle University has an average rating of 2 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

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.

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

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Data Warehouse, Oracle 11G, Oracle, Business Intelligence (BI), and Microsoft SQL Server.

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

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.