Go to main content
2/21
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
Scripting on this page enhances content navigation, but does not change the content in any way.