logical, 477
See also Data Guard; logical standby
databases; physical standby
databases
statement auditing, 332??“336
See also auditing
statistics, 129
STATSPACK, 270??“271
See also Automatic Workload
Repository
stored outlines, 140??“142
editing, 142??“143
SQL profiles, 143
streams pool, 34
STREAMS_POOL_SIZE parameter, 47
stretch clusters, 351
suspending databases, 157??“158
switchovers, 487??“489
synonyms, 22
SYSAUX tablespace, 54, 63??“65, 72
monitoring and usage, 182??“184
System Change Number. See SCN
System Global Area (SGA), 5, 32??“33
buffer caches, 33
data dictionary cache, 34
Java pool, 34
large pool, 34
library cache, 33??“34
redo log buffer, 34
shared pool, 33
specifying the size of,
255??“256
streams pool, 34
System Monitor. See SMON
system privileges, 39, 40, 299??“300
auditing, 336
common system privileges, 301
data dictionary views, 302
granting, 300??“302
SYSTEM tablespace, 63, 72
system triggers, 194??“195
668 Oracle Database 11g DBA Handbook
T
table directories, 167
tables, 8
clustered tables, 13
effective table design, 243??“244
encrypting, 345
estimating space requirements for,
145??“146
external tables, 12, 263??“264, 555??“557
Flashback Table, 227??“232
hash clusters, 13
object tables, 11??“12
partitioned indexes, 15
privileges, 304, 305
recovering dropped tables using
Flashback Drop, 496??“498
redefining online, 507??“508
relational tables, 9??“10
sorted hash clusters, 13??“14
temporary tables, 11
See also index-organized tables;
partitioned tables
tablespaces, 6??“7
backup, 439??“442
bigfile tablespaces, 62, 67??“68, 76??“77,
91, 178??“179, 545??“552
creating in a VLDB environment,
545??“552
dropping a datafile from a tablespace,
84??“91
encrypting, 345??“346
EXAMPLE tablespace, 73
fragmented, 166
installation tablespaces, 72??“73
locally managed tablespaces, 7,
176??“177
managing in a RAC environment, 390
permanent tablespaces, 62??“65
reorganizing, 85??“91
resizing, 76??“91
restoring, 456??“458
running out of free space in a
tablespace, 165
segment segregation, 73??“74
smallfile tablespaces, 76, 77??“84
SYSAUX tablespace, 54, 63??“65, 72
SYSTEM tablespace, 63, 72
TEMP tablespace, 72
temporary tablespaces, 62, 65??“67
transportable tablespaces, 593??“597
undo tablespaces, 62, 65
UNDOTBS1 tablespace, 73
USERS tablespace, 73
See also Optimal Flexible
Architecture (OFA)
TEMP tablespace, 72
templates, selecting, 639??“640
temporary segments, 8, 170??“171
avoiding use of, 130
insufficient space for, 165
temporary tables, 11, 149??“150
temporary tablespace groups, 65??“67
temporary tablespaces, 62, 65??“67
default, 171
testing, 131??“133, 162
text indexes, 250
thin-client architecture, 512, 514
third normal form, 243
three-tier architecture, 512
three-tier authentication, 286
throughput, designing to, 130
TNS.
Pages:
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970