storage of multiple, 235
version 3), 326
user-defined
Digital Imaging and Communications in
objects and collections, 319
Medicine (DICOM) version 3, 326
Oracle8, 87
dimension tables, 21, 229
VARCHAR2, 83
dimensions, 229
XMLType, 87
direct path export, 288
DATE datatype, 85
direct path load, 240
DB_BLOCK_BUFFERS, 156
directory structure, planning, 58
DB_BLOCK_SIZE, 37
dirty reads, 189
DB_DOMAIN, 37
disaster recovery, 275
DB_FILE_ MULTIBLOCK_READ_
database and data redundancy, 282
COUNT, 168
planning, 253
DB_NAME, 37
preparation, 253
DB_RECOVERY_FILE_DEST, 37
Discoverer, 339
DB_RECOVERY_FILE_DEST_SIZE, 37
Administration Edition, 244
DBA_ views, 120
End User Layer (EUL), 244
DBAs (database administrators), 122
Plus, 244
DBMS (database management system), 3
portlet provider, 244
DBMS_RLS package, 145
viewer, 244
DBMS_STATS package, 112
disk failure, recovery from, 262
DBWR (Database Writer), 52
disk farms, 165
DCE (Distributed Computing
disk layout, planning, 160
Environment), 28
disk space requirements, estimating, 60
DCM (Distributed Configuration
disk striping
Management), 344
host-based, 164
DDL (Data Definition Language), 5
nonredundant, 163
DDL_LOCK_TIMEOUT, 38
multiple spindles, 161
DECIMAL, 85
disk technology, 300
decision support systems (DSS), 224, 230,
disks, deployment strategy, 301
233
dismount, databases, 69
decision trees, 246
Dispatcher process, 53
dedicated
dispatchers, 74
model, 73
Distributed Computing Environment
processes, 73
(DCE), 28
storage subsystems
Distributed Configuration Management
basics, 165
(DCM), 344
power outages, vulnerability to, 165
distributed databases
DEFAULT buffer pool, 50
basics, 5
deferred constraints, 106
configurations, 17
deferred rollback, 261
data integrity, ensuring, 308
DELETE, 141
data transfer, 310
depth of indexes, 92
features, 9, 17
dequeue, 313
history, 6
DES (Data Encryption Standard), 28
multiple access of, 305
development
queries and transactions, 18
servers, 336
security, 147
tools, 28, 335
synchronization, 311
DHTML (thin client), 242
Distributed Lock Manager (DLM), 193
distributed queries, 17
distributed transactions, 17
370
|
Index
DLM (Distributed Lock Manager), 193
entity Java beans, 323
DML (Data Manipulation Language), 77,
Entrust Profiles, 148
175, 202
equipartitioning, 97
documentation, 1, 356
ESB (Enterprise Service Bus), 347
books, 357
Essbase, 245
Oracle Corporation from, 357
ETL (extraction, transformation, and
Oracle, installation of, 57
loading) tools, 238
domain indexes, 330
EUL (End User Layer), 244
DOUBLE PRECISION, 85
events, 101
downtime, unplanned causes, 256
exclusive locks, 188
DRM (Database Resource Manager), 184,
EXECUTE privilege, 142
214
execution path, 109
DROP, 141
EXPLAIN PLAN utility, 120
DROP DATABASE, 143
Express Server, 245
DSS (decision support systems), 224, 230,
expression, 101
233
extensibility framework, 330
Dynamic Service Provisioning, 299
eXtensible Markup Language (see XML)
extents, 41, 132
E
extraction, transformation, and loading
(ETL) tools, 238
easy connect naming method, 65
E-Business Suite support, 327
EJBs (Enterprise JavaBeans), 323
F
EM (Oracle Enterprise Manager)
fact tables, 21, 229
backups, 134
factors, 152
cache hit ratio and, 177
Fail Safe, 26, 268
components, 127
failover
consoles, 126, 129
basics, 26
data warehouses, managing, 236
hardware outage duration, 268
features, 23
notification, 344
Intelligent Agents, 128
solutions, 266
manageability features, 124
failures, types of, 133
packs, 126
fast commits, 79
performance evaluation, using for, 156
Fast Mirror Resynchronization, 266
queue management, 314
FAST_START_IO_TARGET parameter, 260
replication management, 313
fast-start rollback, 261
tools, 129
fat clients, 206
EM2Go, 131
fault diagnosability infrastructure, 125
embedded applications, 31
fault-tolerance
EMC dedicated storage subsystems, 165
application servers, 209
encryption, 149
component redundancy, 262
Advanced Security Option (ASO), 148
Feuerstein, Steven, 145
tablespaces, 149
FGAC (fine-grained access control), 91, 145
Transparent Data Encryption, 148
fields, 4
End User Layer (EUL), 244
file placement issues, 162
enqueue, 313
fine-grained access control (FGAC), 91, 145
enterprise data warehouses, 227
fine-grained auditing, 150
Enterprise Edition, 333
FIRST_ROWS, 114
Enterprise JavaBeans (EJBs), 323
Flashback
Enterprise Manager Console, 128
basics, 79
Enterprise Manager Grid Control, 300
capabilities, 79
Enterprise Service Bus (ESB), 347
compliance issues, 153
entities, 103
Data Archive, 281
Index
|
371
Flashback
(continued)
Gray, Jim, 202
data archive feature, 279
grid computing
Database, 281
architecture, 206
DROP, 281
basics, 2, 210
history tracking, 153
clusters and, 217
queries, 78
configuration, 26
Query, 280
database migrations, 317
Restore Points, 281
deployment, 218
rollback feature, 79
deployment models, 8
System Change Number (SCN), 280
Enterprise Manager, 23
Table, 281
Enterprise Manager Grid Control, 300
time span, 79
functionality, 316
Total Recall Option, 279
Grid Control, 23, 127, 157
transaction, 80
history, 7
transaction commands, 279, 281
nongrid solutions, 304
Transaction Query, 280
OLTP (online transaction
Versions Query, 280
processing), 211
Flashback Data Archive, 153, 281
Real Application Clusters, 206
Flashback Database, 281
self-managing features, 2
Flashback DROP, 281
user interface, 210
Flashback Query, 79, 280
Grid Control, 127, 157
Flashback Restore Points, 281
growth, planning for databases, 61
Flashback Table, 281
Flashback Transaction Query, 280
H
Flashback Versions Query, 280
hardware architecture, 290
FLOAT, 85
choosing, 302, 303
FOR UPDATE clause, 189
clustered systems, 295
foreign keys, 5, 103, 106
comparisons, 302
Forms Services, 336
components, latency cost of, 291
fragmentation
disk technology, 300
basics, 132
failover, 269
resolutions, 132
NUMA (Non-Uniform Memory Access)
ftp commands, 317
computers, 297
full backups, 134
SMP systems, 293
full table scans, 109
uniprocessor systems, 292
function-based indexes, 95
hash clusters, 100
funneling, application servers, 208
hash partitioning, 25
Fusion Middleware, 1, 16, 65, 332
hash values, 100
Fusion Middleware Adapters, 17
HASHKEYS, 100
Health Monitor, 125
G
Heterogeneous Services, 18, 19
Geographic Information Systems (GIS), 13
heterogeneous transactions, application
geo-mirroring, 285
servers, 209
GIS (Geographic Information Systems)
high availability, 217
Oracle and, 13
basics, 254
global authentication, 147
cost, 254
Global Cache Service (LMS), 53
RAID and, 263
grain, 144
Real Application Clusters (RAC), 270
(see also access control)
TAF and, 274
GRANT command, 142
high-speed data pump, 18
granularity, 40
hints, optimizer, 114
granule, 49, 176
history, Oracle, 1
372
|
Index
hit ratio, 177
Information Lifecycle Management
home page, 130
(ILM), 24
hostnaming, 65
Information Lifecycle Management
host-based and I/O subsystem volume
Assistant, 136
management, combined, 165
Information Management System (IMS), 3
hot backup, 275
Information Rights Management (IRM), 327
hybrid schemas, 223
inheritance, 321
hybrid tools, 245
INIT.ORA (initialization file) (see
Hyperion Financial Performance
initialization file (INIT.ORA)
Management, 247
parameters)
initialization file (INIT.ORA) parameters
I
allocating memory, 176
archiving, 47, 48
I/O (input/output operations)
backing up, 134, 276
defined, 160
checkpoints and recovery, 260, 261
destinations, 161
control files, 39
distribution of overhead, 162
PGA, 181
initialization parameters, 160
setting parallelism, 173
interactions, 169
initialization parameters, 37
planning for performance impact, 160
in-memory databases, 181
size, 160
input/output operations (see I/O)
IBM
input/output subsystems, 165
CICS, 309
INSERT, 141, 175
Information Management System
instance failure
(IMS), 3
defined, 133
MQSeries, 313
Real Application Clusters (RAC),
Query Management Facility, 3
management by, 271
Structured Query Language (SQL), 5
instance recovery, 258
ILM (Information Lifecycle
phases, 259
Management), 24
rollforward phase, 259
image support, 326
instances, 33
Imaging and Process Management
background processes, 52
(IP/M), 327
defined, 48
immediate constraints, 106
initialization
IMS (Information Management System), 3
CONTROL_FILES, 69
incremental backups, 24, 134
memory
index organized tables (IOTs), 93