---

V

V number format element, SQL 2-36

V variable in SQLDA

how value is set, PC_ 15-8

purpose of, PC_ 15-8

V$ dynamic performance views, STU 12-5

V$ACCESS view, SRF 3-3

V$ACTIVE_INSTANCES, PSC 4-11

V$ACTIVE_INSTANCES table, PSC 6-28

V$ACTIVE_INSTANCES view, SPS 23-4, SPS A-9, SRF 3-4

V$AQ view, SRF 3-4

V$ARCHIVE view, SAD 7-23, SBR 2-4, SBR 2-12, SBR 2-18, SRF 3-4

V$ARCHIVE_DEST, SRF 3-5

V$ARCHIVE_DEST view

obtaining destination status, SAD 7-14

V$ARCHIVE_PROCESSES view, SRF 3-7

V$ARCHIVED_LOG view, SRF 3-6

V$BACKUP view, SBR 13-7, SRF 3-7

V$BACKUP_ASYNC_IO

for tuning backups, STU 20-46

view, description, STU 20-47

V$BACKUP_ASYNC_IO view, SRF 3-7

V$BACKUP_CORRUPTION view, SBR 4-36, SRF 3-9

V$BACKUP_DATAFILE view, SRF 3-9

V$BACKUP_DEVICE view, SRF 3-10

V$BACKUP_PIECE view, SRF 3-11

V$BACKUP_REDOLOG view, SRF 3-12

V$BACKUP_SET view, SRF 3-13

V$BACKUP_SYNC_IO

for tuning backups, STU 20-46

view, description, STU 20-47

V$BACKUP_SYNC_IO view, SRF 3-14

V$BGPROCESS view, SRF 3-15

V$BH view, SPS 9-10, SPS 19-5, SPS A-7, SPS A-9, SPS A-17, SRF 3-15, STU 19-29

V$BUFFER_POOL view, SRF 3-17

V$BUFFER_POOL_STATISTICS view, STU 19-38, STU 19-40

V$CACHE view, SPS 19-5, SPS A-17, SRF 3-18

V$CACHE_LOCK view, SPS 20-12, SRF 3-19

V$CIRCUIT view, SRF 3-20

V$CLASS_PING view, SPS A-7, SRF 3-21

V$COMPATIBILITY view, SRF 3-22

V$COMPATSEG view, SRF 3-23

V$CONTEXT view, SRF 3-23

V$CONTROLFILE view, SRF 3-23

V$CONTROLFILE_RECORD_SECTION view, SRF 3-24

V$COPY_CORRUPTION view, SRF 3-24

V$DATABASE view, SAD 7-24, SBR 2-4, SBR 2-18, SRF 3-25

V$DATAFILE, SAD 9-31, SAD 10-13

V$DATAFILE view, SBR 14-31, SBR 16-28, SPS 6-3, SPS 15-11, SRF 3-26, STU 20-19

listing files for backups, SBR 13-2

V$DATAFILE_COPY view, SRF 3-27

V$DATAFILE_HEADER view, SRF 3-29

V$DB_OBJECT_CACHE view, SRF 3-30

V$DB_PIPES view, SRF 3-31

V$DBFILE view, SAD 2-8, SRF 3-30

V$DBLINK view, SRF 3-30

V$DELETED_OBJECT view, SRF 3-31

V$DISPATCHER view, SRF 3-32, STU 21-6

controlling dispatcher process load, SAD 4-7

V$DISPATCHER_RATE view, SRF 3-33

V$DLM_ALL_LOCKS

new view for 8.1, SPS A-2

V$DLM_ALL_LOCKS view, SPS 7-5, SPS 8-11, SRF 3-35

V$DLM_CONVERT_LOCAL view, SPS 8-11, SPS A-7, SRF 3-37

V$DLM_CONVERT_REMOTE view, SPS 8-11, SPS A-7, SRF 3-37

V$DLM_LATCH view, SPS A-7, SRF 3-38

V$DLM_LOCKS view, SPS 7-5, SPS 8-11, SRF 3-38

changed for 8.0.4, SPS A-6

V$DLM_MISC view, SPS 8-11, SPS A-7, SRF 3-40

V$DLM_RESS

new view, SPS A-2

V$DLM_RESS view, SPS 7-5, SPS 8-11, SRF 3-40

V$ENABLEDPRIVS view, SRF 3-40

V$ENQUEUE_LOCK view, SRF 3-41

V$EVENT_NAME view, SRF 3-41

V$EXECUTION view, SRF 3-42

V$FALSE_PING view, SRF 3-42

V$FAST_START_SERVERS

view, SPS 22-16, SPS A-3

V$FAST_START_SERVERS view, SRF 3-44, STU 11-10, STU 25-16

V$FAST_START_TRANSACTIONS

view, SPS 22-16, SPS A-3

V$FAST_START_TRANSACTIONS view, SRF 3-44, STU 11-11, STU 25-16

V$FILE_PING view, SPS A-7, SRF 3-45

V$FILESTAT view, SRF 3-46

and parallel query, STU 26-79

disk I/O, STU 20-19

PHYRDS column, STU 20-19

PHYWRTS column, STU 20-19

V$FIXED_TABLE view, SRF 3-47, STU 16-2

V$FIXED_VIEW_DEFINITION view, SRF 3-47

V$GLOBAL_BLOCKED_LOCKS view, SRF 3-48

V$GLOBAL_TRANSACTION view, SRF 3-48

V$HS_AGENT view, SRF 3-49

V$HS_SESSION view, SRF 3-49

V$INDEXED_FIXED_COLUMN view, SRF 3-50

V$INSTANCE view, SRF 3-50, STU 16-2

V$INSTANCE_RECOVERY view, SRF 3-51

V$LATCH view, SRF 3-52, STU 16-2, STU 21-2, STU 21-17

V$LATCH_CHILDREN view, SRF 3-53, STU 19-40

V$LATCH_MISSES view, SRF 3-54, STU 18-9

V$LATCH_PARENT view, SRF 3-54

V$LATCHHOLDER view, SRF 3-53

V$LATCHNAME view, SRF 3-53

V$LE table, SPS 9-20

V$LIBRARYCACHE view, SRF 3-54, STU 16-2

NAMESPACE column, STU 19-13

PINS column, STU 19-14

RELOADS column, STU 19-14

V$LICENSE view, SAD 23-6, SRF 3-55

V$LOADCSTAT view, SRF 3-56

V$LOADTSTAT view, SRF 3-56

V$LOCK view, SPS 7-9, SRF 3-56, STU 16-3

V$LOCK_ACTIVITY view, SPS 20-12, SPS A-17, SRF 3-59

detecting lock conversion, SPS 19-3

V$LOCK_ELEMENT view, SPS 7-9, SPS 9-20, SRF 3-60

V$LOCKED_OBJECT view, SRF 3-61

V$LOCKS_WITH_COLLISIONS view, SPS 20-12, SPS A-16, SRF 3-61

V$LOG view, SAD 7-23, SBR 2-4, SBR 2-12, SBR 2-18, SRF 3-62

displaying archiving status, SAD 7-23, SBR 2-4, SBR 2-12, SBR 2-18

online redo log, SAD 6-18

viewing redo data with, SAD 6-18

V$LOG_HISTORY view, SBR 14-7, SPS 21-7, SRF 3-66

V$LOGFILE view, SAD 2-8, SBR 15-6, SBR 15-7, SPS 6-5, SRF 3-63

listing files for backups, SBR 13-2

logfile status, SAD 6-15

viewing redo data with, SAD 6-18

V$LOGHIST view, SRF 3-63

V$LOGMNR_CONTENTS view, SAD 7-31, SRF 3-63

using to analyze archived redo logs, SAD 7-25

V$LOGMNR_DICTIONARY view, SRF 3-65

V$LOGMNR_LOGS view, SRF 3-65

V$LOGMNR_PARAMETERS view, SRF 3-66

V$LONGOPS view, SBR 4-36

V$MLS_PARAMETERS view, SRF 3-67

V$MTS view, SRF 3-67

V$MYSTAT view, SRF 3-68, STU 16-3

V$NLS_PARAMETERS view, SRF 3-68

V$NLS_VALID_VALUES view, SRF 3-68

V$OBJECT_DEPENDENCY view, SRF 3-68, SRF 3-69

V$OFFLINE_RANGE view, SRF 3-69

V$OPEN_CURSOR view, SRF 3-70

V$OPTION table, GTK 4-14

V$OPTION view, SRF 3-70

V$PARALLEL_DEGREE_LIMIT_MTH view, SRF 3-70

V$PARAMETER view, SRF 3-71, STU 26-80

V$PING view, SPS 19-5, SPS 19-6, SPS A-17, SRF 3-71

V$PQ_SESSTAT view, SRF 3-73, STU 26-79, STU 27-31

V$PQ_SLAVE view, SRF 3-74

V$PQ_SYSSTAT table, PSC 1-22

V$PQ_SYSSTAT view, SRF 3-74, STU 27-31

V$PQ_TQSTAT view, SRF 3-75, STU 26-80, STU 27-32

V$PROCESS, STU 16-3

V$PROCESS view, SRF 3-76

V$PROXY_ARCHIVEDLOG view, SBR 4-19

V$PROXY_ARCHIVELOG view, SRF 3-77

V$PROXY_DATAFILE view, SBR 4-19, SRF 3-78

V$PWFILE_USERS view, SAD 1-13, SRF 3-79

V$PX_PROCESS view, SRF 3-80, STU 26-78

V$PX_PROCESS_SYSSTAT view, SRF 3-80

V$PX_SESSION view, SRF 3-81, STU 26-78

V$PX_SESSTAT view, SRF 3-82, STU 26-78

V$QUEUE view, SRF 3-82, STU 21-7, STU 21-10

controlling dispatcher process load, SAD 4-7

V$RECOVER_FILE view, SBR 1-24, SBR 14-3, SRF 3-83

determining which files to recover, SBR 3-27

V$RECOVERY_FILE_STATUS view, SRF 3-83

V$RECOVERY_LOG view, SBR 14-7, SPS 21-7, SRF 3-84

V$RECOVERY_PROGRESS view, SRF 3-84

V$RECOVERY_STATUS view, SRF 3-85

V$REQDIST view, SRF 3-85

V$RESERVED_WORDS view, SRF 3-86

V$RESOURCE view, SRF 3-86

V$RESOURCE_LIMIT view, SPS 16-3, SPS A-7, SRF 3-86, STU 21-2

V$ROLLNAME

finding PENDING OFFLINE segments, SAD 21-15

V$ROLLNAME view, SPS 20-12, SRF 3-88

V$ROLLSTAT

finding PENDING OFFLINE segments, SAD 21-15

V$ROLLSTAT view, SRF 3-88, STU 16-2

V$ROWCACHE view, SRF 3-89, SRF 3-90, SRF 3-91, STU 16-2

GETMISSES column, STU 19-20

GETS column, STU 19-20

performance statistics, STU 19-19

using, STU 19-19

V$RSCRC_CONSUMER_GROUP view, SRF 3-91

V$RSCRC_CONSUMER_GROUP_CPU_MTH view, SRF 3-92

V$RSCRC_PLAN view, SRF 3-92

V$RSCRC_PLAN_CPU_MTH view, SRF 3-92

V$SESS_IO view, SRF 3-104

V$SESSION, SAD 8-14

V$SESSION view, SAD 4-17, SRF 3-92, STU 16-3, STU 25-22

application registration, STU 5-1, STU 12-7

V$SESSION_CONNECT_INFO view, SRF 3-98

V$SESSION_CURSOR_CACHE view, SRF 3-99

V$SESSION_EVENT view, SRF 3-99, SRF A-2, STU 16-3

network information, STU 22-1

V$SESSION_LONGOPS view, SRF 3-100

V$SESSION_OBJECT_CACHE view, SRF 3-101

V$SESSION_WAIT view, SPS 15-17, SRF 3-102, SRF A-2, STU 16-3, STU 19-39, STU 21-2

network information, STU 22-1

V$SESSIONS_LONGOPS view, GTK 2-28

V$SESSTAT view, SRF 3-103, SRF C-1, SRF C-2, STU 16-3, STU 18-5, STU 26-80, STU 26-83

network information, STU 22-2

using, STU 19-22

V$SGA view, SRF 3-104, STU 16-2

V$SGASTAT view, SRF 3-104, STU 16-2

V$SHARED_POOL_RESERVED view, SRF 3-105, STU 19-25

V$SHARED_SERVER view, SRF 3-106

V$SORT_SEGMENT view, SPS A-9, SPS A-10, SRF 3-106, STU 27-12

V$SORT_USAGE view, SRF 3-107, STU 4-5, STU 16-2

V$SQL view, SRF 3-108

V$SQL_BIND_DATA view, SRF 3-110

V$SQL_BIND_METADATA view, SRF 3-110

V$SQL_CURSOR view, SRF 3-111

V$SQL_SHARED_MEMORY view, SRF 3-111

V$SQLAREA, STU 16-2, STU 18-7

application registration, STU 5-1, STU 5-5, STU 12-7

resource-intensive statements, STU 4-5

V$SQLAREA view, SRF 3-112

V$SQLTEXT view, SRF 3-114, STU 16-2

V$SQLTEXT_WITH_NEWLINES view, SRF 3-114

V$STATNAME view, SRF 3-115, SRF C-2

V$SUBCACHE view, SRF 3-119

V$SYSSTAT view, SPS 15-13, SPS 22-5, SPS A-7, SRF 3-119, SRF C-1, STU 16-2, STU 18-5, STU 18-6, STU 26-75, STU 26-80

detecting dynamic extension, STU 20-27

detecting lock conversion, SPS 19-3

examining recursive calls, STU 20-27

redo buffer allocation, STU 21-15

redo buffer allocation retries, STU 26-26

tuning sorts, STU 20-34

using, STU 19-26

V$SYSTEM_CURSOR_CACHE view, SRF 3-120

V$SYSTEM_EVENT view, SPS 15-16, SRF 3-120, SRF A-2, STU 16-2, STU 18-9, STU 21-1, STU 21-2

V$SYSTEM_PARAMETER view, SRF 3-121

V$TABLESPACE view, SRF 3-121

V$TEMP_EXTENT_MAP view, SRF 3-122

V$TEMP_EXTENT_POOL view, SRF 3-123

V$TEMP_PING view, SRF 3-123

V$TEMP_SPACE_HEADER view, SRF 3-125

V$TEMPFILE view, SRF 3-121

V$TEMPORARY_LOBS view, SRF 3-122

V$TEMPSTAT view, SRF 3-125

V$THREAD view, SAD 6-18, SPS 23-4, SRF 3-126

viewing redo data with, SAD 6-18

V$TIMER view, SRF 3-127

V$TRANSACTION view, SRF 3-127

V$TRANSACTION_ENQUEUE view, SRF 3-128

V$TYPE_SIZE view, SRF 3-129

V$VERSION view, SRF 3-129

V$WAITSTAT view, SPS 19-6, SRF 3-130, STU 16-2, STU 21-2

reducing free list contention, STU 21-21

rollback segment contention, STU 21-3

V_$ and V$ views, SCN 2-7

V$LICENSE, SCN 29-20

V1ADD.NPO.OMD record, NET 8-17, NET A-45

Version 6, GTK 6-6

V7

value of DBMS option, PC_ 10-16

valid bit, lock element, SPS 9-20

valid destination state

for archived redo logs, SAD 7-13

validate command (RMAN), SBR 11-150

VALIDATE constraints, SCN 28-22

VALIDATE REF UPDATE clause

of ANALYZE, SQL 7-190

VALIDATE STRUCTURE clause

of ANALYZE, SQL 7-191

VALIDATE STRUCTURE option, SAD 20-8

validation of restore, SBR 6-18

VALUE clause

initializing host variables, PCO 4-22

VALUE function, SQL 4-53

value of LOBs, ADL 1-47

VALUE operator, PLS 9-31

value subqueries

argument to a type constructor or function, GTK 2-36

in VALUES clause of INSERT statement, GTK 2-36

VALUE$ view

NCHAR and NLS, MIG 8-27

VALUE_ERROR exception, PLS 6-6

values, OCI 10-5

in object applications, OCI 10-7

VALUES clause

in INSERT statements, PC_ 6-9

INSERT statement, PCO 5-9

kinds of values allowed in, PC_ 6-9

of CREATE INDEX, SQL 7-284

of embedded SQL INSERT statement, PC_ F-71, PCO F-56

of INSERT, SQL 7-515

of INSERT statement, PC_ F-71, PCO F-56

purpose of, PC_ 6-9

requirements for, PC_ 6-9

use of subqueries in, PC_ 6-9

using a subquery, PCO 5-10

VALUES LESS THAN clause, SCN 11-20

DATE datatype, SCN 11-21

examples, SCN 11-16, SCN 11-18

MAXVALUE, SCN 11-21, SCN 11-23

multicolumn keys, SCN 11-23

of CREATE TABLE, SQL 7-379

VAR directive, PCO F-89

examples, PC_ F-119, PCO F-90

VAR SQL directive, PC_ F-116

VAR statement

CONVBUFSZ clause, PCO 4-49

syntax for, PC_ 5-13, PC_ 5-14, PCO 4-47

using the CHARF datatype specifier, PCO 4-51

VARCHAR

arrays of, PC_ 8-2

external datatype, OCI 3-13

VARCHAR datatype, ADG 4 - 5, PC_ 4-7, PCO 4-14, SCN 12-6, SQL 2-13, SUT 5-59

DB2, SQL 2-25

SQL*Loader, SUT 5-62

SQL/DS, SQL 2-25

trimming whitespace, SUT 5-83

VARCHAR group items

implicit form, PCO A-5

VARCHAR precompiler option, PC_ 10-42, PCO 14-42

VARCHAR pseudotype

requirements for using with PL/SQL, PC_ 7-11

using with PL/SQL, PCO 6-12

VARCHAR subtype, PLS 2-18

VARCHAR variables

advantages, PCO 4-35

advantages of, PC_ 4-19

as input variables, PCO 4-34

as output variables, PCO 4-35

declaring, PC_ 4-18, PCO 4-29

implicit group items, PCO 4-30

length element, PCO 4-30

length member in, PC_ 4-19

maximum length, PCO 4-30

must be passed to a function by reference, PC_ 4-21

referencing, PCO 4-31

server handling, PCO 4-34, PCO 4-35

specifying the length of, PC_ 4-19

string element, PCO 4-30

structure, PCO 4-29

structure of, PC_ 4-18

using macros to define length of, PC_ 5-29

versus character arrays, PC_ 5-9

versus fixed-length strings, PCO 4-35

with PL/SQL, PCO 6-2

VARCHAR2

external datatype, OCI 3-8

VARCHAR2 column

maximum width, PCO 4-5

VARCHAR2 datatype, ADG 4 - 2, ADG 4 - 5, PC_ 4-4, PC_ 5-15, PLS 2-18, SAD 12-17, SCN 12-5, SQL 2-12, SUT 2-65

column length, ADG 4 - 6

converting to NUMBER, SQL 2-35

external, PCO 4-14

internal, PCO 4-5

multi-byte character sets and, NLS 3-14

non-padded comparison semantics, SCN 12-6

similarity to RAW datatype, SCN 12-15

space use of, SAD 12-17

SQL*Loader, SUT 5-70

when to use, ADG 4 - 5

VARCHAR2 semantics, PLS B-1

VARCHARC, SUT 5-68

VARGRAPHIC datatype

SQL*Loader, SUT 5-61

VARGRAPHIC datatype (SQL/DS or DB2), SQL 2-25

variable expressions, SQL 5-4

variable parameters, SRF 1-11

variable record format, SUT 5-92

variable records, SUT 3-6

variable text in messages, SMS 1-3

Variables

BIND, DDS 7-4

variables, PC_ 2-6

assigning values, PLS 2-40

bind variables

optimization, SCN 23-52

user-defined types, SCN 13-14

cursor, PC_ 4-26

declaring, PLS 2-29

embedded SQL, SCN 16-6

host, PC_ 18-4

IN bind, DDS 7-5

IN OUT bind, DDS 7-6

in stored procedures, SCN 16-17

indicator, PC_ 18-4

initializing, PLS 2-40

object variables, SCN 15-4

OUT bind, DDS 7-6

session-specific, PLS 8-11

syntax, PLS 11-30

VARIANCE aggregate function, PLS 5-3

VARIANCE function, SQL 4-54

VARNUM

external datatype, OCI 3-12

VARNUM datatype, PC_ 4-7, PCO 4-15

example of output value, PCO 4-52

VARRAW, SUT 5-63

external datatype, OCI 3-15

VARRAW datatype, PC_ 4-9, PCO 4-15

VARRAWC, SUT 5-68

VARRAY, ADG 18 - 13, ADG 18 - 15

accessing, ADG 18 - 15

querying, ADG 18 - 16

See Also arrays

storage, ADG 18 - 15

updating, ADG 18 - 16

vs nested tables, ADG 16 - 17, ADG 16 - 20

varray

changing returned value, SQL 7-136

size limit, PLS 4-5

VARRAY datatype, PLS 4-4

VARRAY storage clause

of ALTER TABLE, SQL 7-136

of CREATE TABLE, SQL 7-362, SQL 7-375

varray types

creating, SQL 7-413

VARRAYs, SCN 13-11

compatibility, MIG 8-12

creation, PC_ 18-3

example, SUT 4-44

index-organized tables, SCN 10-38

key compression, SCN 10-30

removing incompatibilities, MIG 12-24

varrays, SQL 2-26

compared with nested tables, SQL 2-31

comparison rules, SQL 2-31

creating, SQL 7-413, SQL 7-417

dropping the body of, SQL 7-482

dropping the specification of, SQL 7-480

storage characteristics of, SQL 7-136, SQL 7-375

storage parameters for storing as LOBs, GTK 2-35

storing out of line, SQL 2-27

varying arrays. See varrays.

VARYING keyword

versus VARYING phrase, PCO 4-29

varying length arrays, PC_ 18-3

varying-width character set

LOBs

downgrading, MIG 12-19

VD-4520 error, PSC 5-19

verifying blocks

redo log files, SAD 6-16

verifying DCE groups are mapped to OS roles, OAS 13-8

version 6

Export/Import for migration, MIG 5-2

VERSION command

of LSNRCTL, reference, NET A-30

of NAMESCTL, reference, NET A-88

version compatibility

on the same cluster, SPS 18-22

VERSION precompiler option, PC_ 10-43, PC_ 17-19

versions, SAD 1-21

of other Oracle software, SAD 1-22

versions of COBOL supported, PCO 2-11

versions, Oracle

compatibility, SPS 17-11, SPS A-17

upgrading, SPS A-1

vertical partitioning, SPS 2-10

very large database (VLDB), SCN 11-5

parallel SQL, SCN 26-2

partitions, SCN 11-5

VIA

interconnect protocol, SPS 20-6

VID, SMS 49-1

view

global, SPS 18-25, SPS 20-12

partitioned

converting to partitioned table, SAD 13-18

rollback segments, SPS 14-6

viewing mapping in CDS namespace, for listener endpoint, OAS 20

views, SCN 1-24, SCN 10-11

adding rows to the base table of, SQL 7-513

altering base tables and, SCN 21-5

attributes, OCI 6-7

auditing, SCN 31-8

base tables, SCN 1-24

changing the definition of, SQL 7-485

changing values in base tables of, SQL 7-585

complex view merging, SCN 23-17

constraints and triggers prohibited in, SCN 10-12

constraints indirectly affect, SCN 28-5

containing expressions, ADG 13 - 8, SCN 20-13

creating, ADG 3 - 22, SAD 15-2

multiple, SQL 7-347

creating before base tables, SQL 7-432

creating comments about, SQL 7-212

creating views necessary for Export, SUT 1-9

creating with errors, ADG 3 - 23, SAD 15-4

data dictionary, SBR 13-6, SBR 13-10

updatable columns, SCN 10-15

user-accessible views, SCN 2-3

data dictionary views, SRF 2-2

data files, SRF 1-45

DBA_DATA_FILES, SBR 13-6, SBR 13-10

DBA_REGISTERED_SNAPSHOTS, REP 7-37

DBA_SNAPSHOT_LOGS, REP 7-37

DEFCALL, RAR 9-27

DEFCALLDEST, RAR 9-28

DEFDEFAULTDEST, RAR 9-28

DEFERRCOUNT, RAR 9-28

DEFERROR, RAR 9-29

defining, SQL 7-430

definition expanded, SCN 21-5

DEFLOB, RAR 9-29

DEFPROPAGATOR, RAR 9-30

DEFSCHEDULE, RAR 9-30

DEFTRAN, RAR 9-31

DEFTRANDEST, RAR 9-31

denormalized

star schemas, SCN 24-15

dependency status of, SCN 21-5

describing, OCI 6-2

displaying dependencies of, SAD 20-32

dropped tables and, ADG 3 - 10, SAD 14-12

dropping, ADG 3 - 27, SAD 15-9

Export, SUT 1-49

fixed views, SCN 2-7

FOR UPDATE clause and, ADG 3 - 22, SAD 15-3

granting

system privileges on, SQL 7-502

histograms, SCN 22-11

how stored, SCN 10-12

indexes and, SCN 10-14

inherently modifiable, ADG 13 - 8, SCN 20-13

inline views, SCN 10-16

inserting rows into, PC_ F-68, PCO F-54

instance level, STU 16-2

INSTEAD OF triggers, SCN 20-12

invalid, ADG 3 - 27

INVALID status, SCN 21-2

join views, ADG 3 - 28

location transparency using, DDS 2-20

managing, SAD 15-1, SAD 15-9

managing privileges with, DDS 2-22

materialized views, SCN 1-25, SCN 10-17

dependencies, STU 29-21

same as snapshots, SCN 1-25, SCN 34-3

maximum number of columns in, SCN 10-12

modifiable, ADG 13 - 8, SCN 20-13

modifying, SCN 20-12

multi-threaded server, STU 23-7

mutually referencing

downgrading, MIG 12-10

example of, MIG 12-11

name resolution, DDS 2-18

NLS parameters in, SCN 10-14

non-null values for nulls, SCN 24-11

object views, SCN 10-16, SCN 15-1

updatability, SCN 15-5

optimization, SCN 23-15

ORDER BY clause and, ADG 3 - 22, SAD 15-3

overview of, SCN 1-24, SCN 10-11

partition statistics, SCN 11-14

partition views, SCN 11-11

prerequisites for compilation of, SCN 21-5

privileges, ADG 3 - 24, SAD 15-2

privileges for, SCN 30-6

privileges for dropping, SAD 15-9

privileges for recompiling, SAD 20-25

privileges to replace, SAD 15-8

pseudocolumns, ADG 13 - 8, SCN 20-13

recompiling, SAD 20-25, SQL 7-183

recovery catalog, SBR 12-1

re-creating, SQL 7-432

REFRESH, RAR 9-36

REFRESH_CHILDREN, RAR 9-37

REGISTERED_SNAPSHOTS, RAR 9-34

remote object security, DDS 2-22

remote, accessing, SQL 7-255

removing from the database, SQL 7-485

removing rows from the base table of, SQL 7-439

renaming, SQL 7-527

REPCAT_REFRESH_TEMPLATES, RAR 9-6

REPCAT_TEMPLATE_OBJECTS, RAR 9-6

REPCAT_TEMPLATE_PARMS, RAR 9-8

REPCAT_TEMPLATE_SITES, RAR 9-11

REPCAT_USER_PARM_VALUES, RAR 9-13

REPCATLOG, RAR 9-5, RAR 9-6, RAR 9-12, RAR 9-13, REP 2-40, REP 7-6 to REP 7-8

REPCOLUMN, RAR 9-15

REPCOLUMN_GROUP, RAR 9-15, RAR 9-16

REPCONFLICT, RAR 9-16

REPDDL, RAR 9-17

REPGENOBJECTS, RAR 9-26

REPGROUP, RAR 9-3, REP 2-40

REPGROUP_PRIVILEGES, RAR 9-17

REPGROUPED_COLUMN, RAR 9-18

REPKEY_COLUMNS, RAR 9-18

replacing, ADG 3 - 24, SAD 15-8

replication catalog, RAR 9-2

REPOBJECT, RAR 9-19, REP 2-40

REPPARAMETER_COLUMN, RAR 9-20

REPPRIORITY, RAR 9-21

REPPRIORITY_GROUP, RAR 9-22

REPPROP, RAR 9-22

REPRESOL_STATS_CONTROL, RAR 9-24

REPRESOLUTION, RAR 9-23

REPRESOLUTION_METHOD, RAR 9-24

REPRESOLUTION_STATISTICS, RAR 9-25

REPSITES, RAR 9-26, REP 2-40

restrictions, ADG 3 - 26

retrieving data from, SQL 7-544

schema object dependencies, SCN 10-15, SCN 21-4, SCN 21-8

security applications of, SCN 30-6

select-project-join views, SCN 23-15

SNAPSHOT_LOGS, RAR 9-34

SNAPSHOT_REFRESH_TIMES, RAR 9-35

SNAPSHOTS, RAR 9-32

SQL functions in, SCN 10-14

statistics, SCN 22-14

subquery of, SQL 7-433

restricting, SQL 7-434

synonyms for, SQL 7-355

TS_PITR_CHECK, SBR A-6

tuning, STU 16-1

updatability, SCN 10-15, SCN 15-5, SCN 20-13

updating rows in, PC_ F-112, PCO F-85

USER_OUTLINE_HINTS, STU 7-29

USER_OUTLINES, STU 7-29

USER_REFRESH, REP 7-35

USER_REFRESH_CHILDREN, REP 7-35

uses of, SCN 10-13

using, ADG 3 - 25

V$ARCHIVE, SAD 7-23, SBR 2-4, SBR 2-12, SBR 2-18

V$ARCHIVE_DEST, SAD 7-14

V$BACKUP, SBR 13-7

V$BACKUP_CORRUPTION, SBR 4-36

V$DATABASE, SAD 7-24, SBR 2-4, SBR 2-18

V$DATAFILE, SBR 13-2, SBR 14-31

V$FAST_START_SERVERS, STU 25-16

V$FAST_START_TRANSACTIONS, STU 25-16

V$LOG, SAD 6-18, SAD 7-23, SBR 2-4, SBR 2-12, SBR 2-18

V$LOG_HISTORY, SBR 14-7

V$LOGFILE, SAD 6-15, SAD 6-18, SBR 13-2, SBR 15-6, SBR 15-7

V$LOGMNR_CONTENTS, SAD 7-25, SAD 7-31

V$LONGOPS, SBR 4-36

V$PROXY_ARCHIVEDLOG, SBR 4-19

V$PROXY_DATAFILE, SBR 4-19

V$RECOVER_FILE, SBR 3-27

V$RECOVERFILE, SBR 14-3

V$RECOVERY_LOG, SBR 14-7

V$THREAD, SAD 6-18

when to use, ADG 3 - 22

wildcards in, SAD 15-4

WITH CHECK OPTION, ADG 3 - 22, SAD 15-3

violating integrity constraints, ADG 5 - 21, SAD 20-15

VIR, SMS 53-1

Vir_Pkg package, SPR 1 - 21

virtual circuit status wait event, SRF A-49

virtual memory, SCN 7-17, STU 26-20

virtual memory usage, SPS 19-3

virtual private database, GTK 2-45, GTK 2-68

virtual tables, SCN 1-24

visibility

of package contents, PLS 8-3

transaction, PLS 5-55

versus scope, PLS 2-37

Visual Image Retrieval

compatibility, MIG 8-15

Visual Information Retrieval, GTK 2-12

VLDB

parallel SQL, SCN 26-2

partitions, SCN 11-5

VMS

linking a precompiler application, PC_ 1-10

vmstat UNIX command, STU 18-4, STU 26-83

VOLSIZE, SUT 1-27

VOLSIZE parameter, SUT 2-32

volume operations

Pending Messages Window, LEG 3-21

pool considerations

expiration date of the volume, LEG 3-22

pool volume considerations

number of sessions, LEG 3-23

volume label time, LEG 3-23

volume mode, LEG 3-22

tracking volumes, LEG 3-21

volumes

auto media management for tape devices, LEG 3-19

changing the modes, LEG 3-20

labeling, LEG C-5

labeling and mounting, LEG 3-13

labeling on UNIX, LEG 3-14

labeling on Windows, LEG 3-15, LEG 3-16

labeling storage, LEG C-1

manually removed, recoverable using scanner, LEG 2-7

modes

appendable, LEG 2-9

manual recycle, LEG 2-9

read-only, LEG 2-9

recyclable, LEG 2-9

tracking, LEG 2-9

mounting on UNIX, LEG 3-16

mounting on Windows, LEG 3-17

pools

default attributes, LEG 3-12

default resource attributes, LEG 3-12

label templates, LEG 3-10, LEG 3-11

mounted on storage devices, LEG 3-11

pool resource, LEG 3-10

tape volumes and file-type volumes must be separate, LEG 3-10

unable to find mounted volume, LEG 3-23

volume considerations, LEG 3-22

recyclable, LEG 2-7

recycling volumes, LEG 3-20

relabeled volumes

unavailable for recovery, LEG 3-21

relabeled, not recoverable using scanner, LEG 2-7

removing from media index, LEG 3-20

unlabeled volumes, LEG 3-19

unmounting on UNIX, LEG 3-18

unmounting on Windows, LEG 3-18

viewing details of save sets on a volume, LEG 3-21

viewing inventory of Oracle backup volumes, LEG 3-20

viewing volume-specific information, LEG 3-21

vppcntl -start command, PSC 5-30

VSIZE function, SQL 4-55

vtm command, PSC 5-31

---