Oracle Approved Education Provider
  
 

DBA performance tuning

Class times are from 9 A.M. to 5 P.M

 

This course will introduce participants to a series of tuning steps, which can be used to improve the performance of the Oracle9i Server. The focus is on Database and Instance tuning rather than specific operating system performance issues. Participants will gain practical experience tuning an Oracle database. Using the available Oracle tools, participants also learn how to recognize, troubleshoot and resolve common performance related problems in administering an Oracle database. The class includes a one-day interactive workshop that provides participants with real-world experience including problem diagnosis and performance enhancement.

Audience

  • Technical Support Professionals
  • System Administrators
  • Database Administrators

Required Prerequisites

  • Oracle9i:  DBA Fundamentals I
  • Oracle9i: DBA Fundamentals II

Suggested Prerequisites

Introduction to SQL (5 days)

Oracle Performance Tuning Methodology

  • Job Roles in tuning
  • Tuning during development phases
  • Service Level Agreements
  • Most common performance tuning problems
  • Tuning for Different Types of Applications
  • Tuning Methodology
  • Oracle Alert and Trace Files
  • Alert log file
  • Background process trace files
  • User trace files
  • Tuning Tools
  • Dictionary views providing statistics
  • Dynamic performance views
  • Oracle Wait Interface
  • DBA developed tools
  • OEM [describe how to use EM in the other lessons]
  • ANALYZE command and DBMS_STATS package
  • Sizing the Shared Pool
  • Library cache tuning
    • Library Cache Tuning Issues
    • Shared Server UGA Tuning
    • Guidelines for different application types
    • Fragmentation
    • Dictionary Cache (DC) Tuning
    • Dynamically resizing the Shared Pool

Course Objectives

  • Configure Resource Manager to control resource usage
  • Configure an Oracle Database with an emphasis on good performance.
  • Configure memory and disk resources to optimize sort operations
  • Detect and resolve latch and lock contention problems within the Oracle database environment
  • Diagnose and resolve performance issues associated with Shared Server
  • Identify and resolve I/O, data storage, and database configuration problems
  • List the important steps for outlining a tuning methodology
  • Perform day-to-day monitoring on an operational database using STATSPACK
  • Reconfigure file structures for performance and other considerations
  • Use Oracle tools to diagnose performance problems
  • Configure Resource Manager to control resource usage
  • Configure an Oracle Database with an emphasis on good performance.
  • Configure memory and disk resources to optimize sort operations
  • Detect and resolve latch and lock contention problems within the Oracle database environment
  • Diagnose and resolve performance issues associated with Shared Server
  • Identify and resolve I/O, data storage, and database configuration problems
  • List the important steps for outlining a tuning methodology
  • Perform day-to-day monitoring on an operational database using STATSPACK
  • Reconfigure file structures for performance and other considerations
  • Use Oracle tools to diagnose performance problems

Suggested Next Courses

  • Please check with your Education Representative to determine the appropriate follow up course.

Related Courses

No related Technology Bases Training Courseware is currently available.

- top -

[home] [about us] [people] [products] [investors] [training] [conferences] [news] [contact us]

Copyright RPC Data 2005
Site Design and Development by MindQ