Index

3-way gets, 664

11g

Adaptive Cursor Sharing, 190-191

AMM, 588-595

client-side result set cache, 161-163

hierarchical profilers, 358-362

A

access

cluster balance, 684-685

data access optimization, 362-368

paths, 213-214

tables, 243

avoiding accidental scans, 252-263

LIKE operator, 273-274

multicolumn lookups, 263-266

multivalue single-column lookups, 274-275

optimizing full table scans, 275-286

searching for ranges, 266-272

single value lookups, 243-251

ACCESS_PREDICATES, 38

accidental table scans, avoiding, 252-262

ACFS (ASM Cluster File System), 642

ACID (Atomic, Consistent, Isolated, Durable), 167

Active Session History (ASH), 467-471

Active Sessions Waiting charts, 580

active spinning waits, 493

Active Workload Repository (AWR), 469 ...

Get Oracle now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.