successful DML,
222??“223
rollback, 209
sizing and monitoring, 220??“222
too much or too little undo space
allocated, 165??“166
Undo Advisor, 221
using OMF for, 215
UNDO_MANAGEMENT parameter, 47,
216, 217
UNDO_RETENTION parameter, 217
UNDO_TABLESPACE parameter, 47,
216??“217
UNDOTBS1 tablespace, 73
unique column values, 16
unique indexes, 18
upgrading to Oracle Database 11g
after upgrading, 59
choosing an upgrade method, 51??“52
670 Oracle Database 11g DBA Handbook
copying data from an earlier version,
50, 52, 58??“59
Database Upgrade Assistant (DBUA),
50, 51, 53??“54
direct upgrade, 51
with Export and Import utilities, 50,
57??“58
manual upgrade, 50, 51, 54??“57
options, 50??“51
with Oracle Data Pump, 50, 52
steps prior to upgrading, 52??“53
user accounts
altering users, 289??“291
becoming another user, 291??“292
creating users, 288??“289, 290
data dictionary views, 292
dropping users, 291
users, 21
USERS tablespace, 73
V
V$ALERT_TYPES, 174??“175
V$OBJECT_USAGE, 175
V$SORT_SEGMENT, 175
V$TABLESPACE, 552
V$TEMPSEG_USAGE, 175
V$UNDOSTAT, 175
validating backups, 453??“455
versioning, 158
Very Large Databases. See VLDB
environments
views, 19??“20
materialized views, 19, 20??“21, 131,
268??“269, 589, 603??“604, 612??“615
object views, 21
privileges, 304
regular views, 20
virtual column partitioning, 570
Virtual Private Database, 41, 313??“314
creating a VPD, 320??“328
creating application contexts, 314??“316
developing a VPD policy, 328??“330
security policy implementation,
316??“317
using DBMS_RLS, 317??“320
VLDB environments, 544
bitmap indexes, 589??“591
creating tablespaces in, 545??“552
and external tables, 555??“557
and global temporary tables, 553??“555
and index-organized tables, 553
partitioned tables, 557??“588
VPD.
Pages:
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972