Oracle Database Problem Solving and Troubleshooting Handbook

Index

A

Access structures, 296

ACS (adaptive cursor sharing)

bind-awareness monitoring, 61–73

demonstration, 58–61

and SPM. See SPM (SQL plan management), adaptive cursor sharing.

working algorithm, 52–57

ACS (adaptive cursor sharing), bind sensitiveness with

equality predicate histograms, 55–56

partition keys, 56–57

range predicate, 52–55

ACS (adaptive cursor sharing), bind-aware cursors

creating, examples, 66–73

description, 73–76

performance issue, example, 76–81

Active Data Guard, 279

Active Session History (ASH). See ASH (Active Session History).

Actuator arms, 388

Adams, Steve, 370

ADD_FILE command, 317, 319

ADDM (Automatic Database Diagnostic Monitor), finding buffer busy wait event information, 41

Administrative tasks, utilities and commands, ...