Oracle8i Generic Documentation Master Index
Release 2 (8.1.6)

A76991-01

Library

Product

Contents

Prev Up Next

Oracle8i Generic Documentation Master Index


O

o attribute, NET 2-41, OID 2-5
O2F, SMS 35-1
O2I, SMS 36-1
O2U, SMS 37-1
O7_DICTIONARY_ACCESSIBILITY initialization parameter, SAD 23-3, SRF 1-79
O7_DICTIONARY_ACCESSIBILITY parameter
compatibility, MIG 9-25, MIG B-9
OAS, ADG 12-2
obfuscation, OAS 3-4
OBJ synonym for USER_OBJECTS, SRF 2-155
object access expressions, SQL 5-11
object applications
commit, OCI 13-14
database connection, OCI 10-10
rollback, OCI 13-14
object attributes, PLS 9-3, PLS 9-7
accessing, PLS 9-24
allowed datatypes, PLS 9-7
maximum number, PLS 9-7
object cache, ADL 5-20, OCI 13-2, PC_ 17-4, GTK 3-35, GTK 3-36, GTK 4-12, SQL 7-91, SQL 7-115
coherency, OCI 13-4
consistency, OCI 13-4
creating an object in, ADL 5-20
flushing an object, ADO 7-9
initializing, OCI 10-10
loading objects, OCI 13-7
LOBs, ADL 5-20
memory parameters, OCI 13-5
object views, ADO 5-4, SCN 14-4
OCI, ADO 3-2, SCN 13-14
operations on, OCI 13-6
privileges, ADO 2-13
Pro*C, ADO 3-6, SCN 13-14
removing objects, OCI 13-7
setting the size of, OCI 13-5
object class types
abstract, OID 2-9
auxiliary, OID 2-9
structural, OID 2-8, OID 2-9
object classes, OID 2-7
adding, OID 6-2
concurrently, using ldapaddmt, OID A-9
using command line tools, OID 6-17
using Oracle Directory Manager, OID 6-13
assigning to entries, OID 6-2, OID 6-3
converting auxiliary, OID 6-4
creating, using Oracle Directory Manager, OID 4-11
defining, OID 2-7
definition of, OID 2-7
deleting, using Oracle Directory Manager, OID 6-17
described, NET 2-54
groupOfNames, OID 7-20, OID 7-21
in base schema, OID 6-4
in LDIF files, OID A-2
in top, OID 2-9
managing
using command line tools, OID 6-17
modifying, OID 6-3
using command line tools, OID 6-17
using Oracle Directory Manager, OID 6-16
orclauditoc, OID 5-25
orclDBEnterpriseDomain, OAS E-2
orclDBEnterpriseRole, OAS E-2
orclDBEntryLevelMapping, OAS E-2
orclDBServer, OAS E-2, NET 2-54, NET D-2
orclDBSubtreeLevelMapping, OAS E-2
orclNetAddress, NET 2-54, NET D-4
orclNetAddressList, NET 2-54, NET D-4
orclNetDescription, NET 2-54, NET D-3
orclNetDescriptionList, NET 2-54, NET D-3
orclNetService, NET 2-54, NET D-2
redefining mandatory attributes in, OID 6-3
removing attributes from, OID 6-4
removing superclasses from, OID 6-4
rules, OID 2-10
searching for, OID 6-5
stored in schema, OID 2-10
structural, converting, OID 6-4
subclasses, OID 2-8
defining, OID 2-7
superclasses, OID 2-8, OID 6-12
tab in Oracle Directory Manager, OID 6-10
top, OID 2-8
types of, OID 2-9
unique name of, OID 6-3
unique object identifier, OID 6-3
viewing, OID 6-10, OID 6-12
object columns, indexes on, ADG 5-7
object constructors
calling, PLS 9-25
passing parameters to, PLS 9-26
OBJECT CREATE SQL statement, PC_ 17-9, PC_ F-83
Object Database Designer, GTK 4-13
OBJECT DELETE SQL statement, PC_ 17-11, PC_ F-84
OBJECT DEREF SQL statement, PC_ 17-10, PC_ F-85
OBJECT FLUSH SQL statement, PC_ F-86
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-87
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-401
object identifiers, ADO 9-26, GTK 7-8, SCN 14-3, SCN 14-4, SUT 2-54, SUT 5-95
collections
key compression, SCN 10-33, SCN 10-41
contained in REFs, SQL 2-31
Export, SUT 1-58
for object types, ADO 7-2
for object views, SCN 14-3, SCN 14-4
of object views, SQL 7-459
primary key, SQL 7-401
primary-key based, ADO 6-7
REFs, ADO 6-8
specifying, SQL 7-401
specifying an index on, SQL 7-402
storage, ADO 6-7
system-generated, SQL 7-401
user-defined
downgrading, MIG 13-30
WITH OBJECT IDENTIFIER clause, ADO 5-4
WITH OBJECT OID clause, SCN 14-3, SCN 14-4
object identifiers, of object classes, OID 6-7
Object Message, ADQ 12-27
object methods, PLS 9-3, PLS 9-8
calling, PLS 9-26
object names
SQL*Loader, SUT 5-18
Object Naming, ADQ 2-2
object privileges, SCN 305
granting, SQL 7-365
multiple, SQL 7-369
on specific columns, SQL 7-533
to a role, SQL 7-532
to a user, SQL 7-532
to PUCLIC, SQL 7-533
on a database object
revoking, SQL 7-561
on a directory
revoking, SQL 7-560
revoking
all, from a user, SQL 7-560
from a role, SQL 7-559, SQL 7-560
from a user, SQL 7-559, SQL 7-560
from all users, SQL 7-561
from PUBLIC, SQL 7-560
See also schema object privileges
object reference, OCI 10-33
object reference functions, SQL 4-12
object reference. See REF
object relational enhancements, GTK 2-12, GTK 3-33 to GTK 3-37
ANALYZE statement, dangling REFs, GTK 3-36
collection unnesting, GTK 3-35
object cache enhancements, GTK 3-36
object identifiers, user defined, GTK 3-34
object views, GTK 3-35
parallel query support, GTK 3-37
partitioning of tables containing user-defined types, GTK 3-37
referential integrity constraint on REF column, GTK 3-34
SQL*Loader support, GTK 3-36
value subqueries, GTK 3-36
see also LOBs
see also nested tables
see also varrays
OBJECT RELEASE SQL statement, PC_ F-88
object runtime environment
initializing, OCI 10-10
OBJECT SET SQL statement, PC_ 17-14, PC_ F-89
object support, SUT 3-22
object support in OO4O, ADG 1-17
object tables, ADO 1-5, ADO 6-7, ADO 9-23, PLS 9-30, SCN 13-3, SCN 13-8
adding rows to, SQL 7-540
constraints, ADO 2-3
creating, SQL 7-381
deleting values, ADO 9-39
Import, SUT 2-56
indexes, ADO 2-4
inserting values, ADO 9-34
loading, SUT 5-95
partitioned
downgrading, MIG 13-23
querying, ADO 9-37
row objects, ADO 1-6, SCN 13-8
triggers, ADO 2-5
virtual object tables, ADO 5-2, SCN 14-2
object type, DCI 1-8
attributes, DCI 1-15, DCI 11-2
body code, DCI 1-16
comparisons, DCI 3-5
methods, DCI 11-2
specification, DCI 1-15
object type bodies
creating, SQL 7-448
re-creating, SQL 7-448
SQL examples, SQL 7-450
object type definitions
exporting, SUT 1-58
importing, SUT 2-56
object type identifiers, SUT 2-28
object type tables
creating, SQL 7-391
object type translator
sample output, OCI 10-9
See OTT
use with OCI, OCI 10-8
Object Type Translator (OTT), PC_ A-4, GTK 4-12, SCN 13-15
command line, PC_ 19-6
command line syntax, PC_ 19-26
creating types in the database, PC_ 19-5
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-443, SQL 7-449
Object Types, PC_ A-3
object types, ADO 1-2, GTK 4-11, PLS 9-1, PLS 9-3, SCN 1-21, SCN 13-2, SCN 13-4, SQL 2-30
adding new member subprograms, SQL 7-188
advantages, PLS 9-5
associating functions or procedures, SQL 7-188
attributes, SQL 2-82
attributes of, ADO 1-3, SCN 13-2, SCN 13-4
column objects, ADO 1-6, SCN 13-8
indexes, ADO 2-4
column objects vs. row objects, ADO 6-1
comparison methods for, ADO 1-4, ADO 9-20, SCN 13-7
comparison rules, SQL 2-35
MAP function, SQL 2-35
ORDER function, SQL 2-35
compiling the specification and body, SQL 7-187
components of, SQL 2-30
constructor methods for, ADO 1-4, ADO 7-2, SCN 1-56, SCN 13-6
creating, SQL 7-437, SQL 7-439
defining, PLS 9-12
defining member methods of, SQL 7-448
disassociating statistics types from, SQL 7-506
dropping the body of, SQL 7-508
dropping the specification of, SQL 7-506
examples, PLS 9-12
function subprogram
declaring, SQL 7-449
function subprogram of
specifying, SQL 7-442
function subprograms of, SQL 7-441, SQL 7-448
granting system privileges on, SQL 7-528
incomplete, ADO 2-14, ADO 9-14, SQL 7-437, SQL 7-439
invoker-rights, ADO 6-29
locking in cache, ADO 3-3, SCN 13-15
message queuing, SCN 73
methods, SQL 2-82
methods of, ADO 1-3, ADO 9-21, SCN 1-56, SCN 13-4
method calls, ADO 2-8
PL/SQL, ADO 3-2, SCN 13-14
purchase order example, SCN 13-2, SCN 13-5
mutually dependent, ADO 2-14
nested table, SQL 7-439
object views, SCN 10-17
Oracle type translator, ADO 3-8, SCN 13-15
parallel query, SCN 186
restrictions, SCN 186
procedure subprogram
declaring, SQL 7-449
procedure subprogram of
specifying, SQL 7-442
procedure subprograms of, SQL 7-441, SQL 7-448
purchase order example, ADO 1-10, SCN 13-2, SCN 13-4
restrictions
parallel DDL, SCN 188
parallel DML, SCN 201
row objects, ADO 1-6, SCN 13-8
SQL examples, SQL 7-444
statistics types, SQL 7-211
structure, PLS 9-5
syntax, PLS 11-110
use of table aliases, ADO 2-7
user-defined
creating, SQL 7-440
varrays, SQL 7-439
OBJECT UPDATE SQL statement, PC_ 17-12, PC_ F-90
object views, ADO 5-1 to ADO 5-18, GTK 3-35, GTK 4-11, GTK 4-12, SCN 10-17, SCN 14-1
adding rows to the base table of, SQL 7-540
advantages of, ADO 5-2, SCN 14-2
defining, ADO 5-3, SCN 14-3, SQL 7-456
modifiability, SCN 93
nested tables, ADO 5-11, SCN 14-5
object identifiers for, SCN 14-3, SCN 14-4
updating, SCN 14-5
updating through INSTEAD OF triggers, ADO 5-11
use of INSTEAD OF triggers with, SCN 14-5
OBJECT_CACHE_MAX_SIZE_PERCENT initialization parameter, SRF 1-80
OBJECT_CACHE_MAX_SIZE_PERCENT parameter
of ALTER SESSION, SQL 7-91
of ALTER SYSTEM, SQL 7-115
OBJECT_CACHE_OPTIMAL_SIZE initialization parameter, SRF 1-81
OBJECT_CACHE_OPTIMAL_SIZE parameter
of ALTER SESSION, SQL 7-91
of ALTER SYSTEM, SQL 7-115
OBJECT_INSTANCE column
PLAN_TABLE table, STU 5-5
OBJECT_NAME column
PLAN_TABLE table, STU 5-5
OBJECT_NODE column
PLAN_TABLE table, STU 5-4
OBJECT_OWNER column
PLAN_TABLE table, STU 5-5
OBJECT_TYPE column
PLAN_TABLE table, STU 5-5
objectclass attribute, OID 5-25
object-oriented programming, PLS 9-1
object-relational DBMS (ORDBMS), SCN 1-21, SCN 13-2
object-relational design, ADL 8-4
object-relational model, ADO 9-1
comparing objects, ADO 6-7
constraints, ADO 6-37
design considerations, ADO 6-1
embedded objects, ADO 9-26
implementing with object tables, ADO 9-14
inheritance, ADO 1-10
limiations of relational model, ADO 9-11
methods, ADO 1-3
new object format, ADO 6-31
partitioning, ADO 7-14
programmatic environments for, ADO 3-1 to ??
replication, ADO 6-31
type evolution, ADO 6-38
object-relational technology, GTK 4-10
objects, PLS 9-4, SUT 3-15
accessing with OCI, OCI 14-19, PC_ 19-19
adding to snapshot sites, SPR 37-42, RAR 8-108
adding, by using Oracle Directory Manager, OID 4-12
allocation duration, OCI 13-14
altering, SPR 37-17, RAR 7-27, RAR 8-83
array pin, OCI 10-13
attributes, OCI 10-17
manipulating, OCI 10-13
client-side cache, OCI 13-2
collection objects, ADO 5-6
comparing, OID 4-10
considerations for importing, SUT 2-54
copying, OCI 10-32
creating, OCI 10-32, SPR 37-38, RAR 8-104
for master group, SPR 37-37, RAR 8-103
for master sites, SPR 37-38, RAR 8-104
for snapshot sites, SPR 37-42, RAR 8-108
creation errors, SUT 2-46
data dictionary, SRF 2-2
declaring, PLS 9-22
dropping
snapshot site, SPR 37-60, RAR 8-126
dropping from snapshot sites, RAR 7-13
duration, OCI 13-14
flushing, OCI 13-10
flushing changes, OCI 10-14
freeing, OCI 10-32, OCI 13-9
generating replication support for, SPR 37-64, RAR 8-130
GRANT OPTION, ADG 11-30
granting privileges, ADG 11-22, ADG 11-30
ignoring existing objects during import, SUT 2-22
import creation errors, SUT 2-22
in columns, ADO 5-4
initializing, PLS 9-23
introduction to, PC_ 17-2
lifetime, OCI 16-2
loading column objects, SUT 5-90
loading nested column objects, SUT 5-92
LOB attribute of, OCI 7-3
LOB attributes of transient objects, OCI 7-4
locking, OCI 13-12
manipulating, PLS 9-30
manipulating with OCI, OCI 14-19, PC_ 19-19
marking, OCI 10-14, OCI 13-9
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, ADO 5-9
OCI object application structure, OCI 10-4
of ACI directives, OID 9-6
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, ADG 11-21, SUT 2-11
privileges on, SCN 314
references to, PC_ 17-2
referencing with synonyms, DDS 2-29
refreshing, OCI 13-11
replicated
re-creating, REP B-4
restoring sets
Import, SUT 2-41
revoking privileges, ADG 11-31
row objects and object identifiers, ADO 5-6
searching for, using Oracle Directory Manager, OID 4-12
secondary memory, OCI 13-16
See also schema objects
sharing, PLS 9-27
stream record format, SUT 5-90
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-91
Objects for OLE, GTK 3-86
objects owned by SYS
and TSPITR using RMAN, RMN 8-6
OBJECTS precompiler option, PC_ 10-33, PC_ 17-20
objects. See object types or database objects
objects, schema
listing information, ADG 2-41
name resolution, ADG 2-38
renaming, ADG 2-40
obsolete parameters, PSC A-22, PSC A-23
obsolete parameters in release 8.1, NET C-80
obsolete replication procedures, MIG G-14
ocation of the Pro*C/C++ Executable, PC_ E-3
OCI, ADG 9-2, SCN 8-27
accessing and manipulating objects, OCI 14-19
advantages, ADG 1-7, OCI 1-3
anonymous blocks, SCN 26
applications, ADG 9-4
changing to use Oracle8i, MIG 10-11
associative access, ADO 3-3
available LOB functions, ADL 3-3
bind variables, SCN 22
buffering example, ADL 5-28
cancelling cursors, ADG 7-10
closing cursors, ADG 7-10
compatibility, MIG 9-18
batch error mode, MIG 9-19
client notification, MIG 9-9, MIG 9-19
link line, MIG 9-19
LISTEN call and AQ, MIG 9-20
thread safety, MIG 9-19
complex object retrieval (COR), ADO 7-9
creating a new object, ADO 7-4
deleting an object, ADO 7-5
enabling roles, ADG 11-17
for Oracle objects
building a program, ADO 3-5
functions for BFILEs, ADL 3-15
functions for temporary LOBs, ADL 3-15
functions to modify internal LOB values, ADL 3-14
functions to open/close internal and external LOBs, ADL 3-16
functions to read or examine internal and external LOB values, ADL 3-15
initializing object manipulation, ADO 7-4
interoperability, MIG 9-18
Oracle7 clients, MIG 9-19
shared structures, MIG 9-18
LOB locator functions, ADL 3-16
LOB manipulation functions, DCI 6-6
Lob-buffering functions, ADL 3-16
locators, ADL 2-7
lock options, ADO 7-8
navigational access, ADO 3-4
NCLOB parameters, ADL 3-13
new features, OCI 1-12
object cache, ADO 3-4, ADO 7-11, SCN 13-14
flushing an object, ADO 7-9
object support, OCI 1-6
OCIChangePassword call, MIG 9-37
OCILobFileGetLength
CLOB and NCLOB input and output length, ADL 3-12
OCILobRead
varying-width CLOB and NCLOB input and amount amounts, ADL 3-12
OCILobWrite
varying-width CLOB and NCLOB input and amount amounts, ADL 3-12
OCIObjectFlush, ADO 5-4, SCN 14-4
OCIObjectPin, ADO 5-4, SCN 14-4
OCISessionBegin call, MIG 9-37
offset and amount parameter rules
fixed-width character sets, ADL 3-11
optimizing data transfers using, DDS 9-10
overview, ADG 1-7, OCI 1-2
parts of, ADG 1-8, OCI 1-5
pinning and unpinning objects, ADO 7-6
seeIfLOBOpen and how to use main(), ADL 3-17
setting OCILobRead, OCILobWrite to OCI_UCS2ID, ADL 3-11
stored procedures, SCN 27
temporary LOBs, ADL 10-12
temporary lobs can be grouped into logical buckets, ADL 10-8
updating an object, ADO 7-5
upgrading applications to Oracle8i, MIG 10-3
using to work LOBs, ADL 3-11
OCI application
compiling, OCI 1-4
general structure, OCI 2-3
initialization example, OCI 2-24
linking, OCI 1-4
steps, OCI 2-18
structure, OCI 2-3
structure using objects, OCI 10-4
terminating, OCI 2-27
using the OTT with, OCI 14-18
with objects
initializing, OCI 10-10
OCI applications
upgrading options, MIG 10-8
using the OTT with, PC_ 19-18
OCI calls, PC_ 1-7
embedding, PC_ 5-50
in an X/A environment, PC_ 5-56
OCI enhancements, GTK 3-84
API to append data to LOBs, GTK 3-34
AQ support, GTK 3-38
array DMLs, GTK 3-84
asynchronous event notification, GTK 3-85
collection locator, GTK 3-34
direct path load, GTK 3-23
DML returning, GTK 3-84
LOBs, GTK 3-34
NLS interface, GTK 3-43
non-blocking OCI, GTK 3-85
object cache, GTK 3-36
OCI callback registrations, GTK 3-84
OCIDescribeAny, GTK 3-85
Open/Close/IsOpen API for LOBS, GTK 3-34
UCS2 (fixed-width Unicode) support, GTK 3-43
OCI environment
initializing for objects, OCI 10-10
OCI functions
advanced queuing, OCI xvii
canceling calls, OCI 2-34
codes, OCI 15-237
data cartridges, OCI xvii, OCI 2-3
new and updated calls, OCI 1-13
NLS, OCI xvii, OCI 2-3
not supported, OCI 1-21
obsolescent, OCI 1-19
other guides, OCI xvii
return codes, OCI 2-27, OCI 2-30
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 7-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-90
guide to reference entries, DCI 13-2, 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. See Oracle Call Interface.
OCI single-task linking, GTK 7-5
OCI support for client notification, GTK 3-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-35
OCI vs precompilers, ADG 1-37
OCI, described, NET 3-7
OCI_ATTR_ALLOC_DURATION
environment handle attribute, OCI A-4
OCI_ATTR_AUTOCOMMIT_DDL
attribute, OCI 6-20
OCI_ATTR_BUF_ADDR, OCI A-44
OCI_ATTR_BUF_SIZE, OCI A-40, OCI A-44
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-21
define handle attribute, OCI A-23
use of, OCI 5-33
OCI_ATTR_CHARSET_FORM
attribute, OCI 6-11, OCI 6-14, OCI 6-16
bind handle attribute, OCI A-21
define handle attribute, OCI A-24
OCI_ATTR_CHARSET_ID, OCI A-40, OCI A-47
attribute, OCI 6-11, OCI 6-14, OCI 6-16, OCI 6-18, OCI 6-19
bind handle attribute, OCI A-21
define handle attribute, OCI A-23
OCI_ATTR_CLUSTERED
attribute, OCI 6-7
OCI_ATTR_COL_COUNT, OCI A-43
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-26
OCI_ATTR_COMPLEXOBJECT_LEVEL
COR handle attribute, OCI A-26
OCI_ATTR_COMPLEXOBJECTCOMP _TYPE_LEVEL
COR descriptor attribute, OCI A-27
OCI_ATTR_COMPLEXOBJECTCOMP_TYPE
COR descriptor attribute, OCI A-27
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-48
attribute, OCI 6-10, OCI 6-13, OCI 6-15, OCI 6-16
OCI_ATTR_DATE_FORMAT, OCI A-40
OCI_ATTR_DATEFORMAT, OCI A-48
OCI_ATTR_DBA
attribute, OCI 6-7
OCI_ATTR_DIRPATH_MODE, OCI A-41
OCI_ATTR_DIRPATH_NOLOG, OCI A-41
OCI_ATTR_DIRPATH_PARALLEL, OCI A-41
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, OCI 8-7, OCI 8-16
server handle attribute, OCI A-9
OCI_ATTR_EXTERNAL_USER_NAME, OCI A-13
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_INITIAL_CLIENT_ROLES, OCI 8-17, OCI A-13
OCI_ATTR_INTERNAL_NAME, OCI 8-7
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-41
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-26
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-22
use with binding, OCI 5-32
OCI_ATTR_MEMPOOL_APPNAME, OCI A-50
OCI_ATTR_MEMPOOL_HOMENAME, OCI A-50
OCI_ATTR_MEMPOOL_INSTNAME, OCI A-51
OCI_ATTR_MEMPOOL_SIZE, OCI A-51
OCI_ATTR_MIGSESSION
user session handle attribute, OCI A-12
OCI_ATTR_MIN
attribute, OCI 6-14
OCI_ATTR_NAME, OCI A-42, OCI A-48
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-42, OCI A-43
attribute, OCI 6-7
OCI_ATTR_NUM_DML_ERRORS, OCI A-15
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-43
OCI_ATTR_NUM_TYPE_ATTRS
attribute, OCI 6-9
OCI_ATTR_NUM_TYPE_METHODS
attribute, OCI 6-10
OCI_ATTR_OBJ_ID, OCI 6-5
OCI_ATTR_OBJ_NAME, OCI 6-5
OCI_ATTR_OBJ_SCHEMA, OCI 6-5
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-25
use when an attribute is itself a descriptor, OCI 15-29
OCI_ATTR_PARAM_COUNT
describe handle attribute, OCI A-25
statement handle attribute, OCI A-18
OCI_ATTR_PARSE_ERROR_OFFSET, OCI A-20
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-22, OCI A-24
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-49
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-19
OCI_ATTR_PREFETCH_ROWS
statement handle attribute, OCI A-19
OCI_ATTR_PROC_MODE, OCI A-51
OCI_ATTR_PROXY_CREDENTIALS, OCI 8-16, OCI A-13
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-44
OCI_ATTR_ROWID
statement handle attribute, OCI A-18
OCI_ATTR_ROWS_RETURNED
bind handle attribute, OCI A-23
use with callbacks, OCI 5-30
OCI_ATTR_SAVEPOINT_SUPPORT
attribute, OCI 6-20
OCI_ATTR_SCALE, OCI A-49
attribute, OCI 6-10, OCI 6-13, OCI 6-15, OCI 6-17
OCI_ATTR_SCHEMA_NAME, OCI A-42
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_SERVER_STATUS
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_SQLFNCODE
statement handle attribute, OCI A-15
OCI_ATTR_STMT_TYPE
statement handle attribute, OCI A-18
OCI_ATTR_STREAM_OFFSET, OCI A-45
OCI_ATTR_SUB_NAME, OCI A-43
attribute, OCI 6-18
OCI_ATTR_SUBSCR_CALLBACK, OCI A-38
OCI_ATTR_SUBSCR_CTX, OCI A-38
OCI_ATTR_SUBSCR_NAME, OCI A-39
OCI_ATTR_SUBSCR_NAMESPACE, OCI A-38
OCI_ATTR_SUBSCR_PAYLOAD, OCI A-39
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, OCI 8-4
transaction handle attribute, OCI A-14
OCI_ATTR_TRANS_TIMEOUT
transaction handle attribute, OCI A-14
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, OCI 8-4
transaction handle attribute, OCI A-14
OCI_CONTINUE, OCI 2-28
OCI_CRED_PROXY, OCI 8-16
OCI_CRED_RDBMS, OCI 8-16
OCI_DEFAULT, OCI 8-23
OCI_DTYPE_AQAGENT, OCI 2-14
OCI_DTYPE_AQDEQ_OPTIONS, OCI 2-14
OCI_DTYPE_AQENQ_OPTIONS, OCI 2-14
OCI_DTYPE_AQMSG_PROPERTIES, OCI 2-14
OCI_DTYPE_AQNFY, OCI 2-14
OCI_DTYPE_COMPLEXOBJECTCOMP, OCI 2-14
OCI_DTYPE_FILE, OCI 2-14
OCI_DTYPE_LOB, OCI 2-14
OCI_DTYPE_PARAM, OCI 2-14, OCI 15-28, OCI 15-40
use in code samples, OCI 4-13
when used, OCI 15-29
OCI_DTYPE_ROWID, OCI 2-14
OCI_DTYPE_SNAP, OCI 2-14
OCI_DURATION_SESSION, DCI 13-13, OCI 15-112, OCI 18-10
OCI_DURATION_STATEMENT, DCI 13-13, OCI 15-112, OCI 18-10
OCI_ERROR, OCI 2-27, OCI 8-8
OCI_EVENTS
mode for receiving notifications, OCI 9-32
OCI_EXT_CRED, OCI 8-16
OCI_HTYPE_BIND, OCI 2-6
OCI_HTYPE_COMPLEXOBJECT, OCI 2-6
OCI_HTYPE_COR, OCI 15-40
OCI_HTYPE_DEFINE, OCI 2-6
OCI_HTYPE_DESCRIBE, OCI 2-6
OCI_HTYPE_DIRPATH_COLUMN_ARRAY, OCI 2-7
OCI_HTYPE_DIRPATH_CTX, OCI 2-6
OCI_HTYPE_DIRPATH_STREAM, OCI 2-7
OCI_HTYPE_ENV, OCI 2-6
OCI_HTYPE_ERROR, OCI 2-6
OCI_HTYPE_PROC, OCI 2-7
OCI_HTYPE_SERVER, OCI 2-6
OCI_HTYPE_SESSION, OCI 2-6
OCI_HTYPE_STMT, OCI 2-6, OCI 15-28, OCI 15-40
OCI_HTYPE_SUBSCRIPTION, OCI 2-6
OCI_HTYPE_SVCCTX, OCI 2-6
OCI_HTYPE_TRANS, OCI 2-6
OCI_INVALID_HANDLE, OCI 2-28
OCI_LOCK_X_NOWAIT
parameter usage, OCI 13-13
OCI_MIGRATE, OCI 8-12
OCI_NEED_DATA, OCI 2-28
OCI_NO_DATA, OCI 2-27
OCI_NO_MUTEX, OCI 8-23
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-22
OCI_STILL_EXECUTING, OCI 2-28
OCI_SUCCESS, OCI 2-27, OCI 8-8
OCI_SUCCESS_WITH_INFO, OCI 2-27
OCI_THREADED, OCI 8-23
OCI_TRANS_LOOSE, OCI 8-5
OCI_TRANS_READONLY, OCI 8-4, OCI 8-10
OCI_TRANS_RESUME, OCI 8-10
OCI_TRANS_SERIALIZABLE, OCI 8-4
OCI_TRANS_TIGHT, OCI 8-5
OCI_TRANS_TWOPHASE, OCI 8-10
OCI_TYPECODE
values, OCI 3-23, OCI 3-24, OCI 3-25
OCIAQAgent
descriptor attributes, OCI A-36
OCIAQDeq(), OCI 15-5
OCIAQDeqOptions
descriptor attributes, OCI A-29
OCIAQEnq(), OCI 15-7
OCIAQEnqOptions
descriptor attributes, OCI A-27
OCIAQListen(), OCI 15-19
OCIAQMsgProperties
descriptor attributes, OCI A-32
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-12
OCIAttrSet(), OCI 15-30
OCIBindArrayOfStruct(), OCI 15-44
OCIBindByName(), ADL 7-16, OCI 15-45
OCIBindByPos(), ADL 7-16, OCI 15-49
OCIBindDynamic(), OCI 15-53
OCIBindObject(), OCI 15-57
OCIBreak(), OCI 15-222
use of, OCI 2-34, OCI 2-38
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
OCIContextClearValue(), DCI 13-27, OCI 18-21
OCIContextGenerateKey(), DCI 13-29, OCI 18-22
OCIContextGetValue(), DCI 13-25, OCI 18-20
OCIContextSetValue(), DCI 13-23, OCI 18-18
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-59
OCIDefineByPos(), OCI 15-60
OCIDefineDynamic(), OCI 15-64
OCIDefineObject(), OCI 15-67
OCIDescAlloc(), OCI 15-32
OCIDescFree(), OCI 15-34
OCIDescribeAny(), OCI 15-69
usage examples, OCI 6-20
using, OCI 6-2
ocidfn.h, PC_ 5-50
OCIDirPathAbort(), OCI 15-75
OCIDirPathColArrayEntryGet(), OCI 15-76
OCIDirPathColArrayEntrySet(), OCI 15-78
OCIDirPathColArrayReset(), OCI 15-82
OCIDirPathColArrayRowGet(), OCI 15-80
OCIDirPathColArrayToStream(), OCI 15-83
OCIDirPathFinish(), OCI 15-85
OCIDirPathFlushRow(), OCI 15-86
OCIDirPathPrepare(), OCI 15-88
OCIDirPathStreamLoad(), OCI 15-86
OCIDirPathStreamReset(), OCI 15-89
OCIDuration
use of, OCI 13-7, OCI 13-14
OCIDuration(), ADL 10-8
OCIDurationBegin(), DCI 13-13, OCI 15-112, OCI 18-10
OCIDurationEnd(), ADL 10-8, ADL 10-12, ADL 10-28, DCI 13-15, OCI 15-113, OCI 18-12
OCIEnvCreate(), OCI 15-91
OCIEnvInit(), OCI 15-94
OCIErrorGet(), OCI 15-223
OCIExtProcAllocCallmemory(), DCI 13-5, DCI 13-6, DCI 13-7, DCI 13-9, OCI 18-5
OCIExtProcAllocMemory routine, DCI 4-12
OCIExtProcGetEnv(), DCI 13-11, OCI 18-8
OCIExtProcRaiseExcp routine, DCI 4-13
OCIExtProcRaiseExcp(), OCI 18-6
OCIExtProcRaiseExcpWithMsg routine, DCI 4-13
OCIExtProcRaiseExcpWithMsg(), DCI 13-9, OCI 18-7
OCIExtractFromFile(), DCI 13-38, OCI 18-30
OCIExtractFromList(), DCI 13-51, OCI 18-38
OCIExtractFromStr(), DCI 13-40, OCI 18-31
OCIExtractInit(), DCI 13-31, OCI 18-24
OCIExtractReset(), DCI 13-33, OCI 18-26
OCIExtractSetKey(), DCI 13-35, OCI 18-28
OCIExtractSetNumKeys(), DCI 13-34, OCI 18-27
OCIExtractTerm(), DCI 13-32, OCI 18-25
OCIExtractToBool(), DCI 13-44, OCI 18-33
OCIExtractToInt(), DCI 13-42, OCI 18-32
OCIExtractToList(), DCI 13-50, OCI 18-37
OCIExtractToOCINum(), DCI 13-48, OCI 18-36
OCIFileClose(), DCI 13-59, OCI 18-45
OCIFileExists(), DCI 13-67, OCI 18-51
OCIFileInit(), DCI 13-54, OCI 18-41
OCIFileObject, DCI 13-53
OCIFileRead(), DCI 13-61, OCI 18-46
OCIFileSeek(), DCI 13-65, OCI 18-49
OCIFileTerm(), DCI 13-55, OCI 18-42
OCIFileWrite(), DCI 13-63, OCI 18-48
OCIFormatInit(), OCI 18-55
OCIFormatString(), OCI 18-57
OCIFormatTerm(), OCI 18-56
OCIHandleAlloc(), OCI 15-35
OCIHandleFree(), OCI 15-38
OCIInd
use of, OCI 10-29
OCIInitialize(), OCI 15-96
shared mode, OCI 2-21
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-225
OCILob...() functions, DCI 6-6
OCILobAppend(), OCI 15-114
OCILobAssign(), ADL 5-22, ADL 10-10, OCI 15-115
OCILobCharSet(), OCI 15-117, OCI 15-118
OCILobClose(), OCI 15-119
OCILobCopy(), OCI 15-120
OCILobCreateTemporary(), OCI 15-122
OCILobDisableBuffering(), OCI 15-124
OCILobEnableBuffering(), OCI 15-125
OCILobErase(), OCI 15-126
OCILobFileClose(), OCI 15-127
OCILobFileCloseAll(), OCI 15-128
OCILobFileExists(), OCI 15-129
OCILobFileGetName(), OCI 15-130
OCILobFileIsOpen(), OCI 15-132
OCILobFileOpen(), OCI 15-133
OCILobFileSetName(), ADL 11-7, ADL 11-13, OCI 15-134
OCILobFlushBuffer(), ADL 5-26, OCI 15-135
OCILOBFreeTemporary(), ADL 10-28
OCILobFreeTemporary(), OCI 15-137
OCILobGetChunkSize(), OCI 15-138
OCILobGetLength(), ADL 11-99, OCI 15-140
OCILobIsEqual(), OCI 15-141
OCILobIsOpen(), OCI 15-142
OCILobIsTemporary(), OCI 15-144
OCILobLoadFromFile(), ADL 11-48, OCI 15-145
OCILobLocatorAssign(), OCI 15-147
OCILobLocatorIsInit(), OCI 15-149
OCILobOpen(), OCI 15-150
OCILobRead(), ADL 9-91, ADL 9-102, ADL 10-58, ADL 11-99, OCI 15-152
amount, ADL 6-6
to read large amounts of LOB data, ADL 9-65
OCILobTrim(), OCI 15-156
OCILobWrite(), ADL 10-152, OCI 15-157
to write large amounts of LOB data, ADL 9-76
OCILobWriteAppend(), ADL 9-192, OCI 15-161
OCILockOpt
possible values, OCI 16-28, OCI 16-54
OCILogoff(), OCI 15-99
OCILogon(), OCI 15-100
using, OCI 2-23
OCIMemoryAlloc(, DCI 13-17, OCI 18-13
OCIMemoryFree(), DCI 13-21, OCI 18-16
OCIMemoryResize(), DCI 13-19, OCI 18-15
OCIMultiTransPrepare(), OCI 15-210
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(), ADL 11-13, 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(), ADL 11-13, 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-40
used for describing, OCI 4-12
OCIParamSet(), OCI 15-42
OCIPasswordChange(), OCI 15-226
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-228
use of, OCI 2-38
OCIRowid, OCI 2-16
OCIServerAttach(), OCI 15-102
shadow processes, OCI 15-103
OCIServerDetach(), OCI 15-104
OCIServerVersion(), OCI 15-229
OCISessionBegin(), OCI 15-105
OCISessionEnd(), OCI 15-108
OCISetAttr(), ADL 11-13
OCIStmtExecute(), OCI 15-165
prefetch during, OCI 4-6
use of iters parameter, OCI 4-6
OCIStmtFetch(), OCI 15-168
OCIStmtGetBind(), OCI 15-72
OCIStmtGetPieceInfo(), OCI 15-170
OCIStmtPrepare(), OCI 15-172
preparing SQL statements, OCI 4-4
shared mode, OCI 2-21
OCIStmtSetPieceInfo(), OCI 15-174
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-230
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-109
OCIThreadClose(), OCI 15-178
OCIThreadCreate(), OCI 15-179
OCIThreadHandleGet(), OCI 15-181
OCIThreadHndDestroy(), OCI 15-182
OCIThreadHndInit(), OCI 15-183
OCIThreadIdDestroy(), OCI 15-184
OCIThreadIdGet(), OCI 15-185
OCIThreadIdInit(), OCI 15-186
OCIThreadIdNull(), OCI 15-187
OCIThreadIdSame(), OCI 15-188
OCIThreadIdSet(), OCI 15-189
OCIThreadIdSetNull(), OCI 15-190
OCIThreadInit(), OCI 15-191
OCIThreadIsMulti(), OCI 15-192
OCIThreadJoin(), OCI 15-193
OCIThreadKeyDestroy(), OCI 15-194
OCIThreadKeyGet(), OCI 15-195
OCIThreadKeyInit(), OCI 15-196
OCIThreadKeySet(), OCI 15-197
OCIThreadMutexAcquire(), OCI 15-198
OCIThreadMutexDestroy(), OCI 15-199
OCIThreadMutexInit(), OCI 15-200
OCIThreadMutexRelease(), OCI 15-201
OCIThreadProcessInit(), OCI 15-202
OCIThreadTerm(), OCI 15-203
OCITransCommit(), OCI 15-205
OCITransDetach(), OCI 15-208
OCITransForget(), OCI 15-209
OCITransMultiPrepare(), OCI 8-8
OCITransPrepare(), OCI 15-211
OCITransRollback(), OCI 15-212
OCITransStart(), OCI 15-213
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-231
OCIUserCallbackRegister(), OCI 15-233
ODBC agents
connectivity requirements, DDS 8-12
functions, DDS 8-12
ODBC connectivity
data dictionary mapping, DDS C-4
mapping OBDC datatypes, DDS D-2
mapping Oracle datatypes, DDS D-2
ODBC driver, DDS 8-12
requirements, DDS 8-12
specifying connection information
UNIX, DDS A-4
Windows NT, DDS A-4
specifying path to library, DDS A-5
ODCIArgDesc, DCI 15-33
ODCIArgDesc - oracle.ODCI.ODCIArgDesc, JPR 3-3
ODCIArgDesc() - oracle.ODCI.ODCIArgDesc.ODCIArgDesc(), JPR 3-4
ODCIArgDesc(Connection) - oracle.ODCI.ODCIArgDesc.ODCIArgDesc(java.sql.Connection), JPR 3-4
ODCIArgDesc(ConnectionContext) - oracle.ODCI.ODCIArgDesc.ODCIArgDesc(sqlj.runtime.ConnectionContext), JPR 3-4
ODCIArgDescList, DCI 15-33
ODCIArgDescList - oracle.ODCI.ODCIArgDescList, JPR 3-6
ODCIArgDescList() - oracle.ODCI.ODCIArgDescList.ODCIArgDescList(), JPR 3-7
ODCIArgDescList(ODCIArgDesc[]) - oracle.ODCI.ODCIArgDescList.ODCIArgDescList(oracle.ODCI.ODCIArgDesc[]), JPR 3-7
ODCIArgDescRef, DCI 15-33
ODCIArgDescRef - oracle.ODCI.ODCIArgDescRef, JPR 3-9
ODCIArgDescRef() - oracle.ODCI.ODCIArgDescRef.ODCIArgDescRef(), JPR 3-10
ODCIColInfo, DCI 15-33
ODCIColInfo - oracle.ODCI.ODCIColInfo, JPR 3-11
ODCIColInfo() - oracle.ODCI.ODCIColInfo.ODCIColInfo(), JPR 3-12
ODCIColInfo(Connection) - oracle.ODCI.ODCIColInfo.ODCIColInfo(java.sql.Connection), JPR 3-12
ODCIColInfo(ConnectionContext) - oracle.ODCI.ODCIColInfo.ODCIColInfo(sqlj.runtime.ConnectionContext), JPR 3-12
ODCIColInfoList, DCI 15-33
ODCIColInfoList - oracle.ODCI.ODCIColInfoList, JPR 3-14
ODCIColInfoList() - oracle.ODCI.ODCIColInfoList.ODCIColInfoList(), JPR 3-15
ODCIColInfoList(ODCIColInfo[]) - oracle.ODCI.ODCIColInfoList.ODCIColInfoList(oracle.ODCI.ODCIColInfo[]), JPR 3-15
ODCIColInfoRef, DCI 15-33
ODCIColInfoRef - oracle.ODCI.ODCIColInfoRef, JPR 3-17
ODCIColInfoRef() - oracle.ODCI.ODCIColInfoRef.ODCIColInfoRef(), JPR 3-18
ODCICost, DCI 15-33
ODCICost - oracle.ODCI.ODCICost, JPR 3-19
ODCICost() - oracle.ODCI.ODCICost.ODCICost(), JPR 3-20
ODCICost(Connection) - oracle.ODCI.ODCICost.ODCICost(java.sql.Connection), JPR 3-20
ODCICost(ConnectionContext) - oracle.ODCI.ODCICost.ODCICost(sqlj.runtime.ConnectionContext), JPR 3-20
ODCICostRef, DCI 15-33
ODCICostRef - oracle.ODCI.ODCICostRef, JPR 3-22
ODCICostRef() - oracle.ODCI.ODCICostRef.ODCICostRef(), JPR 3-23
ODCIFuncInfo, DCI 15-33
ODCIFuncInfo - oracle.ODCI.ODCIFuncInfo, JPR 3-24
ODCIFuncInfo() - oracle.ODCI.ODCIFuncInfo.ODCIFuncInfo(), JPR 3-25
ODCIFuncInfo(Connection) - oracle.ODCI.ODCIFuncInfo.ODCIFuncInfo(java.sql.Connection), JPR 3-25
ODCIFuncInfo(ConnectionContext) - oracle.ODCI.ODCIFuncInfo.ODCIFuncInfo(sqlj.runtime.ConnectionContext), JPR 3-25
ODCIFuncInfoRef, DCI 15-33
ODCIFuncInfoRef - oracle.ODCI.ODCIFuncInfoRef, JPR 3-27
ODCIFuncInfoRef() - oracle.ODCI.ODCIFuncInfoRef.ODCIFuncInfoRef(), JPR 3-28
ODCIGetInterfaces method, DCI 11-25
ODCIIndex, SCN 10-46
ODCIIndexClose method, DCI 11-33
ODCIIndexCreate method, DCI 11-25
ODCIIndexCtx, DCI 15-33
ODCIIndexCtx - oracle.ODCI.ODCIIndexCtx, JPR 3-29
ODCIIndexCtx() - oracle.ODCI.ODCIIndexCtx.ODCIIndexCtx(), JPR 3-30
ODCIIndexCtx(Connection) - oracle.ODCI.ODCIIndexCtx.ODCIIndexCtx(java.sql.Connection), JPR 3-30
ODCIIndexCtx(ConnectionContext) - oracle.ODCI.ODCIIndexCtx.ODCIIndexCtx(sqlj.runtime.ConnectionContext), JPR 3-30
ODCIIndexCtxRef, DCI 15-33
ODCIIndexCtxRef - oracle.ODCI.ODCIIndexCtxRef, JPR 3-32
ODCIIndexCtxRef() - oracle.ODCI.ODCIIndexCtxRef.ODCIIndexCtxRef(), JPR 3-33
ODCIIndexDelete method, DCI 11-34
ODCIIndexDrop method, DCI 11-27
ODCIIndexFetch method, DCI 11-32
ODCIIndexGetMetadata method, DCI 11-37
ODCIIndexInfo, DCI 15-33
ODCIIndexInfo - oracle.ODCI.ODCIIndexInfo, JPR 3-34
ODCIIndexInfo() - oracle.ODCI.ODCIIndexInfo.ODCIIndexInfo(), JPR 3-35
ODCIIndexInfo(Connection) - oracle.ODCI.ODCIIndexInfo.ODCIIndexInfo(java.sql.Connection), JPR 3-35
ODCIIndexInfo(ConnectionContext) - oracle.ODCI.ODCIIndexInfo.ODCIIndexInfo(sqlj.runtime.ConnectionContext), JPR 3-35
ODCIIndexInfoRef, DCI 15-33
ODCIIndexInfoRef - oracle.ODCI.ODCIIndexInfoRef, JPR 3-37
ODCIIndexInfoRef() - oracle.ODCI.ODCIIndexInfoRef.ODCIIndexInfoRef(), JPR 3-38
ODCIIndexInsert method, DCI 11-33
ODCIIndexStart method, DCI 11-28, DCI 11-30
ODCIIndexUpdate method, DCI 11-35
ODCI.jar, MIG 8-5
ODCIObject, DCI 15-33
ODCIObject - oracle.ODCI.ODCIObject, JPR 3-39
ODCIObject() - oracle.ODCI.ODCIObject.ODCIObject(), JPR 3-40
ODCIObject(Connection) - oracle.ODCI.ODCIObject.ODCIObject(java.sql.Connection), JPR 3-40
ODCIObject(ConnectionContext) - oracle.ODCI.ODCIObject.ODCIObject(sqlj.runtime.ConnectionContext), JPR 3-40
ODCIObjectList, DCI 15-33
ODCIObjectList - oracle.ODCI.ODCIObjectList, JPR 3-42
ODCIObjectList() - oracle.ODCI.ODCIObjectList.ODCIObjectList(), JPR 3-43
ODCIObjectList(ODCIObject[]) - oracle.ODCI.ODCIObjectList.ODCIObjectList(oracle.ODCI.ODCIObject[]), JPR 3-43
ODCIObjectRef, DCI 15-33
ODCIObjectRef - oracle.ODCI.ODCIObjectRef, JPR 3-45
ODCIObjectRef() - oracle.ODCI.ODCIObjectRef.ODCIObjectRef(), JPR 3-46
ODCIPredInfo, DCI 15-33
ODCIPredInfo - oracle.ODCI.ODCIPredInfo, JPR 3-47
ODCIPredInfo() - oracle.ODCI.ODCIPredInfo.ODCIPredInfo(), JPR 3-48
ODCIPredInfo(Connection) - oracle.ODCI.ODCIPredInfo.ODCIPredInfo(java.sql.Connection), JPR 3-48
ODCIPredInfo(ConnectionContext) - oracle.ODCI.ODCIPredInfo.ODCIPredInfo(sqlj.runtime.ConnectionContext), JPR 3-48
ODCIPredInfoRef, DCI 15-33
ODCIPredInfoRef - oracle.ODCI.ODCIPredInfoRef, JPR 3-50
ODCIPredInfoRef() - oracle.ODCI.ODCIPredInfoRef.ODCIPredInfoRef(), JPR 3-51
ODCIQueryInfo, DCI 15-33
ODCIQueryInfo - oracle.ODCI.ODCIQueryInfo, JPR 3-52
ODCIQueryInfo() - oracle.ODCI.ODCIQueryInfo.ODCIQueryInfo(), JPR 3-53
ODCIQueryInfo(Connection) - oracle.ODCI.ODCIQueryInfo.ODCIQueryInfo(java.sql.Connection), JPR 3-53
ODCIQueryInfo(ConnectionContext) - oracle.ODCI.ODCIQueryInfo.ODCIQueryInfo(sqlj.runtime.ConnectionContext), JPR 3-53
ODCIQueryInfoRef, DCI 15-33
ODCIQueryInfoRef - oracle.ODCI.ODCIQueryInfoRef, JPR 3-55
ODCIQueryInfoRef() - oracle.ODCI.ODCIQueryInfoRef.ODCIQueryInfoRef(), JPR 3-56
ODCIRidList, DCI 15-33
ODCIRidList - oracle.ODCI.ODCIRidList, JPR 3-57
ODCIRidList() - oracle.ODCI.ODCIRidList.ODCIRidList(), JPR 3-58
ODCIRidList(String[]) - oracle.ODCI.ODCIRidList.ODCIRidList(java.lang.String[]), JPR 3-58
ODCIStatsOptions, DCI 15-33
ODCIStatsOptions - oracle.ODCI.ODCIStatsOptions, JPR 3-60
ODCIStatsOptions() - oracle.ODCI.ODCIStatsOptions.ODCIStatsOptions(), JPR 3-61
ODCIStatsOptions(Connection) - oracle.ODCI.ODCIStatsOptions.ODCIStatsOptions(java.sql.Connection), JPR 3-61
ODCIStatsOptions(ConnectionContext) - oracle.ODCI.ODCIStatsOptions.ODCIStatsOptions(sqlj.runtime.ConnectionContext), JPR 3-61
ODCIStatsOptionsRef, DCI 15-33
ODCIStatsOptionsRef - oracle.ODCI.ODCIStatsOptionsRef, JPR 3-63
ODCIStatsOptionsRef() - oracle.ODCI.ODCIStatsOptionsRef.ODCIStatsOptionsRef(), JPR 3-64
oemapp console command, PSG 6-12
oemapp pm command, PSG 6-28
oemctrl start oms command, PSG 6-11
OF clause
of CREATE VIEW, SQL 7-459
OF object_type clause
of CREATE TABLE, SQL 7-391
OFA, MIG 1-11
OFA. See Optimal Flexible Architecture (OFA).
offline
taking standby database datafiles, SBY 4-13
offline backup, PSC 1-5
offline backups, SBR 3-6
parallel, PSA 13-16
redo log files, PSA 13-16
whole database backup, SCN 364
offline bitmapped tablespaces, SUT 1-58
OFFLINE clause
of ALTER ROLLBACK SEGMENT, SQL 7-79
of ALTER TABLESPACE, SQL 7-180
of CREATE TABLESPACE, SQL 7-422
offline data file, PSC A-20
offline datafiles
migration, MIG 4-4
offline instantiation
adding a master site, RAR 7-29
adding a replication site, RAR 7-29
adding a snapshot site, RAR 7-34
replicated object groups, SPR 24-3, SPR 24-4, SPR 24-5, SPR 24-7, SPR 24-8, RAR 8-40, RAR 8-41, RAR 8-42, RAR 8-44, RAR 8-45
snapshots, SPR 25-3, SPR 25-5, RAR 8-48, RAR 8-50
support for, REP A-8
Offline Instantiation Wizard, REP 8-24
offline redo log files, SCN 1-47, SCN 347
offline rollback segments
bringing online, SAD 11-10
when to use, SAD 11-10
offline tablespace
deferred rollback segments, PSC A-21
restrictions, PSC A-20
offline tablespaces
priorities, SAD 9-15
restrictions, PSC 7-6
rollback segments and, SAD 11-10
taking offline, SAD 9-15
OGMS_HOME initialization parameter: obsolete
OGMS_HOME parameter, PSC A-7
obsolete for 8.1, PSC A-6
OID
with CREATE TYPE, DCI 3-3
OID Control Utility, OID 2-30, OID 3-2, OID 4-15
restart command, OID 5-4
run-server command, OID 4-15
start and stop server instances, OID 3-3
start-server command, OID 5-2
stop-server command, OID 4-15
OID Monitor, OID 2-30, OID 4-15
logging, OID 2-31
sleep time, OID 3-2, OID 3-3
starting, OID 3-2, OID 3-3
OID Password Utility, OID 4-16, OID 5-30
OID. See object identifier
OID. See object identifiers
OID. See object identifiers
OiD. See Oracle Internet Directory.
oidctl. See OID Control Utility
OIDINDEX clause
of CREATE TABLE, SQL 7-402
OIDLDAPD, OID 3-6
oidmon. See OID Monitor.
oidmon.log file, OID 2-31
OIDREPLD, OID 3-8
OIDs
See object identifiers
OIDs. See object identifiers
okdstry
Kerberos adapter utility, OAS 6-12
okinit
Kerberos adapter utility, OAS 6-12
oklist
Kerberos adapter utility, OAS 6-12
OLAP tools, DWG 2-5
OLD correlation name, ADG 13-16
OLE DB agents
connectivity requirements, DDS 8-14, DDS 8-15
interfaces, DDS 8-16
OLE DB connectivity
data dictionary mapping, DDS C-4
mapping to Oracle datatypes, DDS D-3
setting connection information, DDS A-4
OLEFS drivers, DDS 8-15
data provider requirements, DDS 8-15
initialization properties, DDS 8-17
rowset properties, DDS 8-17
security, DDS 8-15
OLESQL drivers, DDS 8-14
data provider requirements, DDS 8-14
security, DDS 8-14
OLON calls
obsolete, MIG 9-19
OLQP, MIG 3-18
OLTP, MIG 3-18, PSC 8-16
database environment, SAD 2-6
OLTP applications, PSC 8-5, PSC 8-6, PSC 8-7, PSC A-3
OLTP database, PSG 1-10, SCN 11-6
batch jobs, SCN 195
parallel DML, SCN 194
partitioning indexes, SCN 11-35
partitions, SCN 11-7
OLTS_ATTR_STORE tablespace, OID 12-12
OLTS_ATTRSTORE, OID 13-9
OLTS_CT_CN tablespace, OID 12-12
OLTS_CT_DN, OID 13-9
OLTS_CT_DN tablespace, OID 12-12
OLTS_CT_OBJCL tablespace, OID 12-12
OLTS_CT_STORE tablespace, OID 12-12
OLTS_DEFAULT tablespace, OID 12-12
OLTS_IND_ATTRSTORE, OID 13-9
OLTS_IND_ATTRSTORE tablespace, OID 12-12
OLTS_IND_CT_DN, OID 13-9
OLTS_IND_CT_DN tablespace, OID 12-12
OLTS_IND_CT_STORE tablespace, OID 12-12
OMSCONFIG.PROPERTIES file, PSG 6-11
ON clause
of CREATE OUTLINE, SQL 7-342
ON COMMIT clause, DWG 8-20
of CREATE TABLE, SQL 7-401
ON DATABASE clause
of CREATE TRIGGER, SQL 7-432
ON DEFAULT clause
of AUDIT schema_objects, SQL 7-222
of NOAUDIT schema_objects, SQL 7-552
ON DELETE CASCADE clause
of constraint_clause, SQL 7-241
ON DELETE SET NULL clause
of constraint_clause, SQL 7-241
ON DEMAND clause, DWG 8-20
ON DIRECTORY clause
of AUDIT schema_objects, SQL 7-222
of GRANT object_privileges, SQL 7-533
of NOAUDIT schema_objects, SQL 7-552
of REVOKE schema_object_privileges, SQL 7-560
ON JAVA RESOURCE clause
of GRANT object_privileges, SQL 7-533
ON JAVA SOURCE clause
of GRANT object_privileges, SQL 7-533
ON NESTED TABLE clause
of CREATE TRIGGER, SQL 7-432
ON object clause
of GRANT object_privileges, SQL 7-533
of NOAUDIT schema_objects, SQL 7-552
of REVOKE schema_object_privileges, SQL 7-561
ON PREBUILT TABLE clause
of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-323
ON SCHEMA clause
of CREATE TRIGGER, SQL 7-432
ONAME precompiler option, PC_ 10-33
usage notes for, PC_ 10-34
ONAME precompiler ption, PCO 14-32
One Producer, One Consumer, ADQ 7-3
one-level search, OID 7-6
one-to-many relationship
with foreign keys, ADG 4-10
one-to-one relationship
with foreign keys, ADG 4-10
one-way authentication, SSL, OID 2-22, OID 4-6, OID F-5
online administration tool. See Oracle Directory Manager
online analytical processing (OLAP)
index-organized tables, SCN 10-45
online archiving, PSC 1-5
online backup, PSC 1-5
online backups, SBR 3-6
archiving log files, PSA 13-21
parallel, PSA 13-16
procedure, PSA 13-21
redo log files, PSA 13-16
ONLINE clause
of ALTER ROLLBACK SEGMENT, SQL 7-78
of ALTER TABLESPACE, SQL 7-180
of CREATE INDEX, SQL 7-301
of CREATE TABLESPACE, SQL 7-422
online data file
supported operations, PSC A-20
online help
Export, SUT 1-11
Field Help, LEG 1-14
How Do I Help, LEG 1-14
Import, SUT 2-8
UNIX, LEG 1-11
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 (re)build
compatibility, MIG 9-10
online index builds, GTK 3-41
online indexes, SQL 7-301
rebuilding, SQL 7-144
online read-only tablespaces, GTK 3-42
compatibility, MIG 9-9
online recovery, PSA 14-2, PSA 14-4, PSA 14-7, PSC 7-3, PSC A-24
online redo log, SAD 6-2, SCN 1-46, SCN 347
See also redo logs
archiving, SCN 359, SCN 360, SRF 1-61
archiving mode, SRF 1-55
block, SRF 1-63
checkpoints, SCN 363
creating
groups and members, SAD 6-11
creating members, SAD 6-11
dropping groups, SAD 6-14
dropping members, SAD 6-14
file size, SRF 1-63
forcing a log switch, SAD 6-16
guidelines for configuring, SAD 6-5
INVALID members, SAD 6-15
location of, SAD 6-9
managing, SAD 6-1
media failure, SCN 345
moving files, SAD 6-13
multiplexed, SCN 345
number of files, SRF 1-61
number of files in the, SAD 6-9
optimum configuration for the, SAD 6-9
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, SCN 362
renaming files, SAD 6-13
renaming members, SAD 6-12
setting checkpoint interval, SRF 1-63
STALE members, SAD 6-15
viewing information about, SAD 6-18
online redo log file
archive log mode, PSA 3-8
log switch, PSA 13-15
thread of redo, PSA 1-7
online redo log files
archiving, PSA 13-1, PSA 13-7
log switch, PSA 13-7
thread of redo, PSC 7-3
online redo logs, SBR 1-4, SBR 1-9, SBR 6-8
active group, SBR 6-6, SBR 6-7
applying during media recovery, SBR 5-9
archived group, SBR 6-6, SBR 6-7
backing up, SBR 2-10, SBR 3-10
clearing
failure, SBR 6-9
clearing inactive logs
archived, SBR 6-8
unarchived, SBR 6-8
current group, SBR 1-9, SBR 6-6, SBR 6-7
determining active logs, SBR 6-7
inactive, SBR 1-9
inactive group, SBR 6-6, SBR 6-7
listing log files for backup, SBR 4-2
loss of
active group, SBR 6-10
all members, SBR 6-7
group, SBR 6-7
mirrored members, SBR 6-5
recovery, SBR 6-5
multiple group loss, SBR 6-11
multiplexed, SBR 1-10
overview, SBR 1-9
recorded in control file, SBR 2-3
reinitializing, SQL 7-19
replacing damaged member, SBR 6-6
responding to failures, SBR 2-13
status of members, SBR 6-6, SBR 6-7
unintentional restore of, SBR 3-10
online rollback segments
bringing rollback segments online, SAD 11-10
taking offline, SAD 11-11
online transaction processing (OLTP), SCN 11-6, STU 1-2, STU 3-2
processes, DWG 18-35
reverse key indexes, SCN 10-33
with decision support, STU 3-6
Online Transaction Processing database, PSG 1-10
Online Transaction Processing. See OLTP
ONRS_CONFIG table, NET 6-49
OO4O
See Oracle Objects for OLE, ADG 1-12
OO4O, See Oracle Objects for OLE (OO4O)
open
checking for open BFILEs, ADL 11-70
checking for open BFILEs with FILEISOPEN(), ADL 11-72
checking if BFILE is open with ISOPEN, ADL 11-78
checking if temporary LOB is, ADL 10-41
seeing if a LOB is open, ADL 9-51
OPEN CURSOR statement, PC_ 14-25
open cursors parameter, OID 13-10
open database backups
fractured block detection during, RMN 1-67
open database recovery
using RMAN, RMN 6-24
OPEN DESCRIPTOR SQL statement, PC_ F-93
OPEN DESCRIPTOR statement, PCO F-72
OPEN NORESETLOGS clause
of ALTER DATABASE, SQL 7-12
OPEN READ ONLY clause
ALTER DATABASE statement, SBY 3-18, SBY 3-19, SBY 4-17
of ALTER DATABASE, SQL 7-12
OPEN READ WRITE clause
of ALTER DATABASE, SQL 7-12
OPEN RESETLOGS clause
ALTER DATABASE statement, RMN 3-12, SBY 5-28
of ALTER DATABASE, SQL 7-12
OPEN SQL statement, PC_ F-91, PCO F-72
OPEN statement, PC_ 6-13, PCO F-70, 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-93, PCO F-71
in dynamic SQL method 4, PCO 11-34
purpose of, PC_ 6-12, PC_ 6-13
syntax, PLS 11-119
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 string for XA, ADG 16-10
Open System Interconnection (OSI) model
client application layer, NET 3-4
described, NET 3-2
link layer, NET 3-4
physical, NET 3-4
presentation layer, NET 3-4
session layer, NET 3-4
transport layer, NET 3-4
open_connection()
as a function of UTL_TCP, SPR 66-3
function of UTL_SMTP, SPR 65-3
OPEN_CURSOR procedure, DDS 9-3
OPEN_CURSORS, OID 13-10
OPEN_CURSORS initialization parameter, REP 7-5, SRF 1-81
OPEN_CURSORS parameter, ADG 7-9, SCN 15
allocating more private SQL areas, STU 19-10
increasing cursors per session, STU 19-16
managing private SQL areas, SCN 7-9
open_data(), write_data(), write_raw_data(), close_data()
functions of UTL_SMTP, SPR 65-9
OPEN_LINKS initialization parameter, DDS 2-20, REP 2-15, REP 7-5, SRF 1-82
OPEN_LINKS parameter, SCN 7-17
OPEN_LINKS_PER_INSTANCE initialization parameter, SRF 1-82
OPEN-FOR statement, PLS 5-19
syntax, PLS 11-121
OPEN-FOR-USING statement, PLS 10-7
syntax, PLS 11-124
opening
a cursor variable, PC_ 4-27
BFILEs, ADL 11-55
BFILEs using FILEOPEN, ADL 11-57
BFILEs with OPEN, ADL 11-62
cursors, PC_ F-91, PC_ F-93, PCO F-70, PCO F-72
opening a cursor variable, PCO 6-32
opening a database
after creation, SAD 1-20
operands, SQL 3-1
operating system
authenticating remote clients, SRF 1-103
authenticating users and passwords, SRF 1-90
data cache, STU 23-2
dependent parameters, SRF 1-10
Distributed Lock Manager, PSC 5-22
exported files, PSC B-2
migrating to a different, MIG 4-8, MIG 5-6
monitoring disk I/O, STU 20-15
monitoring tools, STU 11-3
privileges, PSA 4-7
redo log blocks, SRF 1-63
roles, ADG 11-27
roles for remote clients, SRF 1-103
scalability, PSC 8-11
tuning, STU 2-13, STU 16-7, STU 19-4
operating system backups, SBR 1-22, SBR 4-3 to SBR 4-21
Operating System Dependent layer
described, PSG 1-5
installing, PSG 2-11, PSG 9-5
Inter-Process Communication (IP
C), PSC 6-5
operating system utilities
copying files with, RMN 5-27
operating systems
accounts, SAD 23-20
auditing with, SAD 24-2
authentication, SAD 22-10, SAD 23-18
authentication by, SCN 282
block size, SCN 4-3
communications software, SCN 8-28
database administrators requirements for, SAD 1-4
deleting datafiles, SAD 9-23
enabling and disabling roles, SAD 23-21
moving data to different systems using SQL*Loader, SUT 5-74
privileges for administrator, SCN 5-3
renaming and relocating files, SAD 10-9
role identification, SAD 23-20
roles and, SAD 23-18, SCN 325
security in, SAD 21-3
striping, DWG 4-3
operating system-specific Oracle documentation
archived redo log name, PSA 13-6
instance number range, PSA 8-10
OPERATION column
PLAN_TABLE table, STU 5-4, STU 5-9
Operation not allowed on (string) - error, ADQ D-2
operational attributes, OID 5-15
ACI, OID 2-25
fields in Oracle Directory Manager, OID 5-16
Operational Interface - Basic Operations, ADQ 11-1
operations
connect, NET 2-3
exception, NET 2-7
Net8, NET 2-7
operations in a relational database, SCN 1-21
Operations menu item, in Oracle Directory Manager, OID 4-11
operations, volume, LEG 3-21
operators, SQL 3-1
arithmetic, SQL 3-3
binary, SQL 3-1
C versus SQL, PC_ 2-14
comparison, PLS 2-45, SQL 3-5
concatenation, SQL 3-3
dropping, MIG 13-21
granting
system privileges on, SQL 7-524
logical, SQL 3-11
precedence, PLS 2-43, SQL 3-2
relational, PCO 2-19, PLS 2-46
restrictions on, PC_ 2-14
set, SQL 3-12, SQL 7-579
unary, SQL 3-1
user-defined, SQL 3-16
binding to a function, SQL 7-340
creating, SQL 7-340
dropping, SQL 7-489
function providing implementation, SQL 7-341
how bindings are implemented, SQL 7-341
implementation type, SQL 7-341
return type of binding, SQL 7-340
OPI, described, NET 3-9
OPS Communication Daemon, defined, PSG 6-4
/ops directory, PSG A-3
OPS Overview chart, PSG 8-20
OPS. See Oracle Parallel Server
OPS_ADMIN_GROUP initialization parameter: obsolete
OPS_ADMIN_GROUP parameter, PSC A-8
obsolete for 8.1, PSC A-6
OPS_DATABASE entry, PSG C-6
OPS_DATABASE entry in services.ora file, PSG C-6
OPS_FAILOVER clause, PSC A-13
OPS_INSTANCE entry, PSG C-7
OPS_INSTANCE entry in services.ora file, PSG C-7
OPSCTL utility, PSG 6-4
architecture on UNIX, PSG 6-4
architecture on Windows NT, PSG 6-5
configuring on UNIX, PSG B-1 to PSG B-11
db_name.conf file, PSG B-2
OPSD, defined, PSG 6-4
/opsm/admin directory, PSG A-3
ops.sql script, PSG 3-38
Optimal Flexible Architecture (OFA), OID B-2, PSG 1-8, PSG 1-9, SAD 2-5
Optimal Flexible Architecture. See OFA
OPTIMAL parameter
of STORAGE clause, SQL 7-368, SQL 7-608
OPTIMAL setting for SYSTEM rollback segment
migration, MIG A-4
OPTIMAL storage parameter, SAD 12-11, SCN 4-26, STU 20-30, SUT 2-50
rollback segments, SAD 11-5, SAD 11-6, SAD 11-8
optimistic locking
implementing, OCI 13-13
optimization, SCN 124
choosing the approach, STU 4-10
compatibility, MIG 9-34
extensible optimizer, MIG 9-13
optimizer plan stability, MIG 9-13
conversion of expressions and predicates, STU 4-65
cost-based, SCN 130, STU 4-12, STU 4-59
choosing an access path, STU 4-25
examples of, STU 4-26
histograms, SCN 131, STU 8-17
remote databases and, STU 4-94
star queries, STU 4-62
user-defined costs, SCN 141, STU 4-33
described, SCN 124, STU 4-4
DISTINCT, STU 4-78
distributed SQL statements, STU 4-94
execution plan for partitions, SCN 11-13
extensible optimizer, SCN 140, STU 4-32
function-based indexes, SCN 10-27
GROUP BY views, STU 4-78
hints, STU 4-11, STU 4-23, STU 4-24
index build, SCN 10-24
manual, STU 4-11
merging complex views, STU 4-78
merging views into statements, STU 4-76
non-null values for nulls, STU 4-86
operations performed, STU 4-48
parallel SQL, SCN 166
partition pruning, SCN 11-4
indexes, SCN 11-35
partition pruning (elimination), SCN 11-4
partitioned indexes, SCN 11-34
partition-wise joins, SCN 11-5
plan stability, SCN 129
query rewrite, SCN 10-18
in security policies, SCN 326
rule-based, SCN 142, STU 4-34, STU 4-60
selectivity of predicates, SCN 131, STU 8-2
histograms, SCN 131, SCN 133, STU 8-17
user-defined, SCN 141, STU 4-33
selectivity of queries and, STU 4-25
select-project-join views, STU 4-76
semi-joins, STU 4-61
setting session parameters, SQL 7-92
statistics, SCN 131, STU 4-10, STU 8-2
user-defined, SCN 141, STU 4-33
trading cursor space for time, SRF 1-23
transitivity and, STU 4-69
types of SQL statements, STU 4-47
without merging, STU 4-88
optimization approach, PC_ C-5
Optimization of Waiting for Arrival of Messages, ADQ 8-75
optimizations
cost-based
star queries, DWG 16-2
query rewrite
enabling, DWG 19-5
hints, DWG 19-5, DWG 19-28
matching join graphs, DWG 8-18
query rewrites
privileges, DWG 19-6
optimizer, STU 4-4
and remote join enhancement, GTK 3-68
and ROLAP enhancement, GTK 3-24
downgrading, MIG 13-43
extensible, GTK 3-32
plan stability, GTK 3-37, STU 10-2
compatibility, MIG 9-13
OPTIMIZER column
PLAN_TABLE, STU 5-5
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-86
RULE, SRF 1-86
optimizer statistics, SUT 2-61
OPTIMIZER_FEATURES_ENABLE parameter, STU 4-23, STU 4-24, STU 4-78, STU 4-87
OPTIMIZER_FEATURES_ENABLED parameter, STU 4-29
OPTIMIZER_GOAL clause, STU 4-11
OPTIMIZER_INDEX_CACHING, STU 4-31
OPTIMIZER_INDEX_CACHING initialization parameter, SRF 1-84
OPTIMIZER_INDEX_CACHING parameter
of ALTER SESSION, SQL 7-92
OPTIMIZER_INDEX_COST_ADJ initialization parameter, SRF 1-85
OPTIMIZER_INDEX_COST_ADJ parameter, STU 4-30
of ALTER SESSION, SQL 7-92
OPTIMIZER_MAX_PERMUTATIONS initialization parameter, SRF 1-85
OPTIMIZER_MAX_PERMUTATIONS parameter
of ALTER SESSION, SQL 7-92, SQL 7-115
OPTIMIZER_MODE, STU 4-10, STU 4-20
hints affecting, STU 4-11
OPTIMIZER_MODE initialization parameter, SRF 1-86, STU 4-12, STU 4-29, STU 4-34, STU 7-6
OPTIMIZER_MODE parameter, DWG 14-28, DWG 18-64, DWG 19-5
of ALTER SESSION, SQL 7-92
OPTIMIZER_PERCENT_PARALLEL initialization parameter, SRF 1-86, STU 4-9
OPTIMIZER_PERCENT_PARALLEL parameter, DWG 14-28, DWG 18-21, DWG 18-67, SCN 131, STU 4-9, STU 4-29
of ALTER SESSION, SQL 7-92
OPTIMIZER_SEARH_LIMIT initialization parameter: obsolete
optimizers
with rewrite, DWG 19-2
optimizing
direct path loads, SUT 8-16
SQL*Loader input file processing, SUT 5-24
option factoring matrix, GTK 5-2
option, PARALLEL_ENABLE, PLS 7-6
optional attributes, OID 2-7, OID 6-2
adding to pre-defined object classes, OID 2-7
entering values for, OID 7-14
in object classes, OID 6-8
optional division headers, PCO 2-15
OPTIONAL option
LOG_ARCHIVE_DEST_n initialization parameter, SBY 2-17, SBY 5-8
OPTIONALLY ENCLOSED BY, SUT 5-16
SQL*Loader, SUT 5-83
options
deinstalling, MIG 1-13
for Migration utility, MIG 4-17
precompiler concepts, PCO 14-3
OPTIONS column
PLAN_TABLE table, STU 5-4
OPTIONS keyword, SUT 5-18
for parallel loads, SUT 5-41
OR - oracle.xml.parser.v2.ElementDecl.OR, JPR 4-33
OR keyword, PLS 6-16
OR operator, SQL 3-11, SQL 3-12
OR REPLACE clause
for creating packages, ADG 9-16, SPR 1-3
of CREATE CONTEXT, SQL 7-261
of CREATE DIRECTORY, SQL 7-283
of CREATE FUNCTION, SQL 7-286, SQL 7-312
of CREATE LIBRARY, SQL 7-316
of CREATE OUTLINE, SQL 7-342
of CREATE PACKAGE, SQL 7-345
of CREATE PACKAGE BODY, SQL 7-349
of CREATE PROCEDURE, SQL 7-356
of CREATE TRIGGER, SQL 7-428
of CREATE TYPE, SQL 7-440
of CREATE TYPE BODY, SQL 7-448
of CREATE VIEW, SQL 7-458
ora_dictionary_obj_owner event attribute, ADG 14-3
ora_dictionary_obj_owner_list event attribute, ADG 14-3
ora_dictionary_obj_type event attribute, ADG 14-3
ora_grantee event attribute, ADG 14-3
ora_instance_num event attribute, ADG 14-3
ora_is_alter_column event attribute, ADG 14-3
ora_is_creating_nested_table event attribute, ADG 14-4
ora_is_drop_column event attribute, ADG 14-4
ora_is_servererror event attribute, ADG 14-4
ora_login_user event attribute, ADG 14-4
ORA_NLS32 environment variable
compatibility, MIG 9-28
ORA_NLS33 environment variable, MIG 4-19
compatibility, MIG 9-28
ora_privileges event attribute, ADG 14-4
ora_revokee event attribute, ADG 14-4
ora_server_error event attribute, ADG 14-4
ora_sysevent event attribute, ADG 14-4
ora_with_grant_option event attribute, ADG 14-5
ORA-00000 to ORA-00816, SMS 2-1
ORA-00508 error message, NET 12-10
ORA-00900 error, DDS 3-12
ORA-00900 to ORA-01499, SMS 3-1
ORA-01500 to ORA-02198, SMS 4-1
ORA-01578 error message, SBR 5-3
ORA-02015 error, DDS 3-12
ORA-02055 error
integrity constraint violation, DDS 3-3
ORA-02067 error
rollback required, DDS 3-3
ORA-02100 to ORA-04099, SMS 5-1
ORA-06000 to ORA-07499, SMS 6-1
ORA-06510 error
PL/SQL error, DDS 3-13
ORA-07500 to ORA-09857, SMS 7-1
ORA-09870 to ORA-12071, SMS 8-1
ORA-1004 error, OAS 17-33
ORA-1017 error, OAS 17-33
ORA-1017 error messages, NET 12-3
ORA-1034 error messages, NET 12-3
ORA-12154 error message, NET 12-8
ORA-12198 error message, NET 12-9
ORA-12203 error message, NET 12-9, NET 12-10, NET 12-14
sample error stack, NET 12-18
ORA-12224 error message, NET 12-12
ORA-12316 to ORA-12354, SMS 9-1
ORA-12400 to ORA-12495, SMS 10-1
ORA-12533 error message, NET 12-12
ORA-12535 error message, NET 12-14
ORA-12538 error message, NET 12-10
ORA-12545 error message, NET 12-12
ORA-12547 error message, NET 12-14
ORA-12560 error, OAS 17-33
ORA-12560 error message, NET 12-13
ORA-12650 error message, OAS A-7
ORA-12701 to ORA-18010, SMS 11-1
ORA-1555 error on dequeue, ADQ 6-4
ORA-19500 to ORA-24279, SMS 12-1
ORA-21301 error, fixing, ADG 16-15
ORA-24280 to ORA-28657, SMS 13-1
ORA-29250 to ORA-30728, SMS 14-1
ORA-3113 error message, NET 12-13
ORA-3121 error message, NET 12-13
ORA-600, PSG C-12
ORA-9291 message, PSG 4-16
OraAQ object, ADG 1-16
OraAQAgent object, ADG 1-17
OraAQMsg object, ADG 1-17
OraBFILE object, ADG 1-18
OraBfile, See Oracle Objects for OLE (OO4O)
OraBLOB object, ADG 1-18
OraBlob, See Oracle Objects for OLE (OO4O)
ORACA, PC_ 9-3, PCO 8-3
declaring, PCO 8-24
enabling, PCO 8-24
example, PCO 8-28
example of using, PC_ 9-42
fields, PCO 8-25
gathering cursor cache statistics, PCO 8-27
ORACABC field, PCO 8-25
ORACAID field, PCO 8-25
ORACCHF flag, PCO 8-25
ORACOC field, PCO 8-28
ORADBGF flag, PCO 8-26
ORAHCHF flag, PCO 8-26
ORAHOC field, PCO 8-28
ORAMOC field, PCO 8-28
ORANEX field, PCO 8-28
ORANOR field, PCO 8-28
ORANPR field, PCO 8-28
ORASFNMC field, PCO 8-27
ORASFNML field, PCO 8-27
ORASLNR field, PCO 8-27
ORASTXTC field, PCO 8-27
ORASTXTF flag, PCO 8-26
ORASTXTL field, PCO 8-27
precompiler option, PCO 8-25
purpose, PCO 8-3, PCO 8-23
structure of, PCO 8-25
using to gather cursor cache statistics, PC_ 9-40
ORACA precompiler option, PC_ 10-34, PCO 14-33
ORACABC field, PCO 8-25
ORACAID component, PC_ 9-38
ORACAID field, PCO 8-25
ORACCHF flag, PCO 8-25
Oracle
adherence to standards, SCN 1-3
integrity constraints, SCN 255
architecture, SCN 1-12
backing up, PSC 1-5
client/server architecture of, SCN 6-2
compatibility, PSA 8-9, PSC B-3, SCN 1-3
compatibility levels, SCN 3-15
configurations of, SCN 8-2
multiple-process Oracle, SCN 8-2
connectibility, SCN 1-2
data access, SCN 1-50
data dictionary, PSC 4-2
data file compatibility, PSC 7-2
datatypes, PC_ 2-6
examples of operations, SCN 1-19
dedicated server, SCN 8-25
multi-threaded server, SCN 8-21
features, SCN 1-2
Forms Version 4, PC_ 20-14
installing, SAD 1-18
instances, SCN 1-4, SCN 1-14, SCN 5-2
licensing of, SCN 298
migration, PSC A-19
obsolete parameters, PSC A-23
Open Gateway
using the ROWID datatype with, PC_ 4-8
Oracle server, SCN 1-4
Parallel Server option, SCN 1-4
See also Parallel Server
performance features, PSC 1-4
portability, SCN 1-3
processes of, SCN 1-16, SCN 8-5
release numbers, SAD 1-21
restrictions, PSC 8-15, PSC A-19, PSC A-21
scalability of, SCN 6-4
SQL processing, SCN 17
Toolset, PC_ 20-14
using on networks, SCN 1-2, SCN 1-36
Oracle Advanced Queuing (Oracle AQ)
DBMS_AQADM package, SPR 5-1
Oracle Advanced Queuing. See Advanced Queuing
Oracle Advanced Queuing. See Advanced Queuing
Oracle Advanced Security, ADG 11-19, OCI 8-16, GTK 3-70
checksum sample for sqlnet.ora file, OAS A-2
configuration parameters, OAS 3-5
CyberSAFE authentication method, NET 4-26
DCE Integration, NET 4-27
DES_40 encryption, NET 4-26
described, NET 4-25
disabling authentication, OAS 11-2
encryption and checksumming parameters supported, OAS A-1
encryption sample for sqlnet.ora file, OAS A-2
features for thin JDBC, OAS 3-3
features of, NET 4-25
Identix authentication method, NET 4-26
integrated security and directory services, GTK 3-72
Java implementation, OAS 3-2, OAS 3-4
Kerberos authentication method, NET 4-26
MD5 checksumming, NET 4-26
Network Security, NET 4-26
RADIUS, GTK 3-72
RADIUS authentication method, NET 4-26
RC4_128 encryption, NET 4-26
RC4_40 encryption, NET 4-26
RC4_56 encryption, NET 4-26
SecurID authentication method, NET 4-26
Single Sign-On, NET 4-26
SSL, GTK 3-70
SSL authentication method, NET 4-26
SSL features, OAS 10-2
Oracle Advanced Security option, GTK 7-8
Oracle Application Server (OAS), ADG 12-2
Oracle AQ. See Advanced Queuing
Oracle background processes, OID 13-11
Oracle backup volumes
viewing, LEG 3-20
Oracle backups and restores
backup/restore utility, LEG 4-2
monitoring, LEG 4-12
prerequisites to running, LEG 4-2
Oracle blocks, SAD 2-22, SCN 1-7, SCN 4-2
See also data blocks
Oracle Call Interface, OID 2-33
controlling object cache size, ADO 7-5
multi-tier authentication, SAD 22-14
See OCI
Oracle Call Interface (OCI) layer, described, NET 3-7
Oracle Call Interface Rel 7, PC_ 5-50
Oracle Call Interface. See OCI
Oracle Call Interface. See OCI
Oracle Call Interface, See OCI
Oracle Certificate Authority, SCN 283
Oracle Client Replication Tool, REP C-16
Oracle code, SCN 8-2, SCN 8-27
Oracle Communications Area, PC_ 9-35
ORACA, PCO 8-23
Oracle Connection Manager, OAS 1-12, GTK 4-6
access control, NET 4-8
CMADMIN process, NET 4-6
CMGW process, NET 4-5
configuration parameter reference, NET C-70 to NET C-76
configuring
access control, NET 8-35
connection concentration, NET 8-28
multi-protocol support, NET 8-32
Net8 access control, NET 8-35
protocol address for listener, NET 8-42
protocol address for Oracle Connection Manager, NET 8-39
protocol addresses, NET B-1
connection concentration, NET 4-6
log files, NET 12-22
configuring, NET 12-22
understanding, NET 12-29
multiple protocol support, NET 4-8
multi-threaded server, NET 4-6, NET 8-28
Net8 access control, NET 4-8
Net8 Firewall Proxy, NET 4-8
processes, NET 4-5
role in multiple protocol environments, NET 4-9
routing connections, NET 1-3, NET 8-21
SOURCE_ROUTE parameter, NET C-41
starting, NET 11-9
testing, NET 11-15
trace files, NET 12-40
configuring, NET 12-40
Oracle Connection Manager Control Utility (CMCTL)
see CMCTL utility, NET 11-9
Oracle Connection Manager Controll Utility (CMCTL)
see CMCTL utility
Oracle Connection Managers
CMADMIN process, MIG F-16
CMCW process, MIG F-16
intchg.ora, MIG F-17
migrating to release 8.1, MIG F-16
multi-protocol support, MIG F-17
port 1610, MIG F-16
port 1630, MIG F-16
port 1830, MIG F-16
tnsnav.ora file, MIG F-17
tnsnet.ora file, MIG F-17
upgrading to release 8.1, MIG F-16
using instead of Oracle Multi-Protocol Interchange, MIG F-17
Oracle Context, OAS 17-6
creating, NET 6-18, NET 6-22
described, NET 2-41
Oracle Customer Support, contacting, NET 12-59
Oracle Data Cartridge Interface, SCN 10-46
Oracle Data Control (ODC), ADG 1-19
Oracle Data Gatherer
described, PSG 6-3
starting, PSG 6-27
Oracle Data Migration Assistant
advantages and disadvantages, MIG 3-8
character set used, MIG 5-6
differences from the Migration utility, MIG 3-9
documentation roadmap, MIG 5-2
migrating to a different operating system, MIG 5-6
Oracle Parallel Server
does not support migration, MIG 3-9
does not support upgrading, MIG 7-6
overview, MIG 5-3
restrictions, MIG 5-3
running, MIG 5-19, MIG 7-7, MIG 7-13
space required for SYSTEM tablespace, MIG 5-4
Oracle data servers
changing password to, OID 4-16, OID 5-30
error, OID C-2
Oracle database
available types, SAD 2-6
creating for a hybrid environment, SAD 2-6
creating for an OLTP environment, SAD 2-6
custom database overview, SAD 2-6
Custom installation type, SAD 2-6
Minimal installation type, SAD 2-6
starter database overview, SAD 2-6
Typical installation type, SAD 2-6
Oracle Database Configuration Assistant, GTK 3-59, GTK 3-62
advantages, SAD 2-5
control files, PSG 1-14
creating a hybrid database environment, SAD 2-6
creating an OLTP database environment, SAD 2-6
creating Oracle Parallel Server database
after installation, PSG 3-24
during installation, PSG 3-7
Custom database creation type, PSG 1-11
data files, PSG 1-12
database types
Data Warehousing, PSG 1-10
Multi-Purpose, PSG 1-10
OLTP, PSG 1-10
defined, SAD 2-4
deleting Oracle Parallel Server database, PSG 3-43
directory naming, NET 2-43, NET 6-22
error message, PSG 3-26
initialization parameter files, PSG 1-14
methods of creation, SAD 2-6
modes for creation, SAD 2-5
multi-threaded server configuration, PSG 3-13
redo log files, PSG 1-13
rollback segments, PSG 1-14
running
during installation, PSG 3-7
stand-alone mode, PSG 3-23
tablespaces, PSG 1-12
troubleshooting, PSG 3-24, PSG 3-44
Typical database creation type, PSG 1-11
Oracle datatypes, OCI 3-2
mapping to C, OCI 11-2
Oracle Diagnostics Pack
described, PSG 2-4
Oracle Performance Manager, PSG 2-4
Oracle Directory Manager, OID 1-4, OID 7-5
adding
ACPs, OID 9-33, OID 9-35
attributes, OID 6-24
configuration set entries, OID 5-4
entries, OID 7-12
group entries, OID 7-20
object classes, OID 6-13
objects, OID 4-10
Apply button vs. OK button, OID 4-10
attributes, searching for, OID 6-19
Cancel button, OID 4-10
Configure Entry Management menu item, OID 4-11
connecting to a directory server, OID 4-10, OID 4-11
create access control policy point menu, OID 4-11
Create button, OID 4-12
Create Entry menu item, OID 4-11
Create Like button, OID 4-12, OID 7-16
Create Like operation, OID 4-10
creating an attribute, OID 4-11
creating object classes, OID 4-11
deleting configuration set entries, OID 5-4
disconnecting from a directory server, OID 4-10
displaying help navigator, OID 4-11
Edit button, OID 4-12
Edit menu, OID 4-10
Ends With filter, OID 6-8
entries management, OID 4-13
Exact Match filter, OID 6-8, OID 7-7, OID 9-22, OID 9-29
Exit menu, OID 4-10
File menu, OID 4-10
Find Attributes button, OID 6-20
Find Objects button, OID 4-12, OID 6-6
granting access, OID 9-16
Greater or Equal filter, OID 6-8, OID 7-7, OID 9-22, OID 9-29
Help button, OID 4-12
Help menu item, OID 4-11
launching, OID 4-2
Less or Equal filter, OID 6-9, OID 7-7, OID 9-22, OID 9-29
listing attribute types, OID A-3
managing
ACPs, OID 4-13
configuration set entries, OID 5-4
entries, OID 4-13
object classes, OID 6-5
menu bar, OID 4-10
modifying
configuration set entries, OID 2-32
object classes, OID 6-16
objects, OID 4-10, OID 4-12
replication agreements, OID 10-15
modifying configuration set entries, OID 5-4
modifying entries, OID 7-22
navigating, OID 4-7
not null filter, OID 6-9
Operations menu, OID 4-11
overview, OID 4-2
Present filter, OID 7-7
purge schedule, setting, OID 10-12
Refresh button, OID 4-12
Refresh Entry button, OID 4-12
Refresh Subentries button, OID 4-12
Remove button, OID 4-12
removing objects, OID 4-10, OID 4-12
Revert button, OID 4-10
root of search, OID 7-4
running, OID 4-2
schema administration, OID 4-13
search criteria bar, OID 7-6
search filters, OID 6-8
searching
entries, OID 7-2
for an object, OID 4-12
for attributes, OID 6-19
selecting attribute syntax type, OID 6-32
setting maximum number of subentries, OID 4-11
setting maximum search time, OID 4-11
starting, OID 4-2
starting on Sun Solaris, OID 4-2
system operational attribute fields, OID 5-16
tear-off menu item, OID 4-10
toolbar, OID 4-11
updating, OID 4-10
subentry data, OID 4-12
View menu, OID 4-10
viewing
entry attributes, OID 7-11
replication configuration set entries, OID 10-11
Oracle Directory Replication Server, OID 1-4
starting, OID 3-6
stopping, OID 3-8
Oracle Directory Server, OID 1-4
Oracle dynamic SQL
when to use, PCO 10-1
Oracle Enterprise Login Assistant, GTK 2-9, SCN 284
described, OAS 17-20
disabling, OAS 19-3
enabling, OAS 19-2
Oracle Enterprise Manager, OAS 8-5, LEG 4-5, GTK 2-3, GTK 3-60, SAD 3-4, STU 11-8
ALERT file, SCN 8-15
architecture, PSG 6-7
Backup Wizard, PSG 4-9, PSG 4-16
checkpoint statistics, SCN 8-11
components of, PSG 2-3
Configuration Assistant, PSG 6-10
configuring, PSG 6-10 to PSG 6-27
repository, PSG 6-10
connect-time failover, NET 2-21, NET 5-8, GTK 3-76
Console, PSG 2-3, PSG 6-2, PSG 6-12
db_name.conf file requirements, PSG 3-9, PSG 3-33
DBA Studio, PSG 2-3
described, PSG 6-2
discovering nodes, PSG 6-15
Discovery Wizard, PSG 6-15
executing a package, SCN 48
executing a procedure, SCN 46
granting roles, SCN 321
granting system privileges, SCN 305
hardware requirements, PSG 2-3
installation requirements, PSG 2-3
installing repository database, PSG 6-9
lock and latch monitors, SCN 240
managed targets, PSG 2-3
Management Server, PSG 2-3, PSG 6-3, PSG 6-11
nmiconf.log file, PSG C-7
nmiconf.lst file, PSG C-7
OPS Communication Daemon, PSG 6-4
OPSCTL utility, PSG 6-4
OPSD, PSG 6-4
Oracle Data Gatherer, PSG 6-3
Oracle Diagnostics Pack, PSG 2-4
Oracle Intelligent Agents, PSG 6-3
Oracle Parallel Server Management, PSG 1-5
Oracle Performance Manager, PSG 6-3
Oracle8, LEG 1-10
oratab file requirements, PSG 3-32
parallel recovery, SCN 351
PL/SQL, SCN 26, SCN 27
preferred credentials, PSG 6-19
Recovery Wizard, PSG 4-9
registry requirements, PSG 3-10, PSG 3-33
repository database, PSG 6-3
configuring, PSG 6-10
defined, PSG 2-3
scheduling jobs, PSG 7-19
schema object privileges, SCN 306
service discovery, PSG 6-15, PSG C-2
services.ora file, PSG C-6
setup scenarios, PSG 6-7
showing size of SGA, SCN 7-13
shutdown, SCN 5-10, SCN 5-11
SID_LIST_listener_name parameter in listener.ora, NET 7-13, NET C-84
SID_LIST_listener_name parameter in listener.ora file, PSG 3-40, PSG 6-6, PSG C-4
software requirements, PSG 2-3
solving service discovery failures, PSG C-2
specifying preferred credentials, PSG 6-19
SQL statements, SCN 10
starting
components, PSG 6-10
Console, PSG 6-12
Management Server, PSG 6-11
Oracle Data Gatherer, PSG 6-27
Oracle Intelligent Agents, PSG 6-10
Oracle Parallel Server database, PSG 7-7
Oracle Performance Manager, PSG 8-5
startup, SCN 5-6
static service information in LISTENER.ORA, GTK 3-76
static service information in listener.ora, NET 2-21, NET 5-8
static service information in listener.ora file, MIG F-15
statistics monitor, SCN 298
stopping Oracle Parallel Server database, PSG 7-9
super administrator account, PSG 6-12
SYSDBA privilege, PSG 6-26
SYSOPER privilege, PSG 6-26
TOOLS tablespace, PSG 2-6
understanding discovery failures, PSG C-2
User Manager, PSG 6-20
version 2 changes, PSG 6-10
viewing
Oracle Parallel Server status, PSG 7-16
shutdown results, PSG 7-12
startup results, PSG 7-12
Oracle Enterprise Security Manager, OAS 17-13, GTK 2-9, SCN 283
described, OAS 17-20
introduction, OAS 20-2
schemaless users, OAS 17-12
Oracle errors, ADG 9-3
Oracle Expert, STU 2-1, STU 11-13
Oracle Extension, ADQ 3-10
Oracle foreground processes
restricting, OID 13-7
tuning CPU for, OID 13-6
Oracle Forms, STU 6-5
control of parsing and private SQL areas, STU 19-11
object dependencies and, SCN 119
PL/SQL, SCN 25
Oracle home
defined, PSG xxiii
multiple, MIG 1-5
non-shared on UNIX, PSG B-11
shared on UNIX, PSG B-11
Oracle home directory
configuring on the listener, NET 7-13
Oracle Home Directory field in Net8 Assistant, NET 7-13, NET 8-47, NET 8-49
Oracle home directory, defined, NET xx
Oracle instances, OID 10-6
Oracle Intelligent Agents
defined, PSG 6-3
setup and location on UNIX, PSG B-10 to PSG B-11
starting, PSG 6-10
Oracle Internet Directory, ADG 11-67, NET 2-39, GTK 3-70, GTK 3-74, SCN 283
described, OAS 17-20
Oracle Java SSL
cipher suite, OAS F-3
class hierarchy, OAS F-19
example, OAS F-4
features, OAS F-2
interface hierachy, OAS F-19
Oracle JDBC
accessing Oracle object data, ADO 3-12
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 JMSClasses, ADQ B-5
Oracle Management Server (OMS), GTK 3-60
Oracle Media Management API
compatibility, MIG 9-12
proxy copy requirement, MIG 9-44
proxy copy and downgrading, MIG 13-46
Oracle Names, NET 2-36
administrative regions, NET 4-12
advantages and disadvantages, NET 5-4
architecture, NET 4-10
client cache, NET 11-6
coexistence issues, MIG F-11
configuring, NET 6-47 to NET 6-74
clients and servers, NET 6-60
region database, NET 6-50
connecting with, NET 6-74
creating Oracle Names servers, NET 6-49
database as a repository for information, NET 4-13
default network domains, NET 4-17
delegated
administrative regions, NET 4-21
described, NET 2-36, NET 4-10
differences between versions, NET 4-21
discovering Oracle Names servers, NET 6-59, NET 6-60
discovery, NET 4-24
domains, NET 4-12
administering multiple, NET 6-53, NET 6-58
Dynamic Discovery Option, NET 4-22
establishing a connection with, NET 2-35, NET 2-36, NET 6-74
exporting objects to directory server, NET 6-35 to NET 6-46, NET A-30
hierarchical naming model, NET 4-17
installing, NET 6-48
listener configuration for, NET 6-64
log files, NET 12-21
migrating
Oracle Names version 2 using a database, MIG F-18
ROSFILES, MIG F-22
ROSFILES to a tnsnames.ora file, MIG F-23
ROSFILES to Oracle Names tables in database, MIG F-22
version 8.1, MIG F-17
multiple domains, NET 4-18
multiple regions, NET 4-18
NAMES_DID table, MIG F-18
NAMES_DOM table, MIG F-18
NAMES.ADMIN_REGION parameter in names.ora file, MIG F-19, MIG F-20
NAMESCTL utility
DUMP_TNSNAMES command, MIG F-20
LOAD_TNSNAMES command, MIG F-21
NAMES.DOMAINS parameter in names.ora file, MIG F-18
namesini.sql script, MIG F-25, NET 6-51
namesupg.sql script, MIG F-18, MIG F-20, MIG F-23, MIG F-25, NET 6-51
naming network components, NET 4-16
Net8 Assistant
loading tnsnames.ora file into Oracle Names, MIG F-21, MIG F-24
NMO_INFORMATION table, MIG F-19
Oracle Names version 2 with Dynamic Discovery Option, MIG F-20
querying objects, NET 11-14
recommended for, NET 5-4
region database, NET 4-13
regions, NET 4-12
registering
global database link qualifiers, NET 6-68
global database links, NET 6-68
net service names, NET 6-65
objects, NET 6-65
replicated data, NET 4-13, NET 6-55
root administrative region, NET 4-19
.sdns.ora file, NET 4-24
sdns.ora file, NET 4-24
single domain naming mode, NET 4-16
starting
from Net8 Assistant, NET 11-14
from the command line, NET 11-14
from the Control Panel, NET 11-9
starting from the command line, NET 11-14
storing
aliases, NET 4-15
database global database names and addresses, NET 4-14
database links, NET 4-15
net service names, NET 4-14
Oracle Connection Manager information, NET 4-15
other Oracle Names server names and addresses, NET 4-14
trace files, NET 12-39
upgrading to release 8.1, MIG F-17
USE_PLUG_AND_PLAY_listener_name parameter, MIG F-20
version 1, NET 4-21
version 2, NET 4-22
version 8, NET 4-23
Oracle names
how to form, PC_ F-11, PCO F-10
Oracle Names Control Utility (NAMESCTL)
see NAMESCTL utility
Oracle Names servers
ckcfg.ora file, NET 6-49
ckpcch.ora file, NET 6-49
ckpreg.ora file, NET 6-49
client cache, NET 11-6
configuration parameter reference, NET C-59 to NET C-69
configuring
multiple domains, NET 6-53, NET 6-58
protocol addresses, NET B-1
creating, NET 6-49
region database, NET 6-51
replicated data, NET 6-55
data stored in, NET 4-14
default configuration, NET 6-50
delegated
domains, NET 6-73
delegated administrative regions, NET 4-19
described, NET 4-10
discovery of, NET 6-59
log files, NET 12-21
configuring, NET 12-22
preferred, NET 4-21, NET 8-26
registering
global database link qualifiers, NET 6-68, NET 6-70
global database links, NET 6-68
net service names, NET 6-65
objects, NET 6-65
replicated data, NET 6-55
root administrative regions, NET 4-19
starting, NET 6-54, NET 11-5
client cache, NET 11-6
from Net8 Assistant, NET 11-14
from the command line, NET 11-14
from the Control Panel, NET 11-9
storing
aliases, NET 4-15
database global database names and addresses, NET 4-14
database links, NET 4-15
net service names, NET 4-14
Oracle Connection Manager information, NET 4-15
other Oracle Names server names and addresses, NET 4-14
testing, NET 11-13
TNSPING utility, NET 11-19
trace files, NET 12-39
well-known, NET 4-22
Oracle namespaces, PCO C-5
Oracle Network Manager, described, MIG F-2
Oracle NLS, OID 2-26
Oracle objects
See object-relational model
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-12
OraCollection interface, ADO 3-11
OraObject interface, ADO 3-10
OraRef interface, ADO 3-10
overview, ADG 1-11
Oracle Objects for OLE (OO4O)
available LOB methods/properties, ADL 3-3
internal LOB buffering, ADL 3-35
modifying internal LOBs, ADL 3-33
opening/closing external LOBs (BFILEs), ADL 3-34
OraBfile example
OraBlob example
OraBlob, OraClob, and OraBfile encapsulate locators, ADL 3-31
properties for operating on external LOBs (BFILEs), ADL 3-36
properties for operating on LOBs, ADL 3-35
reading/examining internal LOB and external LOB (BFile) values, ADL 3-34
read-only methods for external LOBs (BFILEs), ADL 3-36
syntax reference, ADL 3-30
using Clone method to retain locator independent of dynaset, ADL 3-31
Oracle Open Gateway
using ROWID datatype, PCO 4-9
Oracle Parallel Execution
described, PSC 8-16
Oracle Parallel Server, GTK 3-61 to GTK 3-63, SCN 1-4, STU 3-10
allocating extents for cluster, SAD 16-9
applicable system types, PSC 1-2
architecture, PSG 1-2
backups and, RMN 5-26
benefits, PSC 1-2
cache fusion, GTK 3-61
compared to replication, REP 2-5, REP 6-8
compatibility requirements, MIG 9-34
concurrency limits and, SCN 300
connect-time failover, NET 2-21, NET 8-4, NET C-39, PSC 8-10
CPU, STU 18-17
data files, PSG 1-3
database configuration, GTK 3-62
database files, PSG 1-17
databases and instances, SCN 5-3
datafile upper bound for instances, SAD 10-3
definition of, PSC 1-2
Destination Type tasks, PSG 7-23
disk affinities, DWG 18-47
disk affinity, SCN 205
distributed lock manager (DLM), GTK 3-62
distributed locks, SCN 230
DML locks and performance, SCN 11-46
downgrading, MIG 13-60, MIG 13-61
dynamic performance views, SRF 3-2
exclusive mode
rollback segments and, SCN 4-28
FAILOVER parameter, NET 8-4, NET C-39
FAILOVER_MODE parameter, NET 8-13, NET C-43
file and log management locks, SCN 241
folder in Console Navigator window, PSG 7-3
Group Membership Services (GMS), GTK 3-62
hardware requirements, PSG 2-2
initialization parameter files, PSG 1-14
initialization parameters
FAST_START_PARALLEL_ROLLBACK, SRF 1-39
LM_LOCKS, SRF 1-52
LM_RESS, SRF 1-53
MTS_CIRCUITS, SRF 1-68
MTS_DISPATCHERS, SRF 1-68
PARALLEL_ADAPTIVE_MULTI_USER, SRF 1-91
PARALLEL_AUTOMATIC_TUNING, SRF 1-92
PARALLEL_BROADCAST_ENABLE, SRF 1-93
PARALLEL_EXECUTION_MESSAGE_SIZE, SRF 1-93
PARALLEL_INSTANCE_GROUP, SRF 1-94
PARALLEL_MAX_SERVERS, SRF 1-94
PARALLEL_MIN_PERCENT, SRF 1-95
PARALLEL_MIN_SERVERS, SRF 1-96
PARALLEL_SERVER, SRF 1-96
PARALLEL_SERVER_IDLE_TIME, SRF 1-12, SRF 1-96
PARALLEL_THREADS_PER_CPU, SRF 1-97
installation, GTK 3-62
installation requirements, PSG 2-2
installing, PSG 3-3
instance affinity for jobs, GTK 3-63
compatibility, MIG 9-12
instance groups, SCN 175
INSTANCE_NAME parameter, NET C-46, NET C-87
instances, PSG 1-2
inter-process communication protocol, GTK 3-62
introduction, PSC 1-1
isolation levels, SCN 222
licensed session limit and, SAD 2-24
limits on named users and, SAD 22-6
LOAD_BALANCE parameter, NET C-40, NET C-87
lock processes, SCN 1-18, SCN 8-13
migration, MIG 4-7
not supported by Oracle Data Migration Assistant, MIG 3-9
mounting a database using, SCN 5-7
named user licensing and, SCN 301
named users and, SAD 2-24
Operating System Dependent layer, PSG 1-5
Oracle Parallel Execution, PSC 8-16
Oracle Parallel Server Assistant, GTK 3-63
Oracle Parallel Server Management, PSG 1-5
Oradebug, GTK 3-62
overview, PSG 1-1 to PSG 1-4
parallel execution, DWG 18-44
parallel load, DWG 14-16
parallel SQL, SCN 157
PCM locks, SCN 230
pre-installation, PSG 2-1 to PSG 2-12
raw device setup, PSG 2-5 to PSG 2-10
read consistency, SCN 217
restoring using RMAN, RMN 6-16
reverse key indexes, SCN 10-33
rollback segments, SAD 11-3
rolling upgrade, MIG 1-13
see also, OPSM
sequence numbers and, SAD 18-13
session and warning limits, SAD 22-3
shared mode
rollback segments and, SCN 4-28
software components
Oracle Parallel Server, PSG 1-5
Oracle Parallel Server Management, PSG 1-5
Oracle8i Enterprise Edition, PSG 1-5
software requirements, PSG 2-2
specifying thread for archiving, SAD 7-10
synchronization points, STU 2-8
system change numbers, SCN 8-10
system monitor process and, SCN 8-11, SCN 198
temporary tablespaces, SCN 3-12
threads of online redo log, SAD 6-2
Transparent Application Failover, NET 8-12
tuning, STU 11-14
upgrading, MIG 7-3, MIG 7-29
not supported by Oracle Data Migration Assistant, MIG 7-6
V$THREAD view, SAD 6-18
Oracle Parallel Server (OPS)
and standby databases, SBY 3-22
Oracle Parallel Server (OPS) Support, ADQ 8-29
Oracle Parallel Server Assistant, GTK 3-62
Oracle Parallel Server databases, PSG 3-38
backing up, PSG 3-39
creating
with manual methods, PSG 3-29
with Oracle Database Configuration Assistant after installation, PSG 3-24
with Oracle Database Configuration Assistant during installation, PSG 3-7
creating a job on, PSG 7-19
deleting, PSG 3-43
disconnecting from, PSG 7-10
displaying objects in Console, PSG 7-3
mounting, PSG 7-8
password files, PSG 3-37
shutdown, PSG 7-12
starting, PSG 3-41
Oracle Parallel Server failover
how it works, PSC 9-13
Oracle Parallel Server Management, STU 11-14
administration of instances, PSG 7-2
architecture, PSG 6-2
configuring, PSG 6-1 to PSG 6-34
defined, PSG 1-5
node requirements, PSG 6-6
OPS Communication Daemon, PSG 6-4
OPSCTL utility, PSG 6-4
OPSD process, PSG 6-4
Oracle Enterprise Manager, PSG 1-5, PSG 6-2
requirements, PSG 6-6
SIDs, PSG 6-6
Oracle Parallel Server Management (OPSM), GTK 3-62, PSC A-5
Group Membership Services (GMS), GTK 3-62
Oracle Parallel Server Assistant, GTK 3-62
Parallel Server Manager, Oracle, GTK 3-62
Oracle Parallel Server Support, ADQ 12-17
Oracle parameter SID, OAS 14-17
Oracle parameters
authentication, OAS 1-14
Oracle Password Protocol, OAS 3-4
Oracle Performance Manager, PSG 8-20, STU 11-11
accessing Oracle Parallel Server charts, PSG 6-30
charts, PSG 8-1 to PSG 8-20
OPS Overview, PSG 8-20
Parallel Server Active Users, PSG 8-18
Parallel Server Active Users by Instance, PSG 8-19
Parallel Server Block Ping, PSG 8-7
Parallel Server Block Ping Tablespace Instance, PSG 8-8
Parallel Server Block Ping Tablespace Object, PSG 8-8
Parallel Server Data Block Ping, PSG 8-8
Parallel Server Data Block Ping by Instance, PSG 8-10
Parallel Server File I/O Rate, PSG 8-11
Parallel Server File I/O Rate by Instance, PSG 8-13
Parallel Server File I/O Rate by Object, PSG 8-12
Parallel Server Lock Activity, PSG 8-14
Parallel Server Sessions, PSG 8-15
Parallel Server Users Logged On, PSG 8-16
Parallel Server Users Logged On by Instance, PSG 8-17
configuring, PSG 6-27 to PSG 6-34
Databases folder, PSG 6-32
defined, PSG 2-4, PSG 6-3
displaying charts, PSG 8-5
Oracle Diagnostics Pack, PSG 2-4
overview, PSG 8-3
Parallel Server Instance folder, PSG 6-30
starting, PSG 6-28, PSG 8-5
Oracle precompiler
optimizing data transfers using, DDS 9-10
Oracle precompilers. See precompilers
Oracle program interface (OPI), SCN 8-28
Oracle Program Interface (OPI). described, NET 3-9
Oracle protocols
Bequeath, NET 4-4, NET B-3
configuring addresses, NET B-3
described, NET 3-9, NET 4-2
IPC, NET B-3
LU6.2, NET 4-4, NET B-3
Named Pipes, NET 4-3, NET B-3
SPX, NET 4-3, NET B-4
TCP/IP, NET 4-2, NET B-4
TCP/IP with SSL, NET 4-2, NET B-4
Oracle Rdb database
configuring for connection to, NET 8-52
described, NET 8-52
Oracle RDB Database field, NET 8-9
Oracle Replication Manager, REP 1-13, REP 8-1, SCN 433
Destination Map, REP 8-7
first login, REP 8-3
interface, REP 8-4
menus, REP 8-13
Edit, REP 8-14
File, REP 8-13
Group, REP 8-14
Help, REP 8-17
Object, REP 8-16
Scheduling, REP 8-16
Setup, REP 8-16
Template, REP 8-15
View, REP 8-14
Navigator pane, REP 8-5
right pane, REP 8-5
starting, REP 8-3
toolbar, REP 8-10
Change Database Connection button, REP 8-10
Create Local Job button, REP 8-12
Create Master Group button, REP 8-10
Create Refresh Group button, REP 8-11
Create Scheduled Link button, REP 8-12
Create Snapshot button, REP 8-11
Create Snapshot Group button, REP 8-11
Create Snapshot Log button, REP 8-11
Create Template button, REP 8-12
Help button, REP 8-13
Offline Instantiation File Generation button, REP 8-12
Refresh button, REP 8-10
Setup Wizard button, REP 8-10
usage scenarios, REP 8-2
wizards, REP 8-17
Copy Template, REP 8-26
Deployment Template, REP 8-22
Offline Instantiation Wizard, REP 8-24
Setup, REP 8-18
Snapshot Group, REP 8-20
Oracle reserved words, SQL C -1
Oracle schema, OAS E-1
attributes, NET D-1 to NET D-5
creating, NET 6-22
described, NET 2-54
object classes, NET D-1 to NET D-5
Oracle Security Server, GTK 3-70, GTK 3-72, GTK 7-8
Oracle Server
client/server configuration, STU 3-11
configurations, STU 3-7
events, STU 14-5
Oracle server, SCN 1-4
complying with license agreement, SAD 22-2
hostname, LEG 2-23
See also Oracle
Oracle service names, registering in CDS, OAS 12-4
Oracle Software Packager, GTK 3-58
Oracle Spatial, GTK 2-7, GTK 3-10
Oracle SQL*Loader, used by bulkload, OID A-20
Oracle SQLJ
advantages over JDBC, ADG 1-32
creating custom Java classes, ADO 3-13
definition, ADG 1-30
design, ADG 1-31
example, ADG 1-33
in the server, ADG 1-36
JPublisher, ADO 3-13
stored programs, ADG 1-36
support for Oracle objects, ADO 3-12
Oracle supplied packages, ADG 9-17
Oracle System Identifier (SID), defined, PSG 1-15
Oracle System Identifier, configuring on the listener, NET 7-13
Oracle Time Series, GTK 3-13
Oracle Tools
support of SQL, SQL 1-5
Oracle Trace, DWG 15-3, STU 14-1, STU 19-40
accessing collected data, STU 14-5
binary files, STU 14-5
collection results, STU 14-27
collections, STU 14-4, STU 14-23
command-line interface, STU 14-20
data views, STU 14-6
Average Elapsed Time, STU 14-11
CPU Statistics, STU 14-12
Disk Reads, STU 14-9
Disk Reads/Execution Ratio, STU 14-9
Disk Reads/Logical Reads Ratio, STU 14-10
Disk Reads/Rows Fetched Ratio, STU 14-9
Execute Elapsed Time, STU 14-11
Fetch Elapsed Time, STU 14-11
Logical Reads, STU 14-9
Logical Reads/Rows Fetched Ratio, STU 14-9
Number of Rows Processed, STU 14-12
Parse Elapsed Time, STU 14-11
Parse/Execution Ratio, STU 14-10
Re-Parse Frequency, STU 14-10
Rows Fetched/Fetch Count Ratio, STU 14-12
Rows Sorted, STU 14-12
Sorts in Memory, STU 14-12
Sorts on Disk, STU 14-12
Total Elapsed Time, STU 14-11
Waits by Average Wait Time, STU 14-13
Waits by Event Frequency, STU 14-13
Waits by Total Wait Time, STU 14-13
deleting files, STU 14-22
details property sheet, STU 14-15
drilldown data views, STU 14-17, STU 14-19
Basic Statistics for Parse/Execute/Fetch view, STU 14-19
CPU Statistics for Parse/Execute/Fetch view, STU 14-19
Parse Statistics view, STU 14-19
Row Statistics for Execute/Fetch view, STU 14-20
duration events, STU 14-5
events, STU 14-5
FORMAT statement, STU 14-21
formatter tables, STU 14-5
formatting data, STU 14-27
Oracle Trace Data Viewer, STU 14-6
parameters, STU 14-22
point events, STU 14-5
predefined data views, STU 14-6
reporting utility, STU 14-6, STU 14-28
SQL statement property sheet, STU 14-15
START statement, STU 14-21
STOP statement, STU 14-21
stored procedures, STU 14-25
using to collect workload data, STU 14-3
viewing data, STU 14-13
Oracle Trace Data Viewer, STU 14-6
Oracle Trace Manager, STU 14-4, STU 14-23
used for formatting collections, STU 14-5
Oracle Transparent Gateways
Heterogeneous Services and, DDS 6-3
Oracle type translator (OTT), ADO 3-8, SCN 13-15
Oracle Universal Installer, GTK 2-4, GTK 3-58, GTK 3-62, PSG 3-3, SAD 2-4, SAD 2-5
Oracle Version 6
exporting database objects, SUT 2-62
Oracle Visual Information Retrieval, GTK 3-12
Oracle Wallet Manager, OID 2-23, GTK 2-8, GTK 3-73, SCN 283
described, OAS 17-19
key management, OAS F-4
overview, OAS 18-2, OID D-2
Oracle wallets, OID F-6, SCN 283
changing location of, OID 5-10, OID F-6
Oracle XA
session memory in the large pool, SCN 7-12
ORACLE_HOME environment variable, PSG B-5
ORACLE_HOME initialization parameter, MIG F-15
ORACLE_HOME parameter, NET 7-13, NET 8-47, NET 8-49, NET C-51
oracle_home parameter, PSG B-5
ORACLE_HOME, defined, NET xx, PSG xxiii
oracle_pid, PSC 7-23
ORACLE_PSRV environment variable, PSG B-3, PSG B-5, PSG C-7
ORACLE_SID environment variable, PSG 1-15, PSG 3-35
ORACLE_SID registry entry, PSG 1-15
ORACLE_TRACE_COLLECTION_NAME initialization parameter, SRF 1-87
ORACLE_TRACE_COLLECTION_NAME parameter, STU 14-22, STU 14-23
ORACLE_TRACE_COLLECTION_PATH initialization parameter, SRF 1-88
ORACLE_TRACE_COLLECTION_PATH parameter, STU 14-22
ORACLE_TRACE_COLLECTION_SIZE initialization parameter, SRF 1-88
ORACLE_TRACE_COLLECTION_SIZE parameter, STU 14-22
ORACLE_TRACE_ENABLE initialization parameter, SRF 1-88
ORACLE_TRACE_ENABLE parameter, STU 14-22, STU 14-23
ORACLE_TRACE_FACILITY_NAME initialization parameter, SRF 1-89
ORACLE_TRACE_FACILITY_NAME parameter, STU 14-22, STU 14-23
ORACLE_TRACE_FACILITY_PATH initialization parameter, SRF 1-90
ORACLE_TRACE_FACILITY_PATH parameter, STU 14-22
Oracle7
creating export files with, SUT 1-63
downgrading to, MIG 14-1
Enterprise Backup Utility (EBU), LEG 4-4
Oracle Enterprise Manager, LEG 4-5
prepare for migration, MIG 4-9, MIG 5-7
Windows platforms, MIG 4-12, MIG 5-12
Oracle8
backup and recovery system, LEG 1-8, LEG 1-9, LEG 1-10
Media Management Library (MML), LEG 1-11
MM API, LEG 1-11
Oracle Enterprise Manager, LEG 1-10, LEG 4-5
Recovery Catalog, LEG 1-9, LEG 1-10
Recovery Manager (RMAN), LEG 1-9, LEG 1-10, LEG 4-4
Oracle8 Replication Manager, configuring Advanced Symmetric Replication (ASR), OID 10-3
Oracle8i
Advanced Symmetric Replication, OID 2-14
backup feature, OID 1-5
data server, OID 2-33
database, OID 2-30
Oracle8i
changes to initialization parameters, MIG B-1
Enterprise Edition
features and functionality, SQL v, SRF iii
features and functionality, SQL v, SRF iii
new features, SQL vi
adding after migration or upgrade, MIG 8-8
new internal types, MIG E-1
new replication features, REP A-1
new SQL functions, MIG E-1
Oracle8i Enterprise Edition
defined, PSG 1-5
installing, PSG 3-3
Oracle8i JServer
connections, NET 3-16
listener configuration, NET 7-8
Oracle8i JServer connections, NET 7-8
Oracle8i Lite support, REP C-1
oracle.AQ.AQQueueTable, ADQ B-93
oracle.AQ.AQQueueTableProperty, ADQ B-94
OracleDBCreators group, OAS 17-8, NET 2-43, NET 2-44, NET 2-53, NET 6-22
OracleDBSecurity group, OAS 17-8
OracleDBSecurityAdmins group, OAS E-3, OAS E-4
OracleHOME_NAMEAgent service, PSG 6-10
OracleHOME_NAMEDataGatherer service, PSG 6-27
OracleHOME_NAMEManagementServer service, PSG 6-11
oracle.jms - oracle.jms, JPR 2-1
oracle.jms.AdtMessage, ADQ B-57
oracle.jms.AQjmsAdtMessage, ADQ B-64
oracle.jms.AQjmsAgent, ADQ B-65
oracle.jms.AQjmsBytesMessage, ADQ B-66
oracle.jms.AQjmsConnection, ADQ B-67
oracle.jms.AQjmsConstants, ADQ B-69
oracle.jms.AQjmsConsumer, ADQ B-70
oracle.jms.AQjmsDestination, ADQ B-71
oracle.jms.AQjmsDestinationProperty, ADQ B-73
oracle.jms.AQjmsException, ADQ B-86
oracle.jms.AQjmsFactory, ADQ B-74
oracle.jms.AQjmsInvalidDestinationException, ADQ B-87
oracle.jms.AQjmsInvalidSelectorException, ADQ B-88
oracle.jms.AQjmsMapMessage, ADQ B-75
oracle.jms.AQjmsMessageEOFException, ADQ B-89
oracle.jms.AQjmsMessageFormatException, ADQ B-90
oracle.jms.AQjmsMessageNotReadableException, ADQ B-91
oracle.jms.AQjmsMesssageNotWriteableException, ADQ B-92
oracle.jms.AQjmsObjectMessage, ADQ B-77
oracle.jms.AQjmsOracleDebug, ADQ B-78
oracle.jms.AQjmsProducer, ADQ B-79
oracle.jms.AQjmsQueueBrowser, ADQ B-80
oracle.jms.AQjmsQueueReceiver, ADQ B-58
oracle.jms.AQjmsQueueSender, ADQ B-59
oracle.jms.AQjmsSession, ADQ B-82
oracle.jms.AQjmsStreamMessage, ADQ B-83
oracle.jms.AQjmsTextMessage, ADQ B-84
oracle.jms.AQjmsTopicConnectionFactory, ADQ B-85
oracle.jms.AQjmsTopicPublisher, ADQ B-60
oracle.jms.AQjmsTopicReceiver, ADQ B-63
oracle.jms.AQjmsTopicSubscriber, ADQ B-62
oracle.jms.TopicReceiver, ADQ B-61
OracleNetAdmins group, OAS 17-8, OAS E-4, NET 2-44, NET 2-52, NET 6-22, NET 6-23, NET 6-31
oracle.net.crypto_checksum_client parameter, OAS 3-6
oracle.net.crypto_client parameter, OAS 3-7
oracle.net.encryption_client parameter, OAS 3-5
oracle.net.encryption_types_client parameter, OAS 3-6
oracle.ODCI - oracle.ODCI, JPR 3-1
OraclePGMSService service, PSG 3-21
OraclePreparedStatement, See JDBC
OracleResultSet, See JDBC
OracleSecurityAdmins group, NET 2-53, NET 6-22
OracleServicesid service, PSG 3-11, PSG 3-35
oracle.sql.BFILE
BFILE-buffering, ADL 3-43
JDBC methods to read/examine BFILEs, ADL 3-42
oracle.sql.BLOB
for modifying BLOB values, ADL 3-39
reading/examining BLOB values, ADL 3-39
See JDBC
oracle.sql.BLOBs
BLOB-buffering
oracle.sql.CHAR, NLS 6-3
oracle.sql.CHAR class, NLS 6-8
getString() method, NLS 6-8
getStringWithReplacement() method, NLS 6-8
toString() method, NLS 6-8
oracle.sql.CharacterSet class, NLS 6-8
oracle.sql.CLOB, NLS 6-3
CLOB-buffering
JDBC methods to read/examine CLOB values, ADL 3-41
modifying CLOB values, ADL 3-40
oracle.sql.CLOBs
See JDBC
OracleSSLCredential - oracle.security.ssl.OracleSSLCredential, OAS F-21
OracleSSLCredential() - oracle.security.ssl.OracleSSLCredential.OracleSSLCredential(), OAS F-22
OracleSSLProtocolVersion - oracle.security.ssl.OracleSSLProtocolVersion, OAS F-23
OracleSSLServerSocket - oracle.security.ssl.OracleSSLServerSocket, OAS F-25
OracleSSLServerSocket(int) - oracle.security.ssl.OracleSSLServerSocket.OracleSSLServerSocket(int), OAS F-26
OracleSSLServerSocket(int, int) - oracle.security.ssl.OracleSSLServerSocket.OracleSSLServerSocket(int, int), OAS F-26
OracleSSLServerSocket(int, int, InetAddress) - oracle.security.ssl.OracleSSLServerSocket.OracleSSLServerSocket(int, int, java.net.InetAddress), OAS F-27
OracleSSLServerSocketFactory - oracle.security.ssl.OracleSSLServerSocketFactory, OAS F-28
OracleSSLServerSocketFactory() - oracle.security.ssl.OracleSSLServerSocketFactory.OracleSSLServerSocketFactory(), OAS F-28
OracleSSLServerSocketFactoryImpl - oracle.security.ssl.OracleSSLServerSocketFactoryImpl, OAS F-30
OracleSSLServerSocketFactoryImpl() - oracle.security.ssl.OracleSSLServerSocketFactoryImpl.OracleSSLServerSocketFactoryImpl(), OAS F-31
OracleSSLSession - oracle.security.ssl.OracleSSLSession, OAS F-35
OracleSSLSession() - oracle.security.ssl.OracleSSLSession.OracleSSLSession(), OAS F-36
OracleSSLSocketFactory - oracle.security.ssl.OracleSSLSocketFactory, OAS F-41
OracleSSLSocketFactory() - oracle.security.ssl.OracleSSLSocketFactory.OracleSSLSocketFactory(), OAS F-41
OracleSSLSocketFactoryImpl - oracle.security.ssl.OracleSSLSocketFactoryImpl, OAS F-43
OracleSSLSocketFactoryImpl() - oracle.security.ssl.OracleSSLSocketFactoryImpl.OracleSSLSocketFactoryImpl(), OAS F-44
oracle.xml.parser.v2 - oracle.xml.parser.v2, JPR 4-1
OraCLOB object, ADG 1-18
ORACOC
in ORACA, PCO 8-28
ORACOC field, PCO 8-28
OraCollection interface, ADO 3-11
OraDatabase object, ADG 1-14
ORADBGF flag, PCO 8-26
Oradebug, GTK 3-62, PSC A-5
ORADIM
downgrading, MIG 13-57
migration, MIG 4-24, MIG 7-16
upgrading, MIG 7-16
OraDynaset object, ADG 1-14
OraField object, ADG 1-15
ORAHCHF flag, PCO 8-26
ORAHOC field, PCO 8-28
OraMeta Data object, ADG 1-15
ORAMOC field, PCO 8-28
ORANEX
in ORACA, PCO 8-28
ORANEX field, PCO 8-28
ORANLS option, NLS B-13, NLS B-17
ORANOR field, PCO 8-28
ORANPR field, PCO 8-28
OraObject interface, ADO 3-10
OraParamArray object, ADG 1-16
OraParameter object, ADG 1-15
ORAPWD utility, PSG 3-37, SAD 1-9
orapwsid file, PSG 3-37
OraRef interface, ADO 3-10
OraServer object, ADG 1-13
OraSession object, ADG 1-13
ORASFNM, in ORACA, PCO 8-27
ORASFNMC field, PCO 8-27
ORASFNML field, PCO 8-27
ORASLNR
in ORACA, PCO 8-27
ORASLNR field, PCO 8-27
OraSQLStmt object, ADG 1-16
ORASTXTC field, PCO 8-27
ORASTXTF flag, PCO 8-26
ORASTXTL field, PCO 8-27
oratypes.h
contents, OCI 3-27
only supported means of supplying parameters to the OCI, OCI 3-27
oraxsl - oracle.xml.parser.v2.oraxsl, JPR 4-42
oraxsl() - oracle.xml.parser.v2.oraxsl.oraxsl(), JPR 4-43
oraxxxxx.trc file, PSG C-10
orclACI, OID 9-2, OID F-3
access to, OID 9-2
ACLs in, OID 9-2
optional object class in top, OID 2-9
orclAgreementID, OID 10-14, OID 10-15
orclAgreementId, OID F-3
orclauditattribute, OID F-4
orclAuditLevel, OID F-4
orclauditlevel attribute, OID 5-28
orclauditlevel operational attribute, OID 5-24
orclauditmessage, OID F-4
orclauditmessage attribute, OID 5-25
OrclAuditOC, OID F-4
orclauditoc attributes, OID 5-25
orclauditoc object class, OID 5-25
orclCatalogEntryDN, OID F-4
orclChangeRetryCount, OID 10-10, OID 10-13, OID F-3
orclConfigSet, OID F-4
orclconfigsetnumber, OID F-4
orclConsumerReference, OID F-3
orclcontainerOC, OID F-4
orclDBDistinguishedName attribute, OAS E-2
orclDBEnterpriseDomain object class, OAS E-2
orclDBEnterpriseRole object class, OAS E-2
orclDBEntryLevelMapping object class, OAS E-2
orclDBGlobalName attributes, OAS E-2
orclDBNativeUser attribute, OAS E-2
orclDBRoleOccupant attribute, OAS E-2
orclDBServer object class, OAS E-2, NET 2-54, NET D-2
orclDBServerMember attribute, OAS E-2
orclDBServerRole attribute, OAS E-2
orclDBSubtreeLevelMapping object class, OAS E-2
orclDBTrustedDomain attribute, OAS E-2
orclDBType, OID F-4
orclDebugLevel, OID F-4
orcldebuglevel configuration set entry, OID F-5
orclDescList attribute, NET D-5
orclDescName attribute, NET D-5
orclDirReplGroupAgreement, OID 10-10, OID F-3
orclDirReplGroupDSAs, OID 10-10, OID 10-13, OID 10-15, OID F-3
orclDITRoot, OID F-4
orclEntryLevelACI, OID 9-3, OID F-3
optional object class in top, OID 2-9
orcleventLog, OID F-4
orclEvents, OID F-4
orcleventtime, OID F-4
orcleventtime attribute, OID 5-25
orcleventtype, OID F-4
orcleventtype attribute, OID 5-25
orclExcludedNamingcontexts, OID 10-15, OID F-3
orclGuid, OID F-3
optional object class in top, OID 2-9
orclGuName, OID F-4
orclGuPassword, OID F-4
orclhostname, OID F-4
orclIndexedAttribute, OID F-4
orclIndexOC, OID F-4
orclLDAPInstance, OID F-4
orclLDAPSubConfig, OID F-4
orclLoadBalance attribute, NET D-5
ORCLMAXCC, OID 13-4
orclMaxCC, OID F-4
orclmaxcc, OID 2-32
orclmaxcc configuration set entry, OID F-5
orclNetAddress object class, NET 2-54, NET D-4
orclNetAddressList object class, NET 2-54, NET D-4
orclNetAddrList attribute, NET D-5
orclNetAddrString attribute, NET D-5
orclNetConnParamList attribute, NET D-5
orclNetDescription object class, NET 2-54, NET D-3
orclNetDescriptionList object class, NET 2-54, NET D-3
orclNetFailover attribute, NET D-5
orclNetInstanceName attribute, NET D-5
orclNetProtocolStack attribute, NET D-5
orclNetSdu attribute, NET D-5
orclNetService object class, NET 2-54, NET D-2
orclNetServiceName attribute, NET D-5
orclNetSourceRoute attribute, NET D-5
orclOpResult, OID F-4
orclopresult attribute, OID 5-25
orclParentGUID, OID F-3
orclPrivilegeGroup, OID 7-20
orclPrName, OID F-4
orclProtocol attribute, NET D-5
orclPrPassword, OID F-4
orclPurgeSchedule, OID 10-10, OID 10-13, OID F-3
orclReplAgreementEntry, OID F-3
orclReplBindDN, OID F-3
orclReplBindPassword, OID F-3
orclReplicationProtocol, OID 10-15, OID F-3
orclREPLInstance, OID F-4
orclREPLSubConfig, OID F-4
orclSequence, OID F-4
orclsequence attribute, OID 5-25, OID 5-26
orclServerEvent, OID F-4
orclServerMode, OID 5-18, OID F-4
ORCLSERVERPROCS, OID 13-4
orclServerProcs, OID F-4
orclserverprocs, OID 2-32
orclserverprocs configuration set entry, OID F-5
orclSid attribute, NET D-5
orclSizeLimit, OID 5-18, OID F-4
orclssl authentication configuration set entry, OID F-5
orclsslAuthentication, OID F-4
orclsslEnable, OID F-4
orclsslenable, OID F-5
orclsslenable configuration set entry, OID F-5
orclsslPort, OID F-4
orclsslport configuration set entry, OID F-5
orclsslVersion, OID F-4
orclsslWalletPasswd, OID F-4
orclsslwalletpasswd configuration set entry, OID F-6
orclsslWalletURL, OID F-4
orclsslwalleturl configuration set entry, OID F-6
orclSuffix, OID F-4
orclSuName, OID F-4
orclSuPassword, OID F-4
orclSupplierReference, OID F-3
orclThreadsPerSupplier, OID 10-10
orclTimeLimit, OID 5-18, OID F-4
orclUpdateSchedule, OID 10-15, OID F-3
orclUseEncrypt, OID 5-18, OID F-4
orcluserdn, OID F-4
orcluserdn attribute, OID 5-25
orclVersion attribute, NET D-5
ORDBMS, SCN 1-21, SCN 13-2
ORDER BY clause, NLS 4-9, DWG 8-22
decreasing demand for, DWG 18-39
of CREATE TABLE, SQL 7-409
of queries, SQL 5-21
of SELECT, SQL 5-21, SQL 7-571, SQL 7-580
with ROWNUM, SQL 2-61
of subqueries in CREATE TABLE, SQL 7-409
sorting character data, NLS 2-28
ORDER clause
of ALTER SEQUENCE. See CREATE SEQUENCE
of CREATE SEQUENCE, SQL 7-374
ORDER MEMBER clause
of ALTER TYPE, SQL 7-189
of CREATE TYPE, SQL 7-443
of CREATE TYPE BODY, SQL 7-449
ORDER methods
specifying, SQL 7-189
order methods, ADO 1-5, ADO 6-7, ADO 9-17, ADO 9-23, DCI 3-5, PLS 9-10, SCN 1-56, SCN 13-7
order of evaluation, PLS 2-43, PLS 2-44
ORDER option, PSC 8-14
ORDERED hint, SQL 2-66, STU 4-59, STU 7-18
ORDERED_PREDICATES hint, SQL 2-65, STU 7-35
Ordering of Messages, ADQ 8-38, ADQ 12-58
ordinal numbers
specifying, SQL 2-51
spelling out, SQL 2-51
ORE. See object runtime environment
ORECLEN precompiler option, PCO 14-33
organization attribute, OID 2-5
ORGANIZATION HEAP clause
of CREATE TABLE, SQL 7-396
ORGANIZATION INDEX clause
of CREATE TABLE, SQL 7-396
organizationalUnitName, OID 2-5
ORLON calls
obsolete, MIG 9-19
OS authentication, SAD 1-7
OS_AUTHENT_PREFIX initialization parameter, SRF 1-90
OS_AUTHENT_PREFIX parameter, OAS 1-15
CyberSafe authentication, OAS 5-8
OS_ROLES initialization parameter, SRF 1-91
OS_ROLES parameter, ADG 11-27
operating-system authorization and, SAD 23-9
REMOTE_OS_ROLES and, SAD 23-22
using, SAD 23-20
OS_ROLES parameter, setting, OAS 14-7
OS_USER attribute, USERENV, ADG 11-44
OSI model
client application layer, NET 3-4
network layer, NET 3-4
physical, NET 3-4
presentation layer, NET 3-4
session layer, NET 3-4
transport layer, NET 3-4
OSS. See Oracle Security Server.
OSS.MY.WALLET parameter, NET C-13, NET C-55
OSS.SOURCE.MY_WALLET parameter, OAS 10-12, OAS 10-21
OTHER column
PLAN_TABLE table, STU 5-6
OTHER_GROUPS for Database Resource Manager, SAD 25-7, SAD 25-9, SAD 25-11, SAD 25-14, SAD 25-20
OTHER_TAG column
PLAN_TABLE table, STU 5-5
OTHERS exception handler, PLS 6-2, PLS 6-15
OTT, ADO 3-8
command line, OCI 14-5
command line syntax, OCI 14-23
creating types in the database, OCI 14-4
datatypes mapping, OCI 14-9
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
OTT. See Object Type Translator (OTT)
ou attribute, NET 2-41
OUT bind variables, DDS 9-6
OUT parameter
of CREATE FUNCTION, SQL 7-287
of CREATE PROCEDURE, SQL 7-356
OUT parameter mode, ADG 9-6, PC_ 7-3, PCO 6-5, PLS 7-14
OUT_OF_RELAY, NET A-94
outages
causes of, PSC 9-3
outer joins, ADG 2-26, SQL 5-23, SQL 7-577
defined, STU 4-47
key-preserved tables in, ADG 2-27
non-null values for nulls, STU 4-86
restrictions, SQL 5-23
with query rewrite, DWG 19-29
outlines
assigning to a different category, SQL 7-63
automatically creating and storing, SQL 7-109
CREATE OUTLINE statement, STU 10-5
creating, SQL 7-342
creating and using, STU 10-4
dropping from the database, SQL 7-490
enabling and disabling dynamically, SQL 7-342
execution plans and plan stability, STU 10-2
granting
system privileges on, SQL 7-524
hints, STU 10-3
matching with SQL statements, STU 10-3
moving tables, STU 10-7
rebuilding, SQL 7-63
renaming, SQL 7-63
replacing, SQL 7-342
storage requirements, STU 10-4
storing during the session, SQL 7-86
storing for the instance, SQL 7-118
use by the optimizer, SQL 7-95, SQL 7-118
used to generate execution plans, SQL 7-342
using, STU 10-5
using to move to the cost-based optimizer, STU 10-8
viewing data for, STU 10-6
OUTLN schema
DBA privileges, SCN 129
OUTLN user
avoid, MIG 4-10, MIG 5-9, MIG 7-3
change password, MIG 8-2
OUTLN_PKG package, SPR 58-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, PSG 7-15
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
overall throughput, OID 13-2
OVERFLOW clause
of ALTER INDEX, SQL 7-34
of ALTER TABLE, SQL 7-154
of CREATE TABLE, SQL 7-397
overhead
reducing, PC_ C-2
overlaps, PSA 5-9
overloaded disks, STU 20-19
overloading, PLS 7-24
object method, PLS 9-10
of packaged functions, ADG 9-70
packaged subprogram, PLS 8-15
restrictions, PLS 7-25
stored procedure names, ADG 9-13
using RESTRICT_REFERENCES, ADG 9-70
using subtypes, PLS 7-26
overriding language and territory specifications, NLS 2-6
overriding user-specified configsets, OID 3-10
oversubscribing resources, DWG 18-37, DWG 18-41
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 methods, REP 5-13
overwriting control file records, RMN 3-47
OWA* packages, ADG 12-2
OWNER
Export parameter, SUT 1-22
OWNER# column
SYS.INCEXP table, SUT 1-52

Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents