Oracle 10g Database: Performance Tuning Course

Topics covered on the 5 day Oracle 10g Database: Performance Tuning course

COURSE INTRODUCTION

PERFORMANCE TUNING OVERVIEW

• DATABASE PERFORMANCE TUNING CONTEXT
• THE DATABASE INSTANCE TUNING METHODOLOGY

STATISTICS & WAIT EVENTS

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

USING STATSPACK

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

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()

METRICS, ALERTS & BASELINES

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

TUNING MEMORY: THE SHARED POOL

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

TUNING MEMORY: THE BUFFER CACHE

• MORE ABOUT THE BUFFER CACHE
• REMEDY PERFORMANCE ISSUES

TUNING MEMORY: AUTOMATIC SHARED MEMORY

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

TUNING I/O: CHECKPOINT & REDO TUNING

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

TUNING I/O: DATABASE WRITES

SPACE TUNING: PGA & TEMPORARY SPACE

• PGA MEMORY MANAGEMENT
• TEMPORARY SPACE MANAGEMENT

SPACE TUNING: BLOCK SPACE USAGE

• USING THE SHRINK SPACE OPTION
• USING THE SEGMENT ADVISOR