Oracle8i Generic Documentation Master Index

V number format element, SQL 2-41

V variable in SQLDA

how value is set, PC_ 15-8

purpose of, PC_ 15-8

V$ dynamic performance views, STU 11-5

V$ACCESS view, SRF 3-3

V$ACTIVE_INSTANCES, PSG 3-42

V$ACTIVE_INSTANCES table, PSG 7-17

V$ACTIVE_INSTANCES view, PSC A-11, SRF 3-3

V$AQ view, SRF 3-3

V$ARCHIVE view, SAD 7-22, SBR 2-16, SRF 3-3

V$ARCHIVE_DEST, SRF 3-4

V$ARCHIVE_DEST view, SBY 2-33, SBY 5-41, SRF 3-4

obtaining destination status, SAD 7-13

V$ARCHIVE_PROCESSES view, SRF 3-6

V$ARCHIVED_LOG view, SBY 2-24, SBY 4-5, SBY 5-21, SBY 5-43, SRF 3-5

V$BACKUP view, SBR 4-8, SRF 3-6

V$BACKUP_ASYNC_IO view, SRF 3-7

V$BACKUP_CORRUPTION view, RMN 1-48, RMN 10-27, SRF 3-8

V$BACKUP_DATAFILE view, SRF 3-9

V$BACKUP_DEVICE view, SRF 3-10

V$BACKUP_PIECE view, SRF 3-10

V$BACKUP_REDOLOG view, SRF 3-11

V$BACKUP_SET view, SRF 3-12

V$BACKUP_SYNC_IO view, SRF 3-13

V$BGPROCESS view, SRF 3-14

V$BH view, PSC 5-24, PSC A-9, PSC A-11, PSC A-19, SRF 3-14, STU 19-31

V$BSP view, SRF 3-16

V$BUFFER_POOL view, SRF 3-17

V$BUFFER_POOL_STATISTICS view, STU 19-39, STU 19-41

V$CACHE view, PSC A-19, SRF 3-18

V$CACHE_LOCK view, PSA 12-9, SRF 3-19

V$CIRCUIT view, SRF 3-21

V$CLASS_PING view, PSC A-9, SRF 3-22

V$COMPATIBILITY view, SRF 3-23

V$COMPATSEG view, SRF 3-23

V$CONTEXT view, SRF 3-23

V$CONTROLFILE view, SBR 2-4, SRF 3-24

V$CONTROLFILE_RECORD_SECTION view, SRF 3-24

V$COPY_CORRUPTION view, SRF 3-24

V$DATABASE view, SAD 7-23, SBR 2-4, SBR 2-16, SBY 2-9, SRF 3-25

V$DATAFILE view, PSA 9-7, PSC 7-3, SAD 9-39, SBR 4-2, SBR 5-30, SBY 4-14, SBY 5-14, SBY 5-23, SRF 3-26, STU 20-17

listing files for backups, SBR 4-2

V$DATAFILE_COPY view, SRF 3-27

V$DATAFILE_HEADER view, SRF 3-28

V$DB_OBJECT_CACHE view, SRF 3-30

V$DB_PIPES view, SRF 3-31

V$DBFILE view, SAD 2-16, SRF 3-29

V$DBLINK view, DDS 2-24, SRF 3-30

V$DELETED_OBJECT view, SRF 3-31

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

monitoring MTS dispatchers, SAD 4-8

V$DISPATCHER_RATE view, SRF 3-33

monitoring MTS dispatchers, SAD 4-8

V$DLM_ALL_LOCKS

new view for 8.1, PSC A-3

V$DLM_ALL_LOCKS view, SRF 3-37

V$DLM_CONVERT_LOCAL view, PSC A-9, SRF 3-38

V$DLM_CONVERT_REMOTE view, PSC A-9, SRF 3-39

V$DLM_LATCH view, PSC A-9, SRF 3-39

V$DLM_LOCKS view, SRF 3-40

changed for 8.0.4, PSC A-7

V$DLM_MISC view, PSC A-9, SRF 3-41

V$DLM_RESS

new view, PSC A-3

V$DLM_RESS view, SRF 3-41

V$ENABLEDPRIVS view, SRF 3-42

V$ENQUEUE_LOCK view, SRF 3-42

V$EVENT_NAME view, SRF 3-43

V$EXECUTION view, SRF 3-43

V$FALSE_PING view, SRF 3-44

V$FAST_START_SERVERS

view, PSA 14-16, PSC A-4

V$FAST_START_SERVERS view, SRF 3-45, STU 24-17

V$FAST_START_TRANSACTIONS

view, PSA 14-16, PSC A-4

V$FAST_START_TRANSACTIONS view, SRF 3-45, STU 24-17

V$FILE_PING view, PSC A-9, SRF 3-46

V$FILESTAT view, SRF 3-47

and parallel query, DWG 18-71

disk I/O, STU 20-17

PHYRDS column, STU 20-17

PHYWRTS column, STU 20-17

V$FIXED_TABLE view, SRF 3-48, STU 15-2

V$FIXED_VIEW_DEFINITION view, SRF 3-48

V$GLOBAL_BLOCKED_LOCKS view, SRF 3-49

V$GLOBAL_TRANSACTION view, SRF 3-49

V$HS_AGENT view, SRF 3-50

determining which agents are on host, DDS 7-15

V$HS_PARAMETER view, SRF 3-50

listing HS parameters, DDS 7-17

V$HS_SESSION view, SRF 3-50

determining open sessions, DDS 7-16

V$INDEXED_FIXED_COLUMN view, SRF 3-51

V$INSTANCE view, SBY 3-15, SRF 3-51, STU 15-2

V$INSTANCE_RECOVERY view, SRF 3-52

V$LATCH view, SRF 3-53, STU 15-2, STU 21-2, STU 21-17

V$LATCH_CHILDREN view, SRF 3-55, STU 19-41

V$LATCH_MISSES view, SRF 3-55, STU 18-13

V$LATCH_PARENT view, SRF 3-56

V$LATCHHOLDER view, SRF 3-54

V$LATCHNAME view, SRF 3-54

V$LIBRARYCACHE view, SRF 3-56, STU 15-2

NAMESPACE column, STU 19-15

PINS column, STU 19-15

RELOADS column, STU 19-15

V$LICENSE view, SAD 22-6, SRF 3-57

V$LOADCSTAT view, SRF 3-57

V$LOADTSTAT view, SRF 3-57

V$LOCK view, PSA 9-13, SRF 3-58, STU 15-3

V$LOCK_ACTIVITY view, PSA 12-9, PSC A-19, SRF 3-60

V$LOCK_ELEMENT view, PSA 9-14, SRF 3-60

V$LOCKED_OBJECT view, SRF 3-61

V$LOCKS_WITH_COLLISIONS view, PSA 12-9, PSC A-18, SRF 3-62

V$LOG view, SAD 7-22, SBR 2-16, SRF 3-62

displaying archiving status, SAD 7-22, SBR 2-11, SBR 2-16

online redo log, SAD 6-18

viewing redo data with, SAD 6-18

V$LOG_HISTORY view, PSA 13-8, SBY 1-26, SBY 3-16, SBY 4-9, SBY 5-11, SBY 5-20, SRF 3-67

listing all archived logs, SBR 5-6

V$LOGFILE view, PSC 7-5, SAD 2-16, SBR 6-6, SBR 6-7, SRF 3-63

displaying information about online logs, SBR 2-11

listing files for backups, SBR 4-2

listing online redo logs, SBR 4-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-32, SRF 3-64

using to analyze archived redo logs, SAD 7-26

V$LOGMNR_DICTIONARY view, SRF 3-65

V$LOGMNR_LOGS view, SRF 3-66

V$LOGMNR_PARAMETERS view, SRF 3-66

V$LONGOPS view, RMN 1-48

V$MTS view, SRF 3-67

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

V$NLS_PARAMETERS view, SRF 3-68

V$NLS_VALID_VALUES view, SRF 3-68

V$OBJECT_DEPENDENCY view, SRF 3-69

V$OFFLINE_RANGE view, SRF 3-69

V$OPEN_CURSOR view, SRF 3-70

V$OPTION table, GTK 5-13

V$OPTION view, SRF 3-70

V$PARALLEL_DEGREE_LIMIT_MTH view, SRF 3-70

V$PARAMETER view, DWG 18-71, SRF 3-71

V$PING view, PSC A-19, SRF 3-71

V$PQ_SESSTAT view, DWG 18-68, DWG 18-70, SRF 3-72

V$PQ_SLAVE view, SRF 3-73

V$PQ_SYSSTAT view, DWG 18-68, SRF 3-74

V$PQ_TQSTAT view, DWG 18-69, DWG 18-71, SRF 3-75

V$PROCESS view, RMN 9-13, SRF 3-76, STU 15-3

V$PROXY_ARCHIVEDLOG view, RMN 1-22

V$PROXY_ARCHIVELOG view, SRF 3-76

V$PROXY_DATAFILE view, RMN 1-22, SRF 3-77

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

V$PX_PROCESS view, DWG 18-70, SRF 3-79

V$PX_PROCESS_SYSSTAT view, SRF 3-80

V$PX_SESSION view, DWG 18-70, SRF 3-81

V$PX_SESSTAT view, DWG 18-70, SRF 3-81

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

monitoring MTS dispatchers, SAD 4-8

V$RECOVER_FILE view, SBR 1-27, SBR 5-2, SRF 3-82

determining which files to recover, SBR 3-15

V$RECOVERY_FILE_STATUS view, SRF 3-82

V$RECOVERY_LOG view, PSA 13-8, SRF 3-83

listing logs needed for recovery, SBR 5-6

V$RECOVERY_PROGRESS view, SRF 3-83

V$RECOVERY_STATUS view, SRF 3-84

V$REQDIST view, SRF 3-84

V$RESERVED_WORDS view, SRF 3-85

V$RESOURCE view, SRF 3-85

V$RESOURCE_LIMIT

for information about lock usage, PSA 1-14

V$RESOURCE_LIMIT view, PSC A-9, SRF 3-85, STU 21-2

V$ROLLNAME view, PSA 3-5, PSA 12-9, SRF 3-87

finding PENDING OFFLINE segments, SAD 11-16

V$ROLLSTAT view, PSA 3-5, SRF 3-87, STU 15-2

finding PENDING OFFLINE segments, SAD 11-16

V$ROWCACHE view, SRF 3-88, SRF 3-89, STU 15-2

GETMISSES column, STU 19-22

GETS column, STU 19-22

performance statistics, STU 19-21

using, STU 19-21

V$RSCRC_CONSUMER_GROUP view, SRF 3-90

V$RSCRC_CONSUMER_GROUP_CPU_MTH view, SRF 3-91

V$RSCRC_PLAN view, SRF 3-91

V$RSCRC_PLAN_CPU_MTH view, SRF 3-92

V$RSRC_CONSUMER_GROUP view, STU 18-7

V$SESS_IO view, SRF 3-102

V$SESSION table, NET 8-16, PSG 5-6

V$SESSION view, RMN 9-13, SAD 4-22, SRF 3-92, STU 15-3

application registration, STU 11-8

V$SESSION_CONNECT_INFO view, SRF 3-96

V$SESSION_CURSOR_CACHE view, SRF 3-97

V$SESSION_EVENT view, SRF 3-97, SRF A-2, STU 15-3

network information, STU 22-9

V$SESSION_LONGOPS view, RMN 9-13, SRF 3-98

V$SESSION_OBJECT_CACHE view, SRF 3-99

V$SESSION_WAIT view, PSA 9-12, RMN 9-13, SRF 3-100, SRF A-2, STU 15-3, STU 19-40, STU 21-2

network information, STU 22-9

V$SESSIONS_LONGOPS view, GTK 3-27

V$SESSTAT view, DWG 18-72, DWG 18-75, SRF 3-101, SRF C-1, STU 15-3, STU 18-7

network information, STU 22-10

using, STU 19-24

V$SGA view, SRF 3-102, STU 15-2

V$SGASTAT view, SRF 3-102, STU 15-2

V$SHARED_POOL_RESERVED view, SRF 3-103, STU 19-27

V$SHARED_SERVER view, SRF 3-104

V$SORT SEGMENT view, SAD 9-40

V$SORT_SEGMENT view, DWG 18-44, PSC A-11, PSC A-12, SRF 3-104

V$SORT_USAGE view, SRF 3-105, STU 2-10, STU 15-2

V$SORT_USER view, SAD 9-40

V$SQL view, SRF 3-106

V$SQL_BIND_DATA view, SRF 3-107, STU 19-18

V$SQL_BIND_METADATA view, SRF 3-108, STU 19-18

V$SQL_CURSOR view, SRF 3-109

V$SQL_SHARED_MEMORY view, SRF 3-109

V$SQLAREA view, SRF 3-110, STU 15-2

application registration, STU 11-8

resource-intensive statements, STU 2-10

V$SQLTEXT view, SRF 3-111, STU 15-2

V$SQLTEXT_WITH_NEWLINES view, SRF 3-112

V$STATNAME view, SRF 3-112, SRF C-1

V$SUBCACHE view, SRF 3-113

V$SYSSTAT view, DWG 18-23, DWG 18-56, DWG 18-72, PSA 9-8, PSC A-9, SRF 3-114, SRF C-1, STU 15-2, STU 18-6

detecting dynamic extension, STU 20-27

examining recursive calls, STU 20-27

redo buffer allocation, STU 19-7

tuning sorts, STU 20-35

using, STU 19-28

V$SYSTEM_CURSOR_CACHE view, SRF 3-114

V$SYSTEM_EVENT view, PSA 9-12, SRF 3-115, SRF A-2, STU 15-2, STU 18-12, STU 21-2

V$SYSTEM_PARAMETER view, SRF 3-115

V$TABLESPACE view, SBR 4-2, SRF 3-116

V$TEMP_EXTENT_MAP view, SAD 9-40, SRF 3-117

V$TEMP_EXTENT_POOL view, SAD 9-40, SRF 3-117

V$TEMP_PING view, SRF 3-118

V$TEMP_SPACE_HEADER view, SAD 9-40, SRF 3-119

V$TEMPFILE view, SAD 9-40, SRF 3-116

V$TEMPORARY_LOBS view, SRF 3-116

V$TEMPSTAT view, SRF 3-119

V$THREAD view, SAD 6-18, SRF 3-120

viewing redo data with, SAD 6-18

V$TIMER view, SRF 3-121

V$TRANSACTION view, SRF 3-121

V$TRANSACTION_ENQUEUE view, SRF 3-122

V$TYPE_SIZE view, SRF 3-123

V$VERSION view, SAD 1-23, SRF 3-124

V$WAITSTAT view, SRF 3-124, STU 15-2, STU 21-2

reducing free list contention, STU 21-20

rollback segment contention, STU 21-3

V_$ and V$ views, SCN 2-7

V$LICENSE, SCN 300

V1ADD.NPO.OMD record, NET 11-14, NET A-42

Version 6, GTK 7-6

V7

value of DBMS option, PC_ 10-16

valid bit, lock element, PSC 5-19

valid destination state

for archived redo logs, SAD 7-13

validate command (RMAN), RMN 10-160

VALIDATE constraints, SCN 276

VALIDATE REF UPDATE clause

of ANALYZE, SQL 7-206

VALIDATE STRUCTURE clause

of ANALYZE, SQL 7-206

VALIDATE STRUCTURE option, SAD 19-9

validateContent(Element) - oracle.xml.parser.v2.ElementDecl.validateContent(org.w3c.dom.Element), JPR 4-35

validateElementContent(Element) - oracle.xml.parser.v2.XMLDocument.validateElementContent(org.w3c.dom.Element), JPR 4-81

validating dimensions, DWG 9-14

validation function, ADG 11-41

validation of restore, RMN 3-24

VALUE clause

initializing host variables, PCO 4-19

VALUE function, PLS 9-31, SQL 4-112

value of LOBs, ADL 2-5

value subqueries

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

in VALUES clause of INSERT statement, GTK 3-36

VALUE$ view

NCHAR and NLS, MIG 9-28

VALUE_ERROR exception, PLS 6-6

valueOf(String, NSResolver) - oracle.xml.parser.v2.XMLNode.valueOf(java.lang.String, oracle.xml.parser.v2.NSResolver), JPR 4-115

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-302

of embedded SQL INSERT statement, PC_ F-70, PCO F-57

of INSERT, SQL 7-542

of INSERT statement, PC_ F-70, PCO F-57

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-19

DATE datatype, SCN 11-21

examples, SCN 11-14, SCN 11-17

MAXVALUE, SCN 11-20, SCN 11-23

multicolumn keys, SCN 11-23

of CREATE TABLE, SQL 7-403

VAR directive, PCO F-90

examples, PC_ F-118, PCO F-91

VAR SQL directive, PC_ F-115

VAR statement

CONVBUFSZ clause, PCO 4-45

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

using the CHARF datatype specifier, PCO 4-47

VAR_POP function, DWG 17-47

VAR_SAMP function, DWG 17-47

VARCHAR

arrays of, PC_ 8-2

external datatype, OCI 3-13

VARCHAR datatype, ADG 3-5, PC_ 4-7, PCO 4-10, SCN 12-6, SQL 2-17, SUT 5-59

DB2, SQL 2-29

SQL*Loader, SUT 5-62

SQL/DS, SQL 2-29

VARCHAR group items

implict form, PCO A-5

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

VARCHAR pseudotype

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

using with PL/SQL, PCO 6-11

VARCHAR subtype, PLS 2-19

VARCHAR variables

VARCHAR2

datatype, PLS 2-19

external datatype, OCI 3-9

maximum size

change, MIG 9-16

semantics, PLS B-1

VARCHAR2 datatype, ADG 3-2, ADG 3-5, PC_ 4-4, PC_ 5-15, SCN 12-6, SQL 2-16, SUT 2-62

column length, ADG 3-6

converting to NUMBER, SQL 2-40

external, PCO 4-10

multi-byte character sets and, NLS 3-15

non-padded comparison semantics, SCN 12-6

similarity to RAW datatype, SCN 12-15

VARCHARC datatype

VARGRAPHIC datatype

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

variable expressions, SQL 5-4

variable record format, SUT 5-91

variable records, SUT 3-5

variable text in messages, SMS 1-3

variables, PC_ 2-5

assigning values, PLS 2-41

BIND, DDS 9-4

bind variables

optimization, STU 4-27

user-defined types, ADO 3-2, SCN 13-14

in stored procedures, SCN 26

indicator, PC_ 18-4

initializing, PLS 2-41

object variables, ADO 5-4, SCN 14-4

session-specific, PLS 8-11

syntax, PLS 11-33

VARIANCE aggregate function, PLS 5-3

VARIANCE function, SQL 4-115

VARNUM

external datatype, OCI 3-12

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

example of output value, PCO 4-48

VARP function, SQL 4-113

VARRAW

external datatype, OCI 3-15

VARRAW datatype, PC_ 4-9, PCO 4-11, SUT 5-63

VARRAWC datatype, SUT 5-68

VARRAY

vs nested tables, ADO 9-18

VARRAY Columns

memory issues when loading, SUT 5-111

VARRAY datatype, PLS 4-4

VARRAY storage clause

of ALTER TABLE, SQL 7-142

of CREATE TABLE, SQL 7-385, SQL 7-399

VARRAYs

LOBS are not supported by, ADL 4-15

See creating VARRAYs

varrays, ADO 1-8, SCN 13-11, SQL 2-31

VARS function, SQL 4-114

varying arrays. See varrays

VARYING keyword

versus VARYING phrase, PCO 4-26

varying length arrays, PC_ 18-3

varying-width character data, ADL 2-4

varying-width character set

LOBs

downgrading, MIG 13-27

VBScript

translating to PSP, ADG 12-3

Verify a Queue Type, ADQ 9-72

verifying blocks

redo log files, SAD 6-17

version

defined, MIG 1-2

version 6

Export/Import for migration, MIG 6-2

VERSION command

of CMCTL, NET A-97

of LSNRCTL, NET A-25

of NAMESCTL, NET A-79

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

versioning, in application context, ADG 11-51

versions

multiple, MIG 1-4

versions of COBOL supported, PCO 2-11

versions, Oracle

compatibility, PSA 8-9, PSC A-19

upgrading, PSC A-1

vertical bar, PC_ xvi

very large database (VLDB), SCN 11-5

parallel SQL, SCN 158

partitions, SCN 11-5

VIA

interconnect protocol, PSA 12-5

VID, SMS 49-1

View menu, in Oracle Directory Manager, OID 4-10

viewing

an ACP, by using Oracle Directory Manager, OID 9-17

audit log entries, OID 5-24

configuration parameters, by using Oracle Directory Manager, OID 10-11

entry attributes, OID 7-11

indexed attributes, OID 6-30

object classes, OID 6-10, OID 6-12

system operational attributes, OID 5-15

viewing mapping in CDS namespace, for listener endpoint, OAS 15-2

Views, ADQ 10-1

views, REP 2-19, SCN 1-22, SCN 10-12

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

altering base tables and, SCN 111

attributes, OCI 6-7

auditing, SCN 336

base tables, SCN 1-23

changing

definition, SQL 7-511

values in base tables, SQL 7-616

complex view merging, STU 4-78

constraints and triggers prohibited in, SCN 10-13

constraints indirectly affect, SCN 255

containing expressions, ADG 13-8, SCN 94

creating, ADG 2-15, SAD 18-2

before base tables, SQL 7-458

comments about, SQL 7-228

multiple, SQL 7-369

creating views necessary for Export, SUT 1-9

creating with errors, ADG 2-16, SAD 18-4

data dictionary, SBR 4-6, SBR 4-7, SBR 4-12

updatable columns, SCN 10-16

user-accessible views, SCN 2-3

data dictionary views, SRF 2-1

data files, SRF 1-40

Database Resource Manager, SAD 25-21

deferred transactions, RAR 9-47

defining, SQL 7-456

definition expanded, SCN 111

dependency status of, SCN 111

describing, OCI 6-2

displaying dependencies of, SAD 19-31

dropped tables and, ADG 2-10, SAD 13-16

dropping, ADG 2-20, SAD 18-11

Export, SUT 1-50

fixed views, SCN 2-7

FOR UPDATE clause and, ADG 2-15, SAD 18-3

granting

system privileges on, SQL 7-529

histograms, SCN 134, STU 8-21

how stored, SCN 10-13

indexes and, SCN 10-15

inherently modifiable, ADG 13-8, SCN 94

inline views, SCN 10-17

inserting rows into, PC_ F-67, PCO F-55

instance level, STU 15-2

INSTEAD OF triggers, SCN 93

invalid, ADG 2-20

INVALID status, SCN 109

join. See join views.

join views, ADG 2-21

location transparency using, DDS 2-26

managing, SAD 18-2, SAD 18-12

managing privileges with, DDS 2-28

materialized views, SCN 1-23, SCN 10-18

same as snapshots, SCN 1-24

maximum number of columns in, SCN 10-13

modifiable, ADG 13-8, SCN 94

modifying, SCN 93

mutually referencing

downgrading, MIG 13-18

example of, MIG 13-18

name resolution, SCN 412

name resolution in distributed databases, DDS 1-41

NLS parameters in, SCN 10-15

non-null values for nulls, STU 4-86

object views, SCN 10-17, SCN 14-1

updatability, SCN 14-5

optimization, STU 4-76

ORDER BY clause and, ADG 2-15, SAD 18-3

overview of, SCN 1-22, SCN 10-12

partition statistics, SCN 11-13

partition views, SCN 11-11

prerequisites for compilation of, SCN 111

privileges, ADG 2-17, SAD 18-2

privileges for, SCN 308

privileges for dropping, SAD 18-11

privileges for recompiling, SAD 19-24

privileges to replace, SAD 18-11

pseudocolumns, ADG 13-8, SCN 94

recompiling, SAD 19-24, SQL 7-198

recovery catalog, RMN 11-1

re-creating, SQL 7-458

refresh groups, RAR 9-53

remote object security, DDS 2-28

remote, accessing, SQL 7-273

removing

from the database, SQL 7-511

rows from the base table of, SQL 7-465

renaming, SQL 7-554

replacing, ADG 2-17

replication, REP 2-19

replication catalog, RAR 9-2

restrictions, ADG 2-19

retrieving data from, SQL 7-572

schema object dependencies, SCN 10-16, SCN 110, SCN 114

security applications of, SCN 308

See also object views

select-project-join views, STU 4-76

snapshots, RAR 9-53

SQL functions in, SCN 10-15

statistics, SCN 138, STU 8-13

subquery of, SQL 7-459

restricting, SQL 7-461

synonyms for, SQL 7-377

tuning, STU 15-1

updatability, ADO 5-11, SCN 10-16, SCN 14-5, SCN 94

updating rows in, PC_ F-111, PCO F-86

USER_OUTLINE_HINTS view, STU 10-6

USER_OUTLINES view, STU 10-6

uses of, SCN 10-14

using, ADG 2-18

V$ARCHIVE, SAD 7-22

V$ARCHIVE_DEST, SAD 7-13, SBY 2-33, SBY 5-41

V$ARCHIVED_LOG, SBY 2-24, SBY 4-5, SBY 5-21, SBY 5-43

V$DATABASE, SAD 7-23, SBY 2-9

V$DATAFILE, SBY 4-14, SBY 5-14, SBY 5-23

V$FAST_START_SERVERS view, STU 24-17

V$FAST_START_TRANSACTIONS view, STU 24-17

V$INSTANCE, SBY 3-15

V$LOG, SAD 6-18, SAD 7-22

V$LOG_HISTORY, SBY 1-26, SBY 3-16, SBY 4-9, SBY 5-11, SBY 5-20

V$LOGFILE, SAD 6-15, SAD 6-18

V$LOGMNR_CONTENTS, SAD 7-26, SAD 7-32

V$THREAD, SAD 6-18

when to use, ADG 2-15

wildcards in, SAD 18-4

WITH CHECK OPTION, ADG 2-15, SAD 18-3

views on DIRECTORY object, ADL 11-10

VIR, SMS 53-1

Vir_Pkg package, SPR 1-22

virtual circuit status, SRF A-47

virtual circuits, NET 2-7

virtual memory, OID 12-13, DWG 18-18, SCN 7-18

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

virtual private database (VPD), ADG 11-7, ADG 11-14, ADG 11-15, ADG 11-17, ADG 11-47

virtual tables, SCN 1-22

visibility, ADQ 2-6

of package contents, PLS 8-3

transaction, PLS 5-55

versus scope, PLS 2-38

Visual Basic, ADO 3-9

Visual Basic, See Oracle Objects for OLE(OO4O)

Visual Image Retrieval

compatibility, MIG 9-14

Visual Information Retrieval, GTK 3-12

VLDB

parallel SQL, SCN 158

partitions, SCN 11-5

VMS

linking a precompiler application, PC_ 1-9

vmstat UNIX command, DWG 18-75, STU 18-5

vmstat utility, OID 13-2

VOLSIZE

export parameter, SUT 2-31

Import parameter, SUT 1-28

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, LEG 4-3

manual recycle, LEG 2-9, LEG 4-3

read-only, LEG 2-9, LEG 4-3

recyclable, LEG 2-9, LEG 4-3

tracking, LEG 2-9, LEG 4-3

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, PSG 6-27

vrfy()

function of UTL_SMTP, SPR 65-11

VSIZE function, SQL 4-116