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.