August 2011
Intermediate to advanced
594 pages
15h 54m
English
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
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 ...