Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach

Index

A

Active Session History (ASH) information, 113, 117, 134–139

ashrpt.sql script, 135

awrrpt.sql script, 135

background events, 135

blocking sessions, 137

circular buffer, 139

data dictionary

DBA_HIST_ACTIVE_SESS_HISTORY view, 142, 144

SESSION_STATE column, 143

time frame, 144

V$ACTIVE_SESSION_HISTORY view, 142–145

DBA_HIST_ACTIVE_SESS_HISTORY view, 139

enterprise manager

DBA_HIST_EVENT_NAME view, 141

filter drop-down menu, 141

filter option, 141, 142

performance tuning activities, 140

sample report, 140

SQL_ID, 141

time frames, 140

P1/P2/P3 values, 136

real-time/near real-time session information, 134

report section information, 138

SQL ...