decision
support, 204
read-only, 223
reporting tools, 241
sources, required capabilities, 237
strategic and tactical analyses, 223
tolerance, 286
transfer between databases, 18
Data Definition Language (DDL), 5
data dictionary, 54
access control, 150
AUD$ table, 150
MTS data, views for, 76
performance evaluation, 156
views, 120
Data Encryption Standard (DES), 28
Data Guard, 26
Data Manipulation Language (DML), 77,
175, 202
Data Mining Option, 247
Data Movement page, 131
Data Pump, 288
Data Recovery Advisor, 125
Index | 369
data redundancy
export of data, 288
flat files, export to, 288
data structures
additional, 98
basic, 90
clusters, 99
hash
clusters, 100
functions, 100
partitioning, 96
schemas, 98
sequences, 98
server entities, 108
statistics, 112
synonyms, 98
Data Warehouse Toolkit, 229
database administration
extents, 132
fragmentation, 132
media failure, recovery, 133
problems, reporting, 138
security, 138, 139
segments, 132
user accounts, management, 140
Database Change Management Pack, 127
Database Change Notification, 316
Database Configuration Assistant, 57
Database Configuration Management
Pack, 127
Database Diagnostics Pack, 127
Database Management Packs, 126
Database Provisioning Pack, 127
Database Replay, 118
Database Resource Manager (DRM), 184,
214
Database Tuning Pack, 127
Database Writer (see DBWR)
databases
3GLs and, 10
auto-discovery features, 67
basic architecture, 33, 104, 227
block size, 160
concurrency, 186
connectivity types, 307
creation of, 59, 62
development, 5
evolution, 224
extensibility, 12
features, 9, 13, 32
GIS and, 13
management, 236
multitier computing, 71
multiversion read consistency and
performance, 197
ODBC and, 11
performance, 154
programming tools, 9
relational, 4
reporting tools, 237
required capabilities, 242
resources and, 158
security, 139
datafile headers
checkpoints, 41, 259
structure of, 41
datafiles, 34
defined, 40
extent, 41
segment, 41
structure, 41
datatypes
AnyData, 88
AnyDataSet, 88
AnyType, 88
BFILE, 87
character, 83
CLOB, 84
conversions, 88
data integrity loss, 90
DATE, 85
DECIMAL, 85
defined, 82
DOUBLE PRECISION, 85
extended, basics, 318
FLOAT, 85
INT, 85
INTEGER, 85
large object (LOB), 87
LOB, 87
LONG, 84
LONG RAW, 86
NCHAR, 83
NCLOB, 84
NUMBER, 84
numeric, 84
NVARCHAR2, 83
ORA_ROWSCN, 87
Oracle9i, user-defined, 88
pseudocolumns, 86
RAW, 86
REAL, 85
ROWID, 86
scales, 85
370 | Index
datatypes (continued)
SMALLINT, 85
storage of multiple, 235
user-defined
objects and collections, 319
Oracle8, 87
VARCHAR2, 83
XMLType, 87
DATE datatype, 85
DB_BLOCK_BUFFERS, 156
DB_BLOCK_SIZE, 37
DB_DOMAIN, 37
DB_FILE_ MULTIBLOCK_READ_
COUNT, 168
DB_NAME, 37
DB_RECOVERY_FILE_DEST, 37
DB_RECOVERY_FILE_DEST_SIZE, 37
DBA_ views, 120
DBAs (database administrators), 122
DBMS (database management system), 3
DBMS_RLS package, 145
DBMS_STATS package, 112
DBWR (Database Writer), 52
DCE (Distributed Computing
Environment), 28
DCM (Distributed Configuration
Management), 344
DDL (Data Definition Language), 5
DDL_LOCK_TIMEOUT, 38
DECIMAL, 85
decision support systems (DSS), 224, 230,
233
decision trees, 246
dedicated
model, 73
processes, 73
storage subsystems
basics, 165
power outages, vulnerability to, 165
DEFAULT buffer pool, 50
deferred constraints, 106
deferred rollback, 261
DELETE, 141
depth of indexes, 92
dequeue, 313
DES (Data Encryption Standard), 28
development
servers, 336
tools, 28, 335
DHTML (thin client), 242
DICOM (Digital Imaging and
Communications in Medicine
version 3), 326
Digital Imaging and Communications in
Medicine (DICOM) version 3, 326
dimension tables, 21, 229
dimensions, 229
direct path export, 288
direct path load, 240
directory structure, planning, 58
dirty reads, 189
disaster recovery, 275
database and data redundancy, 282
planning, 253
preparation, 253
Discoverer, 339
Administration Edition, 244
End User Layer (EUL), 244
Plus, 244
portlet provider, 244
viewer, 244
disk failure, recovery from, 262
disk farms, 165
disk layout, planning, 160
disk space requirements, estimating, 60
disk striping
host-based, 164
nonredundant, 163
multiple spindles, 161
disk technology, 300
disks, deployment strategy, 301
dismount, databases, 69
Dispatcher process, 53
dispatchers, 74
Distributed Computing Environment
(DCE), 28
Distributed Configuration Management
(DCM), 344
distributed databases
basics, 5
configurations, 17
data integrity, ensuring, 308
data transfer, 310
features, 9, 17
history, 6
multiple access of, 305
queries and transactions, 18
security, 147
synchronization, 311
Distributed Lock Manager (DLM), 193
distributed queries, 17
distributed transactions, 17
Index | 371
DLM (Distributed Lock Manager), 193
DML (Data Manipulation Language), 77,
175, 202
documentation, 1, 356
books, 357
Oracle Corporation from, 357
Oracle, installation of, 57
domain indexes, 330
DOUBLE PRECISION, 85
downtime, unplanned causes, 256
DRM (Database Resource Manager), 184,
214
DROP, 141
DROP DATABASE, 143
DSS (decision support systems), 224, 230,
233
Dynamic Service Provisioning, 299
E
easy connect naming method, 65
E-Business Suite support, 327
EJBs (Enterprise JavaBeans), 323
EM (Oracle Enterprise Manager)
backups, 134
cache hit ratio and, 177
components, 127
consoles, 126, 129
data warehouses, managing, 236
features, 23
Intelligent Agents, 128
manageability features, 124
packs, 126
performance evaluation, using for, 156
queue management, 314
replication management, 313
tools, 129
EM2Go, 131
embedded applications, 31
EMC dedicated storage subsystems, 165
encryption, 149
Advanced Security Option (ASO), 148
tablespaces, 149
Transparent Data Encryption, 148
End User Layer (EUL), 244
enqueue, 313
enterprise data warehouses, 227
Enterprise Edition, 333
Enterprise JavaBeans (EJBs), 323
Enterprise Manager Console, 128
Enterprise Manager Grid Control, 300
Enterprise Service Bus (ESB), 347
entities, 103
entity Java beans, 323
Entrust Profiles, 148
equipartitioning, 97
ESB (Enterprise Service Bus), 347
Essbase, 245
ETL (extraction, transformation, and
loading) tools, 238
EUL (End User Layer), 244
events, 101
exclusive locks, 188
EXECUTE privilege, 142
execution path, 109
EXPLAIN PLAN utility, 120
Express Server, 245
expression, 101
extensibility framework, 330
eXtensible Markup Language (see XML)
extents, 41, 132
extraction, transformation, and loading
(ETL) tools, 238
F
fact tables, 21, 229
factors, 152
Fail Safe, 26, 268
failover
basics, 26
hardware outage duration, 268
notification, 344
solutions, 266
failures, types of, 133
fast commits, 79
Fast Mirror Resynchronization, 266
FAST_START_IO_TARGET parameter, 260
fast-start rollback, 261
fat clients, 206
fault diagnosability infrastructure, 125
fault-tolerance
application servers, 209
component redundancy, 262
Feuerstein, Steven, 145
FGAC (fine-grained access control), 91, 145
fields, 4
file placement issues, 162
fine-grained access control (FGAC), 91, 145
fine-grained auditing, 150
FIRST_ROWS, 114
Flashback
basics, 79
capabilities, 79
compliance issues, 153
Data Archive, 281
372 | Index
Flashback (continued)
data archive feature, 279
Database, 281
DROP, 281
history tracking, 153
queries, 78
Query, 280
Restore Points, 281
rollback feature, 79
System Change Number (SCN), 280
Table, 281
time span, 79
Total Recall Option, 279
transaction, 80
transaction commands, 279, 281
Transaction Query, 280
Versions Query, 280
Flashback Data Archive, 153, 281
Flashback Database, 281
Flashback DROP, 281
Flashback Query, 79, 280
Flashback Restore Points, 281
Flashback Table, 281
Flashback Transaction Query, 280
Flashback Versions Query, 280
FLOAT, 85
FOR UPDATE clause, 189
foreign keys, 5, 103, 106
Forms Services, 336
fragmentation
basics, 132
resolutions, 132
ftp commands, 317
full backups, 134
full table scans, 109
function-based indexes, 95
funneling, application servers, 208
Fusion Middleware, 1, 16, 65, 332
Fusion Middleware Adapters, 17
G
Geographic Information Systems (GIS), 13
geo-mirroring, 285
GIS (Geographic Information Systems)
Oracle and, 13
global authentication, 147
Global Cache Service (LMS), 53
grain, 144
(see also access control)
GRANT command, 142
granularity, 40
granule, 49, 176
Gray, Jim, 202
grid computing
architecture, 206
basics, 2, 210
clusters and, 217
configuration, 26
database migrations, 317
deployment, 218
deployment models, 8
Enterprise Manager, 23
Enterprise Manager Grid Control, 300
functionality, 316
Grid Control, 23, 127, 157
history, 7
nongrid solutions, 304
OLTP (online transaction
processing), 211
Real Application Clusters, 206
self-managing features, 2
user interface, 210
Grid Control, 127, 157
growth, planning for databases, 61
H
hardware architecture, 290
choosing, 302, 303
clustered systems, 295
comparisons, 302
components, latency cost of, 291
disk technology, 300
failover, 269
NUMA (Non-Uniform Memory Access)
computers, 297
SMP systems, 293
uniprocessor systems, 292
hash clusters, 100
hash partitioning, 25
hash values, 100
HASHKEYS, 100
Health Monitor, 125
Heterogeneous Services, 18, 19
heterogeneous transactions, application
servers, 209
high availability, 217
basics, 254
cost, 254
RAID and, 263
Real Application Clusters (RAC), 270
TAF and, 274
high-speed data pump, 18
hints, optimizer, 114
history, Oracle, 1
Index | 373
hit ratio, 177
home page, 130
hostnaming, 65
host-based and I/O subsystem volume
management, combined, 165
hot backup, 275
hybrid schemas, 223
hybrid tools, 245
Hyperion Financial Performance
Management, 247
I
I/O (input/output operations)
defined, 160
destinations, 161
distribution of overhead, 162
initialization parameters, 160
interactions, 169
planning for performance impact, 160
size, 160
IBM
CICS, 309
Information Management System
(IMS), 3
MQSeries, 313
Query Management Facility, 3
Structured Query Language (SQL), 5
ILM (Information Lifecycle
Management), 24
image support, 326
Imaging and Process Management
(IP/M), 327
immediate constraints, 106
IMS (Information Management System), 3
incremental backups, 24, 134
index organized tables (IOTs), 93
indexes
cooperative, 330
defined, 91
index structures, 92, 96
B*-tree index, 92
bitmap, 21, 94, 230
depth, 92
function-based indexes, 95
reverse key indexes, 94
invisible, 92
keys and, 92
NULL values and, 92
options, 96
ROWIDs and, 92
SQL syntax for creating, 92
information caching, 176
Information Lifecycle Management
(ILM), 24
Information Lifecycle Management
Assistant, 136
Information Management System (IMS), 3
Information Rights Management (IRM), 327
inheritance, 321
INIT.
Pages:
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779