Index

imagesA

Active Session History (ASH) information, 113, 117, 134139

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, 142145

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 ...

Get Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.