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 10g > Oracle Database 10g: Performance Tuning Training

Oracle Database 10g: Performance Tuning Training

Course#: WA1679

The purpose of this course is to equip database administrators to recognize, diagnose and remedy performance problems which might arise in the operation of the Oracle database server. Beyond reactive measures, proactive actions which can be taken to avoid performance issues before they arise or are recognized are also considered. This course goes beyond basic automatic tuning techniques discussed elsewhere within our database administrator curriculum and covers the whole range of tuning issues, including manual database tuning techniques, host system tuning, network and listener tuning, and others.

What you will learn 

Among the specific subjects discussed in this course are:

  • Utilization of advanced self-tuning and self-management capabilities, including the use of the database Advisors and other components of the Management Framework.
  • Performance monitoring, problem troubleshooting, and resolution.
    Detailed scrutiny of database activity using statistics and wait events, as well as a review of the underlying mechanisms and computations involved in the automatic tuning features of the Oracle10g release.
  • Manual database tuning using Statspack.
  • Tuning of the shared pool, buffer cache and shared memory structures, including little known techniques to address unique circumstances and challenges.
  • Tuning recovery structures such as checkpoints and redo data.
    Tuning physical storage structures such as file I/O and database blocks, detecting and reducing fragmentation of physical storage.
  • Tuning specialty structures such as the PGA and temporary space.
    Use of specialty performance tuning features, such as metrics, metric baselines, and alerts. 

Audience  

The target audience for this course is Oracle database administrators and data center support engineers and consultants. Additionally, senior database developers will benefit from an understanding of the architecture of the Oracle database with which they interface. 

Prerequisites 

Suggested prerequisites for this course are the following courses:

WA1380 Oracle Database 10g: Administration I
WA1381 Oracle Database 10g: Administration II 

Duration 

Four days.

Outline of WA1679 Oracle Database 10g: Performance Tuning Training

1. COURSE INTRODUCTION

2. PERFORMANCE TUNING OVERVIEW

  • DATABASE PERFORMANCE TUNING CONTEXT
  • THE DATABASE INSTANCE TUNING METHODOLOGY

3. STATISTICS & WAIT EVENTS

  • ABOUT THE DYNAMIC PERFORMANCE VIEWS
  • EXAMINING THE STATISTICS
  • INTERPRETING THE STATISTICS

4. USING STATSPACK

  • INSTALL THE STATSPACK UTILITY
  • CREATE STATSPACK SNAPSHOTS
  • GENERATE STATSPACK REPORTS
  • IDENTIFY THE REPORT SECTIONS

5. AUTOMATIC TUNING & >AWR

  • ABOUT THE MANAGEMENT & ADVISORY FRAMEWORK
  • MANAGING THE AUTOMATIC WORKLOAD REPOSITORY
  • ABOUT THE ACTIVE SESSION HISTORY (ASH)
  • AUTOMATIC DATABASE DIAGNOSTIC MONITOR
  • MANAGING SNAPSHOTS
  • CREATE_BASELINE() & DROP_BASELINE()
  • CREATE_SNAPSHOT() & DROP_SNAPSHOT_RANGE()

6. METRICS, ALERTS & BASELINES

  • METRICS & ALERT THRESHOLDS
  • MANAGING METRICS
  • MANAGING ALERTS
  • USE EM REAL-TIME MONITORS

7. TUNING MEMORY: THE SHARED POOL

  • MORE ABOUT THE SHARED POOL
  • DIAGNOSE SHARED POOL PROBLEMS
  • KEEP OBJECTS IN THE SHARED POOL

8. TUNING MEMORY: THE BUFFER CACHE

  • MORE ABOUT THE BUFFER CACHE
  • REMEDY PERFORMANCE ISSUES

9. TUNING MEMORY: AUTOMATIC SHARED MEMORY

  • AUTOMATIC SHARED MEMORY MANAGEMENT
  • USING EM & THE MEMORY ADVISORS

10. TUNING I/O: CHECKPOINT & REDO TUNING

  • TUNE REDO WRITING & ARCHIVING
  • MTTR ADVISOR & TUNING CHECKPOINTS
  • LOG_CHECKPOINTS_TO_ALERT
  • ADDITIONAL REDO TUNING OPTIONS

11. TUNING I/O: DATABASE WRITES

12. SPACE TUNING: PGA & TEMPORARY SPACE

  • PGA MEMORY MANAGEMENT
  • TEMPORARY SPACE MANAGEMENT

13. SPACE TUNING: BLOCK SPACE USAGE

  • USING THE SHRINK SPACE OPTION
  • USING THE SEGMENT ADVISOR
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.