Redwood Shores, CA: Oracle Corporation, 2006.
Oracle Database Application Express User??™s Guide. Redwood Shores, CA: Oracle
Corporation, 2007.
Oracle Database Java Developer??™s Guide. Redwood Shores, CA: Oracle Corporation,
2007.
Oracle Database 10g SQLJ Developer??™s Guide and Reference. Redwood Shores, CA:
Oracle Corporation, 2003.
Oracle XML DB Developer??™s Guide. Redwood Shores, CA: Oracle Corporation,
2007.
Oracle 10g: Infrastructure for Grid Computing (An Oracle White Paper). Redwood
Shores, CA: Oracle Corporation, 2003.
365
We??™d like to hear your suggestions for improving our indexes. Send email to index@oreilly.com.
Index
Numbers
3GLs (third-generation languages), 10, 11
3NF (third normal form), 102
A
access control
distributed databases, 147
fine-grained, 144
manager, 308
views, using for, 144
ACID (Atomic, Consistent, Isolated,
Durable) properties, 202
Active Failover Clusters (AFCs), 344
ad hoc query tools, 241
Adapters, 340, 347
ADDM (Automatic Database Diagnostic
Monitor), 124, 156
ADR (Automatic Diagnostic
Repository), 125
Advanced Compression Options, 7
Advanced Encryption Standard (AES), 28
Advanced Networking Option (ANO), 28,
148
Advanced Queuing (see AQ)
Advanced Security Option (ASO), 28, 147
advisors
Data Recovery Advisor, 125
Memory Advisors, 124, 157
MTTR Advisor, 125
Partition Advisor, 97, 120
Segment Advisor, 124, 125, 158
SQL Advisor, 157, 183
SQL Advisor tool, 120
SQL Performance Impact Advisor, 124
SQL Repair Advisor, 125
SQL Tuning Advisor, 124
Streams Tuning Advisor, 125
Undo Advisor, 125, 158
AES (Advanced Encryption Standard), 28
AFCs (Active Failover Clusters), 344
AFTER SUSPEND trigger, 61
aliases (see naming services)
ALL_ views, 121
ALL_ROWS, 114
allocating memory, 176
ALTER, 141
ALTER DATABASE ARCHIVELOG, 143
ALTER DATABASE BACKUP
CONTROLFILE, 142
ALTER DATABASE command, 69
ALTER DATABASE MOUNT, 142
ALTER DATABASE OPEN, 142
ALTER DATABASE RECOVER, 143
ALTER SESSION SQL statement, 119
Amdahl??™s Law, 294
analysis
analytic and statistical functions, 21
disconnected, 242
multidimensional, 237
queries, 237
tools, 237
ANALYZE command, 112
ANO (Advanced Networking Option), 28,
148
AnyData, 88
AnyDataSet, 88
AnyType, 88
366 | Index
ApEx (Application Express), 331
Application Development Framework
(ADF), 336
Application Express (ApEx), 331
Application Management Packs, 126
Application Server, 1, 333
capabilities, 341
management, 341
Application Server Business Intelligence, 15
application server editions, 333
applications, assigning privileges, 146
AQ (Advanced Queuing)
basics, 19, 313
publish-subscribe functionality, 220
Streams, 218
system interfaces, 219
ARCH (Archiver), 53
ARCHIVELOG mode, 47
benefits, 276
parameters, 47
recovery from failure and, 133
Archiver (ARCH), 53
archives
automatic parameter settings, 47
isolation from, 162
redo log files, 46
writing to locations, 48
ASM (Automatic Storage Management), 54,
125
ASO (Advanced Security Option), 28, 145
asynchronous replication, 286, 287, 311
Atomic, 202
Atomic, Consistent, Isolated, Durable
(ACID) properties, 202
attributes, 103, 320
audio and video clips, storage in
database, 324
Audit Vault Server, 28
auditing on by default
automated patching, 138
basics, 139
compliance, 151
data gathering, 150
fine-grained, 150
sessions, 150
track actions, 150
authentication, 65
AUTHID CURRENT_USER keyword, 147
Automated Storage Management (ASM), 27
Automatic Database Diagnostic Monitor
(ADDM), 124, 156
Automatic Diagnostic Repository
(ADR), 125
Automatic Memory Management
(AMM), 49
Automatic Shared Memory Management
(ASMM), 49
Automatic Storage Management (ASM), 54,
125, 300
basics, 265
disk space additions, 61
Automatic Workload Repository
(AWR), 124, 156
availability, 254
databases, 25
measuring and planning, 254
Real Application Clusters (RAC), during
recovery by, 272
system vs.
Pages:
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777