A

abbreviations

AM/PM, NLS 2-17

BC/AD, NLS 2-17

languages, NLS A-2

abbreviations permitted, PCO 2-11

abnormal termination

automatic rollback, PC_ F-26, PCO F-17

abort mode, warning notice, PSG 7-10

ABORT option

SHUTDOWN statement, SBR 1-17, SBR 5-15, SBR 5-16, SBR 5-25, SBR 6-13

abort response, DDS 4-13

two-phase commit, DDS 4-13

aborted save set, LEG 2-8

ABORTED_REQUEST_THRESHOLD procedure, STU 19-26

aborting an instance, SAD 3-13, SCN 5-10, SCN 344

aborting OCI calls, OCI 2-34

ABS function, SQL 4-12

ABSI

standards, SQL B - 1

absolute file number, PSC 7-3

abstract data type

representing in C applications, OCI 10-8

abstract object class type, OID 2-9

abstract object classes, OID 2-9

super classes of, OID 6-3

top, OID 2-8

abstraction, PLS 7-3, PLS 9-2

ACCEPT_CONNECTIONS command, NET A-81

access

data

managing, SAD 23-1

system privileges, SAD 23-2

database, ADG 11-28, ADG 11-29

granting privileges, SAD 23-10

granting

by using command line tools, OID 9-47

by using Oracle Directory Manager, OID 9-16

entry-level, by using command line tools

entry-level, by using Oracle Directory Manager, OID 9-47

to everyone, using Oracle Directory Manager, OID 9-24, OID 9-31

to specific groups, using Oracle Directory Manager, OID 9-24, OID 9-31

to subtrees, OID 9-24, OID 9-31

kinds, OID 9-9

level, required for LDAP operations, OID 9-15

object, OID 9-6

granting privileges, SAD 23-11

revoking privileges, SAD 23-14

objects

sequences, ADG 2-30

operations, OID 9-9

rights, setting by using Oracle Directory Manager, OID 9-25, OID 9-32

schema objects, ADG 11-30, ADG 11-31

remote integrity constraints, ADG 4-14

triggers, ADG 13-3, ADG 13-48

selecting, by DN, OID 9-49

subject, OID 9-8

unspecified, OID 9-36

violation event, OID 5-27

Access control, ADQ 4-5

access control, OID 1-5, OID 2-20, OID 2-25, OID 9-1, SCN 304

discretionary, SCN 1-38

fine-grained access control, SCN 325

managing

by using command line tools, OID 9-47

by using Oracle Directory Manager, OID 9-16

no authentication, OID 9-24, OID 9-30

password encryption, SCN 285

policies

conflicting, OID 9-3

inheriting, OID 9-3

prescriptive, OID 1-5

privileges, SCN 304

roles, SCN 319

setting, using wild cards, OID 9-49

simple, OID 9-24, OID 9-30

SSL no authentication, OID 9-24, OID 9-30

SSL one-way authentication, OID 9-24, OID 9-30

SSL two-way authentication, OID 9-24, OID 9-30

access control directive format. See ACI Directive format.

Access Control Information Item (ACI), OID 2-25

attributes, OID 2-25

components, OID 9-6

format, OID E-1

object of directives, OID 9-6

subject of directives, OID 9-8

syntax, OID E-1

Access Control Lists (ACLs), OID 2-25, OID 2-33

described, NET 2-51

evaluation, OID 9-10

for groups, OID 9-15

precedence rules, OID 9-11

in orclACI, OID 9-2

modification, OID 5-27

Access Control Policy Points (ACPs), OID 9-3, OID 9-17

adding

by using ldapmodify, OID 9-48

by using Oracle Directory Manager, OID 9-35

administering, using Oracle Directory Manager, OID 4-13

content access items, OID 9-20

creating, using Oracle Directory Manager, OID 4-11

multiple, OID 9-3

structural access items, OID 9-20

viewing, using Oracle Directory Manager, OID 9-17

access control to database

with Oracle Connection Manager, NET 8-35

with protocol.ora, NET C-77

access control, prescriptive, OID 9-3

Access Control, System Level, ADQ 8-5

access items

content, OID 9-20

structural, OID 9-20

access methods, STU 4-20

cluster scans, STU 4-22

execution plans, SCN 124, STU 4-5

hash scans, STU 4-22

index scans, STU 4-22

table scans, STU 4-21

access path, STU 2-11

access paths

cluster join, STU 4-38

composite index, STU 4-39

defined, SCN 127, STU 4-7

hash cluster key, STU 4-38

indexed cluster key, STU 4-39

optimization, STU 4-20

single row by cluster join, STU 4-36

single row by hash cluster key (with unique key), STU 4-36

single row by rowid, STU 4-35

single row by unique or primary key, STU 4-37

access privileges, SUT 2-10

Export, SUT 1-4

ACCESS_INTO_NULL exception, PLS 6-5

accessing external LOBs, ADL 11-5

ACCOUNT LOCK clause

of ALTER USER. See CREATE USER

of CREATE USER, SQL 7-453

ACCOUNT UNLOCK clause

of ALTER USER. See CREATE USER

of ALTER USER. See CREATE USER.

of CREATE USER, SQL 7-453

accounting, RADIUS, OAS 4-22

accounts

creating for snapshots, REP 3-32

operating system

database administrator, SAD 1-4

operating-system

role identification, SAD 23-20

user

SYS and SYSTEM, SAD 1-4

ACI Directive format, OID 2-25

ACI directives, OID 2-25

ACI Items. See Access Control Information Item (ACI).

ACI. see Access Control Information Item (ACI)

ACIs. See Access Control Information Item (ACI).

ACL directives

within entries, OID 9-3

within subtrees, OID 9-2

ACLs. See Access Control Lists (ACLs).

ACOS function, SQL 4-13

ACPs. See Access Control Policy Points (ACPs).

acquiring rollback segments, PSA 3-5

distributed locks, SRF 1-42

initialization parameters, PSC 7-7

acquisition AST, PSC 5-27, PSC 5-30

ACT parameter, NET 8-36, NET C-76

ACTIVATE STANDBY DATABASE clause

of ALTER DATABASE, SQL 7-11

activating

standby databases, SBY 1-12, SBY 3-20

consequences, SBY 1-14

activating checksumming and encryption, OAS 2-7

Active Data Object

translating to PSP, ADG 12-3

active destination state

for archived redo logs, SAD 7-13

active online redo log

loss of group, SBR 6-10

active server instances

modifying configuration set entries in, OID 5-4

viewing, OID 5-4

Active Server Pages, ADO 3-9

translating to PSP, ADG 12-3

active set, PCO 5-12

changing, PC_ 6-13, PC_ 6-14, PCO 5-14, PCO 5-15

cursor movement through, PC_ 6-14

definition, PCO 5-12

definition of, PC_ 2-7

how identified, PC_ 6-12

if empty, PC_ 6-14

when empty, PCO 5-15

when fetched from, PC_ 6-14

when no longer defined, PC_ 6-12

active transactions

read-only tablespaces, MIG 9-24

ACTIVE_DELAYS, NET A-94

ACTIVE_INSTANCE_COUNT, PSC 9-18

ACTIVE_INSTANCE_COUNT initialization parameter, SRF 1-12

ACTIVE_INSTANCE_COUNT parameter, PSA 1-8, PSG 5-6

ActiveX, ADO 3-9

actual parameters, PLS 5-8

AD (A.D.) date format element, SQL 2-46, SQL 2-48

Ada. See SQL*Module for Ada

adapters, OAS 1-11

adaptive multi-user

algorithm for, DWG 18-6

definition, DWG 18-6

adaptive multi-user feature, PSA 2-6

Add a Subscriber, ADQ 9-53

ADD clause

of ALTER DIMENSION, SQL 7-27

of ALTER TABLE, SQL 7-140

ADD DATAFILE clause

of ALTER TABLESPACE, SQL 7-179

ADD LOGFILE clause

of ALTER DATABASE, SQL 7-9

THREAD clause, PSC 7-3

thread required, PSA 3-7

ADD LOGFILE GROUP clause

of ALTER DATABASE, SQL 7-18

ADD LOGFILE MEMBER clause

of ALTER DATABASE, SQL 7-9, SQL 7-18

ADD LOGFILE MEMBER option

ALTER DATABASE statement, SAD 6-12

ADD LOGFILE option

ALTER DATABASE statement, SAD 6-11

ADD LOGFILE THREAD clause

of ALTER DATABASE, SQL 7-18

ADD OVERFLOW clause

of ALTER TABLE, SQL 7-155

ADD PARTITION, SQL 7-160

ADD PARTITION clause, SAD 15-14

of ALTER TABLE, SQL 7-158, SQL 7-160

ADD PRIMARY KEY clause

of ALTER MATERIALIZED VIEW LOG, SQL 7-61

ADD ROWID clause

of ALTER MATERIALIZED VIEW, SQL 7-61

of ALTER MATERIALIZED VIEW LOG, SQL 7-61

ADD SUBPARTITION clause, SAD 15-15

ADD TEMPFILE clause

of ALTER TABLESPACE, SQL 7-179

ADD_MONTHS function, SQL 4-13

ADD_POLICY procedure, ADG 11-38

addCertChain(byte[]) - oracle.security.ssl.OracleSSLCredential.addCertChain(byte[]), OAS F-22

addCertChain(String) - oracle.security.ssl.OracleSSLCredential.addCertChain(java.lang.String), OAS F-22

ADDED_EXTENTS, PSC A-12

adding

ACPs, OID 9-35

by using ldapmodify, OID 9-48

by using Oracle Directory Manager, OID 9-35

attributes

by copying an existing attribute, OID 6-28

by using Oracle Directory Manager, OID 6-24

guidelines for, OID 6-18

attributes to existing entries, OID A-7

audit log entries, OID 5-24

audit log event, OID 5-27

configuration set entries, OID 2-32, OID 5-12

by using command line tools, OID 2-32, OID 7-25

by using Oracle Directory Manager, OID 2-32

using Oracle Directory Manager, OID 5-4

configuration set entry, OID 5-2

datafiles, SBY 4-10, SBY 5-22, SBY 5-47

DSA to replicating system, OID B-1

entries, OID 7-12, OID 7-25

by copying an existing entry, OID 7-15

concurrently, OID 4-14, OID A-9

requires write access to parent, OID 7-12

requires write access to parents, OID 7-15

using ldapadd, OID 4-14, OID A-7

using ldapaddmt, OID A-9

using Oracle Directory Manager, OID 7-12

entry-level ACIs, by using ldapmodify, OID 9-49

group entries, by using Oracle Directory Manager, OID 7-20

input files, OID 5-13

mandatory attributes

to an existing object class, OID 6-4

to an object class in use, OID 7-22

multiple entries, using command line tools, OID 7-25

object classes, OID 6-2

using command line tools, OID 6-17

using Oracle Directory Manager, OID 6-13

objects

by using a template, OID 4-12

by using Oracle Directory Manager, OID 4-10, OID 4-12

redo logs, SBY 4-12, SBY 5-25

replication nodes, OID 10-18

user entries, by using Oracle Directory Manager, OID 7-18

adding a file, PSA 3-8, PSC A-20

adding nodes to a cluster, PSG 9-7

additional directory servers, connecting to, OID 4-12

additive conflict resolution method, REP 5-15

add.log, OID A-9

address, PLS 5-16

ADDRESS (ADD or ADDR) attribute, NET 9-4

ADDRESS parameter, NET B-2, NET C-38, NET C-49

ADDRESS_LIST parameter, NET B-2, NET C-38, NET C-49

addresses, configuring, NET 7-6

addTrustedCert(byte[]) - oracle.security.ssl.OracleSSLCredential.addTrustedCert(byte[]), OAS F-22

addTrustedCert(String) - oracle.security.ssl.OracleSSLCredential.addTrustedCert(java.lang.String), OAS F-22

ADMIN OPTION

about, SAD 23-11

revoking roles/privileges, SAD 23-13

roles, SCN 322

system privileges, SCN 305

with EXECUTE ANY TYPE, ADO 2-11

ADMIN_TABLES procedure, SAD 20-3, SAD 20-4

examples

building orphan key table, SAD 20-10

building repair table, SAD 20-9

ADMINISTER ANY TRIGGER system privilege, SQL 7-527

ADMINISTER_RESOURCE_MANAGER system privilege, SAD 25-3

administering instances

with initialization parameter files, PSG 4-4

with Oracle Parallel Server Management, PSG 7-2

administering schema objects, using Oracle Directory Manager, OID 4-13

administration

distributed databases, DDS 2-1

tools, DDS 1-31

administration tools, OID 4-14

bulk tools, OID 4-15

bulkdelete, OID A-25

bulkload, OID A-20

bulkmodify, OID A-23

Catalog Management, OID 4-16

command line, OID 1-4, OID 4-14

ldapadd, OID 4-14, OID A-7

ldapaddmt, OID A-9

ldapbind, OID A-6

ldapcompare, OID A-17

ldapdelete, OID 4-14, OID A-16

ldapmoddn, OID 4-14, OID A-18

ldapmodify, OID 4-14, OID A-11

ldapmodifymt, OID 4-14, OID A-14

ldapsearch, OID A-4

ldifwrite, OID A-21

OID Password Utility, OID 4-16

Oracle Directory Manager, OID 4-2

administrative context, OAS 17-6

described, NET 2-41

selecting, NET 6-19

Administrative Interface, ADQ 9-1

Views, ADQ 10-1

Administrative Interface, Views, ADQ 10-2

administrative queue, REP 2-24

administrative regions

defined, NET 6-47

delegated, NET 4-19

delegated, below root, NET 4-21

delegating domains, NET 6-73

described, NET 4-12

in Oracle Names, NET 4-12

root, NET 4-19

administrative requests, REP 2-22

states, REP 2-25

awaiting callback, REP 2-25

do callback, REP 2-25

error, REP 2-25

ready, REP 2-25

administrator

for replication

creating, RAR 2-4

for snapshot sites

creating, RAR 2-16

Administrator GUI, LSM

Clients Window on UNIX, LEG 2-21

Devices Window on UNIX, LEG 3-4

Devices Window on Windows NT, LEG 3-6

Edit Client Dialog Box on Windows, LEG 2-23

Edit Group Dialog Box on Windows, LEG 4-8, LEG 4-10

Groups Window on UNIX, LEG 4-8

labeling a volume on UNIX, LEG 3-14

labeling a volume on Windows, LEG 3-15

Messages display on UNIX, LEG 4-12

mounting a volume on UNIX, LEG 3-16

mounting a volume on Windows, LEG 3-17

overview, LEG 2-10

Pending Messages Window, LEG 3-21

Server Window on UNIX, LEG 2-24

Sessions display on UNIX, LEG 4-12

Set Up Server Dialog Box on Windows, LEG 2-25

UNIX, LEG 2-11

unmounting a volume on UNIX, LEG 3-18

unmounting a volume on Windows, LEG 3-18

Windows NT, LEG 2-13

administrator privileges, SCN 5-3

connections audited, SCN 333

OUTLN schema, SCN 129

statement execution not audited, SCN 332

Administrator Role, ADQ 4-6

administrators

application, SAD 1-3

administrators, LSM

acceptable names, LEG 2-28

administrator server attribute, LEG 2-26, LEG 2-27

modifying on UNIX, LEG 2-29

modifying on Windows NT, LEG 2-30

server resource attributes, LEG 2-26, LEG 2-27

specifying, LEG 2-27

using wildcard to grant privileges, LEG 2-29

ADO. See attribute descriptor object

Adt Message, ADQ 12-28

ADT. See abstract data type

AdtMessage - oracle.jms.AdtMessage, JPR 2-5

Advanced Networking Option, GTK 3-70

Advanced Program-to-Program Communication (APPC), NET 4-4

Advanced Queueing

dequeue function, OCI 15-5

description, OCI 9-27

enqueue function, OCI 15-7

examples, OCI 15-8

OCI and, OCI 9-27

OCI descriptors for, OCI 9-27

OCI functions for, OCI 9-27

OCI vs. PL/SQL, OCI 9-28

Advanced Queuing, GTK 3-37 to GTK 3-40, GTK 4-6, SCN 65

administrative interface, SPR 4-11

privileges and access control, ADQ 4-5

agents, SCN 70

compatibility, MIG 9-13, MIG 9-32

message streaming, MIG 9-32

privileges, MIG 9-32

rule based subscriptions, MIG 9-32

creation of queue tables and queues, ADQ A-4

database event publication, GTK 3-39

DBMS_AQADM package, SPR 5-1, ADQ 4-4

DEQUEUE request, SCN 74

downgrading queue tables, MIG 13-39

event publication, SCN 99

exception handling, SCN 78

exception queues, SCN 70

exporting advanced queue tables, SUT 1-59

exporting queue tables, SCN 79

extended address field, MIG 7-31

features, SCN 73, ADQ viii

correlation identifier, ADQ 1-10

exception handling, ADQ 1-14

integrated database level support, ADQ 1-7

integrated transactions, ADQ 1-8

local and remote recipients, ADQ 1-13

message grouping, ADQ 1-11

modes of dequeuing, ADQ 1-13

multiple recipients, ADQ 1-13

navigation of messages in dequeuing, ADQ 1-13

optimization of waiting for messages, ADQ 1-14

optional transaction protection, ADQ 1-14

priority and ordering of messages in enqueuing, ADQ 1-11

propagation, ADQ 1-12

retention and message history, ADQ 1-8

retries with delays, ADQ 1-14

sender identification, ADQ 1-12

structured payload, ADQ 1-7

subscription & recipient list, ADQ 1-10

time specification, ADQ 1-12

tracking and event journals, ADQ 1-8

importing advanced queue tables, SUT 2-58

interoperability, MIG 9-32

sender's ID column, MIG 9-32

message properties, ADQ 2-3

message queuing, SCN 66

messages, SCN 70

multiple consumer queues, GTK 3-39

nonpersistent queues, GTK 3-40

object level and system level privileges, GTK 3-39

object type support, GTK 2-5

parallel server mode, GTK 3-40

point-to-point model, SCN 68

propagation, enhanced, GTK 3-39

addition of a sender's ID column, GTK 3-39

history management information, GTK 3-39

single view, GTK 3-39

statistics, GTK 3-39

publish-subscribe model, SCN 69

publish-subscribe support, SCN 77, SCN 99

queue monitor, SCN 72

queue monitor process, SCN 1-19, SCN 8-14, SCN 72

interval statistics, SCN 78

window of execution, SCN 73

queue tables, SCN 70

downgrading, MIG 13-39

recipients, SCN 71

rule-based subscriptions, SCN 72

subscription lists, SCN 71

remote databases, SCN 76

removing incompatibilities

downgrading, MIG 13-35

removing propagation, MIG 13-40

revoking object and system level privileges, MIG 13-38

revoking roles and privelieges, ADQ A-68

rules, SCN 72

rules engine, GTK 3-38

scripts

CATNOQUE.SQL, MIG 7-33

CATQUEUE.SQL, MIG 7-33

subscribers, SCN 71

upgrading, MIG 7-31

user queues, SCN 70

see also publish/subscribe

advanced queuing functions, OCI 15-4

Advanced Queuing, basics, ADQ 7-3

Advanced Queuing, multiple-consumer dequeuing of one message, ADQ 7-6

advanced replication, GTK 3-64 to GTK 3-66

column level snapshot subsetting, GTK 3-65

internal apply packages, GTK 3-64

mass deployment support, GTK 3-65

offline snapshot instantiation, GTK 3-65

Oracle Lite integration, improved, GTK 3-66

Replication Manager, GTK 3-66

security, improved, GTK 3-66

snapshot deployment templates, parameterized, GTK 3-65

snapshot refresh, GTK 3-64

Advanced Security option. See Oracle Advanced Security.

Advanced Symmetric Replication (ASR), OID 2-14

configuring, OID 10-6

using Oracle8 Replication Manager, OID 10-3

installed with Oracle 8i, OID 10-3

installing, OID 10-3

setting up, OID 10-3

advantages

OCI, ADG 1-7, OCI 1-3

ADVISE clause

of ALTER SESSION, SQL 7-84

affinity

awareness, PSA 13-19

disk, PSA 2-3, PSA 2-7

parallel DML, SCN 206

parallel processor, PSC A-17

partitions, SCN 205

AFTER clause

of CREATE TRIGGER, SQL 7-428

AFTER triggers, SCN 90, SQL 7-428

auditing and, ADG 13-35, ADG 13-38, SAD 24-21

correlation names and, ADG 13-16

defined, SCN 90

specifying, ADG 13-7

when fired, SCN 102

Agent, ADQ 2-3

Agent address must be specified for remote subscriber - error, ADQ D-15

Agent must be specified, ADQ D-2

agent self-registration

compatibility, MIG 9-12

agents

generic connectivity, DDS 6-6

Heterogeneous Services, DDS 6-3, DDS 6-5

definition, DDS 1-5

disabling self-registration, DDS 7-9

registering, DDS 7-5, DDS 7-6, DDS 7-7

specifying initialization parameters for, DDS 7-4

agents for queuing, SCN 70

agents, definition, ADQ 1-17

aggregate assignment, PLS 2-34

aggregate computability check, DWG 19-19

aggregate distinct queries, parallelization of, GTK 3-25

aggregate functions, DDS 2-33, SQL 4-6

AVG, PLS 5-3

COUNT, PLS 5-3

GROUPING, PLS 5-3

MAX, PLS 5-3

MIN, PLS 5-3

STDDEV, PLS 5-3

SUM, PLS 5-3

treatment of nulls, PLS 5-3

VARIANCE, PLS 5-3

aggregates, DWG 8-8, DWG 8-11, DWG 18-49, DWG 19-30

agreements, replication, OID 2-14

ALERT file, PSA 14-4, PSC 7-2

alert files, SCN 8-15, SRF 1-16, STU 11-4

ARCn processes, SCN 8-13

redo logs, SCN 8-10

alert log, SBR 6-17

about, SAD 4-15

checking after RESETLOGS, SBR 5-35

control file record messages, RMN 3-47

location of, SAD 4-16

monitoring overwriting of control file records, RMN 3-48

session high water mark in, SAD 22-7

size of, SAD 4-16

useful for RMAN, RMN 9-2

using, SAD 4-15

when written, SAD 4-16

alert logs, PSG C-10

Alias library, DCI 4-2

aliases

directory

exporting, SUT 1-58

importing, SUT 2-57

for columns, SQL 5-19

for expressions in view query, SQL 7-458

qualifying subqueries (inline views), SCN 10-17

specifying in queries and subqueries, SQL 7-576

aliasing, PLS 7-22

ALL, STU 4-67

ALL clause

of SELECT, SQL 7-573

of SET CONSTRAINTS, SQL 7-598

of SET ROLE, SQL 7-601

ALL EXCEPT clause

of SET ROLE, SQL 7-601

ALL operator, SQL 3-6

ALL option, PSA 13-5

ALL PRIVILEGES clause

of GRANT object_privileges, SQL 7-533

of REVOKE schema_object_privileges, SQL 7-560

ALL PRIVILEGES shortcut

of AUDIT sql_statements, SQL 7-214

All Propagation Schedules, Selecting, ADQ 10-12

All Queue Tables in Database, Selecting, ADQ 10-4

All Queues in Database, Selecting, ADQ 10-10

All Recipients in recipient_list must be specified - error, ADQ D-15

ALL row operator, PLS 5-3, PLS 5-5

ALL shortcut

of AUDIT sql_statements, SQL 7-214

ALL_ views, SCN 2-6

ALL_ALL_TABLES view, SRF 2-3

ALL_ARGUMENTS view, SRF 2-5

ALL_ASSOCIATIONS view, SRF 2-7

ALL_CATALOG view, SRF 2-7

ALL_CLUSTER_HASH_EXPRESSIONS view, SRF 2-9

ALL_CLUSTERS view, SRF 2-8

ALL_COL_COMMENTS view, SQL 7-228, SRF 2-9

ALL_COL_PRIVS view, SRF 2-10

ALL_COL_PRIVS_MADE view, SRF 2-11

ALL_COL_PRIVS_RECD view, SRF 2-11

ALL_COLL_TYPES view, SRF 2-12

ALL_CONS_COLUMNS view, SRF 2-13

ALL_CONSTRAINTS view, SRF 2-13

ALL_CONTEXT view, SRF 2-15

ALL_DB_LINKS view, DDS 2-21, SRF 2-15

ALL_DEF_AUDIT_OPTS view, SRF 2-16

ALL_DEPENDENCIES view, SRF 2-16

ALL_DIM_ATTRIBUTES view, SRF 2-18

ALL_DIM_CHILD_OF view, SRF 2-18

ALL_DIM_HIERARCHIES view, SRF 2-19

ALL_DIM_JOIN_KEY view, SRF 2-19

ALL_DIM_LEVEL_KEY view, SRF 2-20

ALL_DIM_LEVELS view, SRF 2-20

ALL_DIMENSIONS view, SRF 2-17

ALL_DIRECTORIES view, SRF 2-21

ALL_ERRORS view, SRF 2-21

debugging stored procedures, ADG 9-43

ALL_IND_COLUMNS view, SRF 2-22

ALL_IND_EXPRESSIONS view, SRF 2-23

ALL_IND_PARTITIONS view, SRF 2-23

ALL_IND_SUBPARTITIONS view, SRF 2-25

ALL_INDEXES view, SRF 2-27, STU 12-17

filling with data, SAD 19-7

ALL_INDEXTYPE_OPERATORS view, SRF 2-31

ALL_INDEXTYPES view, SRF 2-30

ALL_JOBS view, SRF 2-32

ALL_LIBRARIES view, SRF 2-33

ALL_LOB_PARTITIONS view, SRF 2-34

ALL_LOB_SUBPARTITIONS view, SRF 2-35

ALL_LOBS view, SRF 2-33

ALL_METHOD_PARAMS view, SRF 2-37

ALL_METHOD_RESULTS view, SRF 2-37

ALL_MVIEW_AGGREGATES view, SRF 2-38

ALL_MVIEW_ANALYSIS view, SRF 2-39

ALL_MVIEW_DETAIL_RELATIONS view, SRF 2-41

ALL_MVIEW_JOINS view, SRF 2-41

ALL_MVIEW_KEYS view, SRF 2-42

ALL_MVIEWS view, SRF 2-43

ALL_NESTED_TABLES view, SRF 2-46

ALL_OBJECT_TABLES view, SRF 2-47

ALL_OBJECTS view, SRF 2-49, STU 19-34

ALL_OPANCILLARY view, SRF 2-50

ALL_OPARGUMENTS view, SRF 2-51

ALL_OPBINDINGS view, SRF 2-51

ALL_OPERATORS view, SRF 2-52

ALL_OUTLINE_HINTS view, SRF 2-53

ALL_OUTLINES view, SRF 2-53

ALL_PART_COL_STATISTICS view, SRF 2-54

ALL_PART_HISTOGRAMS view, SRF 2-55

ALL_PART_INDEXES view, SRF 2-56

ALL_PART_KEY_COLUMNS view, SRF 2-57

ALL_PART_LOBS view, SRF 2-58

ALL_PART_TABLES view, SRF 2-59

ALL_PARTIAL_DROP_TABS view, SRF 2-61

ALL_POLICIES view, SRF 2-61

ALL_QUEUE_TABLES view, SRF 2-62

ALL_QUEUES view, SRF 2-63

ALL_REFRESH_CHILDREN view, RAR 9-55, SRF 2-65

ALL_REFRESH_DEPENDENCIES view, SRF 2-66

ALL_REFRESHS view, RAR 9-54, SRF 2-64

ALL_REFS view, SRF 2-66

ALL_REGISTERED_SNAPSHOTS view, RAR 9-56, SRF 2-67

ALL_REPCAT_REFRESH_TEMPLATES view, RAR 9-8

ALL_REPCAT_TEMPLATE_OBJECTS view, RAR 9-9

ALL_REPCAT_TEMPLATE_PARMS view, RAR 9-11

ALL_REPCAT_TEMPLATE_SITES view, RAR 9-13

ALL_REPCAT_USER_AUTHORIZATIONS view, RAR 9-14

ALL_REPCAT_USER_PARM_VALUES view, RAR 9-15

ALL_REPCATLOG view, RAR 9-6, SRF 2-2

ALL_REPCOLUMN view, RAR 9-17, SRF 2-2

ALL_REPCOLUMN_GROUP view, RAR 9-18, SRF 2-2

ALL_REPCONFLICT view, RAR 9-18, SRF 2-2

ALL_REPDDL view, RAR 9-19, SRF 2-2

ALL_REPGENERATED view, SRF 2-2

ALL_REPGENOBJECTS view, RAR 9-20, SRF 2-2

ALL_REPGROUP view, RAR 9-21, SRF 2-2

ALL_REPGROUP_PRIVILEGES view, RAR 9-22

ALL_REPGROUPED_COLUMN view, RAR 9-22, SRF 2-2

ALL_REPKEY_COLUMNS view, RAR 9-23, SRF 2-2

ALL_REPOBJECT view, RAR 9-23, SRF 2-2

ALL_REPPARAMETER_COLUMN view, RAR 9-25, SRF 2-2

ALL_REPPRIORITY view, RAR 9-26, SRF 2-2

ALL_REPPRIORITY_GROUP view, RAR 9-28, SRF 2-2

ALL_REPPROP view, RAR 9-28, SRF 2-2

ALL_REPRESOL_STATS_CONTROL view, RAR 9-29, SRF 2-2

ALL_REPRESOLUTION view, RAR 9-30, SRF 2-2

ALL_REPRESOLUTION_METHOD view, RAR 9-32, SRF 2-2

ALL_REPRESOLUTION_STATISTICS view, RAR 9-32, SRF 2-2

gathering statistics, RAR 6-29

ALL_REPSITES view, RAR 9-33, SRF 2-2

ALL_ROWS hint, SQL 2-64, STU 4-11, STU 7-6

ALL_SEQUENCES view, SRF 2-68

ALL_SNAPSHOT_LOGS view, RAR 9-57, SRF 2-68

ALL_SNAPSHOT_REFRESH_TIMES view, RAR 9-58, SRF 2-69

ALL_SNAPSHOTS view, RAR 9-59, SRF 2-69

ALL_SOURCE view, ADG 9-43, SRF 2-71

ALL_SUBPART_COL_STATISTICS view, SRF 2-72

ALL_SUBPART_HISTOGRAMS view, SRF 2-72

ALL_SUBPART_KEY_COLUMNS view, SRF 2-73

ALL_SUMDELTA view, SRF 2-74

ALL_SYNONYMS view, SRF 2-74

ALL_TAB_COL_STATISTICS view, SRF 2-75

ALL_TAB_COLUMNS view, SRF 2-75

filling with data, SAD 19-7

ALL_TAB_COMMENTS view, SQL 7-228, SRF 2-77

ALL_TAB_HISTOGRAMS view, SRF 2-77

ALL_TAB_MODIFICATIONS view, SRF 2-78, SRF 2-136, SRF 2-184

ALL_TAB_PARTITIONS view, SRF 2-79

ALL_TAB_PRIVS view, SRF 2-80

ALL_TAB_PRIVS_MADE view, SRF 2-81

ALL_TAB_PRIVS_RECD view, SRF 2-81

ALL_TAB_SUBPARTITIONS view, SRF 2-82

ALL_TABLES table, PSA 10-4

ALL_TABLES view, SRF 2-83

filling with data, SAD 19-7

ALL_TRIGGER_COLS view, SRF 2-87

ALL_TRIGGERS view, SRF 2-86

ALL_TYPE_ATTRS view, SRF 2-88

ALL_TYPE_METHODS view, SRF 2-88

ALL_TYPES view, SRF 2-89

ALL_UPDATABLE_COLUMNS view, SCN 10-16, SRF 2-90, SRF 2-139, SRF 2-186

ALL_USERS view, SRF 2-91

ALL_USTATS view, SRF 2-91

ALL_VARRAYS view, SRF 2-92

ALL_VIEWS view, SRF 2-92

ALLOCATE

allocating a cursor variable, PC_ 4-27

allocate channel command (RMAN), RMN 10-10

and multi-threaded server, RMN 10-11, RMN 10-15

for delete option, RMN 5-27, RMN 10-14

for maintenance option, RMN 10-14

ALLOCATE DESCRIPTOR statement, PC_ 14-13, PC_ F-14, PCO F-12

ALLOCATE EXTENT, PSA 8-9

!blocks parameter, PSA 8-13

DATAFILE option, PSA 8-10

exclusive mode, PSA 8-9

in exclusive mode, PSA 8-9

instance number, PSA 8-11

INSTANCE option, PSA 8-10

pre-allocating extents, PSA 8-12

SIZE option, PSA 8-9

ALLOCATE EXTENT clause

of ALTER CLUSTER, SQL 7-3, SQL 7-4

of ALTER INDEX, SQL 7-31, SQL 7-35

of ALTER TABLE, SQL 7-150

instance number, SRF 1-47

ALLOCATE EXTENT option

DATAFILE option, PSC 7-24

instance number, PSC 7-20

INSTANCE option, PSC 7-24

not available, PSC A-22

SIZE option, PSC 7-24

ALLOCATE SQL statement, PC_ 17-5

ALLOCATE SQL statements, PC_ F-12

ALLOCATE statement, PCO F-10

use with ROWID, PCO 4-33

allocating

cursor variables, PC_ 4-27

cursors, PC_ F-12, PCO F-10

thread context, PC_ 11-8, PC_ F-28, PCO 12-8, PCO F-19

allocating cursor variables, PCO 6-32

allocation

automatic, PSA 8-11, PSA 8-12, PSC 7-25

dynamic, PSA 6-6

extents, ADG 5-17, PSA 1-6, PSA 8-12, PSA 8-13, SAD 13-13

extents, dynamic, PSA 8-13

free space, PSC 7-24

minimizing extents for rollback segments, SAD 11-12

of memory, STU 19-2

of PCM locks, PSA 7-9

PCM locks, PSA 7-9, PSA 8-9, PSC 5-20, PSC 7-21, SRF 1-40

rollback segments, PSA 3-4, SRF 1-105

sequence numbers, PSC 8-14

static, PSA 6-6

temporary space, SAD 13-6

allocation duration

example, OCI 13-14

of objects, OCI 13-14

ALLOW_PARTIAL_SN_RESULTS initialization parameter: obsolete

ALLOW_PARTIAL_SN_RESULTS parameter

obsolete for 8.1, PSC A-6

Alter a Propagation Schedule, ADQ 9-75

Alter a Queue, ADQ 9-30

ALTER ANY CLUSTER system privilege, SQL 7-521

ALTER ANY DIMENSION system privilege, SQL 7-522

ALTER ANY INDEX system privilege, SQL 7-522

ALTER ANY INDEXTYPE system privilege, SQL 7-522

ALTER ANY MATERIALIZED VIEW system privilege, SQL 7-523

ALTER ANY OUTLINE system privilege, SQL 7-524

ALTER ANY PROCEDURE system privilege, SQL 7-524

ALTER ANY ROLE system privilege, SQL 7-525

ALTER ANY SEQUENCE system privilege, SQL 7-525

ALTER ANY SNAPSHOT system privilege, SQL 7-526

ALTER ANY TABLE system privilege, SQL 7-526

ALTER ANY TRIGGER system privilege, SQL 7-527

ALTER ANY TYPE privilege, ADO 2-10

See also privileges

ALTER ANY TYPE system privilege, SQL 7-528

ALTER AUTHORIZATION

changing password, PCO 3-10

ALTER CLUSTER command, ADG 2-6

ALLOCATE EXTENT option, ADG 5-17

ALTER CLUSTER statement, PSC A-22, SQL 7-2

ALLOCATE EXTENT, PSA 8-9

ALLOCATE EXTENT option, SAD 16-9

allocating extents, PSA 8-12

using for hash clusters, SAD 17-9

using for index clusters, SAD 16-9

ALTER DATABASE

statement, SQL 7-6

system privilege, SQL 7-521

ALTER DATABASE ADD LOGFILE command, PSA 4-7

ALTER DATABASE ADD LOGFILE statement, PSG 9-4

alter database command (RMAN), RMN 10-16

ALTER DATABASE CONVERT statement, MIG 4-4, MIG 4-32

re-running, MIG A-19

ALTER DATABASE DISABLE THREAD statement, PSA 3-8

ALTER DATABASE OPEN RESETLOGS statement, MIG 4-4, MIG 4-32, PSA 14-13

ALTER DATABASE RESET COMPATIBILITY statement, MIG 9-7

ALTER DATABASE statement, SBY 1-28, SCN 5-7

ADD LOGFILE, PSC 7-3, SRF 1-117

ADD LOGFILE MEMBER option, SAD 6-12

ADD LOGFILE option, SAD 6-11

adding or dropping log file, PSC A-20

ARCHIVELOG option, SAD 7-6

BACKUP CONTROLFILE clause, SBR 1-19, SBR 4-4, SBR 4-14

TO TRACE option, SBR 4-14

CLEAR LOGFILE clause, SBR 6-9

CLEAR LOGFILE GROUP clause, SBY 4-16

CLEAR LOGFILE option, SAD 6-17

CLEAR UNARCHIVED LOGFILE clause, SBR 2-14, SBY 4-12, SBY 5-28

CLEAR UNARCHIVED LOGFILE option, SAD 6-7

CLOSE clause, PSA 4-7

CREATE STANDBY CONTROLFILE clause, SBY 4-15, SBY 5-15

database name, SRF 1-32

database partially available to users, SAD 3-8

DATAFILE OFFLINE and ONLINE options, PSC A-20

DATAFILE OFFLINE DROP clause, SBY 4-13

DATAFILE ONLINE option, SBR 5-30

DATAFILE...OFFLINE DROP option, SAD 10-8

DATFILE RESIZE, PSA 9-5

DISABLE, PSA 3-8

DROP LOGFILE MEMBER option, SAD 6-16

DROP LOGFILE option, SAD 6-15

ENABLE THREAD, SRF 1-117

ENABLE THREAD clause, SBY 4-12

MOUNT option, SAD 3-8

MOUNT STANDBY DATABASE clause, SBY 3-4, SBY 4-15

NOARCHIVELOG option, SAD 7-6

NORESETLOGS option, SBR 4-16, SBR 5-34

OPEN option, SAD 3-8

OPEN READ ONLY clause, SBY 3-18, SBY 3-19, SBY 4-17

OPEN RESETLOGS clause, RMN 3-12, SBY 5-28

READ ONLY option, SAD 3-9

RECOVER, PSA 14-7

RECOVER ... FROM option, SBR 5-6, SBR 5-10

RECOVER AUTOMATIC LOGFILE option, SBR 5-13

RECOVER LOGFILE option, SBR 5-12

RECOVER option, PSA 14-7

RENAME DATABASE clause, RMN 6-10

RENAME FILE option

datafiles for multiple tablespaces, SAD 10-11

renaming a file, PSC A-20

RESETLOGS option, SBR 4-16, SBR 5-16, SBR 5-17, SBR 5-34

RESETLOGS parameter, SBY 3-7

setting the log mode, PSA 3-2, PSA 3-8, PSC B-3

THREAD, PSA 3-8, SRF 1-117

thread of redo, PSA 3-8

UNRECOVERABLE DATAFILE option, SAD 6-18

ALTER DIMENSION statement, SQL 7-25

ALTER FUNCTION statement, SQL 7-28

COMPILE option, SAD 19-25

ALTER INDEX COALESCE, SAD 14-7

ALTER INDEX command, ADG 2-6

ALTER INDEX REBUILD statement, STU 12-9

ALTER INDEX statement, SAD 14-15, SQL 7-30

COMPUTE STATISTICS clause, GTK 3-27

DEALLOCATE UNUSED option, PSA 8-14

for maintaining partitioned indexes, SAD 15-12 to SAD 15-32

no-logging mode for SPLIT PARTITION, SCN 11-58, SCN 151

online rebuild, GTK 3-41

partition attributes, SCN 11-36

REBUILD PARTITION clause, SCN 11-60

ALTER JAVA CLASS statement, SQL 7-45

ALTER JAVA SOURCE statement, SQL 7-45

ALTER MATERIALIZED VIEW LOG statement, SQL 7-58

ALTER MATERIALIZED VIEW statement, DWG 8-17, SQL 7-47

enabling query rewrite, DWG 19-5

ALTER object privilege, SQL 7-535

ALTER OUTLINE statement, SQL 7-63

ALTER PACKAGE statement, SQL 7-64

COMPILE option, SAD 19-25

ALTER privilege, ADG 11-22

ALTER PROCEDURE statement, SQL 7-67

COMPILE option, SAD 19-25

ALTER PROFILE

statement, SQL 7-69

system privilege, SQL 7-525

ALTER PROFILE statement

altering resource limits, SAD 22-23

ALTER RESOURCE COST

statement, SQL 7-73

system privilege, SQL 7-525

ALTER RESOURCE COST statement, SAD 22-24

ALTER ROLE statement, SQL 7-76

changing authorization method, SAD 23-7

ALTER ROLLBACK SEGMENT

statement, SQL 7-78

system privilege, SQL 7-525

ALTER ROLLBACK SEGMENT command, PSC 7-8

ALTER ROLLBACK SEGMENT statement, PSA 3-4

changing storage parameters, SAD 11-9

OFFLINE option, SAD 11-11

ONLINE option, SAD 11-10, SAD 11-11

STORAGE clause, SAD 11-9

ALTER SEQUENCE command, ADG 2-30

ALTER SEQUENCE statement, SAD 18-13, SQL 7-81

ALTER SESSION

statement, SQL 7-83

system privilege, DDS 3-2, SQL 7-525

ALTER SESSION command

SERIALIZABLE, ADG 7-25

SET SCHEMA, ADG 11-19

ALTER SESSION SET INSTANCE statement, PSA 8-8

ALTER SESSION SET SCHEMA statement, ADG 11-44

ALTER SESSION statement, SCN 14

ADVISE clause, DDS 5-13

CLOSE DATABASE LINK clause, DDS 3-2

dynamic parameters, SCN 5-5

ENABLE PARALLEL DML clause, SCN 195

examples, STU 6-5

FORCE PARALLEL DDL clause, SCN 181, SCN 184

create or rebuild index, SCN 181, SCN 184

create table as select, SCN 182, SCN 184

move or split partition, SCN 181, SCN 184

FORCE PARALLEL DML clause

insert, SCN 180, SCN 183

update and delete, SCN 178, SCN 183

HASH_JOIN_ENABLED, STU 4-53

OPTIMIZER_GOAL, STU 4-11

SET CONSTRAINTS DEFERRED clause, SCN 275

SET HASH_AREA_SIZE clause, SRF 1-43

SET HASH_JOIN_ENABLED clause, SRF 1-44

SET INSTANCE option, PSA 8-8, PSC 7-24

SET NLS_CURRENCY clause, NLS 2-24, NLS 2-25

SET NLS_DATE_FORMAT clause, NLS 2-15

SET NLS_LANGUAGE clause, NLS 2-12

SET NLS_NUMERIC_CHARACTERS clause, NLS 2-22

SET NLS_TERRITORY clause, NLS 2-12

SET SESSION_CACHED_CURSORS statement, STU 19-21

SET SQL_TRACE initialization parameter, SAD 4-17

transaction isolation level, SCN 218, SCN 242

ALTER SNAPSHOT LOG. See ALTER MATERIALIZED VIEW LOG

ALTER SNAPSHOT LOG statement, RAR 7-17

ALTER SNAPSHOT. See ALTER MATERIALIZED VIEW

ALTER statement, SCN 12

auditing partitions, SCN 11-63

triggers on, SQL 7-430

ALTER SYSTEM

statement, SQL 7-102

system privilege, SQL 7-521

ALTER SYSTEM ARCHIVE LOG CURRENT statement, PSA 4-7

ALTER SYSTEM ARCHIVE LOG statement, PSA 4-7, PSA 13-21

CURRENT clause, PSA 13-15

CURRENT option, PSC A-21

global log switch, PSA 13-15, PSA 13-21

THREAD clause, PSA 4-7, PSA 13-5

ALTER SYSTEM CHECK DATAFILES statement, PSC 7-2

instance recovery, PSA 14-4

ALTER SYSTEM CHECKPOINT LOCAL statement, PSA 4-7

ALTER SYSTEM CHECKPOINT statement, PSA 13-14

global versus local, PSA 4-7

specifying an instance, PSA 4-7

ALTER SYSTEM privilege, PSA 13-14, PSA 13-15

ALTER SYSTEM statement, SCN 14

ARCHIVE ALL option

using to archive online redo logs, SBR 1-19

ARCHIVE LOG ALL option, SAD 7-9

ARCHIVE LOG CURRENT clause, SBY 3-21, SBY 5-42

ARCHIVE LOG option, SAD 7-9

CHECKPOINT clause, STU 24-7

DISABLE DISTRIBUTED RECOVERY clause, DDS 5-28

dynamic parameters, SCN 5-5

LOG_ARCHIVE_MAX_PROCESSES, SCN 8-13, SCN 361

ENABLE DISTRIBUTED RECOVERY clause, DDS 5-28

ENABLE RESTRICTED SESSION option, SAD 3-9

MTS_DISPATCHERS parameter, STU 21-8

RESUME clause, SAD 3-14

RESUME option, SBR 4-11

SET LICENSE_MAX_SESSIONS option, SAD 22-4

SET LICENSE_MAX_USERS option, SAD 22-6

SET LICENSE_SESSIONS_WARNING option, SAD 22-4

SET MTS_SERVERS option, SAD 4-8

SET NLS_LANGUAGE clause, NLS 2-12

SET RESOURCE_LIMIT option, SAD 22-22

SET RESOURCE_MANAGER_PLAN, SAD 25-18

SUSPEND clause, SAD 3-14

SUSPEND option, SBR 4-11

SWITCH LOGFILE clause, SBY 4-11, SCN 8-12

SWITCH LOGFILE option, SAD 6-16

ALTER SYSTEM SWITCH LOGFILE statement, PSA 4-7, PSA 13-15, PSC A-21

DBA privilege, PSA 13-15, PSC A-21

ALTER TABLE command, ADG 2-6, ADG 2-9

defining integrity constraints, ADG 4-18

DISABLE ALL TRIGGERS option, ADG 13-32

DISABLE integrity constraint option, ADG 4-21

DROP integrity constraint option, ADG 4-24

ENABLE ALL TRIGGERS option, ADG 13-31

ENABLE integrity constraint option, ADG 4-21

INITRANS parameter, ADG 7-25

ALTER TABLE statement, SQL 7-123

add or coalesce hash partition, SCN 11-16

ALLOCATE EXTENT, PSA 8-9

ALLOCATE EXTENT option, SAD 13-14

allocating extents, PSA 8-12, PSA 8-13, SRF 1-47

auditing, SCN 335

bitmap index invalidation, MIG 9-26

CACHE clause, SCN 7-4

DEALLOCATE UNUSED clause, SCN 4-15

DISABLE ALL TRIGGERS option, SAD 19-14

DISABLE integrity constraint option, SAD 19-18

disable or enable constraints, SCN 276

DISABLE TABLE LOCK clause, PSA 7-17, PSA 10-4

DISABLE TABLE LOCK option, PSC 4-13

DROP COLUMN clause, SCN 10-7

drop column support, GTK 3-41

DROP integrity constraint option, SAD 19-20

ENABLE ALL TRIGGERS option, SAD 19-14

ENABLE integrity constraint option, SAD 19-18, SAD 19-19

ENABLE ROW MOVEMENT, GTK 3-46

ENABLE TABLE LOCK clause, PSA 7-17, PSA 10-4

ENABLE TABLE LOCK option, PSC 4-13

example, SAD 13-12

EXCHANGE PARTITION, SCN 11-11

for maintaining partitions, SAD 15-12 to SAD 15-32

MAXEXTENTS option, PSA 8-13

MERGE PARTITIONS clause, SCN 11-14

merging partitions, GTK 3-45

MODIFY CONSTRAINT clause, GTK 3-28, SCN 277

MOVE clause for IOT or non-partitioned table, GTK 3-29

no longer invalidates bitmap indexes, GTK 3-25

NOLOGGING clause, DWG 18-60

no-logging mode for SPLIT PARTITION, SCN 11-58, SCN 151

partition attributes, SCN 11-26

triggers, SCN 87

UNUSED column, SCN 10-7

validate or novalidate constraints, SCN 276

ALTER TABLESPACE

statement, SQL 7-176

system privilege, SQL 7-527

ALTER TABLESPACE statement

ADD DATAFILE, PSA 9-5

ADD DATAFILE option, PSC A-20

ADD DATAFILE parameter, SAD 10-5

BACKUP option, PSA 13-20

BEGIN BACKUP option, SBR 4-5, SBR 4-9

BEGIN/END BACKUP clause, RMN 3-35

END BACKUP option, SBR 4-9

OFFLINE and ONLINE options, PSC A-20

ONLINE option

example, SAD 9-17

READ ONLY clause, SCN 3-11

READ ONLY option, PSA 5-3, SAD 9-18

READ WRITE clause, SCN 3-11

READ WRITE option, SAD 9-20

RENAME DATA FILE option, SAD 10-10

renaming a data file, PSC A-20

TEMPORARY or PERMANENT, SCN 3-13

ALTER TRIGGER command

DISABLE option, ADG 13-31

ENABLE option, ADG 13-31

ALTER TRIGGER statement, SQL 7-183

DISABLE option, SAD 19-14

ENABLE option, SAD 19-13

ALTER TYPE statement, SQL 7-186

ALTER USER

statement, SQL 7-193

system privilege, SQL 7-528

ALTER USER privilege, SAD 22-18

ALTER USER statement

default roles, SAD 23-18

GRANT CONNECT THROUGH clause, SAD 22-14

REVOKE CONNECT THROUGH clause, SAD 22-14

temporary segments, SCN 4-20

ALTER VIEW statement, SQL 7-198

COMPILE option, SAD 19-24

alter(Session, AQjmsDestinationProperty) - oracle.jms.AQjmsDestination.alter(javax.jms.Session, oracle.jms.AQjmsDestinationProperty), JPR 2-65

altering

control files, SBY 4-12, SBY 5-26

propagation method, SPR 37-16, SPR 37-24, RAR 8-82, RAR 8-90

storage parameters, ADG 2-9

tables, ADG 2-9

altering dimensions, DWG 9-14

altering storage parameters, SAD 13-12

altering users, SAD 22-19

alternate character mappings, NLS 4-10

AlternateServers attribute, in failover, OID 14-4

alterPropagationSchedule(Session, String, Double, String, Double) - oracle.jms.AQjmsDestination.alterPropagationSchedule(javax.jms.Session, java.lang.String, java.lang.Double, java.lang.String, java.lang.Double), JPR 2-66

Always Use Dedicated Server option in Net8 Assistant, NET 8-21

ALWAYS_ANTI_JOIN initialization parameter, SRF 1-13

ALWAYS_ANTI_JOIN parameter, STU 4-29, STU 4-61, STU 7-23, STU 7-24

ALWAYS_SEMI_JOIN initialization parameter, SRF 1-14

ALWAYS_SEMI_JOIN parameter, STU 4-62

AM (A.M.) date format element, SQL 2-46, SQL 2-48

American National Standards Institute (ANSI)

ANSI-compatible locking, ADG 7-17

American National Standards Institute. See ANSI

amount parameter

reading and loading LOB data, the size of, ADL 6-4

used with BFILEs, ADL 11-47

AM/PM abbreviation

language of, NLS 2-17

analysis

of applications for Oracle Parallel Server, PSA 5-3

analysis dictionary, STU 11-5

analytic functions, DWG 17-21, SQL 4-7

CUME_DIST, SQL 4-28

FIRST_VALUE, SQL 4-34

LAG, SQL 4-40

LAST_VALUE, SQL 4-42

LEAD, SQL 4-44

NTILE, SQL 4-61

PERCENT_RANK, SQL 4-66

RANK, SQL 4-67

RATIO_TO_REPORT, SQL 4-68

ROW_NUMBER, SQL 4-80

ANALYZE, OID 13-6

Import parameter, SUT 2-18

ANALYZE ANY system privilege, SQL 7-529

ANALYZE CLUSTER statement, SQL 7-200

ANALYZE function of DBMS_STATS package, OID 13-3

ANALYZE INDEX statement, SQL 7-200

ANALYZE statement, DWG 18-51, SCN 13, SRF 2-27, SRF 2-75, SRF 2-77, SRF 2-83, SRF 2-111, SRF 2-136, SRF 2-137, SRF 2-183, SRF 2-185, STU 20-31

CASCADE option, SAD 19-9

COMPUTE STATISTICS option, SAD 19-5

corruption reporting, SAD 20-5

creating histograms, SCN 134, STU 8-18

dangling REFs, GTK 3-36

ESTIMATE STATISTICS SAMPLE option, SAD 19-5

estimated statistics, SCN 137

LIST CHAINED ROWS option, SAD 19-9

parallel, GTK 4-2

partition statistics, SCN 11-13

shared pool, SCN 7-11

shared SQL and, SAD 19-8

STATISTICS option, SAD 19-4

VALIDATE STRUCTURE option, SAD 19-9

validating structure, SAD 20-4

ANALYZE TABLE statement, DDS 3-7, DWG 15-3, SQL 7-200

ANALYZE TABLE VALIDATE STRUCTURE statement

change in release 8.1, MIG 9-18

analyzer statistics, SUT 2-61

analyzing archived redo logs, SAD 7-26

analyzing data

for parallel processing, DWG 18-69

analyzing objects

about, SAD 19-3

privileges, SAD 19-4

analyzing tables

cost-based optimization, DDS 3-7

ANCILLARY TO clause

of CREATE OPERATOR, SQL 7-341

AND expression

for simple subquery snapshots, REP 3-15

AND operator, SQL 3-11, SQL 3-12

AND_EQUAL hint, SQL 2-65, STU 7-16, STU 12-7

angle brackets, PC_ xvi

ANO. See Advanced Networking Option.

anonymous

authentication, OID 4-4

login, OID 4-4

anonymous authentication, OID 1-5, OID 2-21

in access control, OID 9-24, OID 9-30

anonymous PL/SQL block, PLS 7-2

anonymous PL/SQL blocks, ADG 11-10, SCN 24, SCN 53

about, ADG 9-2

applications, SCN 26

calling a stored procedure, SCN 28

compared to triggers, ADG 9-28

contrasted with stored procedures, SCN 53

dynamic SQL, SCN 28

dynamic SQL and, SPR 51-2

performance, SCN 53

ANSI, SQL B - 1

compliance, PC_ xvii

datatypes, SQL 2-28

conversion to Oracle datatypes, SQL 2-28

standards, SQL v, SQL 1-2

supported datatypes, SQL 2-12

ANSI C Support, PC_ E-2

ANSI dynamic SQL, PC_ A-4, PCO A-2

reference semantics, PC_ 14-7

See also dynamic SQL (ANSI), PC_ 14-1, PCO 10-1

ANSI Entry SQL compliance, PCO cxxviii

ANSI format

COBOL statements, PCO 2-12

ANSI SQL standard

datatypes of, SCN 12-23

Oracle certification, SCN 1-3

ANSI SQL92

FIPS flagger, ADG 7-2

ANSI standard for LOBs, ADL 10-10

ANSI, address of, PC_ xvii

ANSI/ISO SQL

compliance, PCO cxxvi

extensions, PCO 14-21

ANSI/ISO SQL standard, SCN 1-3

composite foreign keys, SCN 266

data concurrency, SCN 212

isolation levels, SCN 221

ANSWER_TIMEOUT parameter, NET C-73

anti-joins, STU 4-61

ANY, STU 4-67

ANY - oracle.xml.parser.v2.ElementDecl.ANY, JPR 4-32

ANY comparison operator, PLS 5-5

ANY operator, SQL 3-6

API

MM, LEG 1-11

apostrophes, PLS 2-9

APPC architecture, NET 4-4

APPEND hint, DWG 18-60, SQL 2-67, STU 7-28

APPEND keyword

SQL*Loader, SUT 5-44

append sequences conflict resolution method, REP 5-25

append site name conflict resolution method, REP 5-24

APPEND to table

example, SUT 4-11

SQL*Loader, SUT 5-33

appendChild(Node) - oracle.xml.parser.v2.XMLNode.appendChild(org.w3c.dom.Node), JPR 4-106

appending

one LOB to another

internal persistent LOBs, ADL 9-181

one temporary LOB to another, ADL 10-133

write appending to a LOB

internal persistent LOBs, ADL 9-191

application administrators, SAD 21-11

application context, SAD 21-4

as secure data cache, ADG 11-47

bind variables, ADG 11-48

CREATE CONTEXT statement, GTK 3-69

creating, ADG 11-52

design principles, ADG 11-45

examples, ADG 11-53

fine-grained access control, ADG 11-14, ADG 11-18, ADG 11-47

how to use, ADG 11-49

introduction, ADG 11-4, ADG 11-40

parallel query, ADG 11-51

performance, ADG 11-56

returning predicate, ADG 11-48

security features, ADG 11-41

setting, ADG 11-52

USERENV namespace, ADG 11-42

using in policy, ADG 11-52

versioning, ADG 11-51

application design, STU 2-9

application designer, STU 1-8

application developer, STU 1-8

application developers

privileges for, SAD 21-10

roles for, SAD 21-11

application development, GTK 3-69

constraints, DDS 3-3

database links

controlling connections, DDS 3-2

distributed databases, DDS 3-1

analyzing execution plan, DDS 3-10

controlling connections, DDS 3-2

handling errors, DDS 3-3

handling RPC errors, DDS 3-12

managing distribution of data, DDS 3-2

managing referential integrity, DDS 3-3

optimizing distributed queries, DDS 1-47

overview, DDS 1-44

remote procedure calls, DDS 1-46

tuning distributed queries, DDS 3-3

tuning using collocated inline views, DDS 3-4

using cost-based optimization, DDS 3-5

using hints to tune queries, DDS 3-8

distributing data, DDS 3-2

Heterogeneous Services, DDS 9-1, DDS 9-2

controlling array fetches between non-Oracle server and agent, DDS 9-11

controlling array fetches between Oracle server and agent, DDS 9-11

controlling reblocking of array fetches, DDS 9-11

DBMS_HS_PASSTHROUGH package, DDS 9-2

pass-through SQL, DDS 9-2

using bulk fetches, DDS 9-9

using OCI for bulk fetches, DDS 9-10

referential integrity, DDS 3-3

remote connections

terminating, DDS 3-2

security for, SAD 21-10

using Heterogeneous Services, DDS 9-1

application development process, PC_ 2-8, PCO 2-2

application failover

callback example, OCI 9-22

callback registration, OCI 9-22

OCI callbacks, OCI 9-20

Application Generator for Microsoft Visual Studio, GTK 3-85

application information, in attributes, OID 2-4

application program interface (API), for non-Oracle data sources, NET 10-2

application schema, GTK 2-9

application security

considerations for use, ADG 11-6

introduction, ADG 11-4, ADG 11-5

limitations, ADG 11-15

specifying attributes, ADG 11-41

through validation, ADG 11-41

application servers

allowing to connect as a user, SQL 7-195

Application, Sample, ADQ 8-3

applications

administrator, ADG 11-8, SAD 1-3

allowing to connect as a user, SQL 7-195

analysis for Oracle Parallel Server, PSA 5-3

application context

compatibility, MIG 9-12

downgrading, MIG 13-45

application vs. database triggers, SCN 83

availability, PSA 14-3

building with Net8 OPEN, NET 10-7

calling stored procedures and packages, ADG 9-51

can find constraint violations, SCN 256

client/server, STU 3-11

client/server configurations

upgrading, MIG 10-4

compatibility, MIG 9-16, MIG 10-2

configuring system to use custom, NET 10-8

context, SCN 327

converting to multi-instance, PSG 9-3

data dictionary references, SCN 2-4

data warehouses

star queries, DWG 16-2

data warehousing, SCN 10-34

star queries, STU 4-62

database access through, SCN 8-2

database users, ADG 11-6

decision support, DWG 18-2, STU 3-4, STU 9-15

decision support systems, DWG 6-3

decision support systems (DSS), SCN 10-35

parallel SQL, SCN 158, SCN 188

departmentalized, PSC 8-7

dependencies of, SCN 117

designing, PSA A-2

development

role during migration, MIG 2-7

development for Oracle Parallel Server, PSA 5-2

direct-load INSERT, SCN 195

discrete transactions, SCN 39

disjoint data, PSC 8-6

distributed databases, STU 3-8

DSS, PSC 8-6

enhancing security with, SCN 1-41, SCN 256

errors

RAISE_APPLICATION_ERROR() procedure, DDS 3-12

recovery after, SBR 1-12

for Oracle Parallel Server, determining suitability, PSA 5-2

index-organized tables, SCN 10-43

compatibility, MIG 9-17

information retrieval (IR), SCN 10-44

insert-intensive, PSC 7-19

interoperability, MIG 9-16

linking, OCI 2-37

linking with newer libraries, MIG 10-6

network communication and, SCN 6-5

object dependencies and, SCN 119

OCI

compatibility, MIG 9-18

interoperability, MIG 9-18

OLTP, PSC 8-6, STU 3-2

One Big Application User model, ADG 11-6, ADG 11-7

online analytical processing (OLAP), SCN 10-45

online transaction processing (OLTP)

reverse key indexes, SCN 10-33

Oracle Parallel Server, STU 3-10

parallel DML, SCN 194

parallel query, STU 3-5

partitioning, methodology, PSA 5-8

performance, PSC 7-19

physical ROWIDs and UROWIDs, MIG 9-17

physical ROWIDs in Oracle8i, MIG 12-2

PL/SQL

compatibility, MIG 9-21

interoperability, MIG 9-21

precompiler

compatibility, MIG 9-20

interoperability, MIG 9-20

processes, SCN 8-4

profiles, PSC 8-7

program interface and, SCN 8-27

query-intensive, PSC 8-6

random access, PSC 8-6

registering with the database, STU 11-8

roles, ADG 11-5, ADG 11-9

roles and, SCN 320

running against older server, MIG 10-6

samples provided with Net8 OPEN, NET 10-9

scalability, PSC 8-10, PSC 8-12

securing, SQL 7-261

security, ADG 11-7, ADG 11-12

application context, SCN 327

sharing code, SCN 7-19

spatial applications, SCN 10-45

table access patterns, PSA 5-3

that do not scale, PSC 9-23

transaction termination and, SCN 35

transactions, PSA 5-3

tuning, PSA 11-1

tuning performance, PSC 7-19

Tuxedo applications

compatibility, MIG 9-18

unhandled exceptions in, ADG 9-46

upgrading, MIG 10-1

compatibility rules, MIG 10-5

options, MIG 10-8

relinking rules, MIG 10-5

validating, SQL 7-261

applications administrator, SAD 1-3

Apply button, in Oracle Directory Manager, OID 4-10

applying log files

SQL*Plus, SBR 5-11

AQ Agent List Type, ADQ 2-4

AQ Excetpion (string) - error, ADQ D-9

AQ Object Types, Access to, ADQ 4-7

AQ Recipient List Type, ADQ 2-4

AQ. See Advanced Queueing.

AQ. See Advanced Queuing

AQ Subscriber List Type, ADQ 2-4

AQ_ADMINISTRATOR role, SCN 73

AQ_ADMINISTRATOR_ROLE role, SQL 7-530

AQ_TM_PROCESS parameter, SCN 72, SCN 73

AQ_TM_PROCESSES, ADQ 2-7

AQ_TM_PROCESSES initialization parameter, SRF 1-14

AQ_TM_PROCESSES parameter

of ALTER SYSTEM, SQL 7-108

AQ_USER_ROLE role, SQL 7-530

AQjmsAdtMessage - oracle.jms.AQjmsAdtMessage, JPR 2-7

AQjmsAgent - oracle.jms.AQjmsAgent, JPR 2-24

AQjmsAgent() - oracle.jms.AQjmsAgent.AQjmsAgent(), JPR 2-25

AQjmsAgent(String, String) - oracle.jms.AQjmsAgent.AQjmsAgent(java.lang.String, java.lang.String), JPR 2-25

AQjmsAgent(String, String, int) - oracle.jms.AQjmsAgent.AQjmsAgent(java.lang.String, java.lang.String, int), JPR 2-25

AQjmsBytesMessage - oracle.jms.AQjmsBytesMessage, JPR 2-28

AQjmsBytesMessage_C - oracle.jms.AQjmsBytesMessage_C, JPR 2-43

AQjmsConnection - oracle.jms.AQjmsConnection, JPR 2-43

AQjmsConnectionMetaData - oracle.jms.AQjmsConnectionMetaData, JPR 2-49

AQjmsConnectionMetaData() - oracle.jms.AQjmsConnectionMetaData.AQjmsConnectionMetaData(), JPR 2-50

AQjmsConstants - oracle.jms.AQjmsConstants, JPR 2-54

AQjmsConstants() - oracle.jms.AQjmsConstants.AQjmsConstants(), JPR 2-55

AQjmsConsumer - oracle.jms.AQjmsConsumer, JPR 2-56

AQjmsDeqSelConstants - oracle.jms.AQjmsDeqSelConstants, JPR 2-64

AQjmsDestination - oracle.jms.AQjmsDestination, JPR 2-64

AQjmsDestinationProperty - oracle.jms.AQjmsDestinationProperty, JPR 2-73

AQjmsDestinationProperty() - oracle.jms.AQjmsDestinationProperty.AQjmsDestinationProperty(), JPR 2-74

AQjmsDestinationProperty(AQQueueProperty) - oracle.jms.AQjmsDestinationProperty.AQjmsDestinationProperty(oracle.jms.AQQueueProperty), JPR 2-77

AQjmsError - oracle.jms.AQjmsError, JPR 2-77

AQjmsException - oracle.jms.AQjmsException, JPR 2-77

AQjmsFactory - oracle.jms.AQjmsFactory, JPR 2-79

AQjmsInvalidDestinationException - oracle.jms.AQjmsInvalidDestinationException, JPR 2-82

AQjmsInvalidSelectorException - oracle.jms.AQjmsInvalidSelectorException, JPR 2-83

AQjmsMapMessage - oracle.jms.AQjmsMapMessage, JPR 2-84

AQjmsMapMessage_C - oracle.jms.AQjmsMapMessage_C, JPR 2-100

AQjmsMessage - oracle.jms.AQjmsMessage, JPR 2-100

AQjmsMessageEOFException - oracle.jms.AQjmsMessageEOFException, JPR 2-122

AQjmsMessageFormatException - oracle.jms.AQjmsMessageFormatException, JPR 2-123

AQjmsMessageHeaderExt - oracle.jms.AQjmsMessageHeaderExt, JPR 2-124

AQjmsMessageNotReadableException - oracle.jms.AQjmsMessageNotReadableException, JPR 2-124

AQjmsMessageNotWriteableException - oracle.jms.AQjmsMessageNotWriteableException, JPR 2-125

AQjmsMessages - oracle.jms.AQjmsMessages, JPR 2-126

AQjmsObjectMessage - oracle.jms.AQjmsObjectMessage, JPR 2-126

AQjmsOracleDebug - oracle.jms.AQjmsOracleDebug, JPR 2-130

AQjmsProducer - oracle.jms.AQjmsProducer, JPR 2-132

AQjmsQueueBrowser - oracle.jms.AQjmsQueueBrowser, JPR 2-146

AQjmsQueueConnectionFactory, ADQ B-81

AQjmsQueueConnectionFactory - oracle.jms.AQjmsQueueConnectionFactory, JPR 2-150

AQjmsQueueReceiver - oracle.jms.AQjmsQueueReceiver, JPR 2-153

AQjmsQueueSender - oracle.jms.AQjmsQueueSender, JPR 2-156

AQjmsSession - oracle.jms.AQjmsSession, JPR 2-157

AQjmsStreamMessage - oracle.jms.AQjmsStreamMessage, JPR 2-184

AQjmsTextMessage - oracle.jms.AQjmsTextMessage, JPR 2-198

AQjmsTopicConnectionFactory - oracle.jms.AQjmsTopicConnectionFactory, JPR 2-201

AQjmsTopicPublisher - oracle.jms.AQjmsTopicPublisher, JPR 2-204

AQjmsTopicReceiver - oracle.jms.AQjmsTopicReceiver, JPR 2-207

AQjmsTopicSubscriber - oracle.jms.AQjmsTopicSubscriber, JPR 2-210

ARCH process, PSA 13-4, STU 19-8

specifying multiple processes, SAD 7-20

ARCH processes

multiple, DWG 18-56

ARCH_IO_SLAVES initialization parameter: obsolete

architecture, PLS 1-17

client/server, SCN 1-32

components of Oracle Parallel Server, PSC 3-1

connection pooling, NET 2-12

dedicated server, NET 2-13

for parallel processing, PSC 2-1

MPP, SCN 206

multi-threaded server, NET 2-7

Net8, NET 3-1

of Oracle, SCN 1-12

OPSCTL utility on UNIX, PSG 6-4

OPSCTL utility on Windows NT, PSG 6-5

Optimal Flexible Architecture (OFA), PSG 1-8, PSG 1-9, SAD 2-5

Oracle Connection Manager, NET 4-5

Oracle Enterprise Manager, PSG 6-7

Oracle Internet Directory, OID 2-1

Oracle Names, NET 4-10

Oracle Parallel Server, PSG 1-2

Oracle Parallel Server Management, PSG 6-2

SMP, SCN 206

architecture and CPU, STU 18-13

architecture of SSL

in an Oracle environment, OAS 10-3

with other authentication methods, OAS 10-8

architecture, LSM, LEG 2-2, LEG 2-3

archive buffer parameters, SAD 7-21

archive destinations, SBY 2-17, SBY 5-31

MANDATORY, SBY 5-31

OPTIONAL, SBY 5-32

archive log

backup, PSA 13-8

ARCHIVE LOG clause

CURRENT option, PSA 13-15, PSA 13-21, PSC A-21

global log switch, PSA 13-15, PSA 13-21

manual archiving, PSA 13-5

of ALTER SYSTEM, SQL 7-103

THREAD option, PSA 13-1, PSA 13-5

ARCHIVE LOG CURRENT clause

ALTER SYSTEM statement, SBY 3-21, SBY 5-42

archive log destination parameters

new in release 8.1, MIG B-13

archive log destinations

conversion to multi-instance, PSG 9-3

multiple

on UNIX, PSG 4-15

on Windows NT, PSG 4-16

shared

on UNIX, PSG 4-10

on Windows NT, PSG 4-12

ARCHIVE LOG option

ALTER SYSTEM statement, SAD 7-9

ARCHIVE LOG START statement

automatic archiving, SRF 1-55

ARCHIVE LOG statement, PSA 13-4

LIST option, SAD 6-15

archive logs

backing up with RMAN, PSA 13-8

archive mode

switch, PSA 3-8

archive processes, SAD 4-12

archive tracing

and standby databases, SBY 4-6

ARCHIVE_DEST_n initialization parameter

downgrading, MIG 13-47

archived redo logs, SAD 7-2, SBR 2-14, SBR 2-23, SCN 1-47

accessing information about, SBY 4-5, SBY 4-9

ALTER SYSTEM ARCHIVE ALL statement, SBR 1-19

analyzing, SAD 7-26

from other databases, MIG 9-44

and standby databases, SBY 4-5

applying during media recovery, SBR 5-9, SBR 5-12

archiving modes, SAD 7-6

automatic archiving, SCN 360

automatic versus manual, SRF 1-61

automating application, SBR 5-11

backing up, RMN 5-20

using RMAN, RMN 5-9, RMN 5-10

cataloging, RMN 3-9

checking status of, SBY 1-26

compatibility, MIG 9-42

copies, listing, RMN 4-2

definition, SBR 1-10

deleting after recovery, SBR 5-7

destination file, SRF 1-55

destination states, SAD 7-12, SBY 2-18

active/inactive, SAD 7-13

bad param, SAD 7-14

deferred, SAD 7-13

enabled/disabled, SAD 7-13

valid/invalid, SAD 7-13

destinations

re-archiving to failed, SAD 7-19, SBY 2-18

sample scenarios, SAD 7-17

displaying information, SBR 2-16

enabling, SCN 359

enabling automatic archival, SBR 2-20

enabling automatic archiving, SAD 7-7

errors during recovery, SBR 5-14

failed destinations and, SAD 7-16

location during recovery, SBR 5-9

location of, SQL 7-13

loss of, SBR 6-11

manual archiving, SCN 361

multiplexing, SAD 7-10, SBR 2-21, SBY 2-16, SBY 5-7

normal transmission of, SAD 7-14, SBR 2-23

rearchiving, MIG 9-42

restoring to disk, SBR 5-6

restoring using RMAN, RMN 6-14

RMAN fails to delete, RMN 9-30

specifying destinations for, SAD 7-10, SBR 2-21

standby transmission of, SAD 7-14, SBR 2-23

status information, SAD 7-23, SBR 2-4, SBR 2-16

storage device, SRF 1-55, SRF 1-58

storage locations, SQL 7-89, SQL 7-112

transmitting, SAD 7-14, SBR 2-23, SBY 3-13

tuning, SAD 7-19

using for recovery

in non-default location, SBR 5-10

ARCHIVELOG clause

of ALTER DATABASE, SQL 7-9, SQL 7-18

of CREATE CONTROLFILE, SQL 7-266

ARCHIVELOG mode, PSA 3-2, PSA 3-8, SAD 7-4, SBR 2-18, SRF 1-55

advantages, SAD 7-4, SBR 2-19

archiver process (ARCn) and, SCN 1-18, SCN 8-12, SCN 359

archiving, SAD 7-3, SBR 2-17

archiving destination, SRF 1-55, SRF 1-58

automatic archiving, PSA 13-3, PSC 1-5, SRF 1-61

automatic archiving in, SAD 7-5

backup strategies when using, SBR 3-5

changing mode, PSA 3-2, PSA 3-8, PSC B-3

creating a database, PSA 3-2

datafile loss in, SBR 6-3

defined, SCN 359

definition of, SAD 7-4, SBR 2-18

distributed databases, SAD 7-5, SBR 3-9

enabling, SAD 7-6

manual archiving in, SAD 7-5

online and offline backups, PSA 13-3, PSC 1-5

overview, SBR 1-11, SCN 1-47

partial database backups, SCN 1-49, SCN 366

running in, SAD 7-4, SBR 2-18

strategies for backups in, SBR 3-5

switching to, SAD 7-6

taking datafiles offline and online in, SAD 10-8

whole database backups, SCN 365

archivelog process (ARCn)

tracing, SAD 7-25

archivelogRecoverSpecifier clause (RMAN), RMN 10-18

archiver, SAD 4-12

archiver process (ARCn)

automatic archiving, SCN 360

described, SCN 1-18, SCN 8-12

example, SCN 359

multiple processes, SCN 1-18, SCN 8-13

not used for manual archiving, SCN 362

trace file, SCN 361

archiving

advantages, SAD 7-3, SBR 2-17

after inconsistent closed backups, SBR 1-19

after open backups, SBR 1-19

ALTER SYSTEM ARCHIVE ALL statement, SBR 1-19

automatic

disabling, SAD 7-8

disabling at instance startup, SAD 7-8

enabling, SAD 7-7

enabling after instance startup, SAD 7-8

enabling at instance startup, SAD 7-8

changing archiving mode, SAD 7-6

destination states, SAD 7-12, SBY 2-18

active/inactive, SAD 7-13

enabled/disabled, SAD 7-13

valid/invalid, SAD 7-13

destinations

failure, SAD 7-16

disabling, SAD 7-6, SAD 7-8

disadvantages, SAD 7-3, SBR 2-17

enabling, SAD 7-6, SAD 7-8

error detection behavior, MIG 9-43

increasing speed of, SAD 7-22

manual, SAD 7-9

minimizing impact on system performance, SAD 7-22

multiple ARCH processes, SAD 7-20

privileges

disabling, SAD 7-8

enabling, SAD 7-7

for manual archiving, SAD 7-9

setting archive buffer parameters, SAD 7-21

setting initial mode, SAD 7-6

to failed destinations, SAD 7-19, SBY 2-18

trace, controlling, SAD 7-25

tuning, SAD 7-19

viewing information on, SAD 7-23, SBR 2-4, SBR 2-16

archiving redo log files, PSA 13-1

automatic versus manual, PSA 13-4

creating a database, PSA 3-2

forcing a log switch, PSA 13-15

history, PSA 13-7

identified in control file, PSC 7-5

log sequence number, PSA 13-6

online archiving, PSA 13-3, PSC 1-5

ARCHVIELOG clause

OF CREATE DATABASE, SQL 7-270

ARCn background process, SCN 1-18, SCN 8-12

See also archiver process

ARGS parameter, NET B-3

arguments

attributes, OCI 6-16

arguments of operators, SQL 3-1

ARGV0 parameter, NET B-3

arithmetic operators, SQL 3-3

array fetches, DDS 9-10

agents, DDS 9-11

array interface, STU 22-16

array of structs, PC_ 8-17, PC_ A-2

array processing, SCN 23

ARRAYLEN statement, PC_ 7-17, PCO 6-17

arrays, ADO 9-26

batch fetch, PC_ 8-5

BIND_ARRAY procedure, SPR 51-6

binds, OCI 12-3

bulk DML using DBMS_SQL, SPR 51-15

bulk operations (ANSI dynamic SQL), PC_ 14-8

chapter discusses how to use, PC_ 8-1

committing after insert

Import, SUT 2-19

defines, OCI 12-6

definition of, PC_ 4-41

host arrays, PC_ 2-7

operations, PC_ 2-7

size of VARRAYs, ADO 1-8, SCN 13-11

skip parameter for, OCI 5-24

variable (VARRAYs), ADO 1-8, SCN 13-11

varying length, PC_ 18-3

arrays of structures, OCI 5-22

indicator variables, OCI 5-25

OCI calls used, OCI 5-25

skip parameters, OCI 5-23

AS 'filespec' clause

of CREATE LIBRARY, SQL 7-317

AS clause

of CREATE JAVA, SQL 7-314

AS EXTERNAL clause

of CREATE FUNCTION, SQL 7-289, SQL 7-357

of CREATE TYPE BODY, SQL 7-450

AS OBJECT clause

of CREATE TYPE, SQL 7-440

AS SELECT option

CREATE TABLE statement, SBR 5-3

AS subquery

of CREATE MATERIALIZED VIEW / SNAPSHOT, SQL 7-319, SQL 7-328

of CREATE TABLE, SQL 7-409

of CREATE VIEW, SQL 7-459

AS TABLE clause

of CREATE TYPE, SQL 7-444

AS VARRAY clause

of CREATE TYPE, SQL 7-444

ASACC precompiler option, PCO 14-12

ASC clause

of CREATE INDEX, SQL 7-299

ascending indexes, SQL 7-299

ASCII

character set, SQL 2-34

Import, SUT 2-53

fixed-format files

exporting, SUT 1-3

ASCII character set

sorting order, NLS 2-28

ASCII function, SQL 4-14

ASIN function, SQL 4-15

A.SMD record, NET 7-11, NET 11-14, NET A-42

ASP, ADO 3-9

ASR. See Advanced Symmetric Replication (ASR).

assigning

one collection to another collection in temporary LOBs, ADL 10-11

one temporary LOB to another, ADL 10-10

assigning new pincode to SecurID card, OAS 7-12

assigning object classes to entries, OID 6-3

assignment operator, PLS 1-4

assignment statement

syntax, PLS 11-3

assignment tables, REP 3-11

assignments

aggregate, PLS 2-34

character string, PLS B-2

collection, PLS 4-11

cursor variable, PLS 5-32

field, PLS 4-47

record, PLS 4-47

semantics, PLS B-2

ASSOCIATE STATISTICS statement, SQL 7-210

Associating the Extensible Optimizer Methods with Database Objects, DCI 11-62

association operator, PLS 7-13

associations

downgrading, MIG 13-43

associative interface, PC_ 17-4

when to use, PC_ 17-4

ASSUME_SQLCODE precompiler option, PCO 14-13

AST

definition of, PSC 5-27

ASTERISK - oracle.xml.parser.v2.ElementDecl.ASTERISK, JPR 4-32

asterisk (*) row operator, PLS 5-3

asymmetrical multiprocessing, PSC 8-12

Asynchronous, ADQ 1-12

asynchronous (challenge-response) authentication mode in RADIUS, OAS 4-6

asynchronous I/O, DWG 18-26

parallel recovery and, SCN 352

asynchronous lock operations

analyzing, PSA 12-17

Asynchronous Notifications, ADQ 8-77

asynchronous operations, PLS 8-17

asynchronous processing, SCN 66

asynchronous replication, REP 2-29

asynchronous trap, PSC 5-29

asynchronous traps, PSC 5-27, PSC 5-30

Asynchronously Receiving Message w/ Message Listener, ADQ 12-82

AT clause

CONNECT statement, PCO 3-6

DECLARE CURSOR statement, PCO 3-7

DECLARE STATEMENT statement, PCO 3-8

EXECUTE IMMEDIATE statement, PCO 3-8

in CONNECT statement, PC_ 3-9

in DECLARE CURSOR statement, PC_ 3-10

in DECLARE STATEMENT statement, PC_ 3-12

in EXECUTE IMMEDIATE statement, PC_ 3-11

of COMMIT statement, PC_ F-25, PCO F-16

of CONNECT statement, PCO F-18

of DECLARE CURSOR directive, PC_ F-36, PCO F-24

of DECLARE STATEMENT directive, PC_ F-39, PCO F-28

of EXECUTE IMMEDIATE statement, PC_ F-57, PCO F-45

of EXECUTE statement, PC_ F-52, PCO F-40

of INSERT statement, PC_ F-69

of INSERT statements, PCO F-56

of SAVEPOINT statement, PC_ F-102, PCO F-79

of SELECT statement, PC_ F-105, PCO F-82

of SROLLBACK statement, PC_ F-99

of UPDATE statement, PC_ F-113, PCO F-87

restriction on, PC_ 3-11

restrictions, PCO 3-7

use of, PC_ 3-10

ATAN function, SQL 4-15

ATAN2 function, SQL 4-16

atomic nullness, OCI 10-29

atomic nulls, ADO 2-2, SUT 5-94

atomically null, PLS 9-23

attack

data modification, OAS 2-5

replay, OAS 2-5

Attempts Per Names Server field, NET 6-63

AttListDecl - oracle.xml.parser.v2.XMLToken.AttListDecl, JPR 4-135

AttName - oracle.xml.parser.v2.XMLToken.AttName, JPR 4-136

ATTRDECL - oracle.xml.parser.v2.XMLNode.ATTRDECL, JPR 4-106

Attribute - oracle.xml.parser.v2.XMLToken.Attribute, JPR 4-136

ATTRIBUTE clause

of ALTER DIMENSION, SQL 7-26

of CREATE DIMENSION, SQL 7-280

attribute descriptor object, OCI 11-23

attribute indexes, created by bulkload, OID 7-29

attribute indicator, PLS 1-7

attribute syntax, OID 2-6

attribute values, size, OID F-8

attribute-level conflicts, OID 10-25

attributes, DWG 9-7, PLS 1-7

%ROWTYPE, PLS 2-33

%TYPE, PLS 2-32

adding, OID 6-18

by using ldapadd, OID A-7

by using ldapmodify, OID 6-31

by using Oracle Directory Manager, OID 6-24, OID 6-28

concurrently, using ldapaddmt, OID A-9

guidelines for, OID 6-18

to existing entries, OID A-7

adding to a dimension, SQL 7-27

AlternateServers, for failover, OID 14-4

as DNs, OID 7-11

base schema

deleting, OID 6-19

modifying, OID 6-19

c, NET 2-40

cn, NET 2-40

commonName, NET 2-40, OID 2-5

configuration set entry, OID F-5

country, NET 2-40

cursor, PLS 5-35

defined, NET 2-40

deleting, OID 6-19, OID A-13

guidelines for, OID 6-19

values, using ldapmodify, OID A-13

determined by object classes, OID 6-2

domain component, NET 2-40

dropping from a dimension, SQL 7-27

dropping indexes from, OID 6-31

in base schema, OID 6-18

in LDIF files, OID A-2

indexed, OID 6-12, OID 6-30

indexing, OID 6-34

by using command line tools, OID 6-33

using Oracle Directory Manager, OID 6-30

inheritance of, OID 6-2, OID 6-12

jpegPhotos, OID 2-5, OID 7-26

kinds of information in, OID 2-4

leaf-level, ADO 7-1

leaf-level scalar, ADO 7-1

making available for searches, OID 6-30

managing

by using Oracle Directory Manager, OID 6-19

overview, OID 6-18

using command line tools, OID 6-31

mandatory, OID 2-7, OID 6-2, OID 7-22

matching rules, OID 2-6

maximum number of in object type, SQL 7-392, SRF 4-2

modifying

guidelines for, OID 6-18

rules for, OID 6-18

using command line tools, OID 7-25

using ldapmodify, OID 6-31

multi-valued, OID 2-4, OID 9-3

converting to single-valued, OID 6-19

null, SUT 5-93

null values in, OID 6-2

o, NET 2-41

object, PLS 9-3, PLS 9-7

object types, SCN 13-2, SCN 13-4

objectclass, OID 5-25

objects associated with an ACI, OID 9-6

of dimensions, defining, SQL 7-280

of handles, OCI 2-13

of object types, ADO 1-3

of objects, OCI 10-17

of parameter descriptors, OCI 6-5

of parameters, OCI 6-5

optional, OID 2-7, OID 6-2

orclauditlevel, OID 5-28

orclauditmessage, OID 5-25

orclauditoc, OID 5-25

orclDBDistinguishedName, OAS E-2

orclDBGlobalName, OAS E-2

orclDBNativeUser, OAS E-2

orclDBRoleOccupant, OAS E-2

orclDBServerMember, OAS E-2

orclDBServerRole, OAS E-2

orclDBTrustedDomain, OAS E-2

orclDescList, NET D-5

orclDescName, NET D-5

orcleventtime, OID 5-25

orcleventtype, OID 5-25

orclLoadBalance, NET D-5

orclNetAddrList, NET D-5

orclNetAddrString, NET D-5

orclNetConnParamList, NET D-5

orclNetFailover, NET D-5

orclNetInstanceName, NET D-5

orclNetProtocol, NET D-5

orclNetProtocolStack, NET D-5

orclNetSdu, NET D-5

orclNetServiceName, NET D-5

orclNetSourceRoute, NET D-5

orclopresult, OID 5-25

orclsequence, OID 5-25, OID 5-26

orclSid, NET D-5

orcluserdn, OID 5-25

orclVersion, NET D-5

organization, NET 2-41, OID 2-5

organizationalUnitName, OID 2-5

organizationUnitName, NET 2-41

ou, NET 2-41

redefining mandatory, OID 6-3

searching for, by using Oracle Directory Manager, OID 6-19

single-valued, OID 2-4

converting to multi-valued, OID 6-19

size of values, OID F-8

sn, OID 2-5

specifying as mandatory or optional, OID 6-2

stored in schema, OID 2-10

surname, OID 2-5

syntax, OID 2-6

syntaxes

cannot modify, OID 6-19

selecting, OID 6-32

system operational, OID 5-15

tab page in Oracle Directory Manager, OID 6-10

types, OID 2-3

values, OID 2-3

rules for changing, OID 7-22

viewing, OID 7-11

attributes for resources

client resource, LEG 2-20, LEG 2-21, LEG 2-22, LEG 2-23

server resource, LEG 2-26, LEG 2-27

storage device resource, LEG 3-5

volume pool resource, LEG 3-12

attributes of a collection

descriptions, PC_ 18-15

attributes of object type, DCI 1-15, DCI 11-2

referencing in method, DCI 5-5

attributes of object types, SCN 13-4

Attributes of Viiew, ADQ 10-1

attributes, USERENV, ADG 11-43

AttValue - oracle.xml.parser.v2.XMLToken.AttValue, JPR 4-136

AUD, SMS 47-1

AUDIT (Schema Objects) statement, SQL 7-221

AUDIT ANY system privilege, SQL 7-529

audit levels, OID 5-27

audit log, OID 5-24

cleaning up entries, OID 5-24

container object, OID 5-30

default configuration, OID 5-24

entries

position in DIT, OID 5-26

searching, OID 5-24, OID 5-26

viewing, OID 5-24

queries, OID 5-24

sample, OID 5-26

schema elements, OID F-4

structure of entries, OID 5-25

using, OID 5-24

audit log events

access violation, OID 5-27

ACL modification, OID 5-27

add, OID 5-27

bind, OID 5-27

deleting, OID 5-27

DSE modification, OID 5-27

modify, OID 5-27

modifyDN, OID 5-27

replication login, OID 5-27

schema element

add/replace, OID 5-27

delete, OID 5-27

selected, OID 5-28

super user

login, OID 5-27

user password modification, OID 5-27

AUDIT sql_statements statement, SQL 7-213

AUDIT statement, SAD 24-9, SCN 13

BY proxy clause, SAD 24-11

locks, SCN 240

schema objects, SAD 24-10

statement auditing, SAD 24-10

system privileges, SAD 24-10

AUDIT SYSTEM system privilege, SQL 7-521

audit trail, SAD 24-14, STU 11-4

archiving, SAD 24-15

auditing changes to, SAD 24-17

controlling size of, SAD 24-14

creating and deleting, SAD 24-4

deleting views, SAD 24-5

described, NET 12-25

dropping, SAD 24-4

interpreting, SAD 24-17

maximum size of, SAD 24-14

protecting integrity of, SAD 24-16

purging records from, SAD 24-15

recording changes to, SAD 24-17

records in, SAD 24-7

reducing size of, SAD 24-16

script for using information, NET 12-26

table that holds, SAD 24-2

views on, SAD 24-4

AUDIT_ACTIONS table, SRF 2-93

AUDIT_FILE_DEST initialization parameter, SRF 1-14

AUDIT_TRAIL initialization parameter, SRF 1-15

migration, MIG A-3

setting, SAD 24-13

auditable events, OID 5-27

auditing, SAD 24-2, SCN 1-43, SCN 329

audit option levels, SAD 24-8

audit options, SCN 331

audit records, SCN 331

AUDIT statement, SAD 24-9

audit trail records, SAD 24-5

audit trails, SCN 331

database, SCN 331

operating system, SCN 333, SCN 334

by access, SCN 339

mandated for, SCN 340

by session, SCN 338

prohibited with, SCN 340

compromised by One Big Application User, ADG 11-6

conflict resolution, RAR 6-29

connect with administrator privileges, SCN 333

data dictionary used for, SCN 2-5

database and OS usernames, SCN 282

database links, DDS 1-31

DDL statements, SCN 335

default options, SAD 24-10

deleting data in dictionary, SCN 2-5

described, SCN 1-43, SCN 330

disabling default options, SAD 24-13

disabling options, SAD 24-11, SAD 24-12, SAD 24-13

disabling options versus auditing, SAD 24-12

distributed databases and, SCN 334

DML statements, SCN 335

enabling options, SAD 24-9, SAD 24-13

about, SAD 24-9

privileges for, SAD 24-13

enabling options versus auditing, SAD 24-9

guidelines, SAD 24-2

historical information, SAD 24-4

keeping information manageable, SAD 24-2

managing the audit trail, SAD 24-4

multi-tier environments, SAD 24-11

n-tier systems, ADG 11-66, ADG 11-71

operating-system audit trails, SAD 24-7

options

for database objects, SQL 7-215

for SQL statements, SQL 7-218

partitioned tables and indexes, SCN 11-63

policies for, SAD 21-19

privilege audit options, SAD 24-8

privilege use, SCN 330, SCN 335

privileges required for object, SAD 24-11

privileges required for system, SAD 24-10

range of focus, SCN 331, SCN 337

schema object, SCN 330, SCN 336

schema objects, SAD 24-10

stopping, SQL 7-552

security and, SCN 334

session level, SAD 24-8

SQL statements, SQL 7-215

SQL statements, stopping, SQL 7-550

startup and shutdown, SCN 333

statement, SAD 24-10, SCN 330, SCN 335

statement level, SAD 24-8

successful executions, SCN 337

suspicious activity, SAD 24-3

system privileges, SAD 24-10

transaction independence, SCN 332

triggers and, ADG 13-34, SAD 24-20, SAD 24-21

types of, SCN 330

unsuccessful executions, SCN 337

user, SCN 340

using the database, SAD 24-2

viewing

active object options, SAD 24-19

active privilege options, SAD 24-19

active statement options, SAD 24-18

default object options, SAD 24-19

views, SAD 24-4

when options take effect, SCN 333

auditing selected events, OID 5-28

authenticated access, using SSL, OID 1-5

AUTHENTICATED BY clause

CREATE DATABASE LINK statement, DDS 2-16

of CREATE DATABASE LINK, SQL 7-275

authenticated RPC

protocol adapter includes, OAS 12-3

authenticating remote clients, SRF 1-103

authenticating users, SRF 1-90

authentication, OAS 1-6, OAS 1-11, OID 2-20, OID 2-21, OID 2-33

anonymous, OID 1-5, OID 2-21, OID 4-4

in access control, OID 9-24, OID 9-30

biometric, OAS 8-1

by database, SAD 22-8

by SSL, SAD 22-7, SAD 22-12

certificate-based, OID 1-5, OID 2-22

compromised by One Big Application User, ADG 11-6

configuring multiple methods, OAS 11-4

database administrators, SCN 291

database links, DDS 1-25

described, SCN 281

directory service, SAD 22-12

external, SAD 22-9

global, SAD 22-11

in Oracle Internet Directory, OID 1-5

Kerberos, OID A-8, OID A-10, OID A-16

middle tier, ADG 11-4, ADG 11-64, ADG 11-65, ADG 11-66, ADG 11-67

modes in RADIUS, OAS 4-5

multi-tier, SAD 22-13, SCN 287

network, SCN 282

no SSL, OID 4-6

none, in access control, OID 9-24, OID 9-30

n-tier systems, ADG 11-69

one-way SSL, OID 2-22

operating system, SAD 1-7, SCN 282

options, OID 2-21

Oracle, SCN 285

parameters, OID F-5

password file, SAD 1-9

password policy, SAD 21-5

password-based, OID 1-5, OID 2-21, OID 4-4

PKI, OID 2-21

public key infrastructure, SCN 283

remote, SCN 285

simple, OID 1-5, OID 4-4

for access control subjects, OID 9-24, OID 9-30

specifying for access control subjects, OID 9-23, OID 9-30

specifying no SSL, OID F-5

specifying when creating a user, SAD 22-15

SSL, OID 2-22, OID A-7, OID A-8, OID A-10, OID A-11, OID A-15

for Oracle Directory Manager, OID 4-6

one-way, OID F-5

server only, OID 4-6

two-way, OID 4-6

strong, OID 2-21

two-way SSL, OID 2-22, OID F-5

users, SAD 21-2

ways to authenticate users, SAD 22-7

authentication management, OCI 8-12

authentication methods

CyberSAFE, NET 4-26

Identix, NET 4-26

Kerberos, NET 4-26

NDS, NET 4-25

Novell Directory Services, NET 4-25

RADIUS, NET 4-26

SecurID, NET 4-26

SSL, NET 4-26

Windows NT native authentication, NET 4-25

AUTHENTICATION_DATA attribute, ADG 11-44

AUTHENTICATION_LEVEL parameter, NET C-73

AUTHENTICATION_TYPE attribute, ADG 11-44

AUTHID clause, PLS 7-4, PLS 7-6, PLS 7-31

AUTHID CURRENT_USER clause

of ALTER JAVA, SQL 7-46

of CREATE FUNCTION, SQL 7-288

of CREATE JAVA, SQL 7-313

of CREATE PACKAGE, SQL 7-345

of CREATE PROCEDURE, SQL 7-357

of CREATE TYPE, SQL 7-188, SQL 7-441

AUTHID DEFINER clause

of ALTER JAVA, SQL 7-46

of CREATE FUNCTION, SQL 7-288

of CREATE JAVA, SQL 7-313

of CREATE PACKAGE, SQL 7-345

of CREATE PROCEDURE, SQL 7-357

of CREATE TYPE, SQL 7-188, SQL 7-441

authorization, OAS 1-10, OID 2-20, OID 2-25

changing for roles, SAD 23-7

global, SAD 22-11

omitting for roles, SAD 23-7

operating-system role management and, SAD 23-9

roles

about, SAD 23-8

multi-threaded server and, SAD 23-9

authorization ID, OID 2-21

authorize functions, OCI 15-90

authorize template users, RAR 4-10

auto media management

enabled behavior, LEG 3-19

for tape devices, LEG 3-19

not enabled, LEG 3-19, LEG 3-23

AUTO_CONNECT, PC_ 10-11

precompiler option, PC_ 3-5

AUTO_CONNECT option

instead of CONNECT statement, PCO 3-10

AUTO_CONNECT precompiler option, PC_ 10-11, PCO 14-14

AUTOEXTEND, PSA 9-5

AUTOEXTEND clause

for datafiles, SQL 7-17

of ALTER DATABASE, SQL 7-10

of ALTER TABLESPACE, SQL 7-177, SQL 7-179

of CREATE DATABASE, SQL 7-268

of CREATE TABLESPACE, SQL 7-419, SQL 7-421

of CREATE TEMPORARY TABLESPACE, SQL 7-424, SQL 7-425

AUTOLOCATE

RMAN option, PSA 13-11

Automated, ADQ 1-15

automated parallel query tuning, GTK 3-27

automated standby databases, GTK 3-50

automatic archival, GTK 3-50

read-only databases, GTK 3-51

automatic archiving, PSA 13-4

automatic bootstrap backup, LEG 2-5, LEG 4-8

automatic connections, PC_ 3-4, PC_ 3-8

automatic logons, PCO 3-5, PCO 3-9

automatic recovery, PSA 13-8

AUTOMATIC_IPC parameter, MIG F-14, NET 8-21, NET C-80

autonomous PL/SQL blocks, GTK 3-78

autonomous routine, ADG 7-32

autonomous scope

versus autonomous transaction, ADG 7-32

autonomous transactions, ADG 7-32 to ADG 7-40, PLS 5-52

advantages, PLS 5-52

compatibility, MIG 9-13

controlling, PLS 5-56

autonomous triggers, PLS 5-58

AUTONOMOUS_TRANSACTION, ADG 7-32

AUTONOMOUS_TRANSACTION pragma, PLS 5-53

syntax, PLS 11-7

AUTORECOVERY option

SET statement, SBR 5-11

auxiliary

object class type, OID 2-9

object classes, OID 6-4

auxiliary databases

for RMAN TSPITR

converted filenames, RMN 8-15

using datafile copies, RMN 8-14

auxiliary sets

for RMAN TSPITR, RMN 8-4

naming datafiles in tablespaces, RMN 8-13

Availability, ADQ 5-2

availability

and interconnect, PSC 2-5

benefit of parallel databases, PSC 1-3

capacity planning, PSC 9-4

data files, PSA 14-4, PSC 7-2

measuring, PSC 9-2

shared disk systems, PSC 2-6

single-node failure, PSA 14-2

steps of recovery, PSA 14-5

availability, capabilities in Oracle Internet Directory, OID 14-7

available option (RMAN)

change command, RMN 3-13

available()

as a function of UTL_TCP, SPR 66-5

average conflict resolution method, REP 5-16

Average Elapsed Time data view, STU 14-11

average latency, OID 13-2

AVG aggregate function, PLS 5-3

AVG function, SQL 4-16

avoiding dangerous backup techniques, SBR 3-10

AY date format element, SQL 2-46