Oracle8
i
Generic Documentation Master Index
Release 2 (8.1.6)
A76991-01
Library
Product
Contents
Oracle8
i
Generic Documentation Master Index
V
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
advantages, PCO 4-32
advantages of, PC_ 4-19
as input variables, PCO 4-31
as output variables, PCO 4-31
declaring, PC_ 4-18,
PCO 4-26
implicit group items, PCO 4-27
length element, PCO 4-27
length member in, PC_ 4-19
maximum length, PCO 4-27
must be passed to a function by reference, PC_ 4-21
referencing, PCO 4-28
server handling, PCO 4-31
specifying the length of, PC_ 4-19
string element, PCO 4-27
structure, PCO 4-27
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-32