Oracle8i Generic Documentation Master Index
Release 2 (8.1.6)

A76991-01

Library

Product

Contents

Prev Up Next

Oracle8i 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
with PL/SQL, PCO 6-2
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
SQL*Loader, SUT 5-70
when to use, ADG 3-5
VARCHARC datatype
SQL*Loader, SUT 5-68
VARGRAPHIC datatype
SQL*Loader, SUT 5-61
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
cursor, PC_ 4-26
declaring, PLS 2-30
embedded SQL, SCN 14
host, PC_ 18-4
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
accessing, ADO 6-14
changing returned value, SQL 7-145
compared with nested tables, SQL 2-35
comparison rules, SQL 2-35
compatibility, MIG 9-11
creating, SQL 7-439, SQL 7-444
creation, PC_ 18-3
dropping the body of, SQL 7-508
dropping the specification of, SQL 7-506
example, SUT 4-44
index-organized tables, SCN 10-41
key compression, SCN 10-33
querying, ADO 6-14
removing incompatibilities, MIG 13-32
See also arrays, collections
size limit, PLS 4-5
storage, ADO 6-13
storage characteristics of, SQL 7-142, SQL 7-146, SQL 7-399
storage parameters for, SAD 12-12
storage parameters for storing as LOBs, GTK 3-35
stored as LOBs
compatibility, MIG 9-29
storing out of line, SQL 2-31
updating, ADO 6-14
vs nested tables, ADO 9-15
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

Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents