See Transparent Network
Substrate (TNS)
trace log files, 28
traffic reduction, 268
replication of data using materialized
views, 268??“269
using remote procedure calls, 270
transactions, 208??“209
distributed transactions, 630??“632
Flashback Transaction Blackout, 227
Flashback Transaction Query,
234??“235
resolving in-doubt transactions, 631
Transparent Data Encryption, 342??“346
See also data encryption
Transparent Network Substrate (TNS), 515
transportable tablespaces, 593??“597
trigger-based integrity, 17
Index 669
triggers, 23, 603, 610??“612
disabling, 264??“265
system triggers, 194??“195
truncate command, 265??“266
tuning, 275??“276
distribution of CPU requirements,
244??“245
effective application design, 245??“246
effective table design, 243??“244
tuning a RAC node, 389
tuning data access, 257
identifying chained rows, 258??“259
increasing the Oracle block size,
259??“260
locally managed tablespaces, 257??“258
using index-organized tables, 260??“262
tuning data manipulation, 262
bulk data moves, 263??“264
bulk deletes, 265??“266
bulk inserts, 262??“263, 264??“265
using external tables, 263??“264
using partitions, 266
using the SQL*Loader Direct Path
option, 262??“263
using the truncate command, 265??“266
tuning distributed databases, 632??“634
tuning memory usage, 252??“255
compute statistics option, 257
specifying the size of the SGA, 255??“256
using the cost-based optimizer,
256??“257
tuning Oracle Net, 540??“542
tuning physical storage, 267
using ASM, 267
using raw devices, 267
tuning SQL, 247??“248
bitmap indexes, 249
clusters, 249
concatenated indexes, 247
equivalence queries, 249
explain plans, 250??“252
full table scans, 247
function-based indexes, 249??“250
impact of order on load rates, 248??“249
index range scans, 247??“248
range queries, 248
reverse indexes, 249
text indexes, 250
Two-Phase Commit, 602??“603
two-tier architecture, 512
U
Undo Advisor, 187??“189, 204??“206, 221
undo segments
eliminating the need to query, 128??“129
too much or too little undo space
allocated, 165??“166
undo tablespaces, 62, 65, 209
controlling undo usage, 222
creating, 210??“214
and database recovery, 210
dropping, 214??“215
dynamic performance views, 216
Flashback, 210, 223??“239
initialization parameters, 216??“217
management considerations, 181??“182
modifying, 215
multiple, 217??“220
in a RAC environment, 383
read consistency, 209??“210
read consistency vs.
Pages:
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971