system interfaces, 219
Real Application Clusters (RAC), during
ARCH (Archiver), 53
recovery by, 272
ARCHIVELOG mode, 47
system vs. component availability, 256
benefits, 276
Availability page, 130
parameters, 47
AWR (Automatic Workload
recovery from failure and, 133
Repository), 124, 156
Archiver (ARCH), 53
archives
B
automatic parameter settings, 47
B*-tree index, 92
isolation from, 162
background processes, instances, 52
redo log files, 46
Backup Solutions Program (BSP), 136
writing to locations, 48
backups, 24, 135, 149, 172, 275
ASM (Automatic Storage Management), 54,
data warehouses, 237
125
databases, isolation from, 162
ASO (Advanced Security Option), 28, 145
Oracle types, 275
asynchronous replication, 286, 287, 311
overview, 135
Atomic, 202
planning, 275
Atomic, Consistent, Isolated, Durable
preparations essential for recovery, 133
(ACID) properties, 202
recovery, using in, 276
attributes, 103, 320
testing, 135, 275
audio and video clips, storage in
third-party utilities, 135
database, 324
types of, 134
Audit Vault Server, 28
BAM (Business Activity Monitoring), 16, 346
auditing on by default
base tables, 91, 144
automated patching, 138
BEA Tuxedo TP monitor, 309
basics, 139
BFILE datatype, 87
compliance, 151
bigfiles, 35
data gathering, 150
Binary Large Object (BLOB), 320
fine-grained, 150
binary XML, 235
sessions, 150
BINARY_DOUBLE, 85
track actions, 150
BINARY_FLOAT, 85
authentication, 65
bind
AUTHID CURRENT_USER keyword, 147
phase, 214
Automated Storage Management (ASM), 27
variables, 214
Automatic Database Diagnostic Monitor
bitmap indexes, 21, 94, 230
(ADDM), 124, 156
BLOB (Binary Large Object), 320
BLOB datatype, 87
366
|
Index
block-range parallelism, 170
Checkpoint (CKPT), 53
affected operations, 172
checkpoints, 259
affected query processes, 173
I/O activity and, 260
I/O, impact on, 170
size value, impact on recovery time,
inserts, 175
performance, 260
partitioned tables, 171
structure, 41
scaling, 170
CHOOSE mode, 115
blocks, size of, 40
chunk size, 168
bound plans, 212
CKPT (Checkpoint), 53
BPEL (Business Process Engineering
class, 320
Language), 345
clean data, 238
BPEL Process Manager Option, 16
client processes
branch nodes, B*-tree index, 92
accessing with databases, 70
BSP (Backup Solutions Program)
dedicated server, 73
products, 136
defined, 71
buffer caches
server processes, 70
defined, 50
CLOB datatype, 84, 87
performance and, 177
CLOSER TO, 330
BUILD_DB.SQL script, 63
clustered systems
Business Activity Monitoring (BAM),
16, 346
defined, 99
Business Intelligence
IOTs and, 93
applications, 1, 247
locking model requirements, 296
BI Publisher, 16, 242
CMAN (Connection Manager), 14
BI Server Administrator, 242
COBOL programming language, 11
BI servers, 242
Codd, Edward F., 2
dangerous assumptions, 250, 252
cold backup, 275
interfaces, 339
Cold Failover Cluster, 344
reports services, 339
collection types, 320
tools, 22
columns
business intelligence beans, 245
datatype attributes, 82
Business Process Engineering Language
design, 102
(BPEL), 345
relational databases, 90
business rules, 346
commit, 78
business solutions (see Business Intelligence)
COMMIT statement, 187
Common Warehouse Metadata Interchange
C
(CWMI), 248
COMPATIBLE, 38
C programming language
complete database recovery, 276
Oracle Lite, 32
complete site failure
SQL applications, 11
data redundancy solutions, 285
C++ programming language
preparation for, 281, 289
Oracle Lite, 32
compliance, 151
SQL applications, 11
components, 48, 262
cache, 15, 16, 176, 341
composite partitioning, 96
Cache Fusion, 216, 296
composition, 40
cached results, 51
compound triggers, 108
cardinality, 230
concatenation operator, 88
cartridges, 12, 330
blank-padded comparisons, 89
cascade deletes, 106
nonpadded comparisons, 89
central processing units (see CPUs)
concentrators, 14
CHAR datatype, 83
concurrency
character datatypes, 83
basics, 187
check constraints, 106
features, 192
Index
|
367
concurrency
(continued)
crash recovery, 133, 258
multiversion read consistency, 190
hardware failover, 266
performance and, 197
transactions and, 70
transaction isolation and, 190
crawler, 327
user access, 190
CREATE, 141
(see also serialization)
CREATE DATABASE, 143
configuration files
CREATE SPFILE, 143
handcoded, problems with, 66
CREATE TABLE...AS SELECT online
Oracle Net, 67
operation, 132
conflict-resolution routines, 311
CRUD matrix, 60
Connection Manager (CMAN), 14, 213
cursors, 180
connections, 185
Customer Support Identification (CSI), 138
Connection Manager (CMAN), 14
CWMI (Common Warehouse Metadata
features, 13
Interchange), 248
networking, 13
pooling, 208, 212
D
constraining tables runtime errors, 108
data
constraints
abstraction, 319
data normalization, 104
cleansed, 237
vs. triggers, 107
cubes, 245
consumer groups, 184
divergence, 286
content
extraction tools, 239
management, 327
integrity, ensuring, 104
publish and subscribe solutions, 19
loading, 223
Content Database Suite, 327
marts and warehouses, 237
Content Management Kit, 336
marts, 225
contention, 189
mining, 22, 233, 237, 246
control files, 36
modeling, OLTP vs. decision
backup, 39
support, 204
checkpoint records, 259
read-only, 223
multiple files, 39
reporting tools, 241
performance, impact on, 39
sources, required capabilities, 237
writing to multiple, 39
strategic and tactical analyses, 223
CONTROL_FILES, 37, 69
tolerance, 286
cost-based optimization, 110
transfer between databases, 18
comparing changes to, 117
Data Definition Language (DDL), 5
hints, 114
data dictionary, 54
improvements, 115
access control, 150
influence decisions of, 114
AUD$ table, 150
specify modes, 115
MTS data, views for, 76
star schemas, queries against, 230
performance evaluation, 156
statistics, use of, 112
views, 120
saving, 113
Data Encryption Standard (DES), 28
updating, 112
Data Guard, 26
stored outline, 117
Data Manipulation Language (DML), 77,
CPUs (central processing units)
175, 202
database workload, 183
Data Mining Option, 247
nondatabase workload and Oracle
Data Movement page, 131
performance, 184
Data Pump, 288
resources, 182, 184
Data Recovery Advisor, 125
tuning, 182
368
|
Index
data redundancy
multitier computing, 71
export of data, 288
multiversion read consistency and
flat files, export to, 288
performance, 197
data structures
ODBC and, 11
additional, 98
performance, 154
basic, 90
programming tools, 9
clusters, 99
relational, 4
hash
reporting tools, 237
clusters, 100
required capabilities, 242
functions, 100
resources and, 158
partitioning, 96
security, 139
schemas, 98
datafile headers
sequences, 98
checkpoints, 41, 259
server entities, 108
structure of, 41
statistics, 112
datafiles, 34
synonyms, 98
defined, 40
Data Warehouse Toolkit, 229
extent, 41
database administration
segment, 41
extents, 132
structure, 41
fragmentation, 132
datatypes
media failure, recovery, 133
AnyData, 88
problems, reporting, 138
AnyDataSet, 88
security, 138, 139
AnyType, 88
segments, 132
BFILE, 87
user accounts, management, 140
character, 83
Database Change Management Pack, 127
CLOB, 84
Database Change Notification, 316
conversions, 88
Database Configuration Assistant, 57
data integrity loss, 90
Database Configuration Management
DATE, 85
Pack, 127
DECIMAL, 85
Database Diagnostics Pack, 127
defined, 82
Database Management Packs, 126
DOUBLE PRECISION, 85
Database Provisioning Pack, 127
extended, basics, 318
Database Replay, 118
FLOAT, 85
Database Resource Manager (DRM), 184,
INT, 85
214
INTEGER, 85
Database Tuning Pack, 127
large object (LOB), 87
Database Writer (see DBWR)
LOB, 87
databases
LONG, 84
3GLs and, 10
LONG RAW, 86
auto-discovery features, 67
NCHAR, 83
basic architecture, 33, 104, 227
NCLOB, 84
block size, 160
NUMBER, 84
concurrency, 186
numeric, 84
connectivity types, 307
NVARCHAR2, 83
creation of, 59, 62
ORA_ROWSCN, 87
development, 5
Oracle9i, user-defined, 88
evolution, 224
pseudocolumns, 86
extensibility, 12
RAW, 86
features, 9, 13, 32
REAL, 85
GIS and, 13
ROWID, 86
management, 236
scales, 85
Index
|
369
datatypes
(continued)
DICOM (Digital Imaging and
SMALLINT, 85
Communications in Medicine