O'Reilly logo

Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach by Bill Padfield, Darl Kuhn, Sam R. Alapati

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required