traditional backup methods,
420??“421
666 Oracle Database 11g DBA Handbook
validating backups, 453??“455
validating restore operations, 464??“465
roles, 39??“40, 306
assigning roles, 310
creating roles, 308??“309
data dictionary views, 311??“313
default, 310??“311
dropping roles, 309
granting privileges to a role, 309
password-enabled, 311
predefined, 307??“308
revoking roles, 310
secure application roles, 308
rollback, 209
rollback segments, 8
row directories, 167
row migration, 148, 259
S
SAME, 267
schema object auditing, 337??“338
See also auditing
schemas, 21
SCN, 37
Secure Sockets Layer. See SSL
security
for abstract datatypes, 154??“156
non-database, 279
Segment Advisor, 185??“187, 200??“204
segments, 7, 167, 170??“171
data segments, 7
fragmented, 166
index segments, 7
rollback segments, 8
segment segregation, 73??“74
temporary segments, 8
See also Automatic Segment Space
Management (ASSM)
sequences, 22
SGA. See System Global Area (SGA)
SGA_TARGET parameter, 46
shared database links, 608??“609
shared pool, 33
shared server configuration, 35
SHARED_POOL_SIZE parameter, 47
SID. See Oracle System Identifier (SID)
sizing objects, 143
bitmap indexes, 148??“149
estimating proper value for pctfree,
147??“148
estimating space requirements for
indexes, 146??“147
estimating space requirements for
tables, 145??“146
impact of extent size on performance,
144??“145
index-organized tables, 149
partitions, 149
reasons for, 143
reverse key indexes, 148
space calculation rules, 143??“144
tables containing large objects
(LOBs), 149
smallfile tablespaces
resizing, 76
resizing using ALTER DATABASE,
77??“78
resizing using EM Database Control,
78??“84
SMON, 35
snapshots, 271
software code area, 35
software executables, 68??“69
software installation, 636??“637
installation options, 637??“638
using Oracle Universal Installer
(OUI), 638
sorted hash clusters, 13??“14
sorts, eliminating unnecessary sorts, 128
space management
archived redo log file management, 184
Automatic Storage Management
(ASM), 179??“181
Automatic Workload Repository,
187??“189
bigfile tablespaces, 178??“179
RMAN (continued)
Index 667
fragmented tablespaces and
segments, 166
index usage, 189??“190
insufficient space for temporary
segments, 165
locally managed tablespaces, 176??“177
managing alert and trace files with
ADR, 195??“197
OS space management, 197
Resumable Space Allocation, 192??“195
running out of free space in a
tablespace, 165
scripts, 197??“199
Segment Advisor, 185??“187, 200??“204
segments that cannot allocate
additional extents, 197??“198
SYSAUX monitoring and usage,
182??“184
too much or too little undo space
allocated, 165??“166
Undo Advisor, 187??“189, 204??“206
undo management considerations,
181??“182
used and free space by tablespace and
datafile, 198??“199
using DBMS_SCHEDULER to
automate and streamline
notification, 199
using OEM job control and
monitoring, 200??“206
using OMF to manage space, 177??“178
warning levels, 190??“192
SPFILE, backup, 444
SQL
generating SQL from Data Pump
import jobs, 409??“410
profiles, 143
See also Automatic SQL Tuning
Advisor; tuning SQL
SQL Access Advisor, 617??“621
SQL*Loader, Direct Path option, 262??“263
SSL, 284??“285
standard deliverables, 133??“135
Standard Edition, 637
Standard Edition One, 638
standby databases
configuration, 479??“485
physical vs.
Pages:
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969