Overview
Defining the
Scope of Performance Issues
• Defining the Scope of
Performance Issues Objectives
• Tuning Life Cycle Phases
Using the
Time Model to Diagnose Performance Issues
Using
Statistics and Wait Events to Diagnose Performance Issues
• Using Statistics and Wait Events
to Diagnose Performance Issues
• Instance Activity and Wait
Event Statistics
Using Log
and Trace Files to Monitor Performance
Using
Enterprise Manager Cloud Control and SQL Developer to Monitor Performance
Using
Statspack to View Performance Data
Using
Automatic Workload Repository
• Using Automatic Workload
Repository
• Managing AWR Data in a
Multitenant Environment
Using
Metrics and Alerts
Using
Baselines
Managing
Automated Maintenance Tasks
Using ADDM
to Analyze Performance
• Using ADDM to Analyze
Performance
• Compare Periods ADDM:
Analysis
Using Active
Session History Data for First Fault System Analysis
Using
Emergency Monitoring and Real-Time ADDM to Analyze Performance Issues
Overview of
SQL Statement Processing
• Overview
• Processing a DML Statement
Maintaining
Indexes
• Maintaining Indexes
• Automatic Indexing Task
Maintaining
Tables
• Maintaining Tables
• Block Space Management with
Free Lists
• Shrinking Segments: Overview
• Advanced Index Compression
Introduction
to Query Optimizer
• Introduction
• Using Initialization
Parameters to Control Optimizer Behavior
Understanding
Execution Plans
• Understanding Execution Plans
• SQL*Plus AUTOTRACE
Viewing
Execution Plans by Using SQL Trace and TKPROF
Managing
Optimizer Statistics
• Managing Optimizer Statistics
• Extended Statistics
Using
Automatic SQL Tuning
Using the
SQL Plan Management Feature
Overview of
the SQL Advisors
Using the
SQL Tuning Advisor
Using the
SQL Access Advisor
Overview of
Real Application Testing Components
Using SQL
Performance Analyzer to Determine the Impact of Changes
Using
Database Replay to Test System Performance
• Using Database Replay to Test
System Performance
• Database Replay Packages
Implementing
Real-Time Database Operation Monitoring
Using Services
to Monitor Applications
• Using Services to Monitor
Applications
• Creating Services
• Service Aggregation
Configuration
Overview of
Memory Structures
Managing
Shared Pool Performance
• Managing Shared Pool
Performance
• Avoid Hard Parses
• Sizing the Shared Pool
Managing
Buffer Cache Performance
• Managing Buffer Cache
Performance
• Buffer Cache Hit Ratio
• Caching Tables
• Multiple Block Sizes
Managing PGA
and Temporary Space Performance
• Managing PGA and Temporary
Space Performance
• Monitoring SQL Memory Usage
Configuring
the Large Pool
Using
Automatic Shared Memory Management
• Using Automatic Shared Memory
Management
• Using the V$SYSTEM_PARAMETER
View