Language: English
Pages: 140
Contents......Page 3
Documentation Accessibility......Page 9
Conventions......Page 10
Part I Getting Started......Page 11
Common Oracle DBA Tasks......Page 13
Tools for Tuning the Database......Page 14
Gathering Database Statistics Using the Automatic Workload Repository......Page 17
Time Model Statistics......Page 18
Active Session History Statistics......Page 19
Using the Oracle Performance Method......Page 20
Tuning the Database Proactively......Page 21
Tuning the Database Reactively......Page 22
Common Performance Problems Found in Oracle Databases......Page 23
Part II Proactive Database Tuning......Page 27
Overview of the Automatic Database Diagnostic Monitor......Page 29
Setting the STATISTICS_LEVEL parameter......Page 30
Creating Snapshots......Page 31
Modifying Snapshot Settings......Page 32
Reviewing the Automatic Database Diagnostics Monitor Analysis......Page 33
Interpreting the Automatic Database Diagnostics Monitor Findings......Page 34
Implementing ADDM Recommendations......Page 35
Viewing Snapshot Statistics......Page 36
4 Monitoring Real-Time Database Performance......Page 39
Monitoring User Activity......Page 40
Monitoring Top Sessions......Page 42
Monitoring Top Services......Page 43
Monitoring Top Actions......Page 44
Monitoring Host Activity......Page 45
Monitoring CPU Utilization......Page 47
Monitoring Memory Utilization......Page 49
Monitoring Disk I/O Utilization......Page 51
Setting Metric Thresholds for Performance Alerts......Page 55
Clearing Alerts......Page 56
Part III Reactive Database Tuning......Page 59
Manually Running ADDM to Analyze Current Database Performance......Page 61
Manually Running ADDM to Analyze Historical Database Performance......Page 63
Accessing Previous ADDM Results......Page 64
Overview of Active Session History......Page 67
Running Active Session History Reports......Page 68
Top User Events......Page 69
Load Profiles......Page 70
Top SQL Command Types......Page 71
Top Sessions......Page 72
Top DB Objects......Page 73
Activity Over Time......Page 74
Creating Baselines......Page 77
Comparing a Baseline to Another Baseline or Pair of Snapshots......Page 79
Comparing Two Pairs of Snapshots......Page 82
Using the Automatic Workload Repository Compare Periods Reports......Page 85
Top 5 Timed Events......Page 86
Wait Events......Page 87
Operating System Statistics......Page 88
Top 10 SQL Comparison by CPU Time......Page 89
Other Instance Activity Statistics......Page 90
PGA Aggregate Summary......Page 91
Segment Statistics......Page 92
Top 5 Segments by ITL Waits......Page 93
SGA Breakdown Difference......Page 94
init.ora Parameters......Page 95
Part IV SQL Tuning......Page 97
Identifying High-Load SQL Statements Using ADDM Findings......Page 99
Identifying High-Load SQL Statements Using Top SQL......Page 100
Viewing Details of SQL Statements......Page 101
Viewing SQL Statistics Summary......Page 103
Viewing Session Activity......Page 104
Viewing SQL Tuning Information......Page 105
10 Tuning SQL Statements......Page 107
Tuning SQL Statements Using the SQL Tuning Advisor......Page 108
Creating a SQL Tuning Set......Page 110
Using SQL Profiles......Page 113
Running the SQL Access Advisor......Page 115
Running the SQL Access Advisor: Initial Options......Page 116
Using an Existing SQL Tuning Set......Page 117
Using a Hypothetical Workload......Page 118
Defining Filters for Resource Consumption......Page 119
Defining Filters for Tables......Page 120
Running the SQL Access Advisor: Recommendation Options......Page 121
Running the SQL Access Advisor: Schedule......Page 124
Reviewing the SQL Access Advisor Recommendations: Summary......Page 127
Reviewing the SQL Access Advisor Recommendations: Recommendations......Page 129
Reviewing the SQL Access Advisor Recommendations: SQL Statements......Page 130
Reviewing the SQL Access Advisor Recommendations: Details......Page 131
Implementing the SQL Access Advisor Recommendations......Page 132
C......Page 137
M......Page 138
T......Page 139
W......Page 140
