Pro Oracle Database 11g Administration (114 page)
unalias command, 56
viewing enabled actions, 629–630
uncompress utility, 549
bottlenecks, 602–609
UNDO feature, 31
mapping operating system process to
UNDO tablespace, 31
SQL statement, 608–609
overview, 72
using top, 606–607
troubleshooting, 620–623
using vmstat, 605
determining if sized correctly, 620–621
cron jobs, 581
viewing SQL that is consuming undo
database availability, 596–597
space, 622–623
disk fullness, 597–600
undo_management parameter, 31
locating alert log and trace files, 597–599
UNDO_RETENTION parameter, 620
removing files, 599–600
undo_tablespace parameter, 31
installation, 11–12
undropping tables, 152–153
locking issues, 616–618
UNIFORM SIZE clause, 73
open cursor issues, 618–619
uninstallob script, 551
remote installation, 22
UNION clause, 299
resource intensive SQL statements, 610–615
UNIQUE clause, 178
displaying, 611–612
unique constraints, 163–164
monitoring real-time statistics, 610–611
unique indexes, creating, 178–179
using ADDM, 614–615
UNIQUE keyword, 164
using ASH, 615
UNOBF function, 333
using AWR, 614
UNREGISTER_MVIEW procedure,
using Statspack, 615
DBMS_MVIEW package, 407
temporary tablespace issues, 623–625
UNTIL CHANGE clause, 449
determining if sized correctly, 623–624
UNTIL clause, 530, 532
viewing SQL that is consuming
UNTIL SCN clause, 530, 533
temporary space, 624–625
UNTIL SEQUENCE clause, 525
undo tablespace issues, 620–623
UNTIL TIME clause, 532
determining if sized correctly, 620–621
UNUSABLE status, 190
viewing SQL that is consuming undo
unzip command, 15
space, 622–623
updatable join views, 195–197
TRUNCATE command, 631
UPDATE INDEXES clause, 292–293, 297, 304
TRUNCATE parameter, 331
UPDATE privilege, 129
TRUNCATE statement, 153–154, 157, 331, 399,
update statement, 72, 140, 195–196
410
676
■ INDEX
UPDATE_DTT column, 138
accounts in database, 223
UPGRADE parameter, 43
cloning, 333
upgrading
creating, 115–118
OSB, 567–568
authentication method for, 115–116
overview, 15–16
system before installation, 5–6
UPPER function, 177
tablespace settings for, 116–118
UPPER(EMP_NAME) function, 177
username for, 115–116
us column, 605
currently connected user, 220–221
USABLE state, 190
currently executing SQL, 222
usage, monitoring of for indexes, 190–191
default, 112–114
USE_CURRENT_SESSION parameter, 574
dropping, 122–123
USER/ALL/DBA view, 213
logging on as different, 120–122
USER column, 607
modifying, 122
user-defined disk locations, 422–424
passwords for
USER SYS clause, 35
changing, 118
USER SYSTEM clause, 35
security of, 119–120, 124–126
USER$ table, 214
privileges for, 128–130
_USER variable, SQL*Plus, 55
grouping of, 130
USER view, 214
object, 129
USER1 tablespace, 247
system, 128–129
useradd command, 6
resource limits for, 126–128
USER_COL_PRIVS view, 235
and schemas, 111
USER_COL_PRIVS_MADE view, 235
terminology of OSB, 548
USER_COL_PRIVS_RECD view, 235
users currently logged in, 221–222
USER_CONSTRAINTS view, 229
USERS tablespace, 34–35, 72, 115, 122, 394, 443,
userdel command, 6
445, 517, 520
USER_DUMP_DEST parameter, 93, 537
USER_SEGMENTS view, 250, 366–367
USERENV namespace, 220
users.sql script, 67–68
USER_IND_COLUMNS view, 227
USER_SYS_PRIVS view, 235
USER_INDEXES view, 227, 289, 376
USER_TABLES view, 214, 224, 226, 290, 388–389
USER_IND_PARTITIONS table, 300–301
USER_TAB_MODIFICATIONS view, 628
USER_JOBS view, 398
USER_TAB_PARTITIONS table, 284, 375
USER_LOBS view, 251, 255, 266
USER_TAB_PRIVS view, 235–236
usermod command, 6
USER_TAB_PRIVS_MADE view, 235
USER_MVIEW_LOGS view, 392
USER_TAB_PRIVS_RECD view, 235
USER_MVIEWS view, 366, 372, 380, 409
USING BACKUP CONTROLFILE clause, 447
USERNAME column, 233
/usr/local/oracle/backup directory, 549, 551
usernames, for users, 115–116
UTLDTREE script, 238
USER_OBJECTS view, 366
utlpwdmg.sql script, 119
USER_PART_INDEXES table, 302
USER_PART_TABLES table, 375
■ V
USER_REFRESH view, 398
V constraint code, 230
USER_ROLE_PRIVS view, 130, 232, 235
-v option, 563, 567
users, 111–131, 220–223
\v variable, bash shell, 53
677
■ INDEX
V$ view, 213, 215–216
viewing space used by, 392–393
VALID status, 292
VIEW_DEFINITION column, 216
VALIDATE command, 499–501, 523
views, 193–200
VALIDATE HEADER clause, 593
WITH CHECK OPTION clause, 194–195
validating backup files, before restoring, 517
creating, 193–194
VALUE column, 95
data-dictionary, 338–339
VALUES LESS THAN clause, 272, 274
displaying SQL used to create, 198–199
/var/log/cron file, 576, 582
dropping, 200
/var/opt/oracle directory, 12, 14, 26, 28, 583
INSTEAD OF clause, 197–198
/var/spool/cron directory, 576
materialized.
See
MVs
/var/spool/cron/
modifying view definition, 198
VARCHAR data type, 137
WITH READ ONLY clause, 195
VARCHAR2 data type, 137
renaming, 200
V$ARCHIVED_LOG view, 219, 428, 433, 533, 588
updatable join views, 195–197
V$BACKUP view, 505
V$INSTANCE_RECOVERY view, 103
V$BACKUP_ARCHIVELOG_DETAILS view, 505
VIRT column, 607
V$BACKUP_CONTROLFILE_DETAILS view, 505
virtual columns
V$BACKUP_COPY_DETAILS view, 505
partitioning of, 286
V$BACKUP_DATAFILE view, 505
for tables, 138–140
V$BACKUP_DATAFILE_DETAILS view, 505
virtual memory statistics (vmstat), 603–605
V$BACKUP_FILES view, 505
virtual partition type, 272
V$BACKUP_PIECE view, 505
virtual test devices, for OSB, 566–567
V$BACKUP_PIECE_DETAILS view, 505
VISIBLE clause, 184
V$BACKUP_SET view, 505
VISUAL variable, 579
V$BACKUP_SET_DETAILS view, 505
vlib1 library, 567
V$CONTROLFILE view, 93, 219
V$LOG view, 100–102, 219, 531, 533
V_DATA tablespace, 323
V$LOGFILE view, 98, 100–102, 108, 542
V$DATABASE view, 92, 219, 528
V$LOG_HISTORY view, 102, 219, 525, 531, 533
V$DATABASE_BLOCK_CORRUPTION view,
vmstat (virtual memory statistics), 603–605
500–501, 523–524
V$MVREFRESH view, 365
V$DATAFILE view, 219, 442–443, 521
V$OBJECT_USAGE view, 190–191
V$DATAFILE_HEADER view, 219, 443, 530
VOLSIZE parameter, 342, 344
VERSION parameter, 357
V$OPEN_CURSOR view, 619
V$FIXED_VIEW_DEFINITION view, 199, 216
V$PARAMETER view, 215
vi utility, 16, 59, 95, 559, 579
V$PWFILE_USERS view, 40
view command, 600
V$RESTORE_POINT view, 533
view logs, 390–395
V$RMAN_BACKUP_JOB_DETAILS view, 505,
checking row count of, 393–394
507
creating, 391–392
V$RMAN_COMPRESSION_ALGORITHM view,
indexing log columns, 392
477
materialized
V$RMAN_ENCRYPTION_ALGORITHMS view,
dropping, 395
477
moving, 394
V$RMAN_OUTPUT view, 501, 503
shrinking space in, 393
V$ROLLNAME view, 622
V$ROLLSTAT view, 622
678
■ INDEX
V$SESSION view, 222, 619
WITH CHECK OPTION clause, for views,
V$SESSTAT view, 613
194–195
V$SQL view, 611–612, 622
WITH COMMIT SCN clause, 391
V$SQLAREA view, 611–612
WITH GRANT OPTION clause, 129
V$SQL_MONITOR view, 611–612, 614
WITH OBJECT ID clause, 391
V$SQLSTATATS view, 611
WITH PRIMARY KEY clause, 375, 391
V$SQLSTATS view, 611–612
WITH READ ONLY clause, 195
V$SQLTEXT view, 222
WITH ROWID clause, 375, 391
V$SQLTEXT_WITH_NEWLINES view, 222
WITHOUT VALIDATION clause, 294–295
V$SYSSTAT view, 613
WORKPART table, 294
V$TEMPFILE view, 83
:wq command, vi utility, 579
V$UNDOSTAT view, 620
WRAPUP state, 402
write mode, for tablespaces, 77–78
■ W
-x option, 563
\w variable, bash shell, 52–53
wa column, vmstat utility, 604–605
■ X, Y
WAIT_OS_PID column, 618
X$ table, 215
watch command, 604
xargs command, 599
watch -d command, 605
XENGDB server, 403
watch utility, 603–604
xeyes utility, 20
WHENEVER NOT SUCCESSFUL setting, 630
xhost command, 19, 21–22
WHENEVER SUCCESSFUL setting, 630
XML setting, AUDIT_TRAIL parameter, 627
WHERE clause, 139–140, 146, 174, 176, 178, 180,
364, 390, 392
■ Z
WITH ADMIN OPTION clause, 128
Z command, 606
679
- Team rebOOk
