Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > Oracle 11g > Oracle 11g Database Performance Tuning Training

Oracle 11g Database Performance Tuning Training

Course#: WA1805

Get the most out of your Database by learning performance tuning methods that maximize the utility of the database. Students learn how to benefit from Oracle Database automatic tuning features, as well as practicing the manual tuning methods. After clearly defining the various methodologies one can use to tune an Oracle Database, the course covers the various tunable components of an Oracle Database. Throughout the course, students experience hands-on the tuning of an Oracle Database by practicing through a series of workshops.

Objectives

  • Use the Oracle Database tuning methodology appropriate to the available tool
  • Utilize database advisors to proactively tune an Oracle database
  • Use the tools based on the Automatic Workload Repository to tune the database
  • Understand Automatic Memory Management vs. Automatic Shared Memory Management
  • Diagnose and tune common database performance problems
  • Implement Real Application Testing
  • Understand the benefits of private statistics
  • Create invisible indexes
  • Setup and monitoring Result Cache usage 

Audience 

  • Database Administrators
  • Support Engineer
  • Technical Consultant  

Prerequisites 

None

Duration

Four days

Outline of WA1805 Oracle 11g Database Performance Tuning Training

1. Performance Tuning Overview

  • Write appropriate tuning goals
  • Apply the tuning methodology
  • Balance performance and safety trade-offs
  • Identify common tuning problems

2. Statistics and Wait Events

  • Identify dynamic performance views useful in tuning
  • Identify key tuning components of the alert log file
  • Identify key tuning components of user trace files
  • Use dynamic performance views to view statistics and wait events
  • Implementing Private Statistics – 11g

3. Metrics, Alerts, and Baselines

  • View metrics using the metrics history views
  • Create metric thresholds
  • View alerts
  • Create metric baselines
  • Enable adaptive thresholds

4. Using AWR

  • Create and manage AWR snapshots
  • Generate AWR reports
  • Create snapshot sets and compare periods
  • Generate ADDM reports
  • Generate ASH reports

5. Tuning the Shared Pool

  • Diagnose shared pool problems
  • Size the shared pool
  • Size the reserved area
  • Keep objects in the shared pool
  • The Result Cache – 11g

6. Tuning the Buffer Cache

  • Describe the buffer cache architecture
  • Size the buffer cache
  • Resolve common performance issues related to the buffer cache
  • Use common diagnostic indicators to suggest a possible solution

7. Automatic Shared Memory

  • Enable Automatic Shared Memory
  • Set auto-tuned memory parameters
  • Set the manually tuned SGA parameters
  • Use the SGA advisor to set SGA target
  • Enable Automatic Memory Management – 11g

8. Checkpoint and Redo Tuning

  • Diagnose checkpoint and redo issues
  • Implement Fast Start MTTR target
  • Monitor performance impact of Fast Start MTTR target
  • Implement multiple database writers
  • Tune the redo chain
  • Size the redo log file
  • Size the redo log buffer

9. Tuning I/O

  • Diagnose database I/O issues
  • Choose appropriate I/O solutions
  • Invisible Indexes – 11g

10. Tuning Block Space Usage

  • Tune segment space management
  • Convert from dictionary managed tablespaces
  • Convert to automatic segment space management
  • Tune block space management
  • Diagnose and correct row chaining - Diagnose table fragmentation

11. Real Application Testing – 11g

  • Real Application Testing Overview
  • Database Replay
  • Supported/Unsupported Workloads
  •  
    • Capture Steps
    • Replay Steps
  • SQL Performance Analyzer (SPA)
  •  
    • SQL Tuning Sets
    • SPA Steps

12. Initial Configuration

  • List best practices identified throughout the course
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.