See Automatic Diagnostic Repository
(ADR)
alert log files, 28
aliases, 516??“517
application design best practices
acceptance test procedures, 135
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
653
654 Oracle Database 11g DBA Handbook
application-controlled (system)
partitioning, 570
archived log files, 27
archived redo log files
backup, 444??“445
management of, 184
multiplexing, 32
archiver process. See ARCn
archiving, Flashback Data Archive,
236??“239
ARCn, 37
ASM. See Automatic Storage
Management (ASM)
ASM_DISKGROUPS parameter, 102
ASM_DISKSTRING parameter, 102
ASM_POWER_LIMIT parameter, 102
ASM_PREFERRED_READ_FAILURE_
GROUPS parameter, 102
asmcmd command, 116??“119
ASMLib library, 358??“360
ASSM. See Automatic Segment Space
Management (ASSM)
auditing, 40, 278, 331
data dictionary views,
339??“340
enhanced auditing, 340??“341
fine-grained, 40??“41, 338??“339
locations, 331??“332
privilege auditing, 336
protecting the audit trail, 340
schema object auditing, 337??“338
statement auditing, 332??“336
types, 331
authentication, 278, 279??“280
3-tier, 286
altering users, 289??“291
becoming another user, 291??“292
client-side, 286
creating users, 288??“289, 290
database administrator authentication,
280??“283
database authentication, 280
dropping users, 291
network, 284??“285
operating system authentication,
283??“284
Oracle Identity Management (IM),
286??“287
user-related data dictionary views, 292
authorization, 278, 292
create profile command, 293??“294
object privileges, 302??“306
profile management, 292??“293
profiles and password control, 293??“297
profiles and resource control, 297??“299
roles, 306??“313
system privileges, 299??“302
AUTOEXTEND attribute, 165
Automatic Database Diagnostic Monitor,
running reports, 272, 273
Automatic Diagnostic Repository (ADR),
managing alert and trace files with,
195??“197
Automatic Segment Space Management
(ASSM), 169
Automatic SQL Tuning Advisor, 272??“275
Automatic Storage Management (ASM),
29??“30, 98, 179, 636
accessing an ASM instance, 101
administering disk groups, 107??“119
alias names, 104??“105
alias with template names, 105
architecture, 98??“99
automatic rebalancing, 98
background processes, 180
creating an ASM instance, 99??“101
creating objects using, 180??“181
disk group redundancy, 179??“180
dynamic performance views, 103
file types and templates, 105??“107
filename formats, 103??“105
fully qualified names, 104
incomplete names, 105
incomplete names with templates, 105
initialization parameters, 101??“102
instance components, 101??“103
instance startup and shutdown,
102??“103
Index 655
instances, 180
mirroring, 98
numeric names, 104
using to tune physical storage, 267
Automatic Undo Management, 637
migrating to, 239??“240
and rollback segments, 8
Automatic Workload Repository, 187??“189,
270??“271
baselines, 271??“272
generating reports, 272
running ADDM reports, 272, 273
snapshots, 271
using the Automatic SQL Tuning
Advisor, 272??“275
AWR.
Pages:
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957