Performance Tuning Oracle and RAC on Linux & UNIX

Catalog Home Databases, Business Intelligence & Data Science Oracle Administration

Performance Tuning Oracle and RAC on Linux & UNIX

  Add Course to watch list
  View full course outline
  Request in your area

There are no scheduled dates for this course.

  Available by Request

Students will become proficient in all aspects of Oracle database performance tuning; this includes database and instance tuning, and SQL tuning. The hardware and software interactions that affect Oracle database performance are also covered in this course and include tuning the operating system, Oracle I/O and storage area networks. Hands-on lab exercises will be used to reinforce key Oracle performance tuning concepts.

Students should have successfully completed an Oracle Administration class and previous Oracle SQL training is recommended.

4 Days/Lecture & Lab

This class is designed for the DBA, system administrator, developer, or technical consultant who wishes to learn how to tune Oracle databases on the Linux or UNIX operating systems for maximum performance.

  • Overview of Oracle Database Performance Tuning
  • Defining an Effective Tuning Strategy
  • Linux or UNIX Configuration and Tuning for Oracle
  • Tuning SAN I/O for Oracle
  • Diagnostic and Tuning Tools
  • Tuning the Shared Pool and Buffer Cache
  • Dynamic Instance Resizing and sizing SGA Structures
  • Tuning the Oracle Shared Server
  • Optimizing Sort Operations
  • Managing Statistics and using Resource Manager
  • SQL Statement tuning, index tuning and optimizer operations
  • Application Tuning
  • Using Oracle blocks and data storage structures efficiently
  • Using Materialized Views
  • Monitoring and Detecting Lock Contention
  • Introduction to Oracle RAC
  • Oracle RAC Performance Tuning
  • Using the Oracle Parallel Query Option




< >

Recently Viewed Courses:

Copyright © 2018 ProTech. All Rights Reserved.

Sign In Create Account

Navigation

Social Media