List of Figures

• 2-1 DB Time in Overall User Response Time
• 2-2 DB Time in User Transaction
• 2-3 Active Session History
• 4-1 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 Monitoring Top Modules
• 4-9 Monitoring Top Actions
• 4-10 Monitoring Top Clients
• 4-11 Monitoring Top PL/SQL
• 4-12 Monitoring Top Files
• 4-13 Monitoring Top Objects
• 4-14 Monitoring Instance Activity
• 4-15 Monitoring Throughput
• 4-16 Monitoring I/O
• 4-17 Monitoring Parallel Execution
• 4-18 Monitoring Services
• 4-19 Monitoring Host Activity
• 4-20 Performance Summary
• 6-1 Analyzing Historical Database Performance
• 7-1 Top User Events
• 7-2 Top Background Events
• 7-3 Top Service/Module
• 7-4 Top SQL with Top Events
• 7-5 Top Sessions
• 7-6 Top DB Objects
• 7-7 Top DB Files
• 7-8 Activity Over Time
• 8-1 AWR Compare Periods Report
• 9-1 Top Activity Page
• 9-2 Viewing SQL Statement by Wait Class
• 11-1 Scheduling a SQL Access Advisor Task