---

O

O2F, SMS 35-1

O2I, SMS 36-1

O2U, SMS 37-1

O7_DICTIONARY_ACCESSIBILITY parameter, SRF 1-13

compatibility, MIG 8-24, MIG B-8

OBJ synonym for USER_OBJECTS, SRF 2-174

object, PLS 9-4

declaring, PLS 9-22

initializing, PLS 9-23

manipulating, PLS 9-30

sharing, PLS 9-27

object access expressions, SQL 5-10

object applications

commit, OCI 13-14

database connection, OCI 10-10

rollback, OCI 13-14

object attribute, PLS 9-3, PLS 9-7

accessing, PLS 9-24

allowed datatypes, PLS 9-7

maximum number, PLS 9-7

object cache, ADL 2-14, GTK 2-35, GTK 2-36, GTK 3-12, OCI 13-2, PC_ 17-4, SQL 7-86, SQL 7-107

coherency, OCI 13-4

consistency, OCI 13-4

flushing an object, ADG 19 - 13

initializing, OCI 10-10

loading objects, OCI 13-7

LOBs, ADL 2-14

memory parameters, OCI 13-5

object views, SCN 15-4

OCI, SCN 13-14

operations on, OCI 13-6

privileges, SCN 14-16

Pro*C, SCN 13-14

removing objects, OCI 13-7

setting the size of, OCI 13-5

object columns, indexes on, ADG 6 - 7

object constructor

calling, PLS 9-25

passing parameters to, PLS 9-26

OBJECT CREATE SQL statement, PC_ 17-9, PC_ F-84

Object Database Designer, GTK 3-13

OBJECT DELETE SQL statement, PC_ 17-11, PC_ F-85

OBJECT DEREF SQL statement, PC_ 17-10, PC_ F-86

OBJECT FLUSH SQL statement, PC_ F-87

OBJECT FLUSH SQL statements, PC_ 17-12

object functions

See navigational functions.

server roundtrips, OCI C-4

OBJECT GET SQL statement, PC_ 17-16, PC_ F-88

object identifier

for persistent objects, OCI 10-5

object identifier (OID)

with CREATE TYPE, DCI 3-3

OBJECT IDENTIFIER clause

of CREATE TABLE, SQL 7-377

object identifiers, ADG 16 - 28, SCN 15-3, SUT 2-57

contained in REFs, SQL 2-26

Export, SUT 1-56

for object types, SCN 14-18

for object views, SCN 15-3, SCN 15-4

of object views, SQL 7-433

primary key, SQL 7-377

primary-key based, ADG 18 - 8

REFs, ADG 18 - 9

specifying, SQL 7-377

specifying an index on, SQL 7-377

storage, ADG 18 - 8

system-generated, SQL 7-377

WITH OBJECT OID clause, SCN 15-3, SCN 15-4

object method, PLS 9-3, PLS 9-8

calling, PLS 9-26

object names

resolving partial, DDS 2-17

SQL*Loader, SUT 5-18

object privileges, SCN 30-3

granting, SQL 7-343

multiple, SQL 7-347

on specific columns, SQL 7-506

to a role, SQL 7-505

to a user, SQL 7-505

to PUCLIC, SQL 7-506

on a database object

revoking, SQL 7-534

on a directory

revoking, SQL 7-533

revoking

all, from a user, SQL 7-533

from a role, SQL 7-532, SQL 7-533

from a user, SQL 7-532, SQL 7-533

from all users, SQL 7-534

from PUBLIC, SQL 7-533

See also schema object privileges

object reference, OCI 10-33

object reference functions, SQL 4-4

object reference. See REF

object relational enhancements, GTK 2-33 to GTK 2-37

ANALYZE command, dangling REFs, GTK 2-36

collection unnesting, GTK 2-35

object cache enhancements, GTK 2-36

object identifiers, user defined, GTK 2-34

object views, GTK 2-35

parallel query support, GTK 2-37

partitioning of tables containing user-defined types, GTK 2-37

referential integrity constraint on REF column, GTK 2-34

SQL*Loader support, GTK 2-36

value subqueries, GTK 2-36

see also LOBs

see also nested tables

see also varrays

OBJECT RELEASE SQL statement, PC_ F-89

object runtime environment

initializing, OCI 10-10

OBJECT SET SQL statement, PC_ 17-14, PC_ F-90

object support, SUT 3-23

object support in OO4O, ADG 1 - 17

object table, PLS 9-30

object tables, ADG 16 - 26, ADG 18 - 8, SCN 13-3, SCN 13-7

adding rows to, SQL 7-513

constraints, SCN 14-5

creating, SQL 7-358

deleting values, ADG 16 - 41

Import, SUT 2-58

indexes, SCN 14-6

inserting values, ADG 16 - 36

loading, SUT 5-96

partitioned

downgrading, MIG 12-16

querying, ADG 16 - 39

row objects, SCN 13-8

triggers, SCN 14-6

virtual object tables, SCN 15-2

object type, DCI 1-8, PLS 9-1, PLS 9-3

advantages, PLS 9-5

attributes, DCI 1-15, DCI 11-2

body code, DCI 1-16

comparisons, DCI 3-5

defining, PLS 9-12

examples, PLS 9-12

methods, DCI 11-2

specification, DCI 1-15

structure, PLS 9-5

syntax, PLS 11-105

object type bodies

creating, SQL 7-422

re-creating, SQL 7-422

SQL examples, SQL 7-424

object type definitions

exporting, SUT 1-56

importing, SUT 2-58

object type identifiers, SUT 2-30

object type tables

creating, SQL 7-367

Object Type Translator, GTK 3-12

object type translator

sample output, OCI 10-9

See OTT

use with OCI, OCI 10-8

Object Type Translator (OTT), PC_ A-4

command line, PC_ 19-6

command line syntax, PC_ 19-26

creating types in the database, PC_ 19-5

datatype mappings, PC_ 19-10

default name mapping, PC_ 19-38

outtype file, PC_ 19-17

parameters, PC_ 19-27 to PC_ 19-31

providing an intype file, PC_ 19-8

reference, PC_ 19-25

restriction, PC_ 19-39

using, PC_ 19-1, PC_ 19-2

using with Pro*C/C++, PC_ 19-22

object type values

comparing, SQL 7-417, SQL 7-423

Object Types, PC_ A-3

object types, GTK 3-11, SCN 1-22, SCN 13-2, SCN 13-4, SQL 2-26

adding new member subprograms, SQL 7-174

associating functions or procedures, SQL 7-174

attributes, SQL 2-77

attributes of, SCN 13-2, SCN 13-4

column objects, SCN 13-8

indexes, SCN 14-6

column objects vs. row objects, ADG 18 - 2

comparison methods for, ADG 16 - 22, SCN 13-6

comparison rules, SQL 2-30

MAP function, SQL 2-30

ORDER function, SQL 2-30

compiling the specification and body, SQL 7-174

components of, SQL 2-26

constructor methods for, SCN 1-57, SCN 13-6, SCN 14-18

creating, SQL 7-411, SQL 7-413

defining member methods of, SQL 7-422

disassociating statistics types from, SQL 7-480

dropping the body of, SQL 7-482

dropping the specification of, SQL 7-480

function subprogram

declaring, SQL 7-423

function subprogram of

specifying, SQL 7-416

function subprograms of, SQL 7-415, SQL 7-422

incomplete, ADG 16 - 16, SCN 14-17, SQL 7-413

invoker-rights, ADG 18 - 30

locking in cache, SCN 13-15

message queuing, SCN 19-6

methods, SQL 2-77

methods of, ADG 16 - 23, SCN 1-57, SCN 13-4

method calls, SCN 14-9

PL/SQL, SCN 13-14

purchase order example, SCN 13-2, SCN 13-5

mutually dependent, SCN 14-16

object views, SCN 10-16

Oracle type translator, SCN 13-15

parallel query, SCN 26-29

restrictions, SCN 26-30

procedure subprogram

declaring, SQL 7-423

procedure subprogram of

specifying, SQL 7-416

procedure subprograms of, SQL 7-415, SQL 7-422

purchase order example, SCN 13-2, SCN 13-4

restrictions

parallel DDL, SCN 26-31

parallel DML, SCN 26-44

row objects, SCN 13-8

SQL examples, SQL 7-418

statistics types, SQL 7-195

use of table aliases, SCN 14-8

user-defined

creating, SQL 7-414

OBJECT UPDATE SQL statement, PC_ 17-12, PC_ F-91

object views, ADG 17 - 2, GTK 2-35, GTK 3-11, GTK 3-12, SCN 10-16, SCN 15-1

adding rows to the base table of, SQL 7-513

advantages, ADG 17 - 3

advantages of, SCN 15-2

defining, SCN 15-3, SQL 7-430

modifiability, SCN 20-12

nested tables, SCN 15-5

object identifiers for, SCN 15-3, SCN 15-4

updating, ADG 17 - 15, SCN 15-5

use of INSTEAD OF triggers with, SCN 15-5

OBJECT_CACHE_MAX_SIZE_PERCENT parameter, SRF 1-83

of ALTER SESSION, SQL 7-86

of ALTER SYSTEM, SQL 7-107

OBJECT_CACHE_OPTIMAL_SIZE parameter, SRF 1-83

of ALTER SESSION, SQL 7-86

of ALTER SYSTEM, SQL 7-107

OBJECT_INSTANCE column

PLAN_TABLE table, STU 13-4

OBJECT_NAME column

PLAN_TABLE table, STU 13-4

OBJECT_NODE column

PLAN_TABLE table, STU 13-4

OBJECT_OWNER column

PLAN_TABLE table, STU 13-4

OBJECT_TYPE column

PLAN_TABLE table, STU 13-4

object-identifiers

user-defined

downgrading, MIG 12-22

object-oriented programming, PLS 9-1

object-relational DBMS (ORDBMS), SCN 1-22, SCN 13-2

object-relational model, ADG 16 - 1

comparing objects, ADG 18 - 8

constraints, ADG 18 - 39

design considerations, ADG 18 - 1

embedded objects, ADG 16 - 28

implementing with object tables, ADG 16 - 16

inheritance, ADG 18 - 33

limitations of relational model, ADG 16 - 13

methods, ADG 18 - 27

new object format, ADG 18 - 33

partitioning, ADG 16 - 41

programmatic environments for, ADG 19 - 1

replication, ADG 18 - 33

type evolution, ADG 18 - 40

object-relational technology, GTK 3-10

Objects, SUT 3-16

objects, SUT 3-20

accessing with OCI, OCI 14-19, PC_ 19-19

allocation duration, OCI 13-14

altering in a master group, REP 2-28

array pin, OCI 10-13

attributes, OCI 10-17

manipulating, OCI 10-13

client-side cache, OCI 13-2

collection objects, ADG 17 - 6

considerations for Importing, SUT 2-57

copying, OCI 10-32

creating, OCI 10-32

creation errors, SUT 2-48

data dictionary, SRF 2-1

definitions

replication to master sites, REP 2-26

duration, OCI 13-14

flushing, OCI 13-10

flushing changes, OCI 10-14

freeing, OCI 10-32, OCI 13-9

ignoring existing objects during import, SUT 2-24

import creation errors, SUT 2-24

in columns, ADG 17 - 4

introduction to, PC_ 17-2

lifetime, OCI 16-2

loading column objects, SUT 5-91

loading nested column objects, SUT 5-93

LOB attribute of, OCI 7-5

LOB attributes of transient objects, OCI 7-6

locking, OCI 13-12

manipulating with OCI, OCI 14-19, PC_ 19-19

marking, OCI 10-14, OCI 13-9

master groups

generating support for, REP 2-36

memory layout of instance, OCI 13-16

memory management, OCI 13-2

meta-attributes, OCI 10-17

navigation, OCI 13-17

simple, OCI 13-17

NULL values, SUT 5-93

nullness, OCI 10-29

object references, ADG 17 - 8

OCI object application structure, OCI 10-4

persistent, OCI 10-5, OCI 10-6, PC_ 17-4

persistent versus transient copies of, PC_ 17-4

pin count, OCI 10-28

pin duration, OCI 13-14

pinning, OCI 10-12, OCI 13-7

privileges, SUT 2-11

privileges on, SCN 30-11

references to, PC_ 17-2

referencing with synonyms, DDS 2-22

refreshing, OCI 13-11

removing from master groups, REP 2-30

replicated

re-creating, REP 7-32

restoring sets

Import, SUT 2-43

row objects and object identifiers, ADG 17 - 6

secondary memory, OCI 13-16

stream record format, SUT 5-91

support, PC_ 17-1

terminology, OCI 16-2

top-level memory, OCI 13-16

transient, OCI 10-5, OCI 10-7, PC_ 17-4

types, OCI 10-5, OCI 16-2, PC_ 17-2

unmarking, OCI 13-10

unpinning, OCI 10-28, OCI 13-8

use with OCI, OCI 10-3

using object types in Pro*C/C++, PC_ 17-3

variable record format, SUT 5-92

Objects for OLE, GTK 2-86

objects in a database schema, SCN 1-5

See also schema objects

objects owned by SYS

and TSPITR using RMAN, SBR A-6

Objects page

Create New Master Group property sheet, REP 2-19

OBJECTS precompiler option, PC_ 10-33, PC_ 17-20

objects. See object types or database objects.

objects, schema

cascading effects on revoking, SAD 24-15

default tablespace for, SAD 23-13

granting privileges, ADG 12 - 17, SAD 24-10

in a revoked tablespace, SAD 23-14

listing information, ADG 3 - 50

name resolution, ADG 3 - 46

owned by dropped users, SAD 23-16

privileges with, SAD 24-3

renaming, ADG 3 - 48

revoking privileges, ADG 12 - 19, SAD 24-13

when revoking object privileges, ADG 12 - 21

obsolete parameters, SPS A-20, SPS A-21

obsolete parameters in release 8.1, NET 4-20, NET 5-4

obsolete procedures, REP B-13

OCI, SCN 8-25

accessing and manipulating objects, OCI 14-19

advantages, ADG 1 - 8, OCI 1-3

anonymous blocks, SCN 16-17

bind variables, SCN 16-13

compatibility, MIG 8-17

client notification, MIG 8-9

link line, MIG 8-18

thread safety, MIG 8-18

declaring LDA, PCO 3-16

embedding calls, PCO 3-16

interoperability, MIG 8-17

Oracle7 clients, MIG 8-18

shared structures, MIG 8-17

LOB manipulation functions, DCI 6-6

new features, OCI 1-12

object cache, ADG 17 - 23, SCN 13-14

object support, OCI 1-6

OCIChangePassword call, MIG 8-37

OCIObjectFlush, SCN 15-4

OCIObjectPin, SCN 15-4

OCISessionBegin call, MIG 8-37

overview, ADG 1 - 7, OCI 1-2

parts of, ADG 1 - 8, OCI 1-5

stored procedures, SCN 16-18

upgrading applications to Oracle8i, MIG 9-2

using with Oracle Precompilers, PCO 3-16

OCI application

compiling, OCI 1-4

general structure, OCI 2-3

initialization example, OCI 2-24

linking, OCI 1-4

steps, OCI 2-17

structure, OCI 2-3

structure using objects, OCI 10-4

terminating, OCI 2-26

using the OTT with, OCI 14-18

with objects

initializing, OCI 10-10

OCI applications

using the OTT with, PC_ 19-18

OCI calls, PC_ 1-8

embedding, PC_ 5-50

in an X/A environment, PC_ 5-56

OCI enhancements, GTK 2-83

API to append data to LOB, GTK 2-34

AQ support, GTK 2-38

array DMLs, GTK 2-84

asynchronous event notification, GTK 2-84

collection locator, GTK 2-34

direct path load, GTK 2-24

DML returning, GTK 2-83

LOBs, GTK 2-34

NLS interface, GTK 2-43

non-blocking OCI, GTK 2-85

object cache, GTK 2-36

OCI callback registrations, GTK 2-84

OCIDescribeAny, GTK 2-84

Open/Close/IsOpen API for LOBS, GTK 2-34

UCS2 (fixed-width Unicode) support, GTK 2-43

OCI environment

initializing for objects, OCI 10-10

OCI functions

canceling calls, OCI 2-33

codes, OCI 15-230

data cartridges, OCI 2-3

new and updated calls, OCI 1-12

NLS, OCI 2-3

not supported, OCI 1-21

obsolescent, OCI 1-19

return codes, OCI 2-27, OCI 2-29

OCI navigational functions, OCI 13-19

flush functions, OCI 13-20

mark functions, OCI 13-20

meta-attribute accessor functions, OCI 13-20

miscellaneous functions, OCI 13-21

naming scheme, OCI 13-19

pin/unpin/free functions, OCI 13-19

OCI non-deferred linking, GTK 6-4

OCI onblon() call

not used to connect, PC_ 5-50

OCI orlon() call

not used to connect, PC_ 5-50

OCI process

initializing for objects, OCI 10-10

OCI program. See OCI application

OCI relational functions

advanced queuing and publish-subscribe, OCI 15-4

connect, authorize, and initialize, OCI 15-87

guide to reference entries, OCI 18-2

OCI Release 8, PC_ 5-45

accessing and manipulating objects, PC_ 19-19

embedding in Pro*C/C++, PC_ 5-48

interfacing to, PC_ 5-46

parameters in the environment handle, PC_ 5-46

SQLLIB extensions, PC_ 5-45

OCI single-task linking, GTK 6-5

OCI support for client notification, GTK 2-38

see also OCI enhancements, asynchronous event notification

OCI types

declaring, PC_ 17-34

manipulating, PC_ 17-35

OCIDate, PC_ 17-34

OCINumber, PC_ 17-34

OCIRaw, PC_ 17-34

OCIString, PC_ 17-34

using in embedded SQL, PC_ 17-34

OCI_ATTR_ALLOC_DURATION

environment handle attribute, OCI A-4

OCI_ATTR_AUTOCOMMIT_DDL

attribute, OCI 6-20

OCI_ATTR_BUF_ADDR, OCI A-43

OCI_ATTR_BUF_SIZE, OCI A-39, OCI A-43

OCI_ATTR_CACHE

attribute, OCI 6-15

OCI_ATTR_CACHE_ARRAYFLUSH

environment handle attribute, OCI A-3

OCI_ATTR_CACHE_MAX_SIZE

environment handle attribute, OCI A-3

OCI_ATTR_CACHE_OPT_SIZE

environment handle attribute, OCI A-3

OCI_ATTR_CATALOG_LOCATION

attribute, OCI 6-20

OCI_ATTR_CHAR_COUNT

bind handle attribute, OCI A-20

define handle attribute, OCI A-22

use of, OCI 5-28

OCI_ATTR_CHARSET_FORM

attribute, OCI 6-11, OCI 6-14, OCI 6-16

bind handle attribute, OCI A-20

define handle attribute, OCI A-23

OCI_ATTR_CHARSET_ID, OCI A-39, OCI A-46

attribute, OCI 6-11, OCI 6-14, OCI 6-16, OCI 6-18, OCI 6-19

bind handle attribute, OCI A-20

define handle attribute, OCI A-22

OCI_ATTR_CLUSTERED

attribute, OCI 6-7

OCI_ATTR_COL_COUNT, OCI A-42

OCI_ATTR_COLLECTION_ELEMENT

attribute, OCI 6-9

OCI_ATTR_COLLECTION_TYPECODE

attribute, OCI 6-9

OCI_ATTR_COMPLEXOBJECT_ COLL_OUTOFLINE

COR handle attribute, OCI A-25

OCI_ATTR_COMPLEXOBJECT_LEVEL

COR handle attribute, OCI A-25

OCI_ATTR_COMPLEXOBJECTCOMP _TYPE_LEVEL

COR descriptor attribute, OCI A-26

OCI_ATTR_COMPLEXOBJECTCOMP_TYPE

COR descriptor attribute, OCI A-26

OCI_ATTR_CURSOR_COMMIT_ BEHAVIOR

attribute, OCI 6-20

OCI_ATTR_DATA_SIZE, OCI A-47

attribute, OCI 6-10, OCI 6-13, OCI 6-15, OCI 6-16

OCI_ATTR_DATA_TYPE, OCI A-47

attribute, OCI 6-10, OCI 6-13, OCI 6-15, OCI 6-16

OCI_ATTR_DATE_FORMAT, OCI A-39

OCI_ATTR_DATEFORMAT, OCI A-47

OCI_ATTR_DBA

attribute, OCI 6-7

OCI_ATTR_DIRPATH_MODE, OCI A-40

OCI_ATTR_DIRPATH_NOLOG, OCI A-40

OCI_ATTR_DIRPATH_PARALLEL, OCI A-40

OCI_ATTR_DML_ROW_OFFSET, OCI A-6

OCI_ATTR_DURATION

attribute, OCI 6-7

OCI_ATTR_ENCAPSULATION

attribute, OCI 6-11

OCI_ATTR_ENV

server handle attribute, OCI A-9

service context handle attribute, OCI A-7

OCI_ATTR_EXTERNAL_NAME

server handle attribute, OCI A-9

OCI_ATTR_FOCBK

server handle attribute, OCI A-10

OCI_ATTR_HAS_DEFAULT

attribute, OCI 6-17

OCI_ATTR_HAS_FILE

attribute, OCI 6-9

OCI_ATTR_HAS_LOB

attribute, OCI 6-9

OCI_ATTR_HAS_NESTED_TABLE

attribute, OCI 6-9

OCI_ATTR_HW_MARK

attribute, OCI 6-15

OCI_ATTR_IN_V8_MODE

server handle attribute, OCI A-10

service context handle attribute, OCI A-8

OCI_ATTR_INCR

attribute, OCI 6-14

OCI_ATTR_INDEX_ONLY

attribute, OCI 6-7

OCI_ATTR_INTERNAL_NAME

server handle attribute, OCI A-10

OCI_ATTR_IOMODE

attribute, OCI 6-17

OCI_ATTR_IS_CONSTRUCTOR

attribute, OCI 6-11

OCI_ATTR_IS_DESTRUCTOR

attribute, OCI 6-11

OCI_ATTR_IS_INCOMPLETE_TYPE

attribute, OCI 6-9

OCI_ATTR_IS_INVOKER_RIGHTS

attribute, OCI 6-8, OCI 6-10

OCI_ATTR_IS_MAP

attribute, OCI 6-12

OCI_ATTR_IS_NULL

attribute, OCI 6-15, OCI 6-17

OCI_ATTR_IS_OPERATOR

attribute, OCI 6-11

OCI_ATTR_IS_ORDER

attribute, OCI 6-12

OCI_ATTR_IS_PREDEFINED_TYPE

attribute, OCI 6-9

OCI_ATTR_IS_RNDS

attribute, OCI 6-12

OCI_ATTR_IS_RNPS

attribute, OCI 6-12

OCI_ATTR_IS_SELFISH

attribute, OCI 6-12

OCI_ATTR_IS_SYSTEM_GENERATED_TYPE

attribute, OCI 6-9

OCI_ATTR_IS_SYSTEM_TYPE

attribute, OCI 6-9

OCI_ATTR_IS_TEMPORARY

attribute, OCI 6-7

OCI_ATTR_IS_TRANSIENT_TYPE

attribute, OCI 6-9

OCI_ATTR_IS_WNDS

attribute, OCI 6-12

OCI_ATTR_IS_WNPS

attribute, OCI 6-12

OCI_ATTR_LEVEL

attribute, OCI 6-17

OCI_ATTR_LINK

attribute, OCI 6-14, OCI 6-18

OCI_ATTR_LIST_ARGUMENTS

attribute, OCI 6-8, OCI 6-11

OCI_ATTR_LIST_COLUMNS, OCI A-40

attribute, OCI 6-7

OCI_ATTR_LIST_OBJECTS

attribute, OCI 6-19

OCI_ATTR_LIST_SCHEMAS

attribute, OCI 6-19

OCI_ATTR_LIST_SUBPROGRAMS

attribute, OCI 6-8

OCI_ATTR_LIST_TYPE

attribute, OCI 6-18

OCI_ATTR_LIST_TYPE_ATTRS

attribute, OCI 6-10

OCI_ATTR_LIST_TYPE_METHODS

attribute, OCI 6-10

OCI_ATTR_LOBEMPTY

LOB locator attribute, OCI A-25

OCI_ATTR_LOCKING_MODE

attribute, OCI 6-20

OCI_ATTR_MAP_METHOD

attribute, OCI 6-10

OCI_ATTR_MAX

attribute, OCI 6-14

OCI_ATTR_MAX_CATALOG_ NAMELEN

attribute, OCI 6-20

OCI_ATTR_MAX_COLUMN_ NAMELEN

attribute, OCI 6-19

OCI_ATTR_MAX_PROC_NAMELEN

attribute, OCI 6-19

OCI_ATTR_MAXDATA_SIZE

bind handle attribute, OCI A-21

use with binding, OCI 5-27

OCI_ATTR_MEMPOOL_APPNAME, OCI A-49

OCI_ATTR_MEMPOOL_HOMENAME, OCI A-49

OCI_ATTR_MEMPOOL_INSTNAME, OCI A-50

OCI_ATTR_MEMPOOL_SIZE, OCI A-50

OCI_ATTR_MIGSESSION

user session handle attribute, OCI A-12

OCI_ATTR_MIN

attribute, OCI 6-14

OCI_ATTR_NAME, OCI A-41, OCI A-47

attribute, OCI 6-8, OCI 6-10, OCI 6-11, OCI 6-13, OCI 6-14, OCI 6-15, OCI 6-16

OCI_ATTR_NCHARSET_ID

attribute, OCI 6-19

OCI_ATTR_NONBLOCKING_MODE

server handle attribute, OCI A-9

OCI_ATTR_NOWAIT_SUPORT

attribute, OCI 6-20

OCI_ATTR_NUM_ATTRS

attribute, OCI 6-5

OCI_ATTR_NUM_COLS, OCI A-41, OCI A-42

attribute, OCI 6-7

OCI_ATTR_NUM_DML_ERRORS, OCI A-14

OCI_ATTR_NUM_ELEMENTS

attribute, OCI 6-13

OCI_ATTR_NUM_HANDLES

attribute, OCI 6-19

OCI_ATTR_NUM_PARAMS

attribute, OCI 6-5

OCI_ATTR_NUM_ROWS, OCI A-42

OCI_ATTR_NUM_TYPE_ATTRS

attribute, OCI 6-9

OCI_ATTR_NUM_TYPE_METHODS

attribute, OCI 6-10

OCI_ATTR_OBJECT

environment handle attribute, OCI A-4

OCI_ATTR_OBJECT_DETECTCHANGE

environment handle attribute, OCI 13-13

OCI_ATTR_OBJID

attribute, OCI 6-7, OCI 6-14

OCI_ATTR_ORDER

attribute, OCI 6-15

OCI_ATTR_ORDER_METHOD

attribute, OCI 6-10

OCI_ATTR_OVERLOAD

attribute, OCI 6-8

OCI_ATTR_PARAM

describe handle attribute, OCI A-24

OCI_ATTR_PARAM_COUNT

describe handle attribute, OCI A-24

statement handle attribute, OCI A-17

OCI_ATTR_PARTITIONED

attribute, OCI 6-7

OCI_ATTR_PASSWORD

user session handle attribute, OCI A-12

OCI_ATTR_PDSCL

bind handle attribute, OCI A-21, OCI A-23

OCI_ATTR_PIN_DURATION

environment handle attribute, OCI A-4

OCI_ATTR_PINOPTION

environment handle attribute, OCI A-4

OCI_ATTR_POSITION

attribute, OCI 6-16

OCI_ATTR_PRECISION, OCI A-48

attribute, OCI 6-5, OCI 6-10, OCI 6-13, OCI 6-15, OCI 6-17

OCI_ATTR_PREFETCH_MEMORY

statement handle attribute, OCI A-18

OCI_ATTR_PREFETCH_ROWS

statement handle attribute, OCI A-18

OCI_ATTR_PROC_MODE, OCI A-50

OCI_ATTR_PTYPE

attribute, OCI 6-6

OCI_ATTR_RADIX

attribute, OCI 6-17

OCI_ATTR_REF_TDO

attribute, OCI 6-7, OCI 6-9, OCI 6-11, OCI 6-14, OCI 6-16, OCI 6-18

OCI_ATTR_ROW_COUNT, OCI A-43

OCI_ATTR_ROWID

statement handle attribute, OCI A-17

OCI_ATTR_ROWS_RETURNED

bind handle attribute, OCI A-22

use with callbacks, OCI 5-25

OCI_ATTR_SAVEPOINT_SUPPORT

attribute, OCI 6-20

OCI_ATTR_SCALE, OCI A-48

attribute, OCI 6-10, OCI 6-13, OCI 6-15, OCI 6-17

OCI_ATTR_SCHEMA_NAME, OCI A-41

attribute, OCI 6-11, OCI 6-13, OCI 6-14, OCI 6-16, OCI 6-17

OCI_ATTR_SEQ

attributes, OCI 6-14

OCI_ATTR_SERVER

service context handle attribute, OCI A-7

OCI_ATTR_SERVER_GROUP

server handle attribute, OCI A-11

OCI_ATTR_SESSION

service context handle attribute, OCI A-7

OCI_ATTR_SHARED_HEAP_ALLOC, OCI A-6

OCI_ATTR_STMT_TYPE

statement handle attribute, OCI A-17

OCI_ATTR_STREAM_OFFSET, OCI A-44

OCI_ATTR_SUB_NAME, OCI A-42

attribute, OCI 6-18

OCI_ATTR_SUBSCR_CALLBACK, OCI A-37

OCI_ATTR_SUBSCR_CTX, OCI A-37

OCI_ATTR_SUBSCR_NAME, OCI A-38

OCI_ATTR_SUBSCR_NAMESPACE, OCI A-37

OCI_ATTR_SUBSCR_PAYLOAD, OCI A-38

OCI_ATTR_TABLESPACE

attribute, OCI 6-7

OCI_ATTR_TIMESTAMP

attribute, OCI 6-6

OCI_ATTR_TRANS

service context handle attribute, OCI A-7

OCI_ATTR_TRANS_NAME

transaction handle attribute, OCI A-13

OCI_ATTR_TYPE_NAME

attribute, OCI 6-11, OCI 6-13, OCI 6-16, OCI 6-17

OCI_ATTR_TYPECODE

attribute, OCI 6-9, OCI 6-10, OCI 6-13, OCI 6-16

OCI_ATTR_USRNAME

user session handle attribute, OCI A-12

OCI_ATTR_VERSION

attribute, OCI 6-9, OCI 6-19

OCI_ATTR_XID

transaction handle attribute, OCI A-13

OCI_EVENTS

mode for receiving notifications, OCI 9-30

OCI_LOCK_X_NOWAIT

parameter usage, OCI 13-13

OCI_NUM_SHARED_PROCS, OCI 2-22

OCI_PTYPE_ARG

attributes, OCI 6-16

OCI_PTYPE_COL

attributes, OCI 6-15

OCI_PTYPE_COLL

attributes, OCI 6-13

OCI_PTYPE_DATABASE

attributes, OCI 6-19

OCI_PTYPE_FUNC

attributes, OCI 6-8

OCI_PTYPE_LIST

attributes, OCI 6-18

OCI_PTYPE_PKG

attributes, OCI 6-8

OCI_PTYPE_PROC

attributes, OCI 6-8

OCI_PTYPE_SCHEMA

attributes, OCI 6-19

OCI_PTYPE_SYN

attributes, OCI 6-14

OCI_PTYPE_TABLE

attributes, OCI 6-7

OCI_PTYPE_TYPE

attributes, OCI 6-9

OCI_PTYPE_TYPE_ATTR

attributes, OCI 6-10

OCI_PTYPE_TYPE_FUNC

attributes, OCI 6-11

OCI_PTYPE_TYPE_PROC

attributes, OCI 6-11

OCI_PTYPE_VIEW

attributes, OCI 6-7

OCI_SHARED_MODE, OCI 2-21

OCI_TYPECODE

values, OCI 3-23, OCI 3-24, OCI 3-25

OCIAQAgent

descriptor attributes, OCI A-35

OCIAQDeq(), OCI 15-5

OCIAQDeqOptions

descriptor attributes, OCI A-28

OCIAQEnq(), OCI 15-7

OCIAQEnqOptions

descriptor attributes, OCI A-26

OCIAQListen(), OCI 15-19

OCIAQMsgProperties

descriptor attributes, OCI A-31

OCIArray, OCI 11-17

binding and defining, OCI 11-17, OCI 12-6

OCIArray manipulation

code example, OCI 11-19

OCIAttrGet(), OCI 15-28

used for describing, OCI 4-11

OCIAttrSet(), OCI 15-29

OCIBindArrayOfStruct(), OCI 15-43

OCIBindByName(), OCI 15-44

OCIBindByPos(), OCI 15-48

OCIBindDynamic(), OCI 15-52

OCIBindObject(), OCI 15-56

OCIBreak(), OCI 15-216

use of, OCI 2-33, OCI 2-37

OCICacheFlush(), OCI 16-9

OCICacheFree(), OCI 16-48

OCICacheRefresh(), OCI 16-11

OCICacheUnmark(), OCI 16-17

OCICacheUnpin(), OCI 16-49

OCIColl, OCI 11-17

binding and defining, OCI 11-17

OCICollAppend(), OCI 17-6

OCICollAssign(), OCI 17-7

OCICollAssignElem(), OCI 17-8

OCICollGetElem(), OCI 17-10

OCICollIsLocator(), OCI 17-13

OCICollMax(), OCI 17-14

OCICollSetUpdateStatus(), OCI 17-15

OCICollSize(), OCI 17-16

OCICollTrim(), OCI 17-18

OCIComplexObject

use of, OCI 10-23

OCIComplexObjectComp

use of, OCI 10-23

OCIDate, OCI 11-7, PC_ 17-34

binding and defining, OCI 11-7, OCI 12-6

declaring, PC_ 17-34

OCIDate manipulation

code example, OCI 11-8

OCIDateAddDays(), OCI 17-28

OCIDateAddMonths(), OCI 17-29

OCIDateAssign(), OCI 17-30

OCIDateCheck(), OCI 17-31

OCIDateCompare(), OCI 17-33

OCIDateDaysBetween(), OCI 17-34

OCIDateFromText(), OCI 17-35

OCIDateGetDat(), OCI 17-37

OCIDateGetTime(), OCI 17-38

OCIDateLastDay(), OCI 17-39

OCIDateNextDay(), OCI 17-40

OCIDateSetDate(), OCI 17-41

OCIDateSetTime(), OCI 17-42

OCIDateSysDate(), OCI 17-43

OCIDateToText(), OCI 17-44

OCIDateZoneToZone(), OCI 17-46

OCIDefineArrayOfStruct(), OCI 15-58

OCIDefineByPos(), OCI 15-59

OCIDefineDynamic(), OCI 15-63

OCIDefineObject(), OCI 15-65

OCIDescAlloc(), OCI 15-31

OCIDescFree(), OCI 15-33

OCIDescribeAny(), OCI 15-67

usage examples, OCI 6-20

using, OCI 6-2

ocidfn.h, PC_ 5-50

OCIDirPathAbort(), OCI 15-73

OCIDirPathColArrayEntryGet(), OCI 15-74

OCIDirPathColArrayEntrySet(), OCI 15-76

OCIDirPathColArrayReset(), OCI 15-79

OCIDirPathColArrayRowGet(), OCI 15-78

OCIDirPathColArrayToStream(), OCI 15-80

OCIDirPathFinish(), OCI 15-82

OCIDirPathFlushRow(), OCI 15-83

OCIDirPathPrepare(), OCI 15-85

OCIDirPathStreamLoad(), OCI 15-83

OCIDirPathStreamReset(), OCI 15-86

OCIDuration

use of, OCI 13-7, OCI 13-14

OCIDurationBegin(), OCI 15-109

OCIDurationEnd(), OCI 15-110

OCIEnvCallback, OCI 9-15

OCIEnvCreate(), OCI 15-88

OCIEnvInit(), OCI 15-91

OCIErrorGet(), OCI 15-217

OCIExtProcAllocCallmemory(), DCI 13-2, DCI 13-3, DCI 13-4, OCI 18-5

OCIExtProcAllocMemory routine, DCI 4-12

OCIExtProcGetEnv(), OCI 18-8

OCIExtProcRaiseExcp routine, DCI 4-13

OCIExtProcRaiseExcp(), DCI 13-3, OCI 18-6

OCIExtProcRaiseExcpWithMsg routine, DCI 4-13

OCIExtProcRaiseExcpWithMsg(), DCI 13-4, OCI 18-7

OCIHandleAlloc(), OCI 15-34

OCIHandleFree(), OCI 15-37

OCIInd

use of, OCI 10-29

OCIInitialize(), OCI 15-93

shared mode, OCI 2-20

OCIIter, OCI 11-17

binding and defining, OCI 11-17

usage example, OCI 11-19

OCIIterCreate(), OCI 17-19

OCIIterDelete(), OCI 17-20

OCIIterGetCurrent(), OCI 17-21

OCIIterInit(), OCI 17-22

OCIIterNext(), OCI 17-23

OCIIterPrev(), OCI 17-25

OCILdaToSvcCtx(), OCI 15-219

OCILob...() functions, DCI 6-6

OCILobAppend(), OCI 15-111

OCILobAssign(), OCI 15-112

OCILobCharSet(), OCI 15-114, OCI 15-115

OCILobClose(), OCI 15-116

OCILobCopy(), OCI 15-117

OCILobCreateTemporary(), OCI 15-119

OCILobDisableBuffering(), OCI 15-121

OCILobEnableBuffering(), OCI 15-122

OCILobErase(), OCI 15-123

OCILobFileClose(), OCI 15-124

OCILobFileCloseAll(), OCI 15-125

OCILobFileExists(), OCI 15-126

OCILobFileIsOpen(), OCI 15-129

OCILobFileOpen(), OCI 15-130

OCILobFlushBuffer(), OCI 15-132

OCILobFreeTemporary(), OCI 15-134

OCILobGetChunkSize(), OCI 15-135

OCILobGetFileName(), OCI 15-127

OCILobGetLength(), OCI 15-137

OCILobIsEqual(), OCI 15-138

OCILobIsOpen(), OCI 15-139

OCILobIsTemporary(), OCI 15-141

OCILobLoadFromFile(), OCI 15-142

OCILobLocatorAssign(), OCI 15-144

OCILobLocatorIsInit(), OCI 15-146

OCILobOpen(), OCI 15-147

OCILobRead(), OCI 15-148

OCILobSetFileName(), OCI 15-131

OCILobTrim(), OCI 15-152

OCILobWrite(), OCI 15-153

OCILobWriteAppend(), OCI 15-157

OCILockOpt

possible values, OCI 16-28, OCI 16-54

OCILogoff(), OCI 15-96

OCILogon(), OCI 15-97

using, OCI 2-23

OCINumber, OCI 11-10, PC_ 17-34

bind example, OCI 12-8

binding and defining, OCI 11-10, OCI 12-6

declaring, PC_ 17-34

define example, OCI 12-8

OCINumber manipulation

code example, OCI 10-13, OCI 11-13

OCINumberAbs(), OCI 17-50

OCINumberAdd(), OCI 17-51

OCINumberArcCos(), OCI 17-52

OCINumberArcSin(), OCI 17-53

OCINumberArcTan(), OCI 17-54

OCINumberArcTan2(), OCI 17-55

OCINumberAssign(), OCI 17-56

OCINumberCeil(), OCI 17-57

OCINumberCompare(), OCI 17-58

OCINumberCos(), OCI 17-59

OCINumberDec(), OCI 17-60

OCINumberDiv(), OCI 17-61

OCINumberExp(), OCI 17-62

OCINumberFloor(), OCI 17-63

OCINumberFromInt(), OCI 17-64

OCINumberFromReal(), OCI 17-65

OCINumberFromText(), OCI 17-66

OCINumberHypCos(), OCI 17-68

OCINumberHypSin(), OCI 17-69

OCINumberHypTan(), OCI 17-70

OCINumberInc(), OCI 17-71

OCINumberIntPower(), OCI 17-72

OCINumberIsInt(), OCI 17-73

OCINumberIsZero(), OCI 17-74

OCINumberLn(), OCI 17-75

OCINumberLog(), OCI 17-76

OCINumberMod(), OCI 17-77

OCINumberMul(), OCI 17-78

OCINumberNeg(), OCI 17-79

OCINumberPower(), OCI 17-80

OCINumberPrec(), OCI 17-81

OCINumberRound(), OCI 17-82

OCINumberSetPi(), OCI 17-83

OCINumberSetZero(), OCI 17-84

OCINumberShift(), OCI 17-85

OCINumberSign(), OCI 17-86

OCINumberSin(), OCI 17-87

OCINumberSqrt(), OCI 17-88

OCINumberSub(), OCI 17-89

OCINumberTan(), OCI 17-90

OCINumberToInt(), OCI 17-91

OCINumberToReal(), OCI 17-92

OCINumberToText(), OCI 17-93

OCINumberTrunc(), OCI 17-95

OCIObjectArrayPin(), OCI 16-50

OCIObjectCopy(), OCI 16-33

OCIObjectExists(), OCI 16-25

OCIObjectFlush(), OCI 16-13

OCIObjectFree(), OCI 16-52

OCIObjectGetAttr(), OCI 16-35

OCIObjectGetInd(), OCI 16-37

OCIObjectGetObjectRef(), OCI 16-38

OCIObjectGetTypeRef(), OCI 16-39

OCIObjectIsDirty(), OCI 16-30

OCIObjectIsLocked(), OCI 16-31

OCIObjectLifetime

possible values, OCI 16-27

OCIObjectLock(), OCI 16-40

OCIObjectLockNoWait(), OCI 16-41

OCIObjectMarkDelete(), OCI 16-18

OCIObjectMarkDeleteByRef(), OCI 16-19

OCIObjectMarkStatus

possible values, OCI 16-28

OCIObjectMarkUpdate(), OCI 16-20

OCIObjectNew(), OCI 16-42

OCIObjectPin(), OCI 16-54

OCIObjectPinCountReset(), OCI 16-57

OCIObjectPinTable(), OCI 16-58

OCIObjectRefresh(), OCI 16-14

OCIObjectSetAttr(), OCI 16-45

OCIObjectUnmark(), OCI 16-22

OCIObjectUnmarkByRef(), OCI 16-23

OCIObjectUnpin(), OCI 16-60

OCIParamGet(), OCI 15-39

used for describing, OCI 4-11

OCIParamSet(), OCI 15-41

OCIPasswordChange(), OCI 15-220

OCIPinOpt

use of, OCI 13-7

OCIRaw, OCI 11-16, PC_ 17-34

binding and defining, OCI 11-16, OCI 12-6

declaring, PC_ 17-34

OCIRaw manipulation

code example, OCI 11-17

OCIRawAllocSize(), OCI 17-97

OCIRawAssignBytes(), OCI 17-98

OCIRawAssignRaw(), OCI 17-99

OCIRawPtr(), OCI 17-100

OCIRawResize(), OCI 17-101

OCIRawSize(), OCI 17-102

OCIRef, OCI 11-22

binding and defining, OCI 11-22

usage example, OCI 11-22

OCIRefAssign(), OCI 17-104

OCIRefClear(), OCI 17-105

OCIRefFromHex(), OCI 17-106

OCIRefHexSize(), OCI 17-107

OCIRefIsEqual(), OCI 17-108

OCIRefIsNull(), OCI 17-109

OCIRefToHex(), OCI 17-110

OCIReset(), OCI 15-222

use of, OCI 2-37

OCIRowid, OCI 2-16

OCIServerAttach(), OCI 15-99

shadow processes, OCI 15-100

OCIServerDetach(), OCI 15-101

OCIServerVersion(), OCI 15-223

OCISessionBegin(), OCI 15-102

OCISessionEnd(), OCI 15-105

OCIStmtExecute(), OCI 15-161

prefetch during, OCI 4-6

use of iters parameter, OCI 4-6

OCIStmtFetch, STU 25-24

OCIStmtFetch(), OCI 15-164

OCIStmtGetBind(), OCI 15-70

OCIStmtGetPieceInfo(), OCI 15-165

OCIStmtPrepare(), OCI 15-167

preparing SQL statements, OCI 4-4

shared mode, OCI 2-21

OCIStmtSetPieceInfo(), OCI 15-169

OCIString, OCI 11-15, PC_ 17-34

binding and defining, OCI 11-15, OCI 12-6

declaring, PC_ 17-34

OCIString manipulation

code example, OCI 11-15

OCIStringAllocSize(), OCI 17-112

OCIStringAssign(), OCI 17-113

OCIStringAssignText(), OCI 17-114

OCIStringPtr(), OCI 17-115

OCIStringResize(), OCI 17-116

OCIStringSize(), OCI 17-117

OCISubscriptionDisable(), OCI 15-20

OCISubscriptionEnable(), OCI 15-21

OCISubscriptionPost(), OCI 15-22

OCISubscriptionRegister(), OCI 15-24

OCISubscriptionUnRegister(), OCI 15-26

OCISvcCtxToLda(), OCI 15-224

OCITable, OCI 11-17

binding and defining, OCI 11-17, OCI 12-6

OCITableDelete(), OCI 17-119

OCITableExists(), OCI 17-120

OCITableFirst(), OCI 17-121

OCITableLast(), OCI 17-122

OCITableNext(), OCI 17-123

OCITablePrev(), OCI 17-124

OCITableSize(), OCI 17-125

OCITerminate(), OCI 15-106

OCIThreadClose(), OCI 15-173

OCIThreadCreate(), OCI 15-174

OCIThreadHandleGet(), OCI 15-176

OCIThreadHndDestroy(), OCI 15-177

OCIThreadHndInit(), OCI 15-178

OCIThreadIdDestroy(), OCI 15-179

OCIThreadIdGet(), OCI 15-180

OCIThreadIdInit(), OCI 15-181

OCIThreadIdNull(), OCI 15-182

OCIThreadIdSame(), OCI 15-183

OCIThreadIdSet(), OCI 15-184

OCIThreadIdSetNull(), OCI 15-185

OCIThreadInit(), OCI 15-186

OCIThreadIsMulti(), OCI 15-187

OCIThreadJoin(), OCI 15-188

OCIThreadKeyDestroy(), OCI 15-189

OCIThreadKeyGet(), OCI 15-190

OCIThreadKeyInit(), OCI 15-191

OCIThreadKeySet(), OCI 15-192

OCIThreadMutexAcquire(), OCI 15-193

OCIThreadMutexDestroy(), OCI 15-194

OCIThreadMutexInit(), OCI 15-195

OCIThreadMutexRelease(), OCI 15-196

OCIThreadProcessInit(), OCI 15-197

OCIThreadTerm(), OCI 15-198

OCITransCommit(), OCI 15-200

OCITransDetach(), OCI 15-203

OCITransForget(), OCI 15-204

OCITransPrepare(), OCI 15-205

OCITransRollback, STU 25-24

OCITransRollback(), OCI 15-206

OCITransStart(), OCI 15-207

OCIType

description, OCI 11-23

OCITypeArrayByName(), OCI 16-63

OCITypeArrayByRef(), OCI 16-66

OCITypeByName(), OCI 16-68

OCITypeByRef(), OCI 16-70

OCITypeElem

description, OCI 11-23

OCITypeMethod

description, OCI 11-23

OCIUserCallbackGet(), OCI 15-225

OCIUserCallbackRegister(), OCI 15-227

ODCIGetInterfaces method, DCI 11-25

ODCIIndex, SCN 10-43

ODCIIndexClose method, DCI 11-33

ODCIIndexCreate method, DCI 11-25

ODCIIndexDelete method, DCI 11-34

ODCIIndexDrop method, DCI 11-27

ODCIIndexFetch method, DCI 11-32

ODCIIndexGetMetadata method, DCI 11-37

ODCIIndexInsert method, DCI 11-33

ODCIIndexStart method, DCI 11-28, DCI 11-30

ODCIIndexUpdate method, DCI 11-35

ODESSP function

information about stored subprograms, PCO 6-31

OEM_REPOSITORY tablespace raw device, PSC 2-6

oemapp console command, PSC 5-15

oemctrl start oms command, PSC 5-14

OF clause

of CREATE VIEW, SQL 7-432

OF object_type clause

of CREATE TABLE, SQL 7-367

OFA, MIG 1-5

offline

backups, SBR 3-18

taking standby database datafiles, SBR 16-27

offline backup, SPS 4-6, SPS 21-1

parallel, SPS 21-12

redo log files, SPS 21-12

offline backups

whole database backup, SCN 32-23

Offline Bitmapped Tablespaces, SUT 1-55

OFFLINE clause

of ALTER ROLLBACK SEGMENT, SQL 7-74

of ALTER TABLESPACE, SQL 7-168

of CREATE TABLESPACE, SQL 7-396

offline datafile, SPS A-18

offline datafiles

migration, MIG 3-4

offline instantiation, RAR 7-17, REP 2-28

master site, RAR 7-17

master sites, REP 8-16 to REP 8-17

replicated object groups, SPR 21 - 2, SPR 21 - 3, SPR 21 - 4, SPR 21 - 5, SPR 21 - 6, RAR 8-44, RAR 8-46, RAR 8-48, RAR 8-50, RAR 8-52

snapshot site, RAR 7-22

snapshots, SPR 22 - 2, SPR 22 - 3, RAR 8-55, RAR 8-57

support for, REP A-4

offline redo log files, SCN 1-48, SCN 32-7

offline rollback segments

about, SAD 21-10

bringing online, SAD 21-11

when to use, SAD 21-10

offline tablespace

deferred rollback segments, SPS A-19

restrictions, SPS 6-8, SPS A-18

offline tablespaces

altering, SAD 9-10

priorities, SAD 9-10

rollback segments and, SAD 21-10

OGMS_HOME parameter, SPS A-5, SRF 1-83

obsolete for 8.1, SPS A-5

OID

with CREATE TYPE, DCI 3-3

OiD, GTK 6-8

OID. See object identifier

OiD. See Oracle Internet Directory.

OID, See object identifiers

OIDINDEX clause

of CREATE TABLE, SQL 7-377

OIDs, SCN 14-18, SCN 15-3, SCN 15-4, SUT 5-96

collections

key compression, SCN 10-30, SCN 10-38

WITH OBJECT OID clause, SCN 15-3, SCN 15-4

OIDs. See object identifiers.

OLD correlation name, ADG 13 - 16

OLON calls

obsolete, MIG 8-18

OLQP, MIG 2-17

OLTP, MIG 2-17, PSC 1-21

OLTP applications, SPS 1-3, SPS 1-5, SPS 1-8, SPS 1-12, SPS 1-13, SPS 2-7, SPS 2-8, SPS 3-2, SPS A-2

OLTP database, SCN 11-5

batch jobs, SCN 26-38

parallel DML, SCN 26-37

partitioning indexes, SCN 11-36

partitions, SCN 11-6

OMSCONFIG.PROPERTIES file, PSC 5-14

ON clause

of CREATE OUTLINE, SQL 7-322

ON COMMIT clause

of CREATE TABLE, SQL 7-377

ON DATABASE clause

of CREATE TRIGGER, SQL 7-406

ON DEFAULT clause

of AUDIT schema_objects, SQL 7-206

of NOAUDIT schema_objects, SQL 7-525

ON DELETE CASCADE clause

of constraint_clause, SQL 7-224

ON DELETE SET NULL clause

of constraint_clause, SQL 7-224

ON DIRECTORY clause

of AUDIT schema_objects, SQL 7-206

of GRANT object_privileges, SQL 7-506

of NOAUDIT schema_objects, SQL 7-525

of REVOKE schema_object_privileges, SQL 7-533

ON JAVA RESOURCE clause

of GRANT object_privileges, SQL 7-506

ON JAVA SOURCE clause

of GRANT object_privileges, SQL 7-506

ON NESTED TABLE clause

of CREATE TRIGGER, SQL 7-406

ON object clause

of GRANT object_privileges, SQL 7-506

of NOAUDIT schema_objects, SQL 7-525

of REVOKE schema_object_privileges, SQL 7-534

ON PREBUILT TABLE clause

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-303

ON SCHEMA clause

of CREATE TRIGGER, SQL 7-406

ONAME precompiler option, PC_ 10-33

usage notes for, PC_ 10-34

ONAME precompiler option, PCO 14-33

ONAMES value, NET 7-19

one-to-many relationship

with foreign keys, ADG 5 - 9

one-to-one relationship

with foreign keys, ADG 5 - 9

on-going SCN fetch to complete wait event, SRF A-41

online

backups, SBR 3-18

online analytical processing (OLAP)

index-organized tables, SCN 10-42

online backup, SPS 4-6, SPS 21-1

archiving log files, SPS 21-16

parallel, SPS 21-12

procedure, SPS 21-16

redo log files, SPS 21-12

ONLINE clause

of ALTER ROLLBACK SEGMENT, SQL 7-73

of ALTER TABLESPACE, SQL 7-168

of CREATE INDEX, SQL 7-283

of CREATE TABLESPACE, SQL 7-396

online datafile

supported operations, SPS A-18

online help

Export, SUT 1-11

Field Help, LEG 1-14

How Do I Help, LEG 1-14

Import, SUT 2-9

UNIX, LEG 1-12

UNIX manual pages, LEG 1-12

What Is This Help, LEG 1-14

Windows Command Line Utilities, LSM, LEG 1-14

Windows NT, LEG 1-13

online index, SAD 16-7

online index (re)build

compatibility, MIG 8-10

online index builds, GTK 2-41

online indexes, SQL 7-283

rebuilding, SQL 7-134

online read-only tablespaces, GTK 2-42

compatibility, MIG 8-9

online recovery, SPS 6-2, SPS 22-2, SPS 22-4, SPS 22-7, SPS A-22

online redo log, SAD 6-2, SBR 1-8, SBR 15-7, SCN 1-47, SCN 32-7

active group, SBR 15-6, SBR 15-7

applying during media recovery, SBR 14-10

archived group, SBR 15-6, SBR 15-7

archiving, SCN 32-18, SCN 32-19, SRF 1-66

archiving mode, SRF 1-60

backing up, SBR 2-11, SBR 3-23

block, SRF 1-67

checkpoints, SCN 32-22

creating

groups and members, SAD 6-11

creating members, SAD 6-11

current group, SBR 15-6, SBR 15-7

do not back up, SAD 7-3

dropping groups, SAD 6-14

dropping members, SAD 6-14

file size, SRF 1-67

forcing a log switch, SAD 6-16

guidelines for configuring, SAD 6-5

inactive group, SBR 15-6, SBR 15-7

INVALID members, SAD 6-15

location of, SAD 6-9

loss of

active group, SBR 15-9, SBR 15-10

all members, SBR 15-6

group, SBR 15-6

mirrored members, SBR 15-5

recovery, SBR 15-5 to SBR 15-10

managing, SAD 6-1

media failure, SCN 32-5

moving files, SAD 6-13

multiple group loss, SBR 15-10

multiplexed, SBR 1-9, SCN 32-5

number of files, SRF 1-66

number of files in the, SAD 6-9

optimum configuration for the, SAD 6-9

overview, SBR 1-8

privileges

adding groups, SAD 6-11

dropping groups, SAD 6-14

dropping members, SAD 6-15

forcing a log switch, SAD 6-16

recorded in control file, SBR 2-3, SCN 32-21

renaming files, SAD 6-13

renaming members, SAD 6-12

setting checkpoint interval, SRF 1-67

STALE members, SAD 6-15

status of members, SBR 15-6, SBR 15-7

storing separately from datafiles, SAD 10-4

unavailable when database is opened, SAD 3-3

unintentional restore of, SBR 3-23

viewing information about, SAD 6-18

online redo log file

archive log mode, SPS 14-9

archiving, SPS 21-1, SPS 21-6

log switch, SPS 21-6, SPS 21-10

thread of redo, SPS 6-3, SPS 18-15

online redo logs

listing log files for backup, SBR 13-2

reinitializing, SQL 7-19

online rollback segments

about, SAD 21-10

bringing rollback segments online, SAD 21-11

taking offline, SAD 21-12

when new, SAD 21-8

online tablespaces

altering, SAD 9-10

online transaction processing, SPS 1-3

online transaction processing (OLTP), SCN 11-5, STU 1-2, STU 3-1

processes, STU 27-3

reverse key indexes, SCN 10-31

with decision support, STU 3-5

OO4O

features, ADG 1 - 12

Oracle Objects for OLE, ADG 1 - 11

OPEN CURSOR statement, PC_ 14-25

open database backup

fractured block detection during, SBR 4-55

open database recovery

using RMAN, SBR 9-22

OPEN DESCRIPTOR SQL statement, PC_ F-94

OPEN DESCRIPTOR statement, PCO F-71

OPEN NORESETLOGS clause

of ALTER DATABASE, SQL 7-12

OPEN option, SPS 18-13, SPS 18-14

OPEN READ ONLY clause

ALTER DATABASE command, SBR 16-19, SBR 16-20, SBR 16-21

of ALTER DATABASE, SQL 7-11

OPEN READ WRITE clause

of ALTER DATABASE, SQL 7-12

OPEN RESETLOGS clause

of ALTER DATABASE, SQL 7-12

OPEN RESETLOGS option

ALTER DATABASE command, SBR 6-7

OPEN SQL statement, PC_ F-92, PCO F-71

OPEN statement, PC_ 6-13, PCO F-69, PLS 5-8

dependence on precompiler options, PC_ 6-13

effect of, PC_ 6-13

example, PCO 5-14

example of, PC_ 6-13

examples, PC_ F-94, PCO F-70

in dynamic SQL Method 4, PCO 11-34

purpose of, PC_ 6-12, PC_ 6-13

syntax, PLS 11-113

use in dynamic SQL method 3, PC_ 13-20

use in dynamic SQL method 4, PC_ 15-30

using in dynamic SQL Method 3, PCO 9-20

Open System Interconnection (OSI) model

client application layer, described, NET 2-7

described, NET 2-6

link layer, NET 2-8

physical, NET 2-8

presentation layer, NET 2-7

session layer, NET 2-8

transport layer, NET 2-8

OPEN_CURSOR, DDS 7-3

OPEN_CURSORS parameter, ADG 8 - 9, PCO 6-20, SCN 16-7, SRF 1-84

allocating more private SQL areas, STU 19-9

increasing cursors per session, STU 19-15

managing private SQL areas, SCN 7-9

OPEN_LINKS initialization parameter, DDS 2-20

OPEN_LINKS initialization parameters

initialization parameters

OPEN_LINK, REP 2-21

OPEN_LINKS parameter, SCN 7-15, SRF 1-84

OPEN_LINKS_PER_INSTANCE parameter, SRF 1-85

opened cursors current statistic, SRF C-12

OPEN-FOR statement, PLS 5-19

syntax, PLS 11-115

OPEN-FOR-USING statement, PLS 10-5

syntax, PLS 11-119

opening

a cursor variable, PC_ 4-27

cursors, PC_ F-92, PC_ F-94, PCO F-69, PCO F-71

opening a cursor variable, PCO 6-34

opening a database

after creation, SAD 1-19

mounted database, SAD 3-7

opens of replaced files statistic, SRF C-12

opens requiring cache replacement statistic, SRF C-12

operands, SQL 3-1

operating system

accounts, SAD 24-17

auditing with, SAD 25-2

authenticating remote clients, SRF 1-107

authenticating users and passwords, SRF 1-92

authentication, SAD 24-16

data cache, STU 24-2

database administrators requirements for, SAD 1-4

deleting datafiles, SAD 9-15

enabling and disabling roles, SAD 24-19

exported files, SPS B-1

Integrated Distributed Lock Manager, SPS 9-8

limit of number of open files, SAD 10-2

migrating to a different, MIG 3-7, MIG 4-5

monitoring disk I/O, STU 20-17

monitoring tools, STU 12-3

operating system dependent parameters, SRF 1-10

Oracle8i process names, SAD 4-9

privileges, SPS 18-19

redo log blocks, SRF 1-67

renaming and relocating files, SAD 10-9

role identification, SAD 24-17

roles and, ADG 12 - 15, SAD 24-16

roles for remote clients, SRF 1-108

scalability, SPS 2-5

security in, SAD 22-3

striping, STU 26-38

tuning, STU 2-12, STU 17-6, STU 19-4

operating system dependencies, DDS C-1

Operating System Dependent layer

Cluster Manager (CM), PSC 1-6

components, PSC 1-4

defined, PSC 1-3

described, PSC 1-4

Input/Output (IO), PSC 1-7

installing, PSC 2-13, PSC 8-3

Inter-Process Communication (IP
C), PSC 1-7

START, PSC 1-8

Startup (START), PSC 1-8

operating systems

authentication by, SCN 29-4

block size, SCN 4-3

communications software, SCN 8-26

moving data to different systems using SQL*Loader, SUT 5-74

privileges for administrator, SCN 5-3

roles and, SCN 30-22

OPERATION column

PLAN_TABLE, STU 13-4, STU 13-9

operations

connect, NET 2-2

data, NET 2-4

exception, NET 2-4

Net8, NET 2-4

operations in a relational database, SCN 1-22

operations, volume, LEG 3-21

operator

comparison, PLS 2-44

concatenation, PLS 2-46

DEREF, PLS 9-33

precedence, PLS 2-42

REF, PLS 9-32

relational, PLS 2-45

TABLE, PLS 4-18

VALUE, PLS 9-31

operator precedence, SQL 3-2

operators, SQL 3-1

arithmetic, SQL 3-3

binary, SQL 3-1

C versus SQL, PC_ 2-15

comparison, SQL 3-5

concatenation, SQL 3-3

dropping, MIG 12-14

granting

system privileges on, SQL 7-497

logical, SQL 3-10

relational, PCO 2-19

restrictions on, PC_ 2-15

set, SQL 3-12, SQL 7-550

unary, SQL 3-1

user-defined, SQL 3-16

binding to a function, SQL 7-320

creating, SQL 7-320

dropping, SQL 7-463

function providing implementation, SQL 7-321

how bindings are implemented, SQL 7-320

implementation type, SQL 7-321

return type of binding, SQL 7-320

OPI

see Oracle Program Interface

ops, PSC C-9

OPS Assistant, GTK 2-62

OPS Communication Daemon (OPSD), defined, PSC 5-4

/ops directory, PSC A-2, PSC C-4

OPS Overview chart, PSC 7-19

OPS_ADMIN_GROUP parameter, SPS A-6, SRF 1-85, SRF 3-3

obsolete for 8.1, SPS A-5

OPS_DATABASE entry, PSC C-9

OPS_DATABASE entry in SERVICES.ORA file, PSC C-9

OPS_FAILOVER clause, SPS A-11

OPS_INSTANCE entry, PSC C-9

OPS_INSTANCE entry in SERVICES.ORA file, PSC C-9

OPSCTL utility, PSC 5-4

architecture on UNIX, PSC 5-4

architecture on Windows NT, PSC 5-6

configuring for UNIX, PSC 5-12

configuring on UNIX, PSC B-1 to PSC B-12

DB_NAME.CONF file, PSC B-2

OPSD, defined, PSC 5-4

/opsm directory, PSC A-2

OP.TBL, PSC 4-3

Optimal Flexible Architecture (OFA), PSC 1-2

Optimal Flexible Architecture. See OFA

OPTIMAL parameter

of STORAGE clause, SQL 7-346, SQL 7-578

OPTIMAL setting for SYSTEM rollback segment

migration, MIG A-4

OPTIMAL storage parameter, SAD 21-5, SCN 4-25, STU 20-30, SUT 2-53

optimistic locking

implementing, OCI 13-13

optimization, SCN 22-2

choosing an approach and goal for, STU 7-3

choosing the approach, SCN 23-31

compatibility, MIG 8-34

extensible optimizer, MIG 8-14

optimizer plan stability, MIG 8-14

conversion of expressions and predicates, SCN 23-4

cost-based, SCN 22-7, SCN 24-8, STU 7-3

choosing an access path, SCN 23-50

examples of, SCN 23-51

histograms, SCN 22-8

remote databases and, SCN 23-30

star queries, SCN 24-14

user-defined costs, SCN 22-17

described, SCN 22-2

DISTINCT, SCN 23-17

distributed SQL statements, SCN 23-30

execution plan for partitions, SCN 11-11, SCN 11-14

extensible optimizer, SCN 22-16

function-based indexes, SCN 10-25

GROUP BY views, SCN 23-17

hints, SCN 23-33, SCN 23-36

index build, SCN 10-22

manual, SCN 23-33

merging complex views, SCN 23-17

merging views into statements, SCN 23-15

non-null values for nulls, SCN 24-11

operations performed, SCN 23-2

parallel aware, STU 11-6

parallel SQL, SCN 26-10

partition pruning, SCN 11-4

indexes, SCN 11-36

partition pruning (elimination), SCN 11-4

partitioned indexes, SCN 11-35

partition-wise joins, SCN 11-5

plan stability, SCN 22-6

PL/SQL, SCN 23-33

query rewrite, SCN 10-17

enabling, STU 31-4

hints, STU 31-4, STU 31-21

in security policies, SCN 30-23

matching join graphs, STU 29-6

query rewrites

privileges, STU 31-4

rule-based, SCN 22-18, SCN 24-9, STU 7-24

choosing an access path, SCN 23-54

examples of, SCN 23-54

selectivity of predicates, SCN 22-8

histograms, SCN 22-8, SCN 22-10

user-defined, SCN 22-17

selectivity of queries and, SCN 23-51

select-project-join views, SCN 23-15

semi-joins, SCN 24-13

statistics, SCN 22-8, SCN 23-32

user-defined, SCN 22-17

trading cursor space for time, SRF 1-24

transitivity and, SCN 23-8

types of SQL statements, SCN 23-3

without merging, SCN 23-25

optimization approach, PC_ C-5

optimizer, STU 31-2

and remote join enhancement, GTK 2-68

and ROLAP enhancement, GTK 2-24

downgrading, MIG 12-35

extensible, GTK 2-32

Plan Stability, STU 7-25

plan stability, GTK 2-37

compatibility, MIG 8-14

setting session parameters, SQL 7-86

OPTIMIZER column

PLAN_TABLE, STU 13-4

optimizer hint, PCO D-5

optimizer hints, PC_ C-5

in C, PC_ 6-16

in C++, PC_ 6-16, PC_ 12-4

optimizer mode

FIRST_ROWS, SRF 1-89

RULE, SRF 1-89

optimizer statistics, SUT 2-63

OPTIMIZER_FEATURES_ENABLE parameter, SCN 23-17, SCN 23-36, SCN 24-12

OPTIMIZER_FEATURES_ENABLED parameter, SRF 1-86, STU 7-21

OPTIMIZER_GOAL option, SCN 23-32

OPTIMIZER_INDEX_CACHING

for index optimization, STU 7-22

OPTIMIZER_INDEX_CACHING parameter, SRF 1-86

of ALTER SESSION, SQL 7-86

OPTIMIZER_INDEX_COST_ADJ

for index optimization, STU 7-22

OPTIMIZER_INDEX_COST_ADJ parameter, SRF 1-87

of ALTER SESSION, SQL 7-86

OPTIMIZER_MAX_PERMUTATIONS parameter, SRF 1-87

of ALTER SESSION, SQL 7-86

OPTIMIZER_MODE, SCN 23-31, STU 7-3, STU 7-4, STU 7-21, STU 7-24, STU 7-38, STU 11-8, STU 27-27

hints affecting, SCN 23-33

OPTIMIZER_MODE parameter, SRF 1-88

of ALTER SESSION, SQL 7-86

OPTIMIZER_PERCENT_PARALLEL parameter, SCN 22-8, SRF 1-88, STU 7-21, STU 11-7, STU 26-23, STU 27-30

of ALTER SESSION, SQL 7-86

OPTIMIZER_SEARCH_LIMIT parameter, SRF 1-89, STU 7-22

of ALTER SESSION, SQL 7-86

optimizing

direct path loads, SUT 8-16

SQL*Loader input file processing, SUT 5-24

option factoring matrix, GTK 4-2

optional division headers, PCO 2-15

OPTIONALLY ENCLOSED BY, SUT 5-16

SQL*Loader, SUT 5-84

options

deinstalling, MIG 1-6

for Migration utility, MIG 3-14

precompiler concepts, PCO 14-3

OPTIONS column

PLAN_TABLE table, STU 13-4

OPTIONS keyword, SUT 5-18

for parallel loads, SUT 5-40

Options page, REP 7-23

OR keyword, PLS 6-16

OR operator, SQL 3-11, SQL 3-12

OR REPLACE clause

for creating packages, ADG 10 - 14, SPR 1 - 3

of CREATE CONTEXT, SQL 7-243

of CREATE DIRECTORY, SQL 7-265

of CREATE FUNCTION, SQL 7-268, SQL 7-293

of CREATE LIBRARY, SQL 7-297

of CREATE OUTLINE, SQL 7-322

of CREATE PACKAGE, SQL 7-325

of CREATE PACKAGE BODY, SQL 7-328

of CREATE PROCEDURE, SQL 7-334

of CREATE TRIGGER, SQL 7-403

of CREATE TYPE, SQL 7-414

of CREATE TYPE BODY, SQL 7-422

of CREATE VIEW, SQL 7-432

ORA, NET 8-13

ORA_NLS32 environment variable

compatibility, MIG 8-28

ORA_NLS33 environment variable, MIG 3-16

compatibility, MIG 8-28

ORA-00000 to ORA-00816, SMS 2-1

ORA-00508 error message, NET 11-9

ORA-00900

SQL error, DDS 4-11

ORA-00900 to ORA-01499, SMS 3-1

ORA-01500 to ORA-02198, SMS 4-1

ORA-01578 error message, SBR 14-5

ORA-02015

SQL error, DDS 4-11

ORA-02055

integrity constraint violation, DDS 4-3

ORA-02067

rollback required, DDS 4-3

ORA-02100 to ORA-04099, SMS 5-1

ORA-06000 to ORA-07499, SMS 6-1

ORA-06510

PL/SQL error, DDS 4-12

ORA-07500 to ORA-09857, SMS 7-1

ORA-09870 to ORA-12071, SMS 8-1

ORA-1017 error messages, NET 11-3

ORA-1034 error message, NET 8-13

ORA-1034 error messages, NET 11-3

ORA-12154 error message, NET 8-13, NET 11-8

ORA-12198 error message, NET 11-8

ORA-12203 error message, NET 8-12, NET 11-8, NET 11-9, NET 11-13

sample error stack, NET 11-17

troubleshooting, NET 8-12

ORA-12224 error message, NET 11-11

ORA-12316 to ORA-12354, SMS 9-1

ORA-12400 to ORA-12495, SMS 10-1

ORA-12500 error message, NET 11-11

ORA-12533 error message, NET 11-11

ORA-12535 error message, NET 11-13

ORA-12538 error message, NET 11-9

ORA-12541 error message, NET 8-13

ORA-12545 error message, NET 11-12

ORA-12545 error messages

error messages

ORA-12545, NET 11-12

ORA-12547 error message, NET 11-13

ORA-12560 error message, NET 11-12

ORA-12701 to ORA-18010, SMS 11-1

ORA-19500 to ORA-24279, SMS 12-1

ORA-24280 to ORA-28657, SMS 13-1

ORA-29250 to ORA-30728, SMS 14-1

ORA-3113 error message, NET 11-12

ORA-3121 error message, NET 11-12

ORA-600, PSC C-14

OraAQ object, ADG 1 - 16

OraAQAgent object, ADG 1 - 17

OraAQMsg object, ADG 1 - 17

OraBFILE object, ADG 1 - 18

OraBLOB object, ADG 1 - 18

ORACA, PC_ 9-3, PCO 8-4

declaring, PCO 8-37

enabling, PCO 8-37

example, PCO 8-41

example of using, PC_ 9-41

fields, PCO 8-38

gathering cursor cache statistics, PCO 8-40

ORACABC field, PCO 8-38

ORACAID field, PCO 8-38

ORACCHF flag, PCO 8-38

ORACOC field, PCO 8-41

ORADBGF flag, PCO 8-39

ORAHCHF flag, PCO 8-39

ORAHOC field, PCO 8-41

ORAMOC field, PCO 8-41

ORANEX field, PCO 8-41

ORANOR field, PCO 8-41

ORANPR field, PCO 8-41

ORASFNMC field, PCO 8-40

ORASFNML field, PCO 8-40

ORASLNR field, PCO 8-40

ORASTXTC field, PCO 8-40

ORASTXTF flag, PCO 8-39

ORASTXTL field, PCO 8-40

precompiler option, PCO 8-38

purpose, PCO 8-4, PCO 8-36

structure of, PCO 8-38

using to gather cursor cache statistics, PC_ 9-40

ORACA precompiler option, PC_ 10-34, PCO 14-34

ORACABC field, PCO 8-38

ORACAID component, PC_ 9-38

ORACAID field, PCO 8-38

ORACCHF flag, PCO 8-38

Oracle, NET 1-5, NET 2-13, NET 2-29, NET 4-13, NET 6-44, NET 7-29, PSC 2-4

adherence to standards, SCN 1-3

integrity constraints, SCN 28-5

architecture, SCN 1-8, SCN 1-14

background processes, SPS 5-5

backing up, SPS 4-6, SPS 21-1

client/server architecture of, SCN 6-2

compatibility, SCN 1-3, SPS 17-11, SPS B-2

compatibility levels, SCN 3-14

configurations, SPS 1-14

configurations of, SCN 8-2

multiple-process Oracle, SCN 8-2

connectibility, SCN 1-2

different Oracle versions, SCN 33-7

data access, SCN 1-51

data dictionary, SPS 6-6

datafile compatibility, SPS 6-2

datatypes, PC_ 2-7

examples of operations, SCN 1-21

dedicated server, SCN 8-24

multi-threaded server, SCN 8-20

exclusive mode, SPS 4-1, SPS 18-13

executables, SPS 23-8

features, SCN 1-2

Forms Version 4, PC_ 20-14

free space unavailable, SPS 17-11

instance recovery, SPS 22-3

instances, SCN 1-6, SCN 1-16, SCN 5-2

instances on MPP nodes, SPS 3-8

licensing of, SCN 29-19

migration, SPS A-17

multi-instance, SPS 7-3

obsolete parameters, SPS A-21

Open Gateway

using the ROWID datatype with, PC_ 4-8

Oracle server, SCN 1-4

Parallel Server option, SCN 1-8

See also Parallel Server

performance features, SPS 4-5

portability, SCN 1-3

processes of, SCN 1-17, SCN 8-5

restrictions, SPS 6-7, SPS A-17, SPS A-19

scalability of, SCN 6-4

shared mode, SPS 4-2

single-instance, SPS 7-3

SQL processing, SCN 16-8

Toolset, PC_ 20-14

using on networks, SCN 1-2, SCN 1-37

version on all nodes, SPS 5-9

Oracle Advanced Queuing (Oracle AQ)

DBMS_AQADM package, ADQ 3-9, SPR 5 - 1

Oracle Advanced Security, GTK 2-70

authentication, NET 7-28

biometrics authentication method, NET 7-28

configuring, NET 7-28, NET 7-29

CyberSAFE authentication method, NET 4-32

DCE Integration, NET 4-32, NET 7-29

DES_40, NET 4-31

DES_56, NET 4-31

described, NET 4-31

encryption, NET 7-28

features of, NET 4-31

Identifix authentication method

Identix authentication method, NET 4-32

integrated security and directory services, GTK 2-72

Kerberos authentication method, NET 4-32, NET 7-28

MD5, NET 4-31

Network Security, NET 4-31

RADIUS, GTK 2-72

RADIUS authentication method, NET 4-32, NET 7-28

RC4_128, NET 4-31

RC4_40, NET 4-31

RC4_56, NET 4-31

Secure Sockets Layer (SSL) authentication method, NET 7-28

SecurID authentication method, NET 4-32

security features, NET 7-28

Single Sign-On, NET 4-32

SSL, GTK 2-70

SSL authentication method, NET 4-32

using Oracle Advanced Security, NET 7-28

using with Oracle Connection Manager, NET 7-28

with Data Encryption Standard, NET 7-28

with RSA Data Security RC4, NET 7-28

Oracle Advanced Security option, GTK 6-8

Oracle AQ, SCN 19-1

exporting queue tables, SCN 19-12

message queuing, SCN 19-2

publish/subscribe support, SCN 19-10

event publication, SCN 20-18

queue monitor process, SCN 1-20, SCN 8-13, SCN 19-6

interval statistics, SCN 19-11

window of execution, SCN 19-7

queue tables, SCN 19-4

recipients, SCN 19-5

rule-based subscriptions, SCN 19-5, SCN 19-6

subscription lists, SCN 19-5

remote databases, SCN 19-9

Oracle backup volumes

viewing, LEG 3-20

Oracle backups and restores

backup/restore utility, LEG 4-2

monitoring, LEG 4-10

prerequisites to running, LEG 4-2

Oracle blocks, SAD 2-11, SCN 1-10, SCN 4-2

See also data blocks

Oracle Call Interface, ADG 10 - 2

applications, ADG 10 - 4

associative access, ADG 19 - 2

cancelling cursors, ADG 8 - 10

closing cursors, ADG 8 - 10

complex object retrieval (COR), ADG 19 - 8

controlling object cache size, ADG 19 - 5

creating a new object, ADG 19 - 10

deleting an object, ADG 19 - 12

for Oracle objects

building a program, ADG 19 - 4

initializing object manipulation, ADG 19 - 5

lock options, ADG 19 - 7

locking an object, ADG 19 - 12

navigational access, ADG 19 - 3

object cache, ADG 19 - 3

flushing an object, ADG 19 - 13

pin options, ADG 19 - 6

pinning and unpinning objects, ADG 19 - 5

See OCI

updating an object, ADG 19 - 12

with Oracle objects, ADG 19 - 2

Oracle Call Interface (OCI), SCN 8-25

anonymous blocks, SCN 16-17

bind variables, SCN 16-13

object cache, SCN 13-14

OCIObjectFlush, SCN 15-4

OCIObjectPin, SCN 15-4

stored procedures, SCN 16-18

Oracle Call Interface (OCI) layer, described, NET 2-11

Oracle Call Interface Rel 7, PC_ 5-50

Oracle Call Interface. See OCI

Oracle Call Interface (OCI), PCO 3-16

Oracle Certificate Authority, SCN 29-5

Oracle code, SCN 8-2, SCN 8-25

Oracle Communications Area, PC_ 9-34

ORACA, PCO 8-36

Oracle Connection Manager, OAS 1-11, GTK 3-6

CMADMIN process, NET 2-47

CMCTL process, NET 2-47

CMGW process, NET 2-46

configuration file

new parameters in release 8.1, NET 4-19

configuration file changes in release 8.1, NET 4-14

configuration file sample, NET B-9

configuration parameter reference, NET C-76 to NET C-80

configuring address, NET 6-76

configuring address for listener, NET 7-46

configuring address for Oracle Connection Manager, NET 7-43

configuring CMAN.ORA for connection concentration, NET 7-31

configuring CMAN.ORA for multi-protocol support, NET 7-35

configuring CMAN.ORA for Net8 access control, NET 7-38

configuring connection concentration, NET 7-31

configuring multi-protocol support, NET 7-35

configuring Net8 access control, NET 7-38

connection concentration, NET 2-48, NET 3-11, NET 4-30

described, NET 4-30

log files, NET 11-22

log files, understanding, NET 11-27

migrating, NET 5-21

migration issues, NET 5-21

multiple protocol support, NET 2-49

multi-protocol support, NET 4-30, NET 5-22

Ne8 access control, NET 4-30

Net8 access control, NET 2-49

Net8 Firewall Proxy, NET 2-49

processes, NET 2-46

role in multiple protocol environments, diagram, NET 2-50

routing connections, NET 1-6, NET 7-26

SOURCE_ROUTE parameter, NET C-41

starting, NET 8-7

testing, NET 8-18

TNSNAMES.ORA file, NET 7-34

trace files, NET 11-37

upgrading, NET 5-21

using instead of Oracle Multi-Protocol Interchange, NET 5-22

using with multi-threaded servers, NET 2-48, NET 7-31

Oracle Connection Manager Control Utility (CMCTL)

command reference, NET A-90 to NET A-93

function and syntax format, NET A-89

starting, NET 8-7

testing the network

using, NET 8-16

Oracle Customer Support, contacting, NET 11-58

Oracle Data Cartridge Interface, SCN 10-43

Oracle Data Control (ODC), ADG 1 - 19

Oracle Data Gatherer

defined, PSC 5-3

starting, PSC 5-30

Oracle Data Migration Assistant

advantages and disadvantages, MIG 2-8

character set used, MIG 4-6

differences from the Migration utility, MIG 2-9

documentation roadmap, MIG 4-2

migrating to a different operating system, MIG 4-5

Oracle Parallel Server

does not support migration, MIG 2-9, MIG 4-3

does not support upgrading, MIG 7-6

overview, MIG 4-3

running, MIG 4-16, MIG 7-7, MIG 7-12

space required for SYSTEM tablespace, MIG 4-4

Oracle Database Configuration Assistant, GTK 2-59, GTK 2-63

automatically running as a part of installation, PSC 3-5, PSC 3-6

configuring listener for Oracle Enterprise Manager, NET 4-23

creating a database, PSC 4-4

creating a database with, PSC 4-4

error message, PSC 4-6

failing on Windows NT, PSC C-2

initialization files, PSC 1-11

minimum size, PSC 2-6

running after installation, PSC 3-7

troubleshooting, PSC 4-4, PSC 4-6

Oracle Database Configuration Assistant, configuring the listener, NET 4-23

Oracle datatypes, OCI 3-2, PCO 2-8

mapping to C, OCI 11-2

Oracle DCE Integration

compatibility with Net8, NET 7-29

described, NET 7-29

Oracle Designer, STU 28-9

Oracle Diagnostics Pack

described, PSC 2-4

Oracle Performance Manager, PSC 2-4

Oracle Diagnostics Pack, installing, PSC 5-28

Oracle dynamic SQL

when to use, PCO 10-1

Oracle Enterprise Manager, OAS 7-5, LEG 4-3, SBR 3-10

architecture, PSC 5-8

auto-discovery, PSC 5-18, PSC C-3

components, PSC 2-3

Configuration Assistant, PSC 5-13

configuring, PSC 5-11 to PSC 5-28

configuring Net8 on Console, PSC 5-11

configuring Net8 on Oracle Performance Manager machine, PSC 5-29

configuring OPSCTL, PSC 5-12

configuring repository, PSC 5-13

configuring static information in the listener, NET 4-23

connect-time failover, NET 2-29, NET 6-71, NET 7-12

Console, PSC 2-3, PSC 5-2, PSC 5-15

discovering nodes, PSC 5-18

hardware requirements, PSC 2-3

installation, PSC 5-10

installation requirements, PSC 2-3

installing repository database, PSC 5-10

managed targets, PSC 2-4

Management Server, PSC 2-3, PSC 5-2, PSC 5-14

NMICONF.LOG file, PSC C-9

NMICONF.LST file, PSC C-10

OPS Communication Daemon (OPSD), PSC 5-4

OPSCTL utility, PSC 5-4

Oracle Data Gatherer, PSC 5-3

Oracle Diagnostics Pack, PSC 2-4

Oracle Intelligent Agents, PSC 5-3

Oracle Parallel Server Management, PSC 1-3

Oracle Performance Manager, PSC 5-3

Oracle8, LEG 1-10

repository database, PSC 2-4, PSC 5-3

scheduling jobs, PSC 6-31

SERVICES.ORA file, PSC C-9

setting up preferred credentials, PSC 5-21

setup scenarios, PSC 5-8

SID_LIST parameter in LISTENER.ORA, NET 2-29, NET 4-13, NET 5-20, NET 6-71, NET 7-12, NET C-40

SID_LIST_listener_name parameter, PSC 4-12, PSC 4-37, PSC C-6

software requirements, PSC 2-3

solving auto-discovery failures, PSC C-3

specifying preferred credentials, PSC 5-21

starting, PSC 5-13

starting Oracle Data Gatherer, PSC 5-30

starting Oracle Intelligent Agents, PSC 5-13, PSC 6-14

starting Oracle Intelligent Agents, PSC B-12

starting Oracle Parallel Server database, PSC 6-18

starting Oracle Performance Manager, PSC 7-4

starting the Console, PSC 5-15, PSC 6-14

starting the Management Server, PSC 5-14, PSC 6-14

static service information in LISTENER.ORA, NET 2-29, NET 5-20, NET 6-71, NET 7-12, NET C-40

stopping Oracle Parallel Server database, PSC 6-21

super administrator account, PSC 5-15

SYSDBA privilege, PSC 5-28

SYSOPER privilege, PSC 5-28

understanding auto-discovery failures, PSC C-3

User Manager, PSC 5-22

version 2 changes, PSC 5-11

viewing Oracle Parallel Server status, PSC 6-27

viewing shutdown results, PSC 6-24

viewing startup results, PSC 6-24

See Enterprise Manager

Oracle errors, ADG 10 - 3

Oracle Expert, STU 2-1, STU 12-11

Oracle Express Objects, STU 28-9

Oracle Forms, STU 14-5

control of parsing and private SQL areas, STU 19-10

object dependencies and, SCN 21-13

PL/SQL, SCN 16-16

using EXEC TOOLS statements, PCO 12-14

Oracle home

non-shared on UNIX, PSC B-12

shared on UNIX, PSC B-12

Oracle Home Directory

configuring on the listener, NET 6-72

described, NET 6-72

Oracle Home Directory option

Net8 Assistant

Oracle Home Directory, NET 6-72

Oracle Home option, NET 7-69

ORACLE identifiers

how to form, PC_ F-11, PCO F-10

Oracle Intelligent Agents

defined, PSC 5-3

setup and location on UNIX, PSC B-11 to PSC B-12

starting, PSC 5-13, PSC 6-14, PSC B-12

Oracle Internet Directory, GTK 2-70, GTK 2-74, SCN 29-5

Oracle Internet File System, GTK 2-2

Oracle JDBC

accessing Oracle object data, ADG 19 - 19

definition, ADG 1 - 26

example, ADG 1 - 27

OCI driver, ADG 1 - 26

Oracle extensions, ADG 1 - 27

server driver, ADG 1 - 27

stored procedures, ADG 1 - 29

thin driver, ADG 1 - 26

Oracle Management Server (OMS), GTK 2-61

Oracle Media Management API

compatibility, MIG 8-13

proxy copy requirement, MIG 8-44

proxy copy and downgrading, MIG 12-37

Oracle Names

administrative regions, NET 2-33

advantages and disadvantages, NET 3-9

architecture, NET 2-31

centralized naming, NET 3-5

client cache, NET 8-4

coexistence, NET 5-10

configure clients and servers, NET 6-37

configuring, NET 6-21 to NET 6-50

configuring a region database, NET 6-26, NET 6-31

configuring multiple domains, NET 6-29, NET 6-34

connecting with, NET 8-8

creating Oracle Names servers, NET 6-25

default domain, NET 2-38

delegated administrative regions, NET 2-42

delegating domains

Oracle Names server

delegating domains, NET 6-50

described, NET 2-31, NET 4-30, NET 6-5

differences between versions, NET 2-42

discovering Oracle Names servers, NET 6-36, NET 6-37

discovery, NET 2-45

domains, NET 2-33

Dynamic Discovery Option, NET 2-43

establishing a connection with, NET 3-5

global directory service, SCN 33-4

hierarchical naming model, NET 2-38

installing, NET 6-24

listener configuration for, NET 6-40

loading TNSNAMES.ORA file into Oracle Names, NET 5-25

log files, NET 11-21

migrating, NET 5-23 to NET 5-30

migration, NET 5-10

multiple domains, NET 2-39

NAMESINI.SQL script, NET 5-24, NET 5-29, NET 6-26

NAMESUPG.SQL script, NET 5-23, NET 5-27, NET 5-29, NET 6-26

naming network components, NET 2-37

querying objects, NET 8-17

recommended for, NET 3-9

region database, NET 2-34

regions, NET 2-33

registering global database link qualifiers, NET 6-44, NET 6-46

registering global database links, NET 6-44

registering net service names, NET 6-41

registering objects, NET 6-41

replicating data, NET 2-34, NET 6-32

root administrative region, NET 2-40

.SDNS.ORA file, NET 2-45

SDNS.ORA file, NET 2-45

single domain naming mode, NET 2-37

starting from the command line, NET 8-17

starting from the Control Panel, NET 8-7

storing aliases, NET 2-36, NET 6-22

storing database global database names and addresses, NET 2-35, NET 6-21

storing database links, NET 2-36, NET 6-22

storing information in a region database, NET 6-26

storing net service names, NET 2-35, NET 6-22

storing Oracle Connection Manager information, NET 2-36, NET 6-22

storing other Oracle Names server names and addresses, NET 2-35, NET 6-21

trace files, NET 11-37

upgrading, NET 5-23, NET 5-23 to NET 5-30, NET 5-30

using, NET 6-21

using a database as a repository for information, NET 2-34

using multiple regions, NET 2-40

using with external naming, NET 3-7

version 1, NET 2-42

version 2, NET 2-43

version 8, NET 2-44

Oracle Names Control Utility (NAMESCTL)

command reference, NET A-34 to NET A-88

confirmation mode, NET A-33

delegating domains, NET 6-50

description of and types of commands, NET A-31

discovering Oracle Names servers, NET 6-36, NET 6-37

distributed operation, NET A-32

loading TNSNAMES.ORA into Oracle Names, NET 5-25, NET 5-28, NET 6-43

modes of operation, NET A-2

parameter options, NET A-31

querying objects, NET 8-17

registering aliases, NET 6-49

registering global database links, NET 6-45

registering net service names, NET 6-42

security, NET A-3, NET A-32

SET and SHOW modifiers, NET A-3, NET A-31

starting an Oracle Names server, NET 6-31, NET 6-36, NET 8-3

testing network objects with, NET 8-17

testing the network, NET 8-15

Oracle Names server

CKCFG.ORA file, NET 6-25

CKPCCH.ORA file, NET 6-25

CKPREG.ORA file, NET 6-25

configuring address, NET 6-76

configuring multiple domains, NET 6-29, NET 6-34

loading TNSNAMES.ORA file into Oracle Names, NET 5-25

Oracle Names servers

configuration file sample, NET B-7

configuration file, described, NET 6-6

configuration parameter reference, NET C-65 to NET C-75

configuring protocols addresses, NET 6-64

creating, NET 6-25

creating for a region database, NET 6-27

creating for replication, NET 6-32

data it can store, NET 2-35

data stored, NET 2-35

described, NET 1-5, NET 2-31

discovery of Oracle Names servers, NET 6-36

in delegated administrative regions, NET 2-40

in root administrative region, NET 2-40

log files, NET 11-21

preferred, NET 2-42

registering

global database link qualifiers, NET 6-46

registering global database link qualifiers, NET 6-44

registering global database links, NET 6-44

registering net service names, NET 6-41

registering objects, NET 6-41

replicating data, NET 6-32

starting, NET 6-31, NET 8-3

starting client cache, NET 8-4

storing aliases, NET 2-36, NET 6-22

storing database global database names and addresses, NET 2-35, NET 6-21

storing database links, NET 2-36, NET 6-22

storing net service names, NET 2-35, NET 6-22

storing Oracle Connection Manager information, NET 2-36, NET 6-22

storing other Oracle Names server names and addresses, NET 2-35, NET 6-21

testing, NET 8-16

testing with TNSPING, NET 8-22

trace files, NET 11-37

well-known, NET 2-43

Oracle namespaces, PCO C-4

Oracle Network Manager, STU 22-3

Oracle Network Manager, described, NET 5-2

Oracle Objects for OLE

automation server, ADG 1 - 12

C++ Class Library, ADG 1 - 19

data control, ADG 1 - 19

LOB and object support, ADG 1 - 17

object model, ADG 1 - 13

OraCollection interface, ADG 19 - 18

OraObject interface, ADG 19 - 17

OraRef interface, ADG 19 - 17

overview, ADG 1 - 11

with Oracle objects, ADG 19 - 16

Oracle objects, See object-relational model

Oracle Open Gateway

using ROWID datatype, PCO 4-14

Oracle Open Gateways, SCN 33-8

Oracle Parallel Query

defined, PSC 1-15

described, PSC 1-20

issuing SQL statements, PSC 1-22

Oracle Parallel Server, SCN 1-8, STU 3-8, STU 11-6

architecture, PSC 1-2

client load balancing, NET 4-10

compatibility requirements, MIG 8-34

configuring connect-time failover

Oracle Parallel Server

configuring client load balancing, NET 7-12

connect-time failover, NET 2-29, NET 4-15

CPU, STU 18-13

data files, PSC 1-11, PSC 1-14

database creation, PSC 3-5, PSC 3-6, PSC 4-3

database files, PSC 1-14

Destination Type tasks, PSC 6-36

disk affinity, STU 27-16

downgrading, MIG 12-49

enabling client load balancing, NET 4-10

enabling connect-time failover, NET 4-12

FAILOVER parameter, NET 4-15, NET C-40

FAILOVER_MODE parameter, NET C-43

folder in Console Navigator window, PSC 6-14

hardware requirements, PSC 2-2

INITDB_NAME.ORA file, PSC 1-11

installation requirements, PSC 2-2

installing, PSC 3-1

instance affinity for jobs

compatibility, MIG 8-12

INSTANCE_NAME parameter, NET 4-16, NET C-47

instances, PSC 1-9

Integrated Distributed Lock Manager (IDLM), PSC 1-15

LOAD_BALANCE parameter, NET 4-17, NET C-41

migration, MIG 3-7

not supported by Oracle Data Migration Assistant, MIG 2-9, MIG 4-3

Operating System Dependent layer, PSC 1-3

Oracle Parallel Query, PSC 1-15, PSC 1-20

Oracle Parallel Server Management, PSC 1-3

Oracle Parallel Server Option, PSC 1-3

Oracle8i Enterprise Edition, PSC 1-3

overview, PSC 1-1 to PSC 1-22

Parallel Cache Management (PCM), PSC 1-15

parallel execution, STU 27-13

parallel load, STU 26-69

pre-installation, PSC 2-1 to PSC 2-15

raw device setup, PSC 2-6 to PSC 2-12

rolling upgrade, MIG 1-5

software requirements, PSC 2-2

ST enqueue, STU 27-12

synchronization points, STU 2-8

upgrading, MIG 7-1, MIG 7-24

not supported by Oracle Data Migration Assistant, MIG 7-6

See also Parallel Server

Oracle Parallel Server database

creation, PSC 4-4, PSC 8-4

shutdown, PSC 6-24

starting, PSC 4-9, PSC 8-5

Oracle Parallel Server Management

administration of instances, PSC 6-13

architecture, PSC 5-2

configuring, PSC 5-1 to PSC 5-37

defined, PSC 1-3

LISTENER.ORA file, PSC 5-7

node requirements, PSC 5-7

OPS Communication Daemon (OPSD), PSC 5-4

OPSCTL utility, PSC 5-4

Oracle Enterprise Manager, PSC 1-3, PSC 5-2

Oracle Performance Manager, PSC 5-28

requirements, PSC 5-7

SIDs, PSC 5-7

TNSNAMES.ORA file, PSC 5-7

Oracle Parallel Server Management (OPSM), GTK 2-62, STU 12-12, SPS A-4

Group Membership Services (GMS), GTK 2-62

OPS Assistant, GTK 2-62

Parallel Server Manager, GTK 2-62

Oracle Parallel Server Option

defined, PSC 1-3

installing, PSC 3-3, PSC 8-4

Oracle parameter SID, OAS 13-15

Oracle parameters

necessary for authentication, OAS 1-13

Oracle Performance Manager, STU 12-10

accessing Oracle Parallel Server charts, PSC 5-34

charts, PSC 7-1 to PSC 7-19

configuring, PSC 5-29 to PSC 5-37

Databases folder, PSC 5-36

defined, PSC 2-4, PSC 5-3

displaying charts, PSC 7-4

installing, PSC 5-28

installing Oracle Data Gatherer, PSC 5-28

installing Oracle Diagnostics Pack, PSC 5-28

Oracle Diagnostics Pack, PSC 2-4

overview, PSC 7-2

Parallel Server Instance folder, PSC 5-34

starting, PSC 5-31, PSC 7-4

Oracle Precompilers

advantages, PCO 1-3

calling stored procedures and packages, ADG 10 - 52

control of parsing and private SQL areas, STU 19-10

language support, PCO 1-3

NLS support, PCO 4-40

running, PCO 14-1

using PL/SQL, PCO 6-7

Oracle precompilers, SQL 1-3

anonymous blocks, SCN 16-17

bind variables, SCN 16-13

cursors, SCN 16-11

embedded SQL, SCN 16-5

FIPS flagger, SCN 16-6

stored procedures, SCN 16-18

Oracle Program Interface (OPI), NET 2-13

Oracle program interface (OPI), SCN 8-25

Oracle Program Interface (OPI), described, NET 2-13

Oracle protocols

Bequeath, NET 4-27

configuring addresses, NET 6-78

described, NET 2-12, NET 4-25

LU6.2, NET 4-26

Named Pipes, NET 4-26

SPX, NET 4-25

TCP/IP, NET 4-25

TCP/IP with SSL, NET 4-6, NET 4-25

Oracle Rdb database

configuring for connection, NET 7-71

described, NET 7-71

Oracle RDB Database option, NET 7-8

Oracle Replication Manager, REP 1-13, SCN 34-15

Oracle reserved words, SQL C -1

Oracle Sales Analyzer, STU 28-9

Oracle Security Manager, SCN 29-5, SCN 33-18

Oracle Security Server, GTK 2-70, GTK 2-72, GTK 6-8

Oracle Server

client/server configuration, STU 3-9

configurations, STU 3-6

events, STU 15-5

Oracle server, SCN 1-4

hostname, LEG 2-22

See also Oracle

Oracle service names, registering in CDS, OAS 11-4

Oracle Software Packager, GTK 2-58

Oracle SQLJ

advantages over JDBC, ADG 1 - 32

compiling custom Java classes, ADG 19 - 24

creating custom Java classes, ADG 19 - 24

custom Java classes, ADG 19 - 21

CustomDatum interface, ADG 19 - 21

definition, ADG 1 - 31

design, ADG 1 - 32

example, ADG 1 - 34

in the server, ADG 1 - 37

JPublisher, ADG 19 - 24

Oracle object methods, ADG 19 - 23

stored programs, ADG 1 - 37

strongly types objects, ADG 19 - 25

support for Oracle objects, ADG 19 - 19

weakly types objects, ADG 19 - 26

Oracle striping, STU 26-39

Oracle supplied packages, ADG 10 - 16

Oracle System Identifier (SID), configuring on the listener, NET 6-71

Oracle System Identifier (SID), defined, PSC 1-11

Oracle Tools

support of SQL, SQL 1-5

Oracle Toolset, PCO 12-14

Oracle Trace, STU 15-1, STU 19-39, STU 32-16

accessing collected data, STU 15-5

binary files, STU 15-5

collection results, STU 15-25

collections, STU 15-4, STU 15-22

command-line interface, STU 15-19

data views, STU 15-6

Average Elapsed Time, STU 15-10

CPU Statistics, STU 15-11

Disk Reads, STU 15-9

Disk Reads/Execution Ratio, STU 15-9

Disk Reads/Logical Reads Ratio, STU 15-9

Disk Reads/Rows Fetched Ratio, STU 15-9

Execute Elapsed Time, STU 15-10

Fetch Elapsed Time, STU 15-11

Logical Reads, STU 15-9

Logical Reads/Rows Fetched Ratio, STU 15-9

Number of Rows Processed, STU 15-11

Parse Elapsed Time, STU 15-10

Parse/Execution Ratio, STU 15-10

Re-Parse Frequency, STU 15-10

Rows Fetched/Fetch Count Ratio, STU 15-11

Rows Sorted, STU 15-11

Sorts in Memory, STU 15-11

Sorts on Disk, STU 15-11

Total Elapsed Time, STU 15-10

Waits by Average Wait Time, STU 15-12

Waits by Event Frequency, STU 15-12

Waits by Total Wait Time, STU 15-12

deleting files, STU 15-21

details property sheet, STU 15-14

drilldown data views, STU 15-16, STU 15-18

Basic Statistics for Parse/Execute/Fetch, STU 15-18

CPU Statistics for Parse/Execute/Fetch, STU 15-18

Parse Statistics, STU 15-18

Row Statistics for Execute/Fetch, STU 15-19

duration events, STU 15-5

events, STU 15-5

FORMAT statement, STU 15-19, STU 15-20

formatter tables, STU 15-5

formatting data, STU 15-25

Oracle Trace Data Viewer, STU 15-6

parameters, STU 15-21

point events, STU 15-5

predefined data views, STU 15-6

reporting utility, STU 15-6, STU 15-26

SQL statement property sheet, STU 15-14

START statement, STU 15-19, STU 15-20

STOP statement, STU 15-19, STU 15-20

stored procedures, STU 15-24

using to collect workload data, STU 15-3

viewing data, STU 15-12

Oracle Trace Data Viewer, STU 15-6

Oracle Trace Manager, STU 15-4, STU 15-22

used for formatting collections, STU 15-5

Oracle type translator (OTT), SCN 13-15

Oracle Universal Installer, GTK 2-59, GTK 2-63

using, PSC 3-3

Oracle Version 6

exporting database objects, SUT 2-65

Oracle wallet, GTK 2-74

Oracle Wallet Manager, GTK 2-73, SCN 29-5

Oracle Wallet Manager, starting, OAS 9-30

Oracle wallets, SCN 29-5

Oracle XA

session memory in the large pool, SCN 7-12

Oracle, Trusted, PLS 2-10

ORACLE_HOME environment variable, PSC B-6

ORACLE_HOME parameter, NET 6-72, NET 7-66, NET 7-69, NET C-58

oracle_home parameter, PSC B-5

oracle_pid, SPS 11-13

ORACLE_PSRV environment variable, PSC B-3, PSC B-6

ORACLE_SID environment variable, PSC 1-11

ORACLE_SID registry entry, PSC 1-11

ORACLE_TRACE_COLLECTION_NAME parameter, SRF 1-89, STU 15-21, STU 15-22

ORACLE_TRACE_COLLECTION_PATH parameter, SRF 1-90, STU 15-21

ORACLE_TRACE_COLLECTION_SIZE parameter, SRF 1-90, STU 15-21

ORACLE_TRACE_ENABLE parameter, SRF 1-90, STU 15-21, STU 15-22

ORACLE_TRACE_FACILITY_NAME parameter, SRF 1-91, STU 15-21, STU 15-22

ORACLE_TRACE_FACILITY_PATH parameter, SRF 1-91, STU 15-21

Oracle7

and min_communication, REP 5-11

creating export files with, SUT 1-60

downgrading to, MIG 13-1

Enterprise Backup Utility (EBU), LEG 4-2

Oracle Enterprise Manager, LEG 4-3

prepare for migration, MIG 3-9, MIG 4-7

upgrading applications to Oracle8i, MIG 9-1

Oracle8

backup and recovery system, LEG 1-8, LEG 1-9, LEG 1-10

features and migration, REP B-12

Media Management Library (MML), LEG 1-11

MM API, LEG 1-11

Oracle Enterprise Manager, LEG 1-10, LEG 4-3

Recovery Catalog, LEG 1-9, LEG 1-10

Recovery Manager (RMAN), LEG 1-9, LEG 1-10, LEG 4-2

Oracle8 datatypes

binding and defining, OCI 12-6

Oracle8 SQL Reference, PCO 4-46

Oracle8i

installing, SAD 1-18

Oracle8i

changes to initialization parameters, MIG B-1

new features

adding after migration, MIG 6-7

new internal types, MIG E-1

new SQL functions, MIG E-1

Oracle8i Enterprise Edition

defined, PSC 1-3

installing, PSC 3-3, PSC 8-4

Oracle8i Server

complying with license agreement, SAD 23-2

identifying releases, SAD 1-21

processes

checkpoint (CKPT), SAD 4-12

monitoring, SAD 4-8

operating-system names, SAD 4-9

trace files fpr, SAD 4-10

Oracle8i Server processes

processes

dedicated server processes, SAD 4-2

identifying and managing, SAD 4-7

Oracle8i Spatial, GTK 2-10

Oracle8i Time Series, GTK 2-13

Oracle8i utilities

Recovery Manager, SBR 4-2

Oracle8i Visual Information Retrieval, GTK 2-12

oracle.aurora.server.GiopServer, NET 9-7

oracle.aurora.server.SGiopServer, NET 7-52

OracleHOME_NAMEAgent service, PSC 5-13

OracleHOME_NAMEDataGatherer service, PSC 5-30

OracleHOME_NAMEManagementServer service, PSC 5-14

OracleServiceSID registry key

registry

OracleServiceSID key, PSC C-2

OracleServiceSID service, PSC 4-9

OraCLOB object, ADG 1 - 18

ORACOC

in ORACA, PCO 8-41

ORACOC field, PCO 8-41

OraCollection interface, ADG 19 - 18

OraDatabase object, ADG 1 - 14

ORADBGF flag, PCO 8-39

Oradebug, GTK 2-62, SPS A-4

OraDynaset object, ADG 1 - 15

OraField object, ADG 1 - 15

ORAHCHF flag, PCO 8-39

ORAHOC field, PCO 8-41

OraMeta Data object, ADG 1 - 15

ORAMOC field, PCO 8-41

ORANEX

in ORACA, PCO 8-41

ORANEX field, PCO 8-41

ORANLS option, NLS B-13, NLS B-16

ORANOR field, PCO 8-41

ORANPR field, PCO 8-41

OraObject interface, ADG 19 - 17

OraParamArray object, ADG 1 - 16

OraParameter object, ADG 1 - 15

ORAPWD utility, SAD 1-9

OraRef interface, ADG 19 - 17

OraServer object, ADG 1 - 14

OraSession object, ADG 1 - 13

ORASFNM, in ORACA, PCO 8-40

ORASFNMC field, PCO 8-40

ORASFNML field, PCO 8-40

ORASLNR

in ORACA, PCO 8-40

ORASLNR field, PCO 8-40

OraSQLStmt object, ADG 1 - 16

ORASTXTC field, PCO 8-40

ORASTXTF flag, PCO 8-39

ORASTXTL field, PCO 8-40

oratypes.h

contents, OCI 3-27

ORAXXXXX.TRC file, PSC C-12

ORDBMS, SCN 1-22, SCN 13-2

order

preserving, STU 13-26

ORDER BY, STU 13-26

decreasing demand for, STU 27-7

ORDER BY clause, NLS 4-8

of CREATE TABLE, SQL 7-384

of queries, SQL 5-20

of SELECT, SQL 5-20, SQL 7-543, SQL 7-551

with ROWNUM, SQL 2-56

of subqueries in CREATE TABLE, SQL 7-384

sorting character data, NLS 2-25

ORDER clause

of ALTER SEQUENCE. See CREATE SEQUENCE.

of CREATE SEQUENCE, SQL 7-352

ORDER MEMBER clause

of ALTER TYPE, SQL 7-175

of CREATE TYPE, SQL 7-417

of CREATE TYPE BODY, SQL 7-423

order method, PLS 9-10

ORDER methods

specifying, SQL 7-175

order methods, ADG 16 - 19, ADG 16 - 25, ADG 18 - 8, DCI 3-5, SCN 1-57, SCN 13-7

order of evaluation, PLS 2-42, PLS 2-43

ORDER option, SPS 6-6, SPS 6-7

ORDERED hint, SCN 24-9, SQL 2-60, STU 7-51

ORDERED_PREDICATES hint, SQL 2-59, STU 7-67

ordering

conflict resolution methods for column groups, REP 6-17

ordering conflicts

avoiding, REP 6-40

ordinal numbers

specifying, SQL 2-45

spelling out, SQL 2-45

ORE. See object runtime environment

ORECLEN precompiler option, PCO 14-34

ORGANIZATION HEAP clause

of CREATE TABLE, SQL 7-372

ORGANIZATION INDEX clause

of CREATE TABLE, SQL 7-372

ORLON calls

obsolete, MIG 8-18

OS authentication, SAD 1-7

O/S backups, SBR 13-3 to SBR 13-18

O/S utilities

copying files with, SBR 8-25

OS_AUTHENT_PREFIX parameter, OAS 1-14, SRF 1-92

OS_ROLES parameter, SRF 1-92

operating-system authorization and, SAD 24-7

REMOTE_OS_ROLES and, SAD 24-19

using, SAD 24-17

OS_ROLES parameter, setting, OAS 13-6

OSS. See Oracle Security Server.

OSS.MY.WALLET parameter, NET C-15

OSS.SOURCE.CERTIFICATES parameter, NET C-15

OSS.SOURCE.MY_WALLET parameter, NET 7-64

OTHER column

PLAN_TABLE table, STU 13-5

OTHERS exception handler, PLS 6-2, PLS 6-15

OTT, SCN 13-15

command line, OCI 14-6

command line syntax, OCI 14-23

creating types in the database, OCI 14-5

datatype mapping, OCI 14-10

intype file, OCI 14-29

outtype file, OCI 14-16

overview, OCI 14-2

parameters, OCI 14-24

providing an intype file, OCI 14-8

reference, OCI 14-22

restriction, OCI 14-37

using, OCI 14-1

OTT initialization function

calling, OCI 14-20

tasks of, OCI 14-22

OTT parameters

CASE, OCI 14-27, PC_ 19-30

CODE, OCI 14-26, PC_ 19-28

CONFIG, OCI 14-27, PC_ 19-29

ERRTYPE, OCI 14-27, PC_ 19-30

HFILE, OCI 14-26, PC_ 19-29

INITFILE, OCI 14-26, PC_ 19-29

INITFUNC, OCI 14-26, PC_ 19-29

INTYPE, OCI 14-25, PC_ 19-27

OUTTYPE, OCI 14-25, PC_ 19-28

SCHEMA_NAMES, OCI 14-28, PC_ 19-31

USERID, OCI 14-24, PC_ 19-27

where they appear, OCI 14-28, PC_ 19-31

OTT. See Object Type Translator

OTT. See object type translator

OUT Bind Variables, DDS 7-6

OUT bind variables, DDS 7-6

OUT parameter

of CREATE FUNCTION, SQL 7-269

of CREATE PROCEDURE, SQL 7-334

OUT parameter mode, ADG 10 - 6, PC_ 7-3, PCO 6-5, PLS 7-14

OUT_OF_RELAY, NET A-91

outer joins, ADG 3 - 33, SQL 5-22, SQL 7-548, STU 31-22

defined, SCN 23-3

key-preserved tables in, ADG 3 - 34

non-null values for nulls, SCN 24-11

restrictions, SQL 5-22

outlines

assigning category names to, STU 7-28

assigning to a different category, SQL 7-58

automatically creating and storing, SQL 7-101

CREATE OUTLINE statement, STU 7-28

creating, SQL 7-322

creating and using, STU 7-28

creating, using, STU 7-28

dropping, STU 7-30

dropping from the database, SQL 7-464

dropping unused, STU 7-30

enabling and disabling dynamically, SQL 7-322

execution plans and Plan Stability, STU 7-25

granting

system privileges on, SQL 7-497

hints, STU 7-26

managing with OUTLN_PKG, STU 7-30

matching with SQL statements, STU 7-27

reassigning categories, STU 7-31

rebuilding, SQL 7-58

renaming, SQL 7-58

replacing, SQL 7-322

storage requirements, STU 7-27

storing during the session, SQL 7-81

storing for the instance, SQL 7-108

tables, moving, STU 7-31

use by the optimizer, SQL 7-89, SQL 7-108

used to generate execution plans, SQL 7-322

using, STU 7-28

using to move to the cost-based optimizer, STU 7-32

viewing data for, STU 7-29

OUTLN schema

DBA privileges, SCN 22-6

OUTLN user

avoid, MIG 3-10, MIG 4-8, MIG 7-4

change password, MIG 6-4, MIG 7-35

OUTLN_PKG

package to manage outlines, STU 7-30

OUTLN_PKG package, SPR 55 - 1

output file

specifying for Export, SUT 1-19

output host variable, PCO 5-2

output host variables

assigning values to, PC_ 6-2

definition of, PC_ 6-2

Output tab

from Parallel Server Operation Results dialog box, PSC 6-26

output vs input, PCO 5-2

outtype file, OCI 14-29, PC_ 19-32

when running OTT, OCI 14-16, PC_ 19-17

OUTTYPE OTT parameter, OCI 14-25, PC_ 19-28

OVERFLOW clause

of ALTER INDEX, SQL 7-33

of ALTER TABLE, SQL 7-144

of CREATE TABLE, SQL 7-372

overhead

calculating non-PCM resources, SPS 16-4

reducing, PC_ C-2

overhead, process, STU 27-3

overloaded disks, STU 20-20

overloading, PLS 7-23

object method, PLS 9-10

of packaged functions, ADG 10 - 70

packaged subprogram, PLS 8-14

restrictions, PLS 7-24

stored procedure names, ADG 10 - 12

using RESTRICT_REFERENCES, ADG 10 - 70

using subtypes, PLS 7-24

Overriding Language and Territory Specifications, NLS 2-6

oversubscribing resources, STU 27-5, STU 27-9

overview

LSM, LEG 1-2

LSM Features, LEG 1-3, LEG 1-4, LEG 1-5

Oracle backup and recovery system, LEG 1-8

overwrite

conflict resolution method

use of, REP 6-39

conflict resolution methods, RAR 6-3, REP 6-21

OWNER

Export parameter, SUT 1-21

owner of a queued job, SAD 8-7

OWNER# column

SYS.INCEXP table, SUT 1-51

---