Skip to Main Content
Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach
book

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

by Sam R. Alapati, Darl Kuhn, Bill Padfield
August 2011
Intermediate to advanced content levelIntermediate to advanced
594 pages
15h 54m
English
Apress
Content preview from Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

RMAN Recipes for Oracle Database 12c: A Problem-Solution Approach, Second Edition

RMAN Recipes for Oracle Database 12c: A Problem-Solution Approach, Second Edition

Darl Kuhn, Sam Alapati, Arup Nanda

Publisher Resources

ISBN: 9781430236627Purchase book