Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)
A
AASM (Automatic Segment Space Management), 82
accounting, OWI, 47
actions, multiple, 284 ‚ 285
active sessions
Active Session History. See ASH (Active Session History)
defining, 253
EM access to ADDM, 261 ‚ 263, 268 ‚ 269
ADDM (Automatic Database Diagnostic Monitor), 259 ‚ 273
comparing to previous tools, 242 ‚ 243
EM access to, 261 ‚ 270
home page, 265
for individual user response times, 260
manual reports , 270 ‚ 273
overview of, 259 ‚ 260
setup, 260 ‚ 261
views, 273
addmrpti.sql script, 271 ‚ 272
Advisor Central home page, Oracle EM Database Control, 264 ‚ 265
AIOWAIT, 133 ‚ 134
AIX operating system
DBWR write times, 133
RAC network protocols, 225
alert logs
checking interconnect protocol, 226
viewing enqueue resources, 231
algorithms
backoff sleep, 146
buffer cache management, 219 ‚ 220
buffer cloning, 132
"all" trace name , 283
ALTER SESSION command
ASHDUMP events, 258 ‚ 259
buffer dump, 307
buffers dump, 306
control file dumps, 310
dumps, producing, 304
file headers dumps, 308
heap dumps, 311
library cache dumps, 312
processstate dumps, 313
session events, starting and controlling, 285
shared server state dumps, 314
systemstate dumps, 315
trace files, finding, 35
trace files, producing, 304
ALTER SESSION SET EVENTS command
diagnostic events, 279
shared pools contentions, 157
triggering immediate dumps, 276
ALTER SYSTEM command
data block dumps, 304 ‚ 305
producing dumps and trace files, 304
redo log dumps, 316
ALTER SYSTEM SET <parameter> command, 32
ALTER TABLE ALLOCATE EXTENT command, 234
ALTER TABLE MOVE command, 115
ARCH background process, 138
architecture, enqueue, 174
ASH (Active Session History)
ASHDUMP event, 258 ‚ 259
components overview, 253 ‚ 254
defining active sessions, 253
overview of, 252 ‚ 253
performance data sampling, 87
V$ACTIVE_SESSION_HISTORY view, 254 ‚ 257
ASHDUMP event, 258 ‚ 259
ASSM (Automatic Segment Space Management), 82
async disk IO wait event, 133 ‚ 134
asynchronous I/O operations, 104, 133 ‚ 134
Automatic Database Diagnostic Monitor. See ADDM (Automatic Database Diagnostic Monitor)
Automatic Segment Space Management (ASSM), 82
Automatic Workload Repository. See AWR (Automatic Workload Repository)
AVERAGE_WAIT
db file parallel writes , 130 ‚ 131, 134
db file scattered reads, 116
db file sequential reads, 111 ‚ 112
defined, 20 ‚ 21
improving, 107
integer numbers of, 23
log file parallel writes, 135 ‚ 138
working with, 22
AWR (Automatic Workload Repository), 242 ‚ 252
creating/dropping baselines, 250 ‚ 251
creating/dropping snapshots, 249 ‚ 250
managing with EM, 244 ‚ 247
modifying snapshot settings, 247 ‚ 248
overview of, 242 ‚ 243
reports, 251
repository snapshots, 243 ‚ 244
snapshot baselines, 244
views, 252