Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)

E

EM (Enterprise Manager)

ADDM access with. See ADDM (Automatic Database Diagnostic Monitor)

managing Automatic Workload Repository, 244 ‚ 247

end_snap_id parameter, 250 ‚ 251

end-to-end monitoring, 45 ‚ 46

end-to-end response time, 8 ‚ 9

enqueue resources, 174

enqueue wait events, 170 ‚ 184

architecture, 174

decoding type and mode, 174 ‚ 176

defining enqueues, 170

enqueue locks, 171 ‚ 174

enqueue resources, 170 ‚ 171

monitoring, 98

overview of, 57 ‚ 58

parameters, 58

references, 337

table of, 290 ‚ 299

wait time, 58

enqueue wait events, causes

overview of, 177

wait for ST enqueue, 182 ‚ 183

wait for TM enqueue in mode 3, 183 ‚ 184

wait for TX enqueue in mode 4 ‚ bitmap index entry, 181 ‚ 182

wait for TX enqueue in mode 4 ‚ ITL shortage, 179 ‚ 181

wait for TX enqueue in mode 4 ‚ unique key enforcement, 181

wait for TX enqueue in mode 6, 177 ‚ 179

enqueue wait events, in RAC environments, 231 ‚ 236

CF enqueue, 232 ‚ 234

CU enqueue, 232

HW enqueue, 234

overview of, 231

PE enqueue, 235

sequence (SQ and SV) enqueues, 235

TX enqueue, 235 ‚ 236

ENQUEUE_HASH parameter, 174

ENQUEUE_HASH_CHAIN_LATCHES parameter, 174

ENQUEUE_RESOURCES parameter, 171, 174

Enterprise Manager (EM)

ADDM access with. See ADDM (Automatic Database Diagnostic Monitor)

managing Automatic Workload Repository, 244 ‚ 247

error dump events, 277

errors

creating and dropping baselines, 251

triggering on error dump events, 277

ESTIMATE values, 110

EVENT column, 20 ‚ 21, 27 ‚ 28

event monitoring, 92 ‚ 100

buffer busy waits, 98 ‚ 99

db file scattered read, 94 ‚ 95

db file sequential read, 94 ‚ 95

direct path read, 95 ‚ 96

direct path write, 96 ‚ 97

enqueue, 98

free buffer waits, 99

latch free, 95

library cache pin, 100

overview of, 92 ‚ 94

EVENT# column

V#EVENT_HISTOGRAM view, 40

V$EVENT_NAME view, 19

V$SESSION_WAIT_HISTORY view, 37

EVENT_ID column, V$SYSTEM_EVENT view, 20 ‚ 21

events, defining, 16

events, diagnostic. See diagnostic events

EXCLUSIVE mode, 70

extent boundary, 116 ‚ 117