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