Oracle8
i
Generic Documentation Master Index
Release 2 (8.1.6)
A76991-01
Library
Product
Contents
Oracle8
i
Generic Documentation Master Index
W
W date format element, SQL 2-46
wait, ADQ 2-6
wait detection, STU 18-11
wait events
alter system set mts_dispatchers, SRF A-12
batched allocate scn lock request, SRF A-12
BFILE check if exists, SRF A-12
BFILE check if open, SRF A-12
BFILE closure, SRF A-13
BFILE get length, SRF A-13
BFILE get name object, SRF A-13
BFILE get path object, SRF A-13
BFILE internal seek, SRF A-14
BFILE open, SRF A-14
BFILE read, SRF A-14
buffer busy waits, SRF A-15
buffer deadlock, SRF A-15
buffer for checkpoint, SRF A-15
buffer latch, SRF A-16
buffer read retry, SRF A-16
checkpoint completed, SRF A-17
checkpoint range buffer not saved, SRF A-17
controlfile parallel write, SRF A-17
controlfile sequential read, SRF A-18
controlfile single write, SRF A-18
conversion file read, SRF A-19
db file parallel read, SRF A-19
db file parallel write, SRF A-19
db file scattered read, SRF A-20
db file sequential read, SRF A-20
db file single write, SRF A-20
DFS db file lock, SRF A-21
DFS lock handle, SRF A-21
direct path read, SRF A-21,
SRF A-22
direct path write, SRF A-22
dispatcher shutdown, SRF A-23
dispatcher timer, SRF A-23
duplicate cluster key, SRF A-23
enqueue, SRF A-23
file identify, SRF A-24
file open, SRF A-24
free buffer waits, SRF A-24
free global transaction table entry, SRF A-24
free process state object, SRF A-25
global cache freelist wait, SRF A-25
global cache lock busy, SRF A-25
global cache lock cleanup, SRF A-26
global cache lock null to s, SRF A-26
global cache lock null to x, SRF A-26
global cache lock open null, SRF A-27
global cache lock open s, SRF A-27
global cache lock open x, SRF A-27
global cache locks s to x, SRF A-28
inactive session, SRF A-28
inactive transaction branch, SRF A-28
index block split, SRF A-29
instance recovery, SRF A-29
instance state change, SRF A-29
io done, SRF A-30
kcl bg acks, SRF A-30
latch activity, SRF A-30
latch free, SRF A-31
library cache load lock, SRF A-31
library cache lock, SRF A-32
library cache pin, SRF A-32
lock manager wait for remote message, SRF A-33
log file parallel write, SRF A-33
log file sequential read, SRF A-34
log file single write, SRF A-34
log file switch (archiving needed), SRF A-34
log file switch (checkpoint incomplete), SRF A-35
log file switch (clearing log file), SRF A-35
log file switch completion, SRF A-35
log file sync, SRF A-35
log switch/archive, SRF A-35
on-going SCN fetch to complete, SRF A-36
parallel query create server, SRF A-36
parallel query dequeue wait, SRF A-36
parallel query qref latch, SRF A-37
parallel query server shutdown, SRF A-37
parallel query signal server, SRF A-37
pending global transaction(s), SRF A-38
pipe get, SRF A-38
pipe put, SRF A-38
PL/SQL lock timer, SRF A-12,
SRF A-39
pmon rdomain attach, SRF A-39
pmon timer, SRF A-39
process startup, SRF A-39
queue messages, SRF A-40
rdbms ipc message, SRF A-40
rdbms ipc message block, SRF A-40
rdbms ipc reply, SRF A-40
redo, SRF A-41
row cache lock, SRF A-41
scginq AST call, SRF A-41
single-task message, SRF A-41
smon timer, SRF A-42
SQL*Net break/reset to client, SRF A-42
SQL*Net break/reset to dblink, SRF A-42
SQL*Net message from client, SRF A-43
SQL*Net message from dblink, SRF A-43
SQL*Net message to client, SRF A-43
SQL*Net message to dblink, SRF A-43
SQL*Net more data from client, SRF A-44
SQL*Net more data from dblink, SRF A-44
SQL*Net more data to client, SRF A-44
SQL*Net more data to dblink, SRF A-45
switch logfile command, SRF A-45
timer in sksawat, SRF A-45
transaction, SRF A-45
unbound tx, SRF A-46
undo segment extension, SRF A-46
undo segment recovery, SRF A-46
undo segment tx slot, SRF A-46
wait events
log buffer space, SRF A-33
WMON goes to sleep, SRF A-12,
SRF A-47
write complete, SRF A-47
writes stopped by instance recovery or database suspension, SRF A-47
wait time, STU 1-3,
STU 1-4
wait times, DWG 18-37
WAIT_FOREVER - oracle.jms.AQjmsConstants.WAIT_FOREVER, JPR 2-55
WAIT_NONE - oracle.jms.AQjmsConstants.WAIT_NONE, JPR 2-55
Waiting for Arrival of Messages, ADQ 8-75
Waits by Average Wait Time data view, STU 14-13
Waits by Event Frequency data view, STU 14-13
Waits by Total Wait Time data view, STU 14-13
waits for blocking transaction, SCN 221
Wallet Manager, SCN 283
Wallet Manager, Oracle, GTK 2-8,
GTK 3-73
wallets, SCN 283
auto login, OAS 18-10
changing a password, OAS 18-9,
OAS 19-3,
OID D-9
changing location of, OID 5-10,
OID F-6
closing, OAS 18-8,
OID D-8
creating, OAS 18-6,
OID 5-10,
OID D-6,
OID F-6
definition, OAS 10-5,
OID 2-23
deleting, OAS 18-9,
OID D-9
location, OID 4-6,
OID F-6
managing, OAS 18-6,
OID D-5
managing certificates, OAS 18-11,
OID D-10
managing trusted certificates, OAS 18-14,
OID D-13
opening, OAS 18-7,
OID D-7
passwords, OID 4-6
changing, OID 5-10,
OID F-6
saving, OAS 18-8,
OID D-8
setting location, OAS 10-22
SSL, OID F-6
WAN environments
vulnerabilities of, OAS 1-3
warehouse
materialized views, SCN 10-18
refreshing table data, SCN 194
See also
data warehousing
warning
archiving mode for first backup, SBR 3-5
consistency and Export backups, SBR 4-19
WARNING - oracle.xml.parser.v2.XMLParseException.WARNING, JPR 4-118
warning flags
use in error reporting, PC_ 9-15
warning flags for error reporting, PCO 8-9
warning messages, SUT 1-40
warnings
changing data dictionary storage parameters, SAD 19-26
disabling audit options, SAD 24-12
enabling auditing, SAD 24-9
web page scripting, SCN 29
web pages
dynamic, ADG 12-2
WebDB, ADG 12-2,
GTK 2-6,
GTK 3-2,
GTK 3-5
well-known Oracle Names servers, NET 4-22
WHEN clause, ADG 13-13,
PLS 3-7,
PLS 6-15
cannot contain PL/SQL expressions, ADG 13-13
correlation names, ADG 13-16
example, SUT 4-19
examples, ADG 13-3,
ADG 13-12,
ADG 13-32,
ADG 13-41
EXCEPTION examples, ADG 13-18,
ADG 13-41,
ADG 13-47,
ADG 13-48
of CREATE TRIGGER, SQL 7-433
SQL*Loader, SUT 5-41,
SUT 5-44
SQL*Loader discards resulting from, SUT 5-29
WHENEVER
DO CALL example, PCO 8-18
WHENEVER directive, PCO 8-15,
PCO F-92
careless usage, PCO 8-20
CONTINUE action, PCO 8-16
DO CALL action, PCO 8-16
DO PERFORM action, PCO 8-16
example, PCO 8-17
examples, PC_ F-120,
PCO F-94
GOTO action, PCO 8-16
overview, PCO 2-11
purpose, PCO 8-15
scope of, PCO 8-20
SQLERROR condition, PCO 8-16
SQLWARNING condition, PCO 8-15
STOP action, PCO 8-17
syntax, PCO 8-17
using to check SQLCA automatically, PCO 8-15
WHENEVER DO CALL, PCO A-3
WHENEVER NOT SUCCESSFUL clause
of NOAUDIT schema_objects, SQL 7-553
WHENEVER SQL directive, PC_ F-118
WHENEVER statement
automatic checking of SQLCA with, PC_ 9-24
CONTINUE action in, PC_ 9-25
DO action in, PC_ 9-25
DO BREAK action in, PC_ 9-25
DO CONTINUE action in, PC_ 9-25
examples of, PC_ 9-26
GOTO action in, PC_ 9-25
guidelines for, PC_ 9-29
maintaining addressability for, PC_ 9-31
new actions, PC_ A-3
NOT FOUND condition in, PC_ 9-24
overview of, PC_ 2-8
scope of, PC_ 9-28
SQLERROR condition in, PC_ 9-24
SQLWARNING condition in, PC_ 9-24
STOP action in, PC_ 9-25
use in user exits, PC_ 20-9
using to avoid infinite loops, PC_ 9-30
using to handle end-of-data conditions, PC_ 9-29
where to place, PC_ 9-29
WHENEVER SUCCESSFUL clause
of AUDIT schema_objects, SQL 7-222
of AUDIT sql_statements, SQL 7-215
of NOAUDIT schema_objects, SQL 7-553
of NOAUDIT sql_statements, SQL 7-551
WHERE clause, PCO 5-11
and string comparisons, NLS 4-8
DELETE statement, PCO 5-11
host arrays in, PC_ 8-16
if omitted, PC_ 6-11
in DELETE statements, PC_ 6-10
in SELECT statements, PC_ 6-8
in UPDATE statements, PC_ 6-10
of DELETE, SQL 7-467
of DELETE statement, PC_ F-45,
PCO F-33
of SELECT, SQL 5-20,
SQL 7-577
of UPDATE, SQL 7-620
of UPDATE statement, PC_ F-114,
PCO F-88
purpose of, PC_ 6-10
search condition, PCO 5-11
search condition in, PC_ 6-10
SELECT statement, PCO 5-8
UPDATE statement, PCO 5-11
using host tables, PCO 7-18
WHERE clause, dynamic SQL, ADG 11-14
WHERE CURRENT OF clause, PCO 5-16
CURRENT OF clause, PC_ 6-17
WHILE loop, PLS 3-9
whitespace
included in a field, SUT 5-85
leading, SUT 5-82
terminating a field, SUT 5-85
trailing, SUT 5-82
trimming, SUT 5-82
WHITESPACE keyword, SUT 5-16
SQL*Loader, SUT 5-70
whole database backups, SBR 4-3,
SCN 1-49,
SCN 364
ARCHIVELOG mode, SBR 4-3
consistent, SBR 1-16
backup control files and, SBR 1-17
using SHUTDOWN ABORT statement, SBR 1-17
definition, SBR 1-13
inconsistent, SBR 1-18,
SBR 4-3
NOARCHIVELOG mode, SBR 4-3
preparing to take, SBR 4-4
restoring from, SBR 5-15
using RMAN, RMN 5-3
wild cards, in setting access control policies, OID 9-49
wildcard
using to grand LSM administrator privileges, LEG 2-29
wildcards, PLS 2-46
in views, SAD 18-4
windowing functions, DWG 17-35
Windows NT
renaming configuration files, LEG 5-22
SAP R/3 integration with LSM, LEG 1-7
saving disk information, LEG 5-8
Setting up Japanese version of LSM, LEG 2-18
Windows NT native authentication, NET 4-25
Windows NT, starting Oracle Directory Manager on, OID 4-2
WITH ADMIN OPTION clause
of GRANT system_privileges_and_roles, SQL 7-521
WITH CHECK OPTION clause
of CREATE VIEW, SQL 7-456,
SQL 7-461
of DELETE, SQL 7-467
of INSERT, SQL 7-542
of SELECT, SQL 7-570,
SQL 7-575
of UPDATE, SQL 7-618
WITH CONTEXT clause, ADG 10-28
WITH CONTEXT clause and external procedure, DCI 4-9
WITH GRANT OPTION clause
of GRANT object_privileges, SQL 7-534
WITH HOLD
clause of DECLARE CURSOR statement, PCO 5-14
WITH HOLD clause, PCO A-5
WITH INDEX CONTEXT clause
of CREATE OPERATOR, SQL 7-339,
SQL 7-341
WITH OBJECT IDENTIFIER clause, ADO 5-4
of CREATE VIEW, SQL 7-459
WITH OBJECT OID clause, SCN 14-3,
SCN 14-4
WITH OBJECT OID.
See
WITH OBJECT IDENTIFIER.
WITH PRIMARY KEY clause
of ALTER MATERIALIZED VIEW, SQL 7-53
of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG, SQL 7-336
of CREATE MATERIALIZED VIEW/SNAPSHOT...REFRESH, SQL 7-324
WITH READ ONLY clause
of CREATE VIEW, SQL 7-456,
SQL 7-461
of DELETE, SQL 7-467
of INSERT, SQL 7-542
of SELECT, SQL 7-570,
SQL 7-575
of UPDATE, SQL 7-618
WITH ROWID clause
of column ref constraints, SQL 7-242
of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG, SQL 7-336
of CREATE MATERIALIZED VIEW/SNAPSHOT...REFRESH, SQL 7-324
with_context
argument to external procedure functions, DCI 13-3,
OCI 18-3
with_grant_option event attribute, ADG 14-5
WNDS argument, ADG 9-66
WNDS parameter
of PRAGMA RESTRICT_REFERENCES, SQL 7-189
WNPS argument, ADG 9-66
WNPS parameter
of PRAGMA RESTRICT_REFERENCES, SQL 7-189
words, reserved, PLS F-1
word-size
changing, MIG 1-12,
MIG 7-38
work areas, query, PLS 5-16
WORK option
of COMMIT statement, PC_ F-25,
PCO F-16
of ROLLBACK statement, PC_ F-99,
PCO F-76
work ratios
measuring, PSA 11-11
worker threads, OID 2-32,
OID 13-11
in change log processing, OID 10-13
workflow, REP 6-11
workload, STU 1-6
workload skewing, SCN 175
workloads
adjusting, DWG 18-40
and scaleup, PSC 8-2
distribution, DWG 18-68
exceeding, DWG 18-37
WORM devices
and read-only tablespaces, SAD 9-21
Wrap Utility, PLS C-1
input and output files, PLS C-3
running, PLS C-2
wrapper
procedural replication, REP 1-16,
SCN 436
wrapper to hide PL/SQL code, ADG 9-28
write
streaming, ADL 10-152
write appending
to temporary LOBs, ADL 10-143
write batch size, STU 20-45
write_line()
as a function of UTL_TCP, SPR 66-11
write_raw()
as a function of UTL_TCP, SPR 66-7
write_text()
as a function of UTL_TCP, SPR 66-9
write-ahead, SCN 8-9
writeBoolean(boolean) - oracle.jms.AQjmsBytesMessage.writeBoolean(boolean), JPR 2-37
writeBoolean(boolean) - oracle.jms.AQjmsStreamMessage.writeBoolean(boolean), JPR 2-192
writeByte(byte) - oracle.jms.AQjmsBytesMessage.writeByte(byte), JPR 2-37
writeByte(byte) - oracle.jms.AQjmsStreamMessage.writeByte(byte), JPR 2-192
writeBytes(byte[]) - oracle.jms.AQjmsBytesMessage.writeBytes(byte[]), JPR 2-38
writeBytes(byte[]) - oracle.jms.AQjmsStreamMessage.writeBytes(byte[]), JPR 2-193
writeBytes(byte[], int, int) - oracle.jms.AQjmsBytesMessage.writeBytes(byte[], int, int), JPR 2-38
writeBytes(byte[], int, int) - oracle.jms.AQjmsStreamMessage.writeBytes(byte[], int, int), JPR 2-193
writeChar(char) - oracle.jms.AQjmsBytesMessage.writeChar(char), JPR 2-39
writeChar(char) - oracle.jms.AQjmsStreamMessage.writeChar(char), JPR 2-194
writeDouble(double) - oracle.jms.AQjmsBytesMessage.writeDouble(double), JPR 2-39
writeDouble(double) - oracle.jms.AQjmsStreamMessage.writeDouble(double), JPR 2-194
writeFloat(float) - oracle.jms.AQjmsBytesMessage.writeFloat(float), JPR 2-40
writeFloat(float) - oracle.jms.AQjmsStreamMessage.writeFloat(float), JPR 2-194
writeInt(int) - oracle.jms.AQjmsBytesMessage.writeInt(int), JPR 2-40
writeInt(int) - oracle.jms.AQjmsStreamMessage.writeInt(int), JPR 2-195
writeLong(long) - oracle.jms.AQjmsBytesMessage.writeLong(long), JPR 2-40
writeLong(long) - oracle.jms.AQjmsStreamMessage.writeLong(long), JPR 2-195
writeObject(Object) - oracle.jms.AQjmsBytesMessage.writeObject(java.lang.Object), JPR 2-41
writeObject(Object) - oracle.jms.AQjmsStreamMessage.writeObject(java.lang.Object), JPR 2-196
writers block readers, SCN 221
writeShort(short) - oracle.jms.AQjmsBytesMessage.writeShort(short), JPR 2-41
writeShort(short) - oracle.jms.AQjmsStreamMessage.writeShort(short), JPR 2-196
writeString(String) - oracle.jms.AQjmsStreamMessage.writeString(java.lang.String), JPR 2-197
writeUTF(String) - oracle.jms.AQjmsBytesMessage.writeUTF(java.lang.String), JPR 2-42
writing
data to a LOB
internal persistent LOBs, ADL 9-200
data to a temporary LOB, ADL 10-151
singly or piecewise, ADL 9-192
small amounts of data, enable buffering, ADL 9-237
WW date format element, SQL 2-46
Copyright © 1999 Oracle Corporation.
All Rights Reserved.
Library
Product
Contents