background processes, 48
indexes
resources, 176
cooperative, 330
redo log files, failure, recovery from
defined, 91
and, 42
index structures, 92, 96
request queues, 74
B*-tree index, 92
SGA, 48, 50
bitmap, 21, 94, 230
shutting down, 69
depth, 92
starting, 69
function-based indexes, 95
Instant Portal, 337
reverse key indexes, 94
INSTEAD OF triggers, 108
invisible, 92
INT, 85
keys and, 92
INTEGER, 85
NULL values and, 92
integration, 339
options, 96
integration components, 340
ROWIDs and, 92
Integration Manager, 340
SQL syntax for creating, 92
Integration Modeler, 340
information caching, 176
Index
|
373
Inter Process Communication (IPC), 71
Linux, 23
interval partitioning, 25, 96
LISTENER.ORA file, 67
invoker’s rights, 142
list-hash partitioning, 236
IOTs (index organized tables)
list-list partitioning, 236
limitations, 93
list-range partitioning, 236
IPC (Inter Process Communication), 71
load-balancing, 208, 342
IRM (Information Rights Management), 327
loading process, 238
isolation levels, 191
LOB (Large Objects), 87
local name resolution, 64
J
location transparency, 64
locks, 188
J2EE (OC4J) containers, 335
datablocks, in, 193
Java, 11, 322
escalation, 193
triggers, 108
Log Writer (LGWR), 53, 194
Java DataBase Connectivity (JDBC), 11, 322
LOG_ARCHIVE_DEST, 37, 47
Java Edition, 333
LOG_ARCHIVE_DEST_STATE, 37
Java pool, 52
LOG_ARCHIVE_DUPLEX_DEST, 48
Java Virtual Machine (JVM), 10
LOG_ARCHIVE_FORMAT, 47
JD Edwards product support, 327
LOG_ARCHIVE_MIN_SUCCEED_
JDBC (Java DataBase Connectivity), 11, 322
DEST, 48
JDeveloper, 245, 347
LOG_ARCHIVE_START, 47
Job Queue, 53
logical standby database capability, 283
JVM (Java Virtual Machine), 10
logicality of instances, 33
LogMiner and LogMiner Manager, 277
K
LONG datatype, 84
KBIs (key business indicators), 346
LONG RAW, 86
KEEP buffer pool, 50
LONGRAW datatype, 86
Kerberos, 28
lookup tables, 229
key business indicators (KBIs), 346
lost updates, 189
keys, 5, 103
LRU (least recently used) algorithm, 50
indexes and, 92
Kimball, Ralph, 229
M
Management Connectors, 126
L
managment, self-tuning, 23
Label Security Option, 28, 144, 145
MapViewer, 336
LAG/LEAD functions, 233
materialized views, 21, 91, 232
large objects (LOB), 7, 10
media failure, 133
large pool, 51, 76
medical imaging standard support, 326
latency cost, 291
Memory Advisors, 124, 157
LDAP (Lightweight Directory Access
memory management, automated, 49, 124
Protocol), 65, 338
memory resources
LDAP.ORA file, 68
information access, 176
leaf nodes, B*-tree index, 92
SGA, 176, 179
least recently used (LRU) algorithm, 50
MEMORY_TARGET, 38, 49
LGWR (Log Writer), 53, 194
merge, 200
Lifecycle Events Calendar, 136
messaging, 218
Lifecycle Management, 136
message-oriented middleware (MOM)
Lightweight Directory Access Protocol
queuing, advanced, 313
(LDAP), 65, 338
propagation, 219
linear regression functions, 234
queuing and streams, 19
links, to databases, 5
warehousing, 219
374
|
Index
messaging server, 315
NDMP (Network Data Management
metadata
Protocol), 136
dictionary, 54
Net Configuration Assistant, 57
management, 237
Net8
standardization initiatives, 248
Assistant, 66
MetaLink, 138
configuration, 63
methods, 320
network
Microsoft Cluster Services, 26
configuration, 63
Microsoft Transaction Server
network attached storage (NAS), 136
distributed transactions through Oracle
problems, debugging, 66
databases, 18
protocols, dispatchers, 74
Oracle Manager for, 309
Network Data Management Protocol
Middleware (Oracle Application Server)
(NDMP), 136
Management Packs, 126
NLS (National Language Support), 12, 83
mirroring, 163
NLS_LANGUAGE, 38
RAID and, 263
NLS_TERRITORY, 38
resynchronization, 266
NOARCHIVELOG mode
mirror-pair, 39
cold backups and, 276
(see also striped disk arrays)
defined, 46
modules, 334
node failure
MOLAP (Multidimensional Online
management and recovery, 271
Analytical Processing) engines, 245
Real Application Clusters (RAC),
MOM (message-oriented middleware), 313
management by, 271
MOUNT state, 69
NOLOGGING keyword, 42
mounting, databases, 69
nonescalating row locks, 193, 211
MTS (Multi-Threaded Server)
nonrepeatable reads, 189
basics, 73, 212
Non-Uniform Memory Access (see NUMA)
data dictionary information, 76
normalized forms
session data and, 76
benefits, 103, 105
MTS_MAX_SERVERS, 74
databases, 102
MTTR Advisor, 125
defined, 102
multiblock I/Os, 160
NOT NULL, 104
Multidimensional Online Analytical
NULLs, 89
Processing (MOLAP) engines, 245
TRUE or FALSE states, 89
multidimensional query, 229
values, 90
Multimedia enhancements, 325
NUMA (Non-Uniform Memory Access)
Multi-Threaded Server (see MTS)
advantages, 298
multiversion read consistency (MVRC), 211
synchronized data, 297
mutating tables runtime errors, 108
NUMBER datatype, 84
MVRC multiversion read consistency, 190,
NVARCHAR2 datatype, 83
211
O
N
OBIEE (Oracle Business Intelligence
naming services
Enterprise Edition Suite), 22
host, 65
object identifiers (OIDs), 320
Oracle Names, 64
object technologies, Oracle systems, 221
third-party, 65
object-oriented programming
Nanda, Arup, 145
Oracle8i, since, 11
NAS (network attached storage), 136
objects
National Language Support (NLS), 12, 83
data abstraction, 319
NCHAR datatype, 83
datatypes, 319
NCLOB datatype, 84, 87
development, 319
Index
|
375
objects
(continued)
OPTIMIZER_MODE, 114
instances and tables, 319
ORA_ROWSCN, 87
relational enhancements, 321, 329
ORA-01034: Oracle not available
relational features, 319
message, 258
views, 320
ORA-03113: End-of-file on communication
OC4J (J2EE ) containers, 335
channel message, 258
OCI (Oracle Call Interface), 11
Oracle
ODBC (Open DataBase Connectivity)
architecture, 33, 290
Oracle and, 11
auditing, 139
ODS (operational data store), 226
binary XML, 235
OFA (Optimal Flexible Architecture), 58
capabilities, 331
office plug-ins, 242
client/server communication,
OHS (Oracle HTTP Server), 334
configuring, 63
OID (Oracle Internet Directory), 14,
64, 147,
compliance, 139
338
concurrency, multiuser, 186
OIDs (object identifiers), 320
content management suite, 12
OIM (Oracle Identity Management), 147
data structures, 82
OLAP Option, 21
datatypes, extended, 318
OLAP tools, 245
distributed data and databases, 305
OLTP (online transaction processing)
high availability, 253
batch processing, contrasted with, 203
history, 1, 7
characteristics, 202
I/O management, 50
concurrency and performance
installation, 56, 57, 59
support, 211
installation and running, 56
data warehouse systems, contrasted
Java support, 322
with, 60
locking model and, 228
decision support, vs., 204
management, 122
history of, 201
multiple versions on one server, 58
Oracle features for, 211, 218
object technologies, supported, 221
Oracle products and, 205
OLTP, basics, 201
system architectures, 206
parallelism, support for, 170
systems, contrasted with data
performance, 154
warehouses, 223
security, 139
two-tier client/server, 206
single source code model, 8
OMFs (Oracle Managed Files), 35
supported operating systems, 6
online datafile backups, 133
transaction processing, 201
online redo log files, 46
warehousing, 222
online transaction processing (see OLTP)
Oracle Application Server
open connectivity, 307
components, 334
Open DataBase Connectivity (ODBC), 11
installation, 334
OPEN_CURSORS, 38
security, 338
opening, databases, 69
Web Cache, 341
operating system audit trail, 150
Oracle Application Server Containers, 335
Operating System Management Packs, 126
Oracle Application Server Portal, 15, 337
operational data store (ODS), 226
Oracle Application Server Web Cache, 15
operators, 330
Oracle Audit Vault Server, 153
OPS (Oracle Parallel Server), 26, 170, 215,
Oracle Berkeley DB, 31
296
Oracle Business Intelligence Enterprise
Optimal Flexible Architecture (OFA), 58
Edition Suite (OBI EE), 22
Optimal Flexible Architecture for a Growing
Oracle Call Interface (OCI), 11
Oracle Database, 58
Oracle Corporation, 5
optimize phase, 214
Oracle data dictionary, 54
376
|
Index
Oracle Data Guard, 282
Application Server
Oracle Database 10g
application server editions, 333
advanced queuing, 19
basics, 333
Automated Storage Management
ASM improvements, 300
(ASM), 27
auditing on by default, 139, 150
automatically and dynamically size pools
automated memory management of SGA
in SGA, 162
and PGA size, 124
configuration, 15
Automatic Database Diagnostic Monitor
Data Guard
(ADDM), 157, 159
basics, 26
automatic storage management, 266
management, 284
Automatic Workload Repository, 156
grid computing, 2
background processes, 52
deployment models, 8