Index

*_TABLESPACES, 552

2PC, 602-603

A

abstract datatypes, 150-151

indexing attributes, 156-157

security for, 154-156

using object views, 151-154

ADR. See Automatic Diagnostic Repository (ADR)

alert log files, 28

aliases, 516-517

application design best practices acceptance test procedures, 135

acceptance test procedures

avoiding repeated connections to the database, 127

avoiding trips to the database, 126

avoiding use of temporary segments, 130

breaking large queries into its atomic components, 127-128

data requirements, 135

designing to throughput, 130

dividing and conquering data, 130-131

doing as little as possible, 124-127

doing it as simply as possible, 127-129

effective application design, 245-246

eliminating logical reads, 125-126

Get Oracle Database 11g DBA Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.