See index-organized tables
iterative development, 158
forcing cursor sharing, 159??“160
iterative column definitions, 159
J
Java pool, 34
JAVA_POOL_SIZE parameter, 47
K
Kerberos, 285
L
Label Security, 41
large pool, 34
LARGE_POOL_SIZE parameter, 47, 102
least recently used (LRU) algorithms, 252
LGWR, 37
library cache, 33??“34
licensing, 637??“638
list command, 472??“473
list partitions, 15, 561
listeners, 517??“519
listener.ora parameters, 519??“520
LMTs. See locally managed tablespaces
load rates, impact of order on, 248??“249
LOBs
and Flashback, 239
sizing tables containing, 149
Index 661
locally managed tablespaces, 7, 176??“177,
257??“258
Log Writer. See LGWR
LOG_ARCHIVE_DEST_n parameter
attributes, 478??“479
logical backups, 392??“393
integrating logical and physical
backups, 415??“416
logical database structures
constraints, 15??“17
database links and remote databases, 24
external file access, 23??“24
indexes, 17??“19
PL/SQL, 22??“23
profiles, 21
sequences, 22
synonyms, 22
tables, 8??“15
users and schemas, 21
views, 19??“21
logical reads, eliminating, 125??“126
logical standby databases, 484??“485
failovers to, 490??“491
performing DDL on, 492??“493
switchovers to, 489
logical storage structures, 6
blocks, 7
extents, 7
segments, 7??“8
tablespaces, 6??“7
LogMiner, 500??“501
analyzing one or more redo log files,
502??“504
extracting the data dictionary, 501??“502
features introduced in Oracle
Database 10g, 504??“505
features introduced in Oracle
Database 11g, 505
M
management repository, 42
See also Oracle Enterprise Manager
(OEM)
manual database creation, 649??“652
manual upgrade, 50, 51, 54??“57
materialized view logs, 624??“625
materialized views, 19, 20??“21, 131,
268??“269, 589, 603??“604
altering query execution paths,
629??“630
managing, 612??“615
referential integrity, 621??“624
MAXDATAFILES, 552
Mean Time to Recovery (MTTR), 37
memory structures, 32
background processes, 35??“37
Program Global Area (PGA), 35
software code area, 35
System Global Area (SGA), 32??“34
memory usage, tuning, 252??“257
MEMORY_TARGET parameter, 46
Metalink, 637
MTTR.
Pages:
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964