V W

Page 240

options, 3

other methods, 5–6

rolling upgrades for RAC, 14–15

Upgrade Information Tool (UIT), 4

versions to upgrade from, 3

See also downgrading

user-configurable default tablespaces, 33

user-specified quote character assignment, 174

utl_compress package, 174–175

utl_mail package, 175

V

V$ALERT_TYPES, 61

V$ASM_ALIAS, 12

V$ASM_CLIENT, 12–13

V$ASM_DISK, 13

V$ASM_DISKGROUP, 13

V$ASM_FILE, 13

V$ASM_OPERATION, 13

V$ASM_TEMPLATE, 13

V$DATABASE view, 96

V$DISPATCHER_CONFIG, 66

V$EVENT_HISTOGRAM, 43

V$EVENT_NAME view, 40–41

V$EVENTMETRIC, 49

V$FILE_HISTOGRAM, 43

V$FILEMETRIC, 49

V$FILEMETRIC_HISTORY, 49

V$FLASHBACK_DATABASE_LOG view, 96

V$FLASHBACK_DATABASE_STAT view, 96

V$JAVA_LIBRARY_CACHE_MEMORY, 59

V$JAVA_POOL_ADVICE, 59

V$LIBRARY_CACHE_MEMORY, 58

V$METRICGROUP, 49

V$METRICNAME, 49

V$SERVICEMETRIC, 49

V$SESSION, 41, 42

V$SESSMETRIC, 49

V$SHARED_POOL_ADVICE, 58

V$SYSMETRIC, 49, 60

V$SYSMETRIC_HISTORY, 49, 61

V$TEMP_HISTOGRAM, 43

V$WAITCLASSMETRIC, 49

V$WAITCLASSMETRIC_HISTORY, 49

variables

define variables in SQL*Plus, 204

run-time variable substitution, 204–205

VARRAY columns

ANSI support for, 178–181

changing the element size, 177

creating temporary tables with, 176–177

versioned data, 197–199

views

flash recovery area, 81

Flashback Database, 96

histogram, 42–43

Virtual Private Database

column-level privacy, 68–69

new policies, 69–70

support for parallel query, 70

Workspace Manager support for, 200

VPD. See Virtual Private Database

W

wait interface, improvements to, 40–43

windows, 27, 221

workload repository (WR), 45–48

See also Automatic Workload Repository

Workspace Manager, 190–191

continuous refresh, 199

data dictionary views, 196

DBA_WM_SYS_PRIVS view, 200

DDL functionality, 200

events, 196

exporting, importing and loading versioned data, 197–199

multiparent workspaces, 193–196

new functionality in dbms_wm package, 191–193

setting system-wide parameters, 191–193

support for Virtual Private Database, 200

table-level constraint support, 199–200

using SQL*Loader with versioned tables, 198–199