Index

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