Overview & Preparing the Databases
- Defining the Scope of Performance Issues, Tuning Life Cycle Phases and Using Enterprise Manager to Identify OS Issues
- Using the Time Model to Diagnose Performance Issues
- Using Statistics and Wait Events to Diagnose Performance Issues
- 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: Installing Statspack, Creating Snapshots and Generating Statspack Reports
- Using Automatic Workload Repository
- Setting Up and Viewing Server-Generated Alerts
- Using Baselines
- Configuring and Managing Automated Maintenance Tasks
- Using ADDM to Analyze Performance and AWR-Based Tools to Identify Performance Issues
- Using Active Session History Data for First Fault System Analysis and Generating and Reviewing an ASH Report to Identify Performance Issues
- Using Emergency Monitoring and Real-Time ADDM to Analyze Performance Issues
Overview of SQL Statement Processing
- Maintaining Indexes
- Maintaining Tables: Block Space Management, Shrinking Segments, Advanced Index Compression, Analyzing the Impact of Excess Blocks
- Introduction to Query Optimizer and Using Initialization Parameters to Control Optimizer Behavior
- Understanding Execution Plans, Using AUTOTRACE and EXPLAIN PLAN
- Viewing Execution Plans by Using SQL Trace and the TKPROF Utility
- Managing Optimizer Statistics
- Using Automatic SQL Tuning
- Using the SQL Plan Management Feature
Overview of the SQL Advisors
- Using the SQL Tuning Advisor and SQL Access Advisor to Improve SQL Performance
Overview of Real Application Testing Components
- Using SQL Performance Analyzer to Determine the Impact of Changes
- Using Database Replay to Test System Performance
- Implementing Real-Time Database Operation Monitoring
- Using Services to Monitor Applications
Overview of Memory Structures
- Managing Shared Pool Performance
- Managing Buffer Cache Performance
- Managing PGA and Temporary Space Performance
- Configuring the Large Pool
- Using Automatic Shared Memory Management
- Introduction to In-Memory Column Store
- Configuring the In-Memory Column Store Feature
- Using the In-Memory Column Store Feature to Improve SQL Performance
- Using In-Memory Column Store with Oracle Database Features
