Oracle Database 11g: Performance Self-Study Course

Logo Oracle University

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 eStudy introduces you to the features in Oracle Database 11g that are relevant for Performance.


Audience
  • Support Engineer
  • Technical Administrator
  • End Users
  • Database Administrators

Course Topics Performance New Features
  • Foreground Statistics
  • Online Redefinition Enhancements
  • Minimizing Dependent Recompilations
  • PL/SQL and Java Native Compilation Enhancements
  • Temporary Tablespace Shrink
  • DBA_TEMP_FREE_SPACE
  • Adaptive Cursor Sharing: Overview & Architecture
  • Easier Recovery from Loss of SPFILE
Using Result Caches
  • SQL Query Result Cache: Overview
  • Setting Up SQL Query Result Cache
  • Managing the SQL Query Result Cache
  • SQL Query Result Cache: Consideration
  • OCI Client Query Cache
  • PL/SQ…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. Send an Email to info@springest.com

Didn't find what you were looking for? See also: Statistics, SQL, Java, Oracle, and Hour of Code.

This eStudy introduces you to the features in Oracle Database 11g that are relevant for Performance.


Audience
  • Support Engineer
  • Technical Administrator
  • End Users
  • Database Administrators

Course Topics Performance New Features
  • Foreground Statistics
  • Online Redefinition Enhancements
  • Minimizing Dependent Recompilations
  • PL/SQL and Java Native Compilation Enhancements
  • Temporary Tablespace Shrink
  • DBA_TEMP_FREE_SPACE
  • Adaptive Cursor Sharing: Overview & Architecture
  • Easier Recovery from Loss of SPFILE
Using Result Caches
  • SQL Query Result Cache: Overview
  • Setting Up SQL Query Result Cache
  • Managing the SQL Query Result Cache
  • SQL Query Result Cache: Consideration
  • OCI Client Query Cache
  • PL/SQL Function Cache
  • Using PL/SQL Function Cache
  • PL/SQL Function Cache: Considerations
Oracle SecureFiles
  • Managing Enterprise Information
  • Problems with Existing LOB Implementation
  • Enabling SecureFiles Storage
  • SecureFiles Advanced Features
  • Creating SecureFiles
  • Accessing SecureFiles Metadata
  • Migrating to SecureFiles
  • SecureFiles Demonstration

Course Objectives
  • Describe enhancements to locking mechanisms
  • Use the enhanced PL/SQL recompilation mechanism
  • Create and use invisible indexes
  • Describe Adaptive Cursor Sharing
  • Manage your SPFILE
  • Improve memory usage by caching result sets
  • Discuss LOB improvements using SecureFiles

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. Send an Email to info@springest.com