ORA file, 68
leaf nodes, B*-tree index, 92
least recently used (LRU) algorithm, 50
LGWR (Log Writer), 53, 194
Lifecycle Events Calendar, 136
Lifecycle Management, 136
Lightweight Directory Access Protocol
(LDAP), 65, 338
linear regression functions, 234
links, to databases, 5
Linux, 23
LISTENER.ORA file, 67
list-hash partitioning, 236
list-list partitioning, 236
list-range partitioning, 236
load-balancing, 208, 342
loading process, 238
LOB (Large Objects), 87
local name resolution, 64
location transparency, 64
locks, 188
datablocks, in, 193
escalation, 193
Log Writer (LGWR), 53, 194
LOG_ARCHIVE_DEST, 37, 47
LOG_ARCHIVE_DEST_STATE, 37
LOG_ARCHIVE_DUPLEX_DEST, 48
LOG_ARCHIVE_FORMAT, 47
LOG_ARCHIVE_MIN_SUCCEED_
DEST, 48
LOG_ARCHIVE_START, 47
logical standby database capability, 283
logicality of instances, 33
LogMiner and LogMiner Manager, 277
LONG datatype, 84
LONG RAW, 86
LONGRAW datatype, 86
lookup tables, 229
lost updates, 189
LRU (least recently used) algorithm, 50
M
Management Connectors, 126
managment, self-tuning, 23
MapViewer, 336
materialized views, 21, 91, 232
media failure, 133
medical imaging standard support, 326
Memory Advisors, 124, 157
memory management, automated, 49, 124
memory resources
information access, 176
SGA, 176, 179
MEMORY_TARGET, 38, 49
merge, 200
messaging, 218
message-oriented middleware (MOM)
queuing, advanced, 313
propagation, 219
queuing and streams, 19
warehousing, 219
Index | 375
messaging server, 315
metadata
dictionary, 54
management, 237
standardization initiatives, 248
MetaLink, 138
methods, 320
Microsoft Cluster Services, 26
Microsoft Transaction Server
distributed transactions through Oracle
databases, 18
Oracle Manager for, 309
Middleware (Oracle Application Server)
Management Packs, 126
mirroring, 163
RAID and, 263
resynchronization, 266
mirror-pair, 39
(see also striped disk arrays)
modules, 334
MOLAP (Multidimensional Online
Analytical Processing) engines, 245
MOM (message-oriented middleware), 313
MOUNT state, 69
mounting, databases, 69
MTS (Multi-Threaded Server)
basics, 73, 212
data dictionary information, 76
session data and, 76
MTS_MAX_SERVERS, 74
MTTR Advisor, 125
multiblock I/Os, 160
Multidimensional Online Analytical
Processing (MOLAP) engines, 245
multidimensional query, 229
Multimedia enhancements, 325
Multi-Threaded Server (see MTS)
multiversion read consistency (MVRC), 211
mutating tables runtime errors, 108
MVRC multiversion read consistency, 190,
211
N
naming services
host, 65
Oracle Names, 64
third-party, 65
Nanda, Arup, 145
NAS (network attached storage), 136
National Language Support (NLS), 12, 83
NCHAR datatype, 83
NCLOB datatype, 84, 87
NDMP (Network Data Management
Protocol), 136
Net Configuration Assistant, 57
Net8
Assistant, 66
configuration, 63
network
configuration, 63
network attached storage (NAS), 136
problems, debugging, 66
protocols, dispatchers, 74
Network Data Management Protocol
(NDMP), 136
NLS (National Language Support), 12, 83
NLS_LANGUAGE, 38
NLS_TERRITORY, 38
NOARCHIVELOG mode
cold backups and, 276
defined, 46
node failure
management and recovery, 271
Real Application Clusters (RAC),
management by, 271
NOLOGGING keyword, 42
nonescalating row locks, 193, 211
nonrepeatable reads, 189
Non-Uniform Memory Access (see NUMA)
normalized forms
benefits, 103, 105
databases, 102
defined, 102
NOT NULL, 104
NULLs, 89
TRUE or FALSE states, 89
values, 90
NUMA (Non-Uniform Memory Access)
advantages, 298
synchronized data, 297
NUMBER datatype, 84
NVARCHAR2 datatype, 83
O
OBIEE (Oracle Business Intelligence
Enterprise Edition Suite), 22
object identifiers (OIDs), 320
object technologies, Oracle systems, 221
object-oriented programming
Oracle8i, since, 11
objects
data abstraction, 319
datatypes, 319
development, 319
376 | Index
objects (continued)
instances and tables, 319
relational enhancements, 321, 329
relational features, 319
views, 320
OC4J (J2EE ) containers, 335
OCI (Oracle Call Interface), 11
ODBC (Open DataBase Connectivity)
Oracle and, 11
ODS (operational data store), 226
OFA (Optimal Flexible Architecture), 58
office plug-ins, 242
OHS (Oracle HTTP Server), 334
OID (Oracle Internet Directory), 14, 64, 147,
338
OIDs (object identifiers), 320
OIM (Oracle Identity Management), 147
OLAP Option, 21
OLAP tools, 245
OLTP (online transaction processing)
batch processing, contrasted with, 203
characteristics, 202
concurrency and performance
support, 211
data warehouse systems, contrasted
with, 60
decision support, vs.
Pages:
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779