1: Overview
- Overview
- Practice 1-1: Preparing the Databases
2: Defining the Scope of Performance Issues
- Defining the Scope of Performance Issues Objectives
- Tuning Life Cycle Phases
- Practice 2-1: Using Enterprise Manager to Identify OS Issues
3: Using the Time Model to Diagnose Performance Issues
- Using the Time Model to Diagnose Performance Issues
- Practice 3-1: Viewing the Top Wait Events and the Time Model
4: Using Statistics and Wait Events to Diagnose Performance Issues
- Using Statistics and Wait Events to Diagnose Performance Issues
- Instance Activity and Wait Event Statistics
- Practice 4-1: Viewing System Statistics and Wait Events
5: Using Log and Trace Files to Monitor Performance
- Using Log and Trace Files to Monitor Performance
- Practice 5-1: Viewing Performance Information in the Alert Log
6: Using Enterprise Manager Cloud Control and SQL Developer to Monitor Performance
- Using Enterprise Manager Cloud Control and SQL Developer to Monitor Performance
- Practice 6-1: Using Enterprise Manager to Monitor Performance
- Practice 6-2: Using SQL Developer to Monitor Performance Part 1
- Practice 6-2: Using SQL Developer to Monitor Performance Part 2
7: Using Statspack to View Performance Data
- Using Statspack to View Performance Data
- Practice 7-1: Installing Statspack
- Practice 7-2: Creating Snapshots
- Practice 7-3: Generating Statspack Reports
- Practice 7-4: Using Statspack to Examine Segment Statistics (Optional)
8: Using Automatic Workload Repository
- Using Automatic Workload Repository
- Managing AWR Data in a Multitenant Environment
- Practice 1-1: Creating and Managing AWR Snapshots
- Practice 1-2: Generating and Viewing an AWR Report
- Practice 1-3: Generating and Viewing a Compare Periods Report
9: Using Metrics and Alerts
- Using Metrics and Alerts
- Practice 2-1: Setting Up and Viewing Server-Generated Alerts
10: Using Baselines
11: Managing Automated Maintenance Tasks
- Managing Automated Maintenance Tasks
- Practice 1-1: Configuring Automatic Maintenance Tasks (Part 1)
- Practice 1-1: Configuring Automatic Maintenance Tasks (Part 2)
12: Using ADDM to Analyze Performance
- Using ADDM to Analyze Performance
- Compare Periods ADDM: Analysis
- Practice 2-1: Using AWR-Based Tools to Identify Performance Issues
- Practice 2-2: Performing an ADDM Analysis of a PDB
13: Using Active Session History Data for First Fault System Analysis
- Using Active Session History Data for First Fault System Analysis
- Practice 3-1: Generating and Reviewing an ASH Report to Identify Performance Issues
14: Using Emergency Monitoring and Real-Time ADDM to Analyze Performance Issues
- Using Emergency Monitoring and Real-Time ADDM to Analyze Performance
15: Overview of SQL Statement Processing
- Overview
- Processing a DML Statement
16: Maintaining Indexes
- Maintaining Indexes
- Automatic Indexing Task
- Practice 2-1: Coalescing an Index
17: Maintaining Tables
- Maintaining Tables
- Block Space Management with Free Lists
- Shrinking Segments: Overview
- Advanced Index Compression
- Practice 3-1: Analyzing the Impact of Excess Blocks
18: Introduction to Query Optimizer
- Introduction
- Using Initialization Parameters to Control Optimizer Behavior
19: Understanding Execution Plans
- Understanding Execution Plans
- SQL*Plus AUTOTRACE
- Practice 2-1: Using AUTOTRACE and EXPLAIN PLAN
20: Viewing Execution Plans by Using SQL Trace and TKPROF
- Viewing Execution Plans by Using SQL Trace and TKPROF
- Practice 3-1: Using SQL TRACE and the TKPROF Utility
21: Managing Optimizer Statistics
- Managing Optimizer Statistics
- Extended Statistics
- Practice 4-1: Capturing Extended Statistics
- Practice 4-2: Determining the Impact of Stale Statistics
- Practice 4-3: Using the Optimizer Statistics Advisor to Improve Statistics Collection Quality
22: Using Automatic SQL Tuning
- Using Automatic SQL Tuning
23: Using the SQL Plan Management Feature
- Using the SQL Plan Management Feature
- Practice 6-1: Using SQL Plan Management (Part 1)
- Practice 6-1: Using SQL Plan Management (Part 2)
24: Overview of the SQL Advisors
- Overview of the SQL Advisors
25: Using the SQL Tuning Advisor
- Using the SQL Tuning Advisor
- Practice 2-1: Using the SQL Tuning Advisor
26: Using the SQL Access Advisor
- Using the SQL Access Advisor
- Practice 3-1: Using the SQL Access Advisor to Improve SQL Performance
27: Overview of Real Application Testing Components
- Overview of Real Application Testing Components
28: Using SQL Performance Analyzer to Determine the Impact of Changes
- Using SQL Performance Analyzer to Determine the Impact of Changes
- Practice 2-1: Using SQL Performance Analyzer (Part 1)
- Practice 2-1: Using SQL Performance Analyzer (Part 2)
- Practice 2-2: Seeding SQL Plan Baselines from SQL Performance Analyzer
29: Using Database Replay to Test System Performance
- Using Database Replay to Test System Performance
- Database Replay Packages
- Practice 3-1: Configuring and Using Database Replay at the PDB Level
30: Implementing Real-Time Database Operation Monitoring
- Implementing Real-Time Database Operation Monitoring
- Practice 1-1: Monitoring a Composite Database Operation
- Practice 1-2: Monitoring a PL/SQL Operation
31: Using Services to Monitor Applications
- Using Services to Monitor Applications
- Creating Services
- Service Aggregation Configuration
- Practice 2-1: Using Services in a Single-Instance Oracle Database (Part 1)
- Practice 2-1: Using Services in a Single-Instance Oracle Database (Part 2)
- Practice 2-2: Tracing Services in a Single-Instance Environment
32: Overview of Memory Structures
- Overview
- Practices for Lesson 1: Overview
33: Managing Shared Pool Performance
- Managing Shared Pool Performance
- Avoid Hard Parses
- Sizing the Shared Pool
- Practice 2-1: Sizing the Shared Pool
- Practice 2-2: Tuning a Hard-Parse Workload
- Practice 2-3: Tuning a Soft-Parse Workload
- Practice 2-4: Keeping Objects in the Shared Pool
34: Managing Buffer Cache Performance
- Managing Buffer Cache Performance
- Buffer Cache Hit Ratio
- Caching Tables
- Multiple Block Sizes
- Practice 3-1: Sizing the Buffer Cache
- Practice 3-2: Using the Keep Pool
- Practice 3-3: Using Force Full Database Caching
35: Managing PGA and Temporary Space Performance
- Managing PGA and Temporary Space Performance
- Monitoring SQL Memory Usage
- Practice 4-1: Adjusting the Value of PGA_AGGREGATE_TARGET
36: Configuring the Large Pool
- Configuring the Large Pool
37: Using Automatic Shared Memory Management
- Using Automatic Shared Memory Management
- Using the V$SYSTEM_PARAMETER View
- Practice 6-1: Enabling Automatic Shared Memory Management
38: Introduction to In-Memory Column Store
39: Configuring the In-Memory Column Store Feature
- Configuring the In-Memory Column Store Feature
- Practice 2-1: Configuring In-Memory Column Store
- Practice 2-2: Configuring In-Memory Objects
- Practice 2-3: Querying In-Memory Objects and Viewing Execution Plans
40: Using In-Memory Column Store with Oracle Database Features
- Using In-Memory Column Store with Oracle Database Features
- Practice 4-1: Exporting and Importing In-Memory Objects