Oracle Database 11g: Performance Self-Study Course

Oracle Database 11g: Performance Self-Study Course

$231.40check
  • VAT: excluding VAT
  • Price completeness: This price is complete, there are no hidden additional costs.
Oracle University
Start
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.

Start
Starting dates and places
There are no known starting dates for this product.
  • View related products with starting dates: Oracle 11G.

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. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle 11G, CompTIA A+ / Network+ / Security+, Oracle, IT Security, and Retail (Management).

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. If you have any more questions or need help, contact our customer service.