List of Figures

• 2-1 DB Time in Overall User Response Time
• 2-2 DB Time in User Transaction
• 2-3 Active Session History
• 3-1 Diagnostic Summary
• 3-2 Automatic Database Diagnostic Monitor (ADDM) Page
• 3-3 Performance Analysis
• 4-1 Database Performance Page
• 4-2 Monitoring User Activity
• 4-3 Active Sessions Working page
• 4-4 Monitoring Top SQL
• 4-5 Monitoring Top Sessions
• 4-6 Viewing Session Details
• 4-7 Monitoring Top Services
• 4-8 Viewing Service Details
• 4-9 Monitoring Top Modules
• 4-10 Monitoring Top Actions
• 4-11 Monitoring Instance Activity
• 4-12 Monitoring Host Activity
• 4-13 Performance Summary
• 5-1 Responding to Alerts
• 6-1 Analyzing Current Database Performance
• 6-2 Analyzing Historical Database Performance
• 7-1 ASH Report Results
• 7-2 Top User Events
• 7-3 Top Event P1/P2/P3 Values
• 7-4 Top Service/Module
• 7-5 Top SQL Command Types
• 7-6 Top SQL Statements
• 7-7 Top Sessions
• 7-8 Activity Over Time
• 8-1 AWR Compare Periods Report
• 8-2 Snapshot Sets
• 8-3 Top 5 Timed Events
• 8-4 Wait Events
• 8-5 Time Model Statistics
• 8-6 Top 10 SQL Comparison by Execution Time
• 8-7 Top 5 Segments Comparison by Logical Reads
• 9-1 Top Activity Page
• 9-2 Viewing SQL Statement By Wait Class
• 9-3 SQL Details Page
• 9-4 Viewing SQL Text
• 9-5 Viewing SQL Statistics
• 9-6 Viewing Session Activity
• 9-7 Viewing SQL Execution Plan
• 9-8 Viewing SQL Tuning Information
• 11-1 Scheduling a SQL Access Advisor Task