Oracle8i Generic Documentation Master Index
Release 8.1.5

A68826-01

Library

Product

Contents

Index

Prev Top Next


O

O2F, SMS 35-1
O2I, SMS 36-1
O2U, SMS 37-1
O7_DICTIONARY_ACCESSIBILITY parameter, SRF 1-13
compatibility, MIG 8-24, MIG B-8
OBJ synonym for USER_OBJECTS, SRF 2-174
object, PLS 9-4
declaring, PLS 9-22
initializing, PLS 9-23
manipulating, PLS 9-30
sharing, PLS 9-27
object access expressions, SQL 5-10
object applications
commit, OCI 13-14
database connection, OCI 10-10
rollback, OCI 13-14
object attribute, PLS 9-3, PLS 9-7
accessing, PLS 9-24
allowed datatypes, PLS 9-7
maximum number, PLS 9-7
object cache, ADL 2-14, GTK 2-35, GTK 2-36, GTK 3-12, OCI 13-2, PC_ 17-4, SQL 7-86, SQL 7-107
coherency, OCI 13-4
consistency, OCI 13-4
flushing an object, ADG 19 - 13
initializing, OCI 10-10
loading objects, OCI 13-7
LOBs, ADL 2-14
memory parameters, OCI 13-5
object views, SCN 15-4
OCI, SCN 13-14
operations on, OCI 13-6
privileges, SCN 14-16
Pro*C, SCN 13-14
removing objects, OCI 13-7
setting the size of, OCI 13-5
object columns, indexes on, ADG 6 - 7
object constructor
calling, PLS 9-25
passing parameters to, PLS 9-26
OBJECT CREATE SQL statement, PC_ 17-9, PC_ F-84
Object Database Designer, GTK 3-13
OBJECT DELETE SQL statement, PC_ 17-11, PC_ F-85
OBJECT DEREF SQL statement, PC_ 17-10, PC_ F-86
OBJECT FLUSH SQL statement, PC_ F-87
OBJECT FLUSH SQL statements, PC_ 17-12
object functions
See navigational functions.
server roundtrips, OCI C-4
OBJECT GET SQL statement, PC_ 17-16, PC_ F-88
object identifier
for persistent objects, OCI 10-5
object identifier (OID)
with CREATE TYPE, DCI 3-3
OBJECT IDENTIFIER clause
of CREATE TABLE, SQL 7-377
object identifiers, ADG 16 - 28, SCN 15-3, SUT 2-57
contained in REFs, SQL 2-26
Export, SUT 1-56
for object types, SCN 14-18
for object views, SCN 15-3, SCN 15-4
of object views, SQL 7-433
primary key, SQL 7-377
primary-key based, ADG 18 - 8
REFs, ADG 18 - 9
specifying, SQL 7-377
specifying an index on, SQL 7-377
storage, ADG 18 - 8
system-generated, SQL 7-377
WITH OBJECT OID clause, SCN 15-3, SCN 15-4
object method, PLS 9-3, PLS 9-8
calling, PLS 9-26
object names
resolving partial, DDS 2-17
SQL*Loader, SUT 5-18
object privileges, SCN 30-3
granting, SQL 7-343
multiple, SQL 7-347
on specific columns, SQL 7-506
to a role, SQL 7-505
to a user, SQL 7-505
to PUCLIC, SQL 7-506
on a database object
revoking, SQL 7-534
on a directory
revoking, SQL 7-533
revoking
all, from a user, SQL 7-533
from a role, SQL 7-532, SQL 7-533
from a user, SQL 7-532, SQL 7-533
from all users, SQL 7-534
from PUBLIC, SQL 7-533
See also schema object privileges
object reference, OCI 10-33
object reference functions, SQL 4-4
object reference. See REF
object relational enhancements, GTK 2-33 to GTK 2-37
ANALYZE command, dangling REFs, GTK 2-36
collection unnesting, GTK 2-35
object cache enhancements, GTK 2-36
object identifiers, user defined, GTK 2-34
object views, GTK 2-35
parallel query support, GTK 2-37
partitioning of tables containing user-defined types, GTK 2-37
referential integrity constraint on REF column, GTK 2-34
SQL*Loader support, GTK 2-36
value subqueries, GTK 2-36
see also LOBs
see also nested tables
see also varrays
OBJECT RELEASE SQL statement, PC_ F-89
object runtime environment
initializing, OCI 10-10
OBJECT SET SQL statement, PC_ 17-14, PC_ F-90
object support, SUT 3-23
object support in OO4O, ADG 1 - 17
object table, PLS 9-30
object tables, ADG 16 - 26, ADG 18 - 8, SCN 13-3, SCN 13-7
adding rows to, SQL 7-513
constraints, SCN 14-5
creating, SQL 7-358
deleting values, ADG 16 - 41
Import, SUT 2-58
indexes, SCN 14-6
inserting values, ADG 16 - 36
loading, SUT 5-96
partitioned
downgrading, MIG 12-16
querying, ADG 16 - 39
row objects, SCN 13-8
triggers, SCN 14-6
virtual object tables, SCN 15-2
object type, DCI 1-8, PLS 9-1, PLS 9-3
advantages, PLS 9-5
attributes, DCI 1-15, DCI 11-2
body code, DCI 1-16
comparisons, DCI 3-5
defining, PLS 9-12
examples, PLS 9-12
methods, DCI 11-2
specification, DCI 1-15
structure, PLS 9-5
syntax, PLS 11-105
object type bodies
creating, SQL 7-422
re-creating, SQL 7-422
SQL examples, SQL 7-424
object type definitions
exporting, SUT 1-56
importing, SUT 2-58
object type identifiers, SUT 2-30
object type tables
creating, SQL 7-367
Object Type Translator, GTK 3-12
object type translator
sample output, OCI 10-9
See OTT
use with OCI, OCI 10-8
Object Type Translator (OTT), PC_ A-4
command line, PC_ 19-6
command line syntax, PC_ 19-26
creating types in the database, PC_ 19-5
datatype mappings, PC_ 19-10
default name mapping, PC_ 19-38
outtype file, PC_ 19-17
parameters, PC_ 19-27 to PC_ 19-31
providing an intype file, PC_ 19-8
reference, PC_ 19-25
restriction, PC_ 19-39
using, PC_ 19-1, PC_ 19-2
using with Pro*C/C++, PC_ 19-22
object type values
comparing, SQL 7-417, SQL 7-423
Object Types, PC_ A-3
object types, GTK 3-11, SCN 1-22, SCN 13-2, SCN 13-4, SQL 2-26
adding new member subprograms, SQL 7-174
associating functions or procedures, SQL 7-174
attributes, SQL 2-77
attributes of, SCN 13-2, SCN 13-4
column objects, SCN 13-8
indexes, SCN 14-6
column objects vs. row objects, ADG 18 - 2
comparison methods for, ADG 16 - 22, SCN 13-6
comparison rules, SQL 2-30
MAP function, SQL 2-30
ORDER function, SQL 2-30
compiling the specification and body, SQL 7-174
components of, SQL 2-26
constructor methods for, SCN 1-57, SCN 13-6, SCN 14-18
creating, SQL 7-411, SQL 7-413
defining member methods of, SQL 7-422
disassociating statistics types from, SQL 7-480
dropping the body of, SQL 7-482
dropping the specification of, SQL 7-480
function subprogram
declaring, SQL 7-423
function subprogram of
specifying, SQL 7-416
function subprograms of, SQL 7-415, SQL 7-422
incomplete, ADG 16 - 16, SCN 14-17, SQL 7-413
invoker-rights, ADG 18 - 30
locking in cache, SCN 13-15
message queuing, SCN 19-6
methods, SQL 2-77
methods of, ADG 16 - 23, SCN 1-57, SCN 13-4
method calls, SCN 14-9
PL/SQL, SCN 13-14
purchase order example, SCN 13-2, SCN 13-5
mutually dependent, SCN 14-16
object views, SCN 10-16
Oracle type translator, SCN 13-15
parallel query, SCN 26-29
restrictions, SCN 26-30
procedure subprogram
declaring, SQL 7-423
procedure subprogram of
specifying, SQL 7-416
procedure subprograms of, SQL 7-415, SQL 7-422
purchase order example, SCN 13-2, SCN 13-4
restrictions
parallel DDL, SCN 26-31
parallel DML, SCN 26-44
row objects, SCN 13-8
SQL examples, SQL 7-418
statistics types, SQL 7-195
use of table aliases, SCN 14-8
user-defined
creating, SQL 7-414
OBJECT UPDATE SQL statement, PC_ 17-12, PC_ F-91
object views, ADG 17 - 2, GTK 2-35, GTK 3-11, GTK 3-12, SCN 10-16, SCN 15-1
adding rows to the base table of, SQL 7-513
advantages, ADG 17 - 3
advantages of, SCN 15-2
defining, SCN 15-3, SQL 7-430
modifiability, SCN 20-12
nested tables, SCN 15-5
object identifiers for, SCN 15-3, SCN 15-4
updating, ADG 17 - 15, SCN 15-5
use of INSTEAD OF triggers with, SCN 15-5
OBJECT_CACHE_MAX_SIZE_PERCENT parameter, SRF 1-83
of ALTER SESSION, SQL 7-86
of ALTER SYSTEM, SQL 7-107
OBJECT_CACHE_OPTIMAL_SIZE parameter, SRF 1-83
of ALTER SESSION, SQL 7-86
of ALTER SYSTEM, SQL 7-107
OBJECT_INSTANCE column
PLAN_TABLE table, STU 13-4
OBJECT_NAME column
PLAN_TABLE table, STU 13-4
OBJECT_NODE column
PLAN_TABLE table, STU 13-4
OBJECT_OWNER column
PLAN_TABLE table, STU 13-4
OBJECT_TYPE column
PLAN_TABLE table, STU 13-4
object-identifiers
user-defined
downgrading, MIG 12-22
object-oriented programming, PLS 9-1
object-relational DBMS (ORDBMS), SCN 1-22, SCN 13-2
object-relational model, ADG 16 - 1
comparing objects, ADG 18 - 8
constraints, ADG 18 - 39
design considerations, ADG 18 - 1
embedded objects, ADG 16 - 28
implementing with object tables, ADG 16 - 16
inheritance, ADG 18 - 33
limitations of relational model, ADG 16 - 13
methods, ADG 18 - 27
new object format, ADG 18 - 33
partitioning, ADG 16 - 41
programmatic environments for, ADG 19 - 1
replication, ADG 18 - 33
type evolution, ADG 18 - 40
object-relational technology, GTK 3-10
Objects, SUT 3-16
objects, SUT 3-20
accessing with OCI, OCI 14-19, PC_ 19-19
allocation duration, OCI 13-14
altering in a master group, REP 2-28
array pin, OCI 10-13
attributes, OCI 10-17
manipulating, OCI 10-13
client-side cache, OCI 13-2
collection objects, ADG 17 - 6
considerations for Importing, SUT 2-57
copying, OCI 10-32
creating, OCI 10-32
creation errors, SUT 2-48
data dictionary, SRF 2-1
definitions
replication to master sites, REP 2-26
duration, OCI 13-14
flushing, OCI 13-10
flushing changes, OCI 10-14
freeing, OCI 10-32, OCI 13-9
ignoring existing objects during import, SUT 2-24
import creation errors, SUT 2-24
in columns, ADG 17 - 4
introduction to, PC_ 17-2
lifetime, OCI 16-2
loading column objects, SUT 5-91
loading nested column objects, SUT 5-93
LOB attribute of, OCI 7-5
LOB attributes of transient objects, OCI 7-6
locking, OCI 13-12
manipulating with OCI, OCI 14-19, PC_ 19-19
marking, OCI 10-14, OCI 13-9
master groups
generating support for, REP 2-36
memory layout of instance, OCI 13-16
memory management, OCI 13-2
meta-attributes, OCI 10-17
navigation, OCI 13-17
simple, OCI 13-17
NULL values, SUT 5-93
nullness, OCI 10-29
object references, ADG 17 - 8
OCI object application structure, OCI 10-4
persistent, OCI 10-5, OCI 10-6, PC_ 17-4
persistent versus transient copies of, PC_ 17-4
pin count, OCI 10-28
pin duration, OCI 13-14
pinning, OCI 10-12, OCI 13-7
privileges, SUT 2-11
privileges on, SCN 30-11
references to, PC_ 17-2
referencing with synonyms, DDS 2-22
refreshing, OCI 13-11
removing from master groups, REP 2-30
replicated
re-creating, REP 7-32
restoring sets
Import, SUT 2-43
row objects and object identifiers, ADG 17 - 6
secondary memory, OCI 13-16
stream record format, SUT 5-91
support, PC_ 17-1
terminology, OCI 16-2
top-level memory, OCI 13-16
transient, OCI 10-5, OCI 10-7, PC_ 17-4
types, OCI 10-5, OCI 16-2, PC_ 17-2
unmarking, OCI 13-10
unpinning, OCI 10-28, OCI 13-8
use with OCI, OCI 10-3
using object types in Pro*C/C++, PC_ 17-3
variable record format, SUT 5-92
Objects for OLE, GTK 2-86
objects in a database schema, SCN 1-5
See also schema objects
objects owned by SYS
and TSPITR using RMAN, SBR A-6
Objects page
Create New Master Group property sheet, REP 2-19
OBJECTS precompiler option, PC_ 10-33, PC_ 17-20
objects. See object types or database objects.
objects, schema
cascading effects on revoking, SAD 24-15
default tablespace for, SAD 23-13
granting privileges, ADG 12 - 17, SAD 24-10
in a revoked tablespace, SAD 23-14
listing information, ADG 3 - 50
name resolution, ADG 3 - 46
owned by dropped users, SAD 23-16
privileges with, SAD 24-3
renaming, ADG 3 - 48
revoking privileges, ADG 12 - 19, SAD 24-13
when revoking object privileges, ADG 12 - 21
obsolete parameters, SPS A-20, SPS A-21
obsolete parameters in release 8.1, NET 4-20, NET 5-4
obsolete procedures, REP B-13
OCI, SCN 8-25
accessing and manipulating objects, OCI 14-19
advantages, ADG 1 - 8, OCI 1-3
anonymous blocks, SCN 16-17
bind variables, SCN 16-13
compatibility, MIG 8-17
client notification, MIG 8-9
link line, MIG 8-18
thread safety, MIG 8-18
declaring LDA, PCO 3-16
embedding calls, PCO 3-16
interoperability, MIG 8-17
Oracle7 clients, MIG 8-18
shared structures, MIG 8-17
LOB manipulation functions, DCI 6-6
new features, OCI 1-12
object cache, ADG 17 - 23, SCN 13-14
object support, OCI 1-6
OCIChangePassword call, MIG 8-37
OCIObjectFlush, SCN 15-4
OCIObjectPin, SCN 15-4
OCISessionBegin call, MIG 8-37
overview, ADG 1 - 7, OCI 1-2
parts of, ADG 1 - 8, OCI 1-5
stored procedures, SCN 16-18
upgrading applications to Oracle8i, MIG 9-2
using with Oracle Precompilers, PCO 3-16
OCI application
compiling, OCI 1-4
general structure, OCI 2-3
initialization example, OCI 2-24
linking, OCI 1-4
steps, OCI 2-17
structure, OCI 2-3
structure using objects, OCI 10-4
terminating, OCI 2-26
using the OTT with, OCI 14-18
with objects
initializing, OCI 10-10
OCI applications
using the OTT with, PC_ 19-18
OCI calls, PC_ 1-8
embedding, PC_ 5-50
in an X/A environment, PC_ 5-56
OCI enhancements, GTK 2-83
API to append data to LOB, GTK 2-34
AQ support, GTK 2-38
array DMLs, GTK 2-84
asynchronous event notification, GTK 2-84
collection locator, GTK 2-34
direct path load, GTK 2-24
DML returning, GTK 2-83
LOBs, GTK 2-34
NLS interface, GTK 2-43
non-blocking OCI, GTK 2-85
object cache, GTK 2-36
OCI callback registrations, GTK 2-84
OCIDescribeAny, GTK 2-84
Open/Close/IsOpen API for LOBS, GTK 2-34
UCS2 (fixed-width Unicode) support, GTK 2-43
OCI environment
initializing for objects, OCI 10-10
OCI functions
canceling calls, OCI 2-33
codes, OCI 15-230
data cartridges, OCI 2-3
new and updated calls, OCI 1-12
NLS, OCI 2-3
not supported, OCI 1-21
obsolescent, OCI 1-19
return codes, OCI 2-27, OCI 2-29
OCI navigational functions, OCI 13-19
flush functions, OCI 13-20
mark functions, OCI 13-20
meta-attribute accessor functions, OCI 13-20
miscellaneous functions, OCI 13-21
naming scheme, OCI 13-19
pin/unpin/free functions, OCI 13-19
OCI non-deferred linking, GTK 6-4
OCI onblon() call
not used to connect, PC_ 5-50
OCI orlon() call
not used to connect, PC_ 5-50
OCI process
initializing for objects, OCI 10-10
OCI program. See OCI application
OCI relational functions
advanced queuing and publish-subscribe, OCI 15-4
connect, authorize, and initialize, OCI 15-87
guide to reference entries, OCI 18-2
OCI Release 8, PC_ 5-45
accessing and manipulating objects, PC_ 19-19
embedding in Pro*C/C++, PC_ 5-48
interfacing to, PC_ 5-46
parameters in the environment handle, PC_ 5-46
SQLLIB extensions, PC_ 5-45
OCI single-task linking, GTK 6-5
OCI support for client notification, GTK 2-38
see also OCI enhancements, asynchronous event notification
OCI types
declaring, PC_ 17-34
manipulating, PC_ 17-35
OCIDate, PC_ 17-34
OCINumber, PC_ 17-34
OCIRaw, PC_ 17-34
OCIString, PC_ 17-34
using in embedded SQL, PC_ 17-34
OCI_ATTR_ALLOC_DURATION
environment handle attribute, OCI A-4
OCI_ATTR_AUTOCOMMIT_DDL
attribute, OCI 6-20
OCI_ATTR_BUF_ADDR, OCI A-43
OCI_ATTR_BUF_SIZE, OCI A-39, OCI A-43
OCI_ATTR_CACHE
attribute, OCI 6-15
OCI_ATTR_CACHE_ARRAYFLUSH
environment handle attribute, OCI A-3
OCI_ATTR_CACHE_MAX_SIZE
environment handle attribute, OCI A-3
OCI_ATTR_CACHE_OPT_SIZE
environment handle attribute, OCI A-3
OCI_ATTR_CATALOG_LOCATION
attribute, OCI 6-20
OCI_ATTR_CHAR_COUNT
bind handle attribute, OCI A-20
define handle attribute, OCI A-22
use of, OCI 5-28
OCI_ATTR_CHARSET_FORM
attribute, OCI 6-11, OCI 6-14, OCI 6-16
bind handle attribute, OCI A-20
define handle attribute, OCI A-23
OCI_ATTR_CHARSET_ID, OCI A-39, OCI A-46
attribute, OCI 6-11, OCI 6-14, OCI 6-16, OCI 6-18, OCI 6-19
bind handle attribute, OCI A-20
define handle attribute, OCI A-22
OCI_ATTR_CLUSTERED
attribute, OCI 6-7
OCI_ATTR_COL_COUNT, OCI A-42
OCI_ATTR_COLLECTION_ELEMENT
attribute, OCI 6-9
OCI_ATTR_COLLECTION_TYPECODE
attribute, OCI 6-9
OCI_ATTR_COMPLEXOBJECT_ COLL_OUTOFLINE
COR handle attribute, OCI A-25
OCI_ATTR_COMPLEXOBJECT_LEVEL
COR handle attribute, OCI A-25
OCI_ATTR_COMPLEXOBJECTCOMP _TYPE_LEVEL
COR descriptor attribute, OCI A-26
OCI_ATTR_COMPLEXOBJECTCOMP_TYPE
COR descriptor attribute, OCI A-26
OCI_ATTR_CURSOR_COMMIT_ BEHAVIOR
attribute, OCI 6-20
OCI_ATTR_DATA_SIZE, OCI A-47
attribute, OCI 6-10, OCI 6-13, OCI 6-15, OCI 6-16
OCI_ATTR_DATA_TYPE, OCI A-47
attribute, OCI 6-10, OCI 6-13, OCI 6-15, OCI 6-16
OCI_ATTR_DATE_FORMAT, OCI A-39
OCI_ATTR_DATEFORMAT, OCI A-47
OCI_ATTR_DBA
attribute, OCI 6-7
OCI_ATTR_DIRPATH_MODE, OCI A-40
OCI_ATTR_DIRPATH_NOLOG, OCI A-40
OCI_ATTR_DIRPATH_PARALLEL, OCI A-40
OCI_ATTR_DML_ROW_OFFSET, OCI A-6
OCI_ATTR_DURATION
attribute, OCI 6-7
OCI_ATTR_ENCAPSULATION
attribute, OCI 6-11
OCI_ATTR_ENV
server handle attribute, OCI A-9
service context handle attribute, OCI A-7
OCI_ATTR_EXTERNAL_NAME
server handle attribute, OCI A-9
OCI_ATTR_FOCBK
server handle attribute, OCI A-10
OCI_ATTR_HAS_DEFAULT
attribute, OCI 6-17
OCI_ATTR_HAS_FILE
attribute, OCI 6-9
OCI_ATTR_HAS_LOB
attribute, OCI 6-9
OCI_ATTR_HAS_NESTED_TABLE
attribute, OCI 6-9
OCI_ATTR_HW_MARK
attribute, OCI 6-15
OCI_ATTR_IN_V8_MODE
server handle attribute, OCI A-10
service context handle attribute, OCI A-8
OCI_ATTR_INCR
attribute, OCI 6-14
OCI_ATTR_INDEX_ONLY
attribute, OCI 6-7
OCI_ATTR_INTERNAL_NAME
server handle attribute, OCI A-10
OCI_ATTR_IOMODE
attribute, OCI 6-17
OCI_ATTR_IS_CONSTRUCTOR
attribute, OCI 6-11
OCI_ATTR_IS_DESTRUCTOR
attribute, OCI 6-11
OCI_ATTR_IS_INCOMPLETE_TYPE
attribute, OCI 6-9
OCI_ATTR_IS_INVOKER_RIGHTS
attribute, OCI 6-8, OCI 6-10
OCI_ATTR_IS_MAP
attribute, OCI 6-12
OCI_ATTR_IS_NULL
attribute, OCI 6-15, OCI 6-17
OCI_ATTR_IS_OPERATOR
attribute, OCI 6-11
OCI_ATTR_IS_ORDER
attribute, OCI 6-12
OCI_ATTR_IS_PREDEFINED_TYPE
attribute, OCI 6-9
OCI_ATTR_IS_RNDS
attribute, OCI 6-12
OCI_ATTR_IS_RNPS
attribute, OCI 6-12
OCI_ATTR_IS_SELFISH
attribute, OCI 6-12
OCI_ATTR_IS_SYSTEM_GENERATED_TYPE
attribute, OCI 6-9
OCI_ATTR_IS_SYSTEM_TYPE
attribute, OCI 6-9
OCI_ATTR_IS_TEMPORARY
attribute, OCI 6-7
OCI_ATTR_IS_TRANSIENT_TYPE
attribute, OCI 6-9
OCI_ATTR_IS_WNDS
attribute, OCI 6-12
OCI_ATTR_IS_WNPS
attribute, OCI 6-12
OCI_ATTR_LEVEL
attribute, OCI 6-17
OCI_ATTR_LINK
attribute, OCI 6-14, OCI 6-18
OCI_ATTR_LIST_ARGUMENTS
attribute, OCI 6-8, OCI 6-11
OCI_ATTR_LIST_COLUMNS, OCI A-40
attribute, OCI 6-7
OCI_ATTR_LIST_OBJECTS
attribute, OCI 6-19
OCI_ATTR_LIST_SCHEMAS
attribute, OCI 6-19
OCI_ATTR_LIST_SUBPROGRAMS
attribute, OCI 6-8
OCI_ATTR_LIST_TYPE
attribute, OCI 6-18
OCI_ATTR_LIST_TYPE_ATTRS
attribute, OCI 6-10
OCI_ATTR_LIST_TYPE_METHODS
attribute, OCI 6-10
OCI_ATTR_LOBEMPTY
LOB locator attribute, OCI A-25
OCI_ATTR_LOCKING_MODE
attribute, OCI 6-20
OCI_ATTR_MAP_METHOD
attribute, OCI 6-10
OCI_ATTR_MAX
attribute, OCI 6-14
OCI_ATTR_MAX_CATALOG_ NAMELEN
attribute, OCI 6-20
OCI_ATTR_MAX_COLUMN_ NAMELEN
attribute, OCI 6-19
OCI_ATTR_MAX_PROC_NAMELEN
attribute, OCI 6-19
OCI_ATTR_MAXDATA_SIZE
bind handle attribute, OCI A-21
use with binding, OCI 5-27
OCI_ATTR_MEMPOOL_APPNAME, OCI A-49
OCI_ATTR_MEMPOOL_HOMENAME, OCI A-49
OCI_ATTR_MEMPOOL_INSTNAME, OCI A-50
OCI_ATTR_MEMPOOL_SIZE, OCI A-50
OCI_ATTR_MIGSESSION
user session handle attribute, OCI A-12
OCI_ATTR_MIN
attribute, OCI 6-14
OCI_ATTR_NAME, OCI A-41, OCI A-47
attribute, OCI 6-8, OCI 6-10, OCI 6-11, OCI 6-13, OCI 6-14, OCI 6-15, OCI 6-16
OCI_ATTR_NCHARSET_ID
attribute, OCI 6-19
OCI_ATTR_NONBLOCKING_MODE
server handle attribute, OCI A-9
OCI_ATTR_NOWAIT_SUPORT
attribute, OCI 6-20
OCI_ATTR_NUM_ATTRS
attribute, OCI 6-5
OCI_ATTR_NUM_COLS, OCI A-41, OCI A-42
attribute, OCI 6-7
OCI_ATTR_NUM_DML_ERRORS, OCI A-14
OCI_ATTR_NUM_ELEMENTS
attribute, OCI 6-13
OCI_ATTR_NUM_HANDLES
attribute, OCI 6-19
OCI_ATTR_NUM_PARAMS
attribute, OCI 6-5
OCI_ATTR_NUM_ROWS, OCI A-42
OCI_ATTR_NUM_TYPE_ATTRS
attribute, OCI 6-9
OCI_ATTR_NUM_TYPE_METHODS
attribute, OCI 6-10
OCI_ATTR_OBJECT
environment handle attribute, OCI A-4
OCI_ATTR_OBJECT_DETECTCHANGE
environment handle attribute, OCI 13-13
OCI_ATTR_OBJID
attribute, OCI 6-7, OCI 6-14
OCI_ATTR_ORDER
attribute, OCI 6-15
OCI_ATTR_ORDER_METHOD
attribute, OCI 6-10
OCI_ATTR_OVERLOAD
attribute, OCI 6-8
OCI_ATTR_PARAM
describe handle attribute, OCI A-24
OCI_ATTR_PARAM_COUNT
describe handle attribute, OCI A-24
statement handle attribute, OCI A-17
OCI_ATTR_PARTITIONED
attribute, OCI 6-7
OCI_ATTR_PASSWORD
user session handle attribute, OCI A-12
OCI_ATTR_PDSCL
bind handle attribute, OCI A-21, OCI A-23
OCI_ATTR_PIN_DURATION
environment handle attribute, OCI A-4
OCI_ATTR_PINOPTION
environment handle attribute, OCI A-4
OCI_ATTR_POSITION
attribute, OCI 6-16
OCI_ATTR_PRECISION, OCI A-48
attribute, OCI 6-5, OCI 6-10, OCI 6-13, OCI 6-15, OCI 6-17
OCI_ATTR_PREFETCH_MEMORY
statement handle attribute, OCI A-18
OCI_ATTR_PREFETCH_ROWS
statement handle attribute, OCI A-18
OCI_ATTR_PROC_MODE, OCI A-50
OCI_ATTR_PTYPE
attribute, OCI 6-6
OCI_ATTR_RADIX
attribute, OCI 6-17
OCI_ATTR_REF_TDO
attribute, OCI 6-7, OCI 6-9, OCI 6-11, OCI 6-14, OCI 6-16, OCI 6-18
OCI_ATTR_ROW_COUNT, OCI A-43
OCI_ATTR_ROWID
statement handle attribute, OCI A-17
OCI_ATTR_ROWS_RETURNED
bind handle attribute, OCI A-22
use with callbacks, OCI 5-25
OCI_ATTR_SAVEPOINT_SUPPORT
attribute, OCI 6-20
OCI_ATTR_SCALE, OCI A-48
attribute, OCI 6-10, OCI 6-13, OCI 6-15, OCI 6-17
OCI_ATTR_SCHEMA_NAME, OCI A-41
attribute, OCI 6-11, OCI 6-13, OCI 6-14, OCI 6-16, OCI 6-17
OCI_ATTR_SEQ
attributes, OCI 6-14
OCI_ATTR_SERVER
service context handle attribute, OCI A-7
OCI_ATTR_SERVER_GROUP
server handle attribute, OCI A-11
OCI_ATTR_SESSION
service context handle attribute, OCI A-7
OCI_ATTR_SHARED_HEAP_ALLOC, OCI A-6
OCI_ATTR_STMT_TYPE
statement handle attribute, OCI A-17
OCI_ATTR_STREAM_OFFSET, OCI A-44
OCI_ATTR_SUB_NAME, OCI A-42
attribute, OCI 6-18
OCI_ATTR_SUBSCR_CALLBACK, OCI A-37
OCI_ATTR_SUBSCR_CTX, OCI A-37
OCI_ATTR_SUBSCR_NAME, OCI A-38
OCI_ATTR_SUBSCR_NAMESPACE, OCI A-37
OCI_ATTR_SUBSCR_PAYLOAD, OCI A-38
OCI_ATTR_TABLESPACE
attribute, OCI 6-7
OCI_ATTR_TIMESTAMP
attribute, OCI 6-6
OCI_ATTR_TRANS
service context handle attribute, OCI A-7
OCI_ATTR_TRANS_NAME
transaction handle attribute, OCI A-13
OCI_ATTR_TYPE_NAME
attribute, OCI 6-11, OCI 6-13, OCI 6-16, OCI 6-17
OCI_ATTR_TYPECODE
attribute, OCI 6-9, OCI 6-10, OCI 6-13, OCI 6-16
OCI_ATTR_USRNAME
user session handle attribute, OCI A-12
OCI_ATTR_VERSION
attribute, OCI 6-9, OCI 6-19
OCI_ATTR_XID
transaction handle attribute, OCI A-13
OCI_EVENTS
mode for receiving notifications, OCI 9-30
OCI_LOCK_X_NOWAIT
parameter usage, OCI 13-13
OCI_NUM_SHARED_PROCS, OCI 2-22
OCI_PTYPE_ARG
attributes, OCI 6-16
OCI_PTYPE_COL
attributes, OCI 6-15
OCI_PTYPE_COLL
attributes, OCI 6-13
OCI_PTYPE_DATABASE
attributes, OCI 6-19
OCI_PTYPE_FUNC
attributes, OCI 6-8
OCI_PTYPE_LIST
attributes, OCI 6-18
OCI_PTYPE_PKG
attributes, OCI 6-8
OCI_PTYPE_PROC
attributes, OCI 6-8
OCI_PTYPE_SCHEMA
attributes, OCI 6-19
OCI_PTYPE_SYN
attributes, OCI 6-14
OCI_PTYPE_TABLE
attributes, OCI 6-7
OCI_PTYPE_TYPE
attributes, OCI 6-9
OCI_PTYPE_TYPE_ATTR
attributes, OCI 6-10
OCI_PTYPE_TYPE_FUNC
attributes, OCI 6-11
OCI_PTYPE_TYPE_PROC
attributes, OCI 6-11
OCI_PTYPE_VIEW
attributes, OCI 6-7
OCI_SHARED_MODE, OCI 2-21
OCI_TYPECODE
values, OCI 3-23, OCI 3-24, OCI 3-25
OCIAQAgent
descriptor attributes, OCI A-35
OCIAQDeq(), OCI 15-5
OCIAQDeqOptions
descriptor attributes, OCI A-28
OCIAQEnq(), OCI 15-7
OCIAQEnqOptions
descriptor attributes, OCI A-26
OCIAQListen(), OCI 15-19
OCIAQMsgProperties
descriptor attributes, OCI A-31
OCIArray, OCI 11-17
binding and defining, OCI 11-17, OCI 12-6
OCIArray manipulation
code example, OCI 11-19
OCIAttrGet(), OCI 15-28
used for describing, OCI 4-11
OCIAttrSet(), OCI 15-29
OCIBindArrayOfStruct(), OCI 15-43
OCIBindByName(), OCI 15-44
OCIBindByPos(), OCI 15-48
OCIBindDynamic(), OCI 15-52
OCIBindObject(), OCI 15-56
OCIBreak(), OCI 15-216
use of, OCI 2-33, OCI 2-37
OCICacheFlush(), OCI 16-9
OCICacheFree(), OCI 16-48
OCICacheRefresh(), OCI 16-11
OCICacheUnmark(), OCI 16-17
OCICacheUnpin(), OCI 16-49
OCIColl, OCI 11-17
binding and defining, OCI 11-17
OCICollAppend(), OCI 17-6
OCICollAssign(), OCI 17-7
OCICollAssignElem(), OCI 17-8
OCICollGetElem(), OCI 17-10
OCICollIsLocator(), OCI 17-13
OCICollMax(), OCI 17-14
OCICollSetUpdateStatus(), OCI 17-15
OCICollSize(), OCI 17-16
OCICollTrim(), OCI 17-18
OCIComplexObject
use of, OCI 10-23
OCIComplexObjectComp
use of, OCI 10-23
OCIDate, OCI 11-7, PC_ 17-34
binding and defining, OCI 11-7, OCI 12-6
declaring, PC_ 17-34
OCIDate manipulation
code example, OCI 11-8
OCIDateAddDays(), OCI 17-28
OCIDateAddMonths(), OCI 17-29
OCIDateAssign(), OCI 17-30
OCIDateCheck(), OCI 17-31
OCIDateCompare(), OCI 17-33
OCIDateDaysBetween(), OCI 17-34
OCIDateFromText(), OCI 17-35
OCIDateGetDat(), OCI 17-37
OCIDateGetTime(), OCI 17-38
OCIDateLastDay(), OCI 17-39
OCIDateNextDay(), OCI 17-40
OCIDateSetDate(), OCI 17-41
OCIDateSetTime(), OCI 17-42
OCIDateSysDate(), OCI 17-43
OCIDateToText(), OCI 17-44
OCIDateZoneToZone(), OCI 17-46
OCIDefineArrayOfStruct(), OCI 15-58
OCIDefineByPos(), OCI 15-59
OCIDefineDynamic(), OCI 15-63
OCIDefineObject(), OCI 15-65
OCIDescAlloc(), OCI 15-31
OCIDescFree(), OCI 15-33
OCIDescribeAny(), OCI 15-67
usage examples, OCI 6-20
using, OCI 6-2
ocidfn.h, PC_ 5-50
OCIDirPathAbort(), OCI 15-73
OCIDirPathColArrayEntryGet(), OCI 15-74
OCIDirPathColArrayEntrySet(), OCI 15-76
OCIDirPathColArrayReset(), OCI 15-79
OCIDirPathColArrayRowGet(), OCI 15-78
OCIDirPathColArrayToStream(), OCI 15-80
OCIDirPathFinish(), OCI 15-82
OCIDirPathFlushRow(), OCI 15-83
OCIDirPathPrepare(), OCI 15-85
OCIDirPathStreamLoad(), OCI 15-83
OCIDirPathStreamReset(), OCI 15-86
OCIDuration
use of, OCI 13-7, OCI 13-14
OCIDurationBegin(), OCI 15-109
OCIDurationEnd(), OCI 15-110
OCIEnvCallback, OCI 9-15
OCIEnvCreate(), OCI 15-88
OCIEnvInit(), OCI 15-91
OCIErrorGet(), OCI 15-217
OCIExtProcAllocCallmemory(), DCI 13-2, DCI 13-3, DCI 13-4, OCI 18-5
OCIExtProcAllocMemory routine, DCI 4-12
OCIExtProcGetEnv(), OCI 18-8
OCIExtProcRaiseExcp routine, DCI 4-13
OCIExtProcRaiseExcp(), DCI 13-3, OCI 18-6
OCIExtProcRaiseExcpWithMsg routine, DCI 4-13
OCIExtProcRaiseExcpWithMsg(), DCI 13-4, OCI 18-7
OCIHandleAlloc(), OCI 15-34
OCIHandleFree(), OCI 15-37
OCIInd
use of, OCI 10-29
OCIInitialize(), OCI 15-93
shared mode, OCI 2-20
OCIIter, OCI 11-17
binding and defining, OCI 11-17
usage example, OCI 11-19
OCIIterCreate(), OCI 17-19
OCIIterDelete(), OCI 17-20
OCIIterGetCurrent(), OCI 17-21
OCIIterInit(), OCI 17-22
OCIIterNext(), OCI 17-23
OCIIterPrev(), OCI 17-25
OCILdaToSvcCtx(), OCI 15-219
OCILob...() functions, DCI 6-6
OCILobAppend(), OCI 15-111
OCILobAssign(), OCI 15-112
OCILobCharSet(), OCI 15-114, OCI 15-115
OCILobClose(), OCI 15-116
OCILobCopy(), OCI 15-117
OCILobCreateTemporary(), OCI 15-119
OCILobDisableBuffering(), OCI 15-121
OCILobEnableBuffering(), OCI 15-122
OCILobErase(), OCI 15-123
OCILobFileClose(), OCI 15-124
OCILobFileCloseAll(), OCI 15-125
OCILobFileExists(), OCI 15-126
OCILobFileIsOpen(), OCI 15-129
OCILobFileOpen(), OCI 15-130
OCILobFlushBuffer(), OCI 15-132
OCILobFreeTemporary(), OCI 15-134
OCILobGetChunkSize(), OCI 15-135
OCILobGetFileName(), OCI 15-127
OCILobGetLength(), OCI 15-137
OCILobIsEqual(), OCI 15-138
OCILobIsOpen(), OCI 15-139
OCILobIsTemporary(), OCI 15-141
OCILobLoadFromFile(), OCI 15-142
OCILobLocatorAssign(), OCI 15-144
OCILobLocatorIsInit(), OCI 15-146
OCILobOpen(), OCI 15-147
OCILobRead(), OCI 15-148
OCILobSetFileName(), OCI 15-131
OCILobTrim(), OCI 15-152
OCILobWrite(), OCI 15-153
OCILobWriteAppend(), OCI 15-157
OCILockOpt
possible values, OCI 16-28, OCI 16-54
OCILogoff(), OCI 15-96
OCILogon(), OCI 15-97
using, OCI 2-23
OCINumber, OCI 11-10, PC_ 17-34
bind example, OCI 12-8
binding and defining, OCI 11-10, OCI 12-6
declaring, PC_ 17-34
define example, OCI 12-8
OCINumber manipulation
code example, OCI 10-13, OCI 11-13
OCINumberAbs(), OCI 17-50
OCINumberAdd(), OCI 17-51
OCINumberArcCos(), OCI 17-52
OCINumberArcSin(), OCI 17-53
OCINumberArcTan(), OCI 17-54
OCINumberArcTan2(), OCI 17-55
OCINumberAssign(), OCI 17-56
OCINumberCeil(), OCI 17-57
OCINumberCompare(), OCI 17-58
OCINumberCos(), OCI 17-59
OCINumberDec(), OCI 17-60
OCINumberDiv(), OCI 17-61
OCINumberExp(), OCI 17-62
OCINumberFloor(), OCI 17-63
OCINumberFromInt(), OCI 17-64
OCINumberFromReal(), OCI 17-65
OCINumberFromText(), OCI 17-66
OCINumberHypCos(), OCI 17-68
OCINumberHypSin(), OCI 17-69
OCINumberHypTan(), OCI 17-70
OCINumberInc(), OCI 17-71
OCINumberIntPower(), OCI 17-72
OCINumberIsInt(), OCI 17-73
OCINumberIsZero(), OCI 17-74
OCINumberLn(), OCI 17-75
OCINumberLog(), OCI 17-76
OCINumberMod(), OCI 17-77
OCINumberMul(), OCI 17-78
OCINumberNeg(), OCI 17-79
OCINumberPower(), OCI 17-80
OCINumberPrec(), OCI 17-81
OCINumberRound(), OCI 17-82
OCINumberSetPi(), OCI 17-83
OCINumberSetZero(), OCI 17-84
OCINumberShift(), OCI 17-85
OCINumberSign(), OCI 17-86
OCINumberSin(), OCI 17-87
OCINumberSqrt(), OCI 17-88
OCINumberSub(), OCI 17-89
OCINumberTan(), OCI 17-90
OCINumberToInt(), OCI 17-91
OCINumberToReal(), OCI 17-92
OCINumberToText(), OCI 17-93
OCINumberTrunc(), OCI 17-95
OCIObjectArrayPin(), OCI 16-50
OCIObjectCopy(), OCI 16-33
OCIObjectExists(), OCI 16-25
OCIObjectFlush(), OCI 16-13
OCIObjectFree(), OCI 16-52
OCIObjectGetAttr(), OCI 16-35
OCIObjectGetInd(), OCI 16-37
OCIObjectGetObjectRef(), OCI 16-38
OCIObjectGetTypeRef(), OCI 16-39
OCIObjectIsDirty(), OCI 16-30
OCIObjectIsLocked(), OCI 16-31
OCIObjectLifetime
possible values, OCI 16-27
OCIObjectLock(), OCI 16-40
OCIObjectLockNoWait(), OCI 16-41
OCIObjectMarkDelete(), OCI 16-18
OCIObjectMarkDeleteByRef(), OCI 16-19
OCIObjectMarkStatus
possible values, OCI 16-28
OCIObjectMarkUpdate(), OCI 16-20
OCIObjectNew(), OCI 16-42
OCIObjectPin(), OCI 16-54
OCIObjectPinCountReset(), OCI 16-57
OCIObjectPinTable(), OCI 16-58
OCIObjectRefresh(), OCI 16-14
OCIObjectSetAttr(), OCI 16-45
OCIObjectUnmark(), OCI 16-22
OCIObjectUnmarkByRef(), OCI 16-23
OCIObjectUnpin(), OCI 16-60
OCIParamGet(), OCI 15-39
used for describing, OCI 4-11
OCIParamSet(), OCI 15-41
OCIPasswordChange(), OCI 15-220
OCIPinOpt
use of, OCI 13-7
OCIRaw, OCI 11-16, PC_ 17-34
binding and defining, OCI 11-16, OCI 12-6
declaring, PC_ 17-34
OCIRaw manipulation
code example, OCI 11-17
OCIRawAllocSize(), OCI 17-97
OCIRawAssignBytes(), OCI 17-98
OCIRawAssignRaw(), OCI 17-99
OCIRawPtr(), OCI 17-100
OCIRawResize(), OCI 17-101
OCIRawSize(), OCI 17-102
OCIRef, OCI 11-22
binding and defining, OCI 11-22
usage example, OCI 11-22
OCIRefAssign(), OCI 17-104
OCIRefClear(), OCI 17-105
OCIRefFromHex(), OCI 17-106
OCIRefHexSize(), OCI 17-107
OCIRefIsEqual(), OCI 17-108
OCIRefIsNull(), OCI 17-109
OCIRefToHex(), OCI 17-110
OCIReset(), OCI 15-222
use of, OCI 2-37
OCIRowid, OCI 2-16
OCIServerAttach(), OCI 15-99
shadow processes, OCI 15-100
OCIServerDetach(), OCI 15-101
OCIServerVersion(), OCI 15-223
OCISessionBegin(), OCI 15-102
OCISessionEnd(), OCI 15-105
OCIStmtExecute(), OCI 15-161
prefetch during, OCI 4-6
use of iters parameter, OCI 4-6
OCIStmtFetch, STU 25-24
OCIStmtFetch(), OCI 15-164
OCIStmtGetBind(), OCI 15-70
OCIStmtGetPieceInfo(), OCI 15-165
OCIStmtPrepare(), OCI 15-167
preparing SQL statements, OCI 4-4
shared mode, OCI 2-21
OCIStmtSetPieceInfo(), OCI 15-169
OCIString, OCI 11-15, PC_ 17-34
binding and defining, OCI 11-15, OCI 12-6
declaring, PC_ 17-34
OCIString manipulation
code example, OCI 11-15
OCIStringAllocSize(), OCI 17-112
OCIStringAssign(), OCI 17-113
OCIStringAssignText(), OCI 17-114
OCIStringPtr(), OCI 17-115
OCIStringResize(), OCI 17-116
OCIStringSize(), OCI 17-117
OCISubscriptionDisable(), OCI 15-20
OCISubscriptionEnable(), OCI 15-21
OCISubscriptionPost(), OCI 15-22
OCISubscriptionRegister(), OCI 15-24
OCISubscriptionUnRegister(), OCI 15-26
OCISvcCtxToLda(), OCI 15-224
OCITable, OCI 11-17
binding and defining, OCI 11-17, OCI 12-6
OCITableDelete(), OCI 17-119
OCITableExists(), OCI 17-120
OCITableFirst(), OCI 17-121
OCITableLast(), OCI 17-122
OCITableNext(), OCI 17-123
OCITablePrev(), OCI 17-124
OCITableSize(), OCI 17-125
OCITerminate(), OCI 15-106
OCIThreadClose(), OCI 15-173
OCIThreadCreate(), OCI 15-174
OCIThreadHandleGet(), OCI 15-176
OCIThreadHndDestroy(), OCI 15-177
OCIThreadHndInit(), OCI 15-178
OCIThreadIdDestroy(), OCI 15-179
OCIThreadIdGet(), OCI 15-180
OCIThreadIdInit(), OCI 15-181
OCIThreadIdNull(), OCI 15-182
OCIThreadIdSame(), OCI 15-183
OCIThreadIdSet(), OCI 15-184
OCIThreadIdSetNull(), OCI 15-185
OCIThreadInit(), OCI 15-186
OCIThreadIsMulti(), OCI 15-187
OCIThreadJoin(), OCI 15-188
OCIThreadKeyDestroy(), OCI 15-189
OCIThreadKeyGet(), OCI 15-190
OCIThreadKeyInit(), OCI 15-191
OCIThreadKeySet(), OCI 15-192
OCIThreadMutexAcquire(), OCI 15-193
OCIThreadMutexDestroy(), OCI 15-194
OCIThreadMutexInit(), OCI 15-195
OCIThreadMutexRelease(), OCI 15-196
OCIThreadProcessInit(), OCI 15-197
OCIThreadTerm(), OCI 15-198
OCITransCommit(), OCI 15-200
OCITransDetach(), OCI 15-203
OCITransForget(), OCI 15-204
OCITransPrepare(), OCI 15-205
OCITransRollback, STU 25-24
OCITransRollback(), OCI 15-206
OCITransStart(), OCI 15-207
OCIType
description, OCI 11-23
OCITypeArrayByName(), OCI 16-63
OCITypeArrayByRef(), OCI 16-66
OCITypeByName(), OCI 16-68
OCITypeByRef(), OCI 16-70
OCITypeElem
description, OCI 11-23
OCITypeMethod
description, OCI 11-23
OCIUserCallbackGet(), OCI 15-225
OCIUserCallbackRegister(), OCI 15-227
ODCIGetInterfaces method, DCI 11-25
ODCIIndex, SCN 10-43
ODCIIndexClose method, DCI 11-33
ODCIIndexCreate method, DCI 11-25
ODCIIndexDelete method, DCI 11-34
ODCIIndexDrop method, DCI 11-27
ODCIIndexFetch method, DCI 11-32
ODCIIndexGetMetadata method, DCI 11-37
ODCIIndexInsert method, DCI 11-33
ODCIIndexStart method, DCI 11-28, DCI 11-30
ODCIIndexUpdate method, DCI 11-35
ODESSP function
information about stored subprograms, PCO 6-31
OEM_REPOSITORY tablespace raw device, PSC 2-6
oemapp console command, PSC 5-15
oemctrl start oms command, PSC 5-14
OF clause
of CREATE VIEW, SQL 7-432
OF object_type clause
of CREATE TABLE, SQL 7-367
OFA, MIG 1-5
offline
backups, SBR 3-18
taking standby database datafiles, SBR 16-27
offline backup, SPS 4-6, SPS 21-1
parallel, SPS 21-12
redo log files, SPS 21-12
offline backups
whole database backup, SCN 32-23
Offline Bitmapped Tablespaces, SUT 1-55
OFFLINE clause
of ALTER ROLLBACK SEGMENT, SQL 7-74
of ALTER TABLESPACE, SQL 7-168
of CREATE TABLESPACE, SQL 7-396
offline datafile, SPS A-18
offline datafiles
migration, MIG 3-4
offline instantiation, RAR 7-17, REP 2-28
master site, RAR 7-17
master sites, REP 8-16 to REP 8-17
replicated object groups, SPR 21 - 2, SPR 21 - 3, SPR 21 - 4, SPR 21 - 5, SPR 21 - 6, RAR 8-44, RAR 8-46, RAR 8-48, RAR 8-50, RAR 8-52
snapshot site, RAR 7-22
snapshots, SPR 22 - 2, SPR 22 - 3, RAR 8-55, RAR 8-57
support for, REP A-4
offline redo log files, SCN 1-48, SCN 32-7
offline rollback segments
about, SAD 21-10
bringing online, SAD 21-11
when to use, SAD 21-10
offline tablespace
deferred rollback segments, SPS A-19
restrictions, SPS 6-8, SPS A-18
offline tablespaces
altering, SAD 9-10
priorities, SAD 9-10
rollback segments and, SAD 21-10
OGMS_HOME parameter, SPS A-5, SRF 1-83
obsolete for 8.1, SPS A-5
OID
with CREATE TYPE, DCI 3-3
OiD, GTK 6-8
OID. See object identifier
OiD. See Oracle Internet Directory.
OID, See object identifiers
OIDINDEX clause
of CREATE TABLE, SQL 7-377
OIDs, SCN 14-18, SCN 15-3, SCN 15-4, SUT 5-96
collections
key compression, SCN 10-30, SCN 10-38
WITH OBJECT OID clause, SCN 15-3, SCN 15-4
OIDs. See object identifiers.
OLD correlation name, ADG 13 - 16
OLON calls
obsolete, MIG 8-18
OLQP, MIG 2-17
OLTP, MIG 2-17, PSC 1-21
OLTP applications, SPS 1-3, SPS 1-5, SPS 1-8, SPS 1-12, SPS 1-13, SPS 2-7, SPS 2-8, SPS 3-2, SPS A-2
OLTP database, SCN 11-5
batch jobs, SCN 26-38
parallel DML, SCN 26-37
partitioning indexes, SCN 11-36
partitions, SCN 11-6
OMSCONFIG.PROPERTIES file, PSC 5-14
ON clause
of CREATE OUTLINE, SQL 7-322
ON COMMIT clause
of CREATE TABLE, SQL 7-377
ON DATABASE clause
of CREATE TRIGGER, SQL 7-406
ON DEFAULT clause
of AUDIT schema_objects, SQL 7-206
of NOAUDIT schema_objects, SQL 7-525
ON DELETE CASCADE clause
of constraint_clause, SQL 7-224
ON DELETE SET NULL clause
of constraint_clause, SQL 7-224
ON DIRECTORY clause
of AUDIT schema_objects, SQL 7-206
of GRANT object_privileges, SQL 7-506
of NOAUDIT schema_objects, SQL 7-525
of REVOKE schema_object_privileges, SQL 7-533
ON JAVA RESOURCE clause
of GRANT object_privileges, SQL 7-506
ON JAVA SOURCE clause
of GRANT object_privileges, SQL 7-506
ON NESTED TABLE clause
of CREATE TRIGGER, SQL 7-406
ON object clause
of GRANT object_privileges, SQL 7-506
of NOAUDIT schema_objects, SQL 7-525
of REVOKE schema_object_privileges, SQL 7-534
ON PREBUILT TABLE clause
of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-303
ON SCHEMA clause
of CREATE TRIGGER, SQL 7-406
ONAME precompiler option, PC_ 10-33
usage notes for, PC_ 10-34
ONAME precompiler option, PCO 14-33
ONAMES value, NET 7-19
one-to-many relationship
with foreign keys, ADG 5 - 9
one-to-one relationship
with foreign keys, ADG 5 - 9
on-going SCN fetch to complete wait event, SRF A-41
online
backups, SBR 3-18
online analytical processing (OLAP)
index-organized tables, SCN 10-42
online backup, SPS 4-6, SPS 21-1
archiving log files, SPS 21-16
parallel, SPS 21-12
procedure, SPS 21-16
redo log files, SPS 21-12
ONLINE clause
of ALTER ROLLBACK SEGMENT, SQL 7-73
of ALTER TABLESPACE, SQL 7-168
of CREATE INDEX, SQL 7-283
of CREATE TABLESPACE, SQL 7-396
online datafile
supported operations, SPS A-18
online help
Export, SUT 1-11
Field Help, LEG 1-14
How Do I Help, LEG 1-14
Import, SUT 2-9
UNIX, LEG 1-12
UNIX manual pages, LEG 1-12
What Is This Help, LEG 1-14
Windows Command Line Utilities, LSM, LEG 1-14
Windows NT, LEG 1-13
online index, SAD 16-7
online index (re)build
compatibility, MIG 8-10
online index builds, GTK 2-41
online indexes, SQL 7-283
rebuilding, SQL 7-134
online read-only tablespaces, GTK 2-42
compatibility, MIG 8-9
online recovery, SPS 6-2, SPS 22-2, SPS 22-4, SPS 22-7, SPS A-22
online redo log, SAD 6-2, SBR 1-8, SBR 15-7, SCN 1-47, SCN 32-7
active group, SBR 15-6, SBR 15-7
applying during media recovery, SBR 14-10
archived group, SBR 15-6, SBR 15-7
archiving, SCN 32-18, SCN 32-19, SRF 1-66
archiving mode, SRF 1-60
backing up, SBR 2-11, SBR 3-23
block, SRF 1-67
checkpoints, SCN 32-22
creating
groups and members, SAD 6-11
creating members, SAD 6-11
current group, SBR 15-6, SBR 15-7
do not back up, SAD 7-3
dropping groups, SAD 6-14
dropping members, SAD 6-14
file size, SRF 1-67
forcing a log switch, SAD 6-16
guidelines for configuring, SAD 6-5
inactive group, SBR 15-6, SBR 15-7
INVALID members, SAD 6-15
location of, SAD 6-9
loss of
active group, SBR 15-9, SBR 15-10
all members, SBR 15-6
group, SBR 15-6
mirrored members, SBR 15-5
recovery, SBR 15-5 to SBR 15-10
managing, SAD 6-1
media failure, SCN 32-5
moving files, SAD 6-13
multiple group loss, SBR 15-10
multiplexed, SBR 1-9, SCN 32-5
number of files, SRF 1-66
number of files in the, SAD 6-9
optimum configuration for the, SAD 6-9
overview, SBR 1-8
privileges
adding groups, SAD 6-11
dropping groups, SAD 6-14
dropping members, SAD 6-15
forcing a log switch, SAD 6-16
recorded in control file, SBR 2-3, SCN 32-21
renaming files, SAD 6-13
renaming members, SAD 6-12
setting checkpoint interval, SRF 1-67
STALE members, SAD 6-15
status of members, SBR 15-6, SBR 15-7
storing separately from datafiles, SAD 10-4
unavailable when database is opened, SAD 3-3
unintentional restore of, SBR 3-23
viewing information about, SAD 6-18
online redo log file
archive log mode, SPS 14-9
archiving, SPS 21-1, SPS 21-6
log switch, SPS 21-6, SPS 21-10
thread of redo, SPS 6-3, SPS 18-15
online redo logs
listing log files for backup, SBR 13-2
reinitializing, SQL 7-19
online rollback segments
about, SAD 21-10
bringing rollback segments online, SAD 21-11
taking offline, SAD 21-12
when new, SAD 21-8
online tablespaces
altering, SAD 9-10
online transaction processing, SPS 1-3
online transaction processing (OLTP), SCN 11-5, STU 1-2, STU 3-1
processes, STU 27-3
reverse key indexes, SCN 10-31
with decision support, STU 3-5
OO4O
features, ADG 1 - 12
Oracle Objects for OLE, ADG 1 - 11
OPEN CURSOR statement, PC_ 14-25
open database backup
fractured block detection during, SBR 4-55
open database recovery
using RMAN, SBR 9-22
OPEN DESCRIPTOR SQL statement, PC_ F-94
OPEN DESCRIPTOR statement, PCO F-71
OPEN NORESETLOGS clause
of ALTER DATABASE, SQL 7-12
OPEN option, SPS 18-13, SPS 18-14
OPEN READ ONLY clause
ALTER DATABASE command, SBR 16-19, SBR 16-20, SBR 16-21
of ALTER DATABASE, SQL 7-11
OPEN READ WRITE clause
of ALTER DATABASE, SQL 7-12
OPEN RESETLOGS clause
of ALTER DATABASE, SQL 7-12
OPEN RESETLOGS option
ALTER DATABASE command, SBR 6-7
OPEN SQL statement, PC_ F-92, PCO F-71
OPEN statement, PC_ 6-13, PCO F-69, PLS 5-8
dependence on precompiler options, PC_ 6-13
effect of, PC_ 6-13
example, PCO 5-14
example of, PC_ 6-13
examples, PC_ F-94, PCO F-70
in dynamic SQL Method 4, PCO 11-34
purpose of, PC_ 6-12, PC_ 6-13
syntax, PLS 11-113
use in dynamic SQL method 3, PC_ 13-20
use in dynamic SQL method 4, PC_ 15-30
using in dynamic SQL Method 3, PCO 9-20
Open System Interconnection (OSI) model
client application layer, described, NET 2-7
described, NET 2-6
link layer, NET 2-8
physical, NET 2-8
presentation layer, NET 2-7
session layer, NET 2-8
transport layer, NET 2-8
OPEN_CURSOR, DDS 7-3
OPEN_CURSORS parameter, ADG 8 - 9, PCO 6-20, SCN 16-7, SRF 1-84
allocating more private SQL areas, STU 19-9
increasing cursors per session, STU 19-15
managing private SQL areas, SCN 7-9
OPEN_LINKS initialization parameter, DDS 2-20
OPEN_LINKS initialization parameters
initialization parameters
OPEN_LINK, REP 2-21
OPEN_LINKS parameter, SCN 7-15, SRF 1-84
OPEN_LINKS_PER_INSTANCE parameter, SRF 1-85
opened cursors current statistic, SRF C-12
OPEN-FOR statement, PLS 5-19
syntax, PLS 11-115
OPEN-FOR-USING statement, PLS 10-5
syntax, PLS 11-119
opening
a cursor variable, PC_ 4-27
cursors, PC_ F-92, PC_ F-94, PCO F-69, PCO F-71
opening a cursor variable, PCO 6-34
opening a database
after creation, SAD 1-19
mounted database, SAD 3-7
opens of replaced files statistic, SRF C-12
opens requiring cache replacement statistic, SRF C-12
operands, SQL 3-1
operating system
accounts, SAD 24-17
auditing with, SAD 25-2
authenticating remote clients, SRF 1-107
authenticating users and passwords, SRF 1-92
authentication, SAD 24-16
data cache, STU 24-2
database administrators requirements for, SAD 1-4
deleting datafiles, SAD 9-15
enabling and disabling roles, SAD 24-19
exported files, SPS B-1
Integrated Distributed Lock Manager, SPS 9-8
limit of number of open files, SAD 10-2
migrating to a different, MIG 3-7, MIG 4-5
monitoring disk I/O, STU 20-17
monitoring tools, STU 12-3
operating system dependent parameters, SRF 1-10
Oracle8i process names, SAD 4-9
privileges, SPS 18-19
redo log blocks, SRF 1-67
renaming and relocating files, SAD 10-9
role identification, SAD 24-17
roles and, ADG 12 - 15, SAD 24-16
roles for remote clients, SRF 1-108
scalability, SPS 2-5
security in, SAD 22-3
striping, STU 26-38
tuning, STU 2-12, STU 17-6, STU 19-4
operating system dependencies, DDS C-1
Operating System Dependent layer
Cluster Manager (CM), PSC 1-6
components, PSC 1-4
defined, PSC 1-3
described, PSC 1-4
Input/Output (IO), PSC 1-7
installing, PSC 2-13, PSC 8-3
Inter-Process Communication (IP
C), PSC 1-7
START, PSC 1-8
Startup (START), PSC 1-8
operating systems
authentication by, SCN 29-4
block size, SCN 4-3
communications software, SCN 8-26
moving data to different systems using SQL*Loader, SUT 5-74
privileges for administrator, SCN 5-3
roles and, SCN 30-22
OPERATION column
PLAN_TABLE, STU 13-4, STU 13-9
operations
connect, NET 2-2
data, NET 2-4
exception, NET 2-4
Net8, NET 2-4
operations in a relational database, SCN 1-22
operations, volume, LEG 3-21
operator
comparison, PLS 2-44
concatenation, PLS 2-46
DEREF, PLS 9-33
precedence, PLS 2-42
REF, PLS 9-32
relational, PLS 2-45
TABLE, PLS 4-18
VALUE, PLS 9-31
operator precedence, SQL 3-2
operators, SQL 3-1
arithmetic, SQL 3-3
binary, SQL 3-1
C versus SQL, PC_ 2-15
comparison, SQL 3-5
concatenation, SQL 3-3
dropping, MIG 12-14
granting
system privileges on, SQL 7-497
logical, SQL 3-10
relational, PCO 2-19
restrictions on, PC_ 2-15
set, SQL 3-12, SQL 7-550
unary, SQL 3-1
user-defined, SQL 3-16
binding to a function, SQL 7-320
creating, SQL 7-320
dropping, SQL 7-463
function providing implementation, SQL 7-321
how bindings are implemented, SQL 7-320
implementation type, SQL 7-321
return type of binding, SQL 7-320
OPI
see Oracle Program Interface
ops, PSC C-9
OPS Assistant, GTK 2-62
OPS Communication Daemon (OPSD), defined, PSC 5-4
/ops directory, PSC A-2, PSC C-4
OPS Overview chart, PSC 7-19
OPS_ADMIN_GROUP parameter, SPS A-6, SRF 1-85, SRF 3-3
obsolete for 8.1, SPS A-5
OPS_DATABASE entry, PSC C-9
OPS_DATABASE entry in SERVICES.ORA file, PSC C-9
OPS_FAILOVER clause, SPS A-11
OPS_INSTANCE entry, PSC C-9
OPS_INSTANCE entry in SERVICES.ORA file, PSC C-9
OPSCTL utility, PSC 5-4
architecture on UNIX, PSC 5-4
architecture on Windows NT, PSC 5-6
configuring for UNIX, PSC 5-12
configuring on UNIX, PSC B-1 to PSC B-12
DB_NAME.CONF file, PSC B-2
OPSD, defined, PSC 5-4
/opsm directory, PSC A-2
OP.TBL, PSC 4-3
Optimal Flexible Architecture (OFA), PSC 1-2
Optimal Flexible Architecture. See OFA
OPTIMAL parameter
of STORAGE clause, SQL 7-346, SQL 7-578
OPTIMAL setting for SYSTEM rollback segment
migration, MIG A-4
OPTIMAL storage parameter, SAD 21-5, SCN 4-25, STU 20-30, SUT 2-53
optimistic locking
implementing, OCI 13-13
optimization, SCN 22-2
choosing an approach and goal for, STU 7-3
choosing the approach, SCN 23-31
compatibility, MIG 8-34
extensible optimizer, MIG 8-14
optimizer plan stability, MIG 8-14
conversion of expressions and predicates, SCN 23-4
cost-based, SCN 22-7, SCN 24-8, STU 7-3
choosing an access path, SCN 23-50
examples of, SCN 23-51
histograms, SCN 22-8
remote databases and, SCN 23-30
star queries, SCN 24-14
user-defined costs, SCN 22-17
described, SCN 22-2
DISTINCT, SCN 23-17
distributed SQL statements, SCN 23-30
execution plan for partitions, SCN 11-11, SCN 11-14
extensible optimizer, SCN 22-16
function-based indexes, SCN 10-25
GROUP BY views, SCN 23-17
hints, SCN 23-33, SCN 23-36
index build, SCN 10-22
manual, SCN 23-33
merging complex views, SCN 23-17
merging views into statements, SCN 23-15
non-null values for nulls, SCN 24-11
operations performed, SCN 23-2
parallel aware, STU 11-6
parallel SQL, SCN 26-10
partition pruning, SCN 11-4
indexes, SCN 11-36
partition pruning (elimination), SCN 11-4
partitioned indexes, SCN 11-35
partition-wise joins, SCN 11-5
plan stability, SCN 22-6
PL/SQL, SCN 23-33
query rewrite, SCN 10-17
enabling, STU 31-4
hints, STU 31-4, STU 31-21
in security policies, SCN 30-23
matching join graphs, STU 29-6
query rewrites
privileges, STU 31-4
rule-based, SCN 22-18, SCN 24-9, STU 7-24
choosing an access path, SCN 23-54
examples of, SCN 23-54
selectivity of predicates, SCN 22-8
histograms, SCN 22-8, SCN 22-10
user-defined, SCN 22-17
selectivity of queries and, SCN 23-51
select-project-join views, SCN 23-15
semi-joins, SCN 24-13
statistics, SCN 22-8, SCN 23-32
user-defined, SCN 22-17
trading cursor space for time, SRF 1-24
transitivity and, SCN 23-8
types of SQL statements, SCN 23-3
without merging, SCN 23-25
optimization approach, PC_ C-5
optimizer, STU 31-2
and remote join enhancement, GTK 2-68
and ROLAP enhancement, GTK 2-24
downgrading, MIG 12-35
extensible, GTK 2-32
Plan Stability, STU 7-25
plan stability, GTK 2-37
compatibility, MIG 8-14
setting session parameters, SQL 7-86
OPTIMIZER column
PLAN_TABLE, STU 13-4
optimizer hint, PCO D-5
optimizer hints, PC_ C-5
in C, PC_ 6-16
in C++, PC_ 6-16, PC_ 12-4
optimizer mode
FIRST_ROWS, SRF 1-89
RULE, SRF 1-89
optimizer statistics, SUT 2-63
OPTIMIZER_FEATURES_ENABLE parameter, SCN 23-17, SCN 23-36, SCN 24-12
OPTIMIZER_FEATURES_ENABLED parameter, SRF 1-86, STU 7-21
OPTIMIZER_GOAL option, SCN 23-32
OPTIMIZER_INDEX_CACHING
for index optimization, STU 7-22
OPTIMIZER_INDEX_CACHING parameter, SRF 1-86
of ALTER SESSION, SQL 7-86
OPTIMIZER_INDEX_COST_ADJ
for index optimization, STU 7-22
OPTIMIZER_INDEX_COST_ADJ parameter, SRF 1-87
of ALTER SESSION, SQL 7-86
OPTIMIZER_MAX_PERMUTATIONS parameter, SRF 1-87
of ALTER SESSION, SQL 7-86
OPTIMIZER_MODE, SCN 23-31, STU 7-3, STU 7-4, STU 7-21, STU 7-24, STU 7-38, STU 11-8, STU 27-27
hints affecting, SCN 23-33
OPTIMIZER_MODE parameter, SRF 1-88
of ALTER SESSION, SQL 7-86
OPTIMIZER_PERCENT_PARALLEL parameter, SCN 22-8, SRF 1-88, STU 7-21, STU 11-7, STU 26-23, STU 27-30
of ALTER SESSION, SQL 7-86
OPTIMIZER_SEARCH_LIMIT parameter, SRF 1-89, STU 7-22
of ALTER SESSION, SQL 7-86
optimizing
direct path loads, SUT 8-16
SQL*Loader input file processing, SUT 5-24
option factoring matrix, GTK 4-2
optional division headers, PCO 2-15
OPTIONALLY ENCLOSED BY, SUT 5-16
SQL*Loader, SUT 5-84
options
deinstalling, MIG 1-6
for Migration utility, MIG 3-14
precompiler concepts, PCO 14-3
OPTIONS column
PLAN_TABLE table, STU 13-4
OPTIONS keyword, SUT 5-18
for parallel loads, SUT 5-40
Options page, REP 7-23
OR keyword, PLS 6-16
OR operator, SQL 3-11, SQL 3-12
OR REPLACE clause
for creating packages, ADG 10 - 14, SPR 1 - 3
of CREATE CONTEXT, SQL 7-243
of CREATE DIRECTORY, SQL 7-265
of CREATE FUNCTION, SQL 7-268, SQL 7-293
of CREATE LIBRARY, SQL 7-297
of CREATE OUTLINE, SQL 7-322
of CREATE PACKAGE, SQL 7-325
of CREATE PACKAGE BODY, SQL 7-328
of CREATE PROCEDURE, SQL 7-334
of CREATE TRIGGER, SQL 7-403
of CREATE TYPE, SQL 7-414
of CREATE TYPE BODY, SQL 7-422
of CREATE VIEW, SQL 7-432
ORA, NET 8-13
ORA_NLS32 environment variable
compatibility, MIG 8-28
ORA_NLS33 environment variable, MIG 3-16
compatibility, MIG 8-28
ORA-00000 to ORA-00816, SMS 2-1
ORA-00508 error message, NET 11-9
ORA-00900
SQL error, DDS 4-11
ORA-00900 to ORA-01499, SMS 3-1
ORA-01500 to ORA-02198, SMS 4-1
ORA-01578 error message, SBR 14-5
ORA-02015
SQL error, DDS 4-11
ORA-02055
integrity constraint violation, DDS 4-3
ORA-02067
rollback required, DDS 4-3
ORA-02100 to ORA-04099, SMS 5-1
ORA-06000 to ORA-07499, SMS 6-1
ORA-06510
PL/SQL error, DDS 4-12
ORA-07500 to ORA-09857, SMS 7-1
ORA-09870 to ORA-12071, SMS 8-1
ORA-1017 error messages, NET 11-3
ORA-1034 error message, NET 8-13
ORA-1034 error messages, NET 11-3
ORA-12154 error message, NET 8-13, NET 11-8
ORA-12198 error message, NET 11-8
ORA-12203 error message, NET 8-12, NET 11-8, NET 11-9, NET 11-13
sample error stack, NET 11-17
troubleshooting, NET 8-12
ORA-12224 error message, NET 11-11
ORA-12316 to ORA-12354, SMS 9-1
ORA-12400 to ORA-12495, SMS 10-1
ORA-12500 error message, NET 11-11
ORA-12533 error message, NET 11-11
ORA-12535 error message, NET 11-13
ORA-12538 error message, NET 11-9
ORA-12541 error message, NET 8-13
ORA-12545 error message, NET 11-12
ORA-12545 error messages
error messages
ORA-12545, NET 11-12
ORA-12547 error message, NET 11-13
ORA-12560 error message, NET 11-12
ORA-12701 to ORA-18010, SMS 11-1
ORA-19500 to ORA-24279, SMS 12-1
ORA-24280 to ORA-28657, SMS 13-1
ORA-29250 to ORA-30728, SMS 14-1
ORA-3113 error message, NET 11-12
ORA-3121 error message, NET 11-12
ORA-600, PSC C-14
OraAQ object, ADG 1 - 16
OraAQAgent object, ADG 1 - 17
OraAQMsg object, ADG 1 - 17
OraBFILE object, ADG 1 - 18
OraBLOB object, ADG 1 - 18
ORACA, PC_ 9-3, PCO 8-4
declaring, PCO 8-37
enabling, PCO 8-37
example, PCO 8-41
example of using, PC_ 9-41
fields, PCO 8-38
gathering cursor cache statistics, PCO 8-40
ORACABC field, PCO 8-38
ORACAID field, PCO 8-38
ORACCHF flag, PCO 8-38
ORACOC field, PCO 8-41
ORADBGF flag, PCO 8-39
ORAHCHF flag, PCO 8-39
ORAHOC field, PCO 8-41
ORAMOC field, PCO 8-41
ORANEX field, PCO 8-41
ORANOR field, PCO 8-41
ORANPR field, PCO 8-41
ORASFNMC field, PCO 8-40
ORASFNML field, PCO 8-40
ORASLNR field, PCO 8-40
ORASTXTC field, PCO 8-40
ORASTXTF flag, PCO 8-39
ORASTXTL field, PCO 8-40
precompiler option, PCO 8-38
purpose, PCO 8-4, PCO 8-36
structure of, PCO 8-38
using to gather cursor cache statistics, PC_ 9-40
ORACA precompiler option, PC_ 10-34, PCO 14-34
ORACABC field, PCO 8-38
ORACAID component, PC_ 9-38
ORACAID field, PCO 8-38
ORACCHF flag, PCO 8-38
Oracle, NET 1-5, NET 2-13, NET 2-29, NET 4-13, NET 6-44, NET 7-29, PSC 2-4
adherence to standards, SCN 1-3
integrity constraints, SCN 28-5
architecture, SCN 1-8, SCN 1-14
background processes, SPS 5-5
backing up, SPS 4-6, SPS 21-1
client/server architecture of, SCN 6-2
compatibility, SCN 1-3, SPS 17-11, SPS B-2
compatibility levels, SCN 3-14
configurations, SPS 1-14
configurations of, SCN 8-2
multiple-process Oracle, SCN 8-2
connectibility, SCN 1-2
different Oracle versions, SCN 33-7
data access, SCN 1-51
data dictionary, SPS 6-6
datafile compatibility, SPS 6-2
datatypes, PC_ 2-7
examples of operations, SCN 1-21
dedicated server, SCN 8-24
multi-threaded server, SCN 8-20
exclusive mode, SPS 4-1, SPS 18-13
executables, SPS 23-8
features, SCN 1-2
Forms Version 4, PC_ 20-14
free space unavailable, SPS 17-11
instance recovery, SPS 22-3
instances, SCN 1-6, SCN 1-16, SCN 5-2
instances on MPP nodes, SPS 3-8
licensing of, SCN 29-19
migration, SPS A-17
multi-instance, SPS 7-3
obsolete parameters, SPS A-21
Open Gateway
using the ROWID datatype with, PC_ 4-8
Oracle server, SCN 1-4
Parallel Server option, SCN 1-8
See also Parallel Server
performance features, SPS 4-5
portability, SCN 1-3
processes of, SCN 1-17, SCN 8-5
restrictions, SPS 6-7, SPS A-17, SPS A-19
scalability of, SCN 6-4
shared mode, SPS 4-2
single-instance, SPS 7-3
SQL processing, SCN 16-8
Toolset, PC_ 20-14
using on networks, SCN 1-2, SCN 1-37
version on all nodes, SPS 5-9
Oracle Advanced Queuing (Oracle AQ)
DBMS_AQADM package, ADQ 3-9, SPR 5 - 1
Oracle Advanced Security, GTK 2-70
authentication, NET 7-28
biometrics authentication method, NET 7-28
configuring, NET 7-28, NET 7-29
CyberSAFE authentication method, NET 4-32
DCE Integration, NET 4-32, NET 7-29
DES_40, NET 4-31
DES_56, NET 4-31
described, NET 4-31
encryption, NET 7-28
features of, NET 4-31
Identifix authentication method
Identix authentication method, NET 4-32
integrated security and directory services, GTK 2-72
Kerberos authentication method, NET 4-32, NET 7-28
MD5, NET 4-31
Network Security, NET 4-31
RADIUS, GTK 2-72
RADIUS authentication method, NET 4-32, NET 7-28
RC4_128, NET 4-31
RC4_40, NET 4-31
RC4_56, NET 4-31
Secure Sockets Layer (SSL) authentication method, NET 7-28
SecurID authentication method, NET 4-32
security features, NET 7-28
Single Sign-On, NET 4-32
SSL, GTK 2-70
SSL authentication method, NET 4-32
using Oracle Advanced Security, NET 7-28
using with Oracle Connection Manager, NET 7-28
with Data Encryption Standard, NET 7-28
with RSA Data Security RC4, NET 7-28
Oracle Advanced Security option, GTK 6-8
Oracle AQ, SCN 19-1
exporting queue tables, SCN 19-12
message queuing, SCN 19-2
publish/subscribe support, SCN 19-10
event publication, SCN 20-18
queue monitor process, SCN 1-20, SCN 8-13, SCN 19-6
interval statistics, SCN 19-11
window of execution, SCN 19-7
queue tables, SCN 19-4
recipients, SCN 19-5
rule-based subscriptions, SCN 19-5, SCN 19-6
subscription lists, SCN 19-5
remote databases, SCN 19-9
Oracle backup volumes
viewing, LEG 3-20
Oracle backups and restores
backup/restore utility, LEG 4-2
monitoring, LEG 4-10
prerequisites to running, LEG 4-2
Oracle blocks, SAD 2-11, SCN 1-10, SCN 4-2
See also data blocks
Oracle Call Interface, ADG 10 - 2
applications, ADG 10 - 4
associative access, ADG 19 - 2
cancelling cursors, ADG 8 - 10
closing cursors, ADG 8 - 10
complex object retrieval (COR), ADG 19 - 8
controlling object cache size, ADG 19 - 5
creating a new object, ADG 19 - 10
deleting an object, ADG 19 - 12
for Oracle objects
building a program, ADG 19 - 4
initializing object manipulation, ADG 19 - 5
lock options, ADG 19 - 7
locking an object, ADG 19 - 12
navigational access, ADG 19 - 3
object cache, ADG 19 - 3
flushing an object, ADG 19 - 13
pin options, ADG 19 - 6
pinning and unpinning objects, ADG 19 - 5
See OCI
updating an object, ADG 19 - 12
with Oracle objects, ADG 19 - 2
Oracle Call Interface (OCI), SCN 8-25
anonymous blocks, SCN 16-17
bind variables, SCN 16-13
object cache, SCN 13-14
OCIObjectFlush, SCN 15-4
OCIObjectPin, SCN 15-4
stored procedures, SCN 16-18
Oracle Call Interface (OCI) layer, described, NET 2-11
Oracle Call Interface Rel 7, PC_ 5-50
Oracle Call Interface. See OCI
Oracle Call Interface (OCI), PCO 3-16
Oracle Certificate Authority, SCN 29-5
Oracle code, SCN 8-2, SCN 8-25
Oracle Communications Area, PC_ 9-34
ORACA, PCO 8-36
Oracle Connection Manager, OAS 1-11, GTK 3-6
CMADMIN process, NET 2-47
CMCTL process, NET 2-47
CMGW process, NET 2-46
configuration file
new parameters in release 8.1, NET 4-19
configuration file changes in release 8.1, NET 4-14
configuration file sample, NET B-9
configuration parameter reference, NET C-76 to NET C-80
configuring address, NET 6-76
configuring address for listener, NET 7-46
configuring address for Oracle Connection Manager, NET 7-43
configuring CMAN.ORA for connection concentration, NET 7-31
configuring CMAN.ORA for multi-protocol support, NET 7-35
configuring CMAN.ORA for Net8 access control, NET 7-38
configuring connection concentration, NET 7-31
configuring multi-protocol support, NET 7-35
configuring Net8 access control, NET 7-38
connection concentration, NET 2-48, NET 3-11, NET 4-30
described, NET 4-30
log files, NET 11-22
log files, understanding, NET 11-27
migrating, NET 5-21
migration issues, NET 5-21
multiple protocol support, NET 2-49
multi-protocol support, NET 4-30, NET 5-22
Ne8 access control, NET 4-30
Net8 access control, NET 2-49
Net8 Firewall Proxy, NET 2-49
processes, NET 2-46
role in multiple protocol environments, diagram, NET 2-50
routing connections, NET 1-6, NET 7-26
SOURCE_ROUTE parameter, NET C-41
starting, NET 8-7
testing, NET 8-18
TNSNAMES.ORA file, NET 7-34
trace files, NET 11-37
upgrading, NET 5-21
using instead of Oracle Multi-Protocol Interchange, NET 5-22
using with multi-threaded servers, NET 2-48, NET 7-31
Oracle Connection Manager Control Utility (CMCTL)
command reference, NET A-90 to NET A-93
function and syntax format, NET A-89
starting, NET 8-7
testing the network
using, NET 8-16
Oracle Customer Support, contacting, NET 11-58
Oracle Data Cartridge Interface, SCN 10-43
Oracle Data Control (ODC), ADG 1 - 19
Oracle Data Gatherer
defined, PSC 5-3
starting, PSC 5-30
Oracle Data Migration Assistant
advantages and disadvantages, MIG 2-8
character set used, MIG 4-6
differences from the Migration utility, MIG 2-9
documentation roadmap, MIG 4-2
migrating to a different operating system, MIG 4-5
Oracle Parallel Server
does not support migration, MIG 2-9, MIG 4-3
does not support upgrading, MIG 7-6
overview, MIG 4-3
running, MIG 4-16, MIG 7-7, MIG 7-12
space required for SYSTEM tablespace, MIG 4-4
Oracle Database Configuration Assistant, GTK 2-59, GTK 2-63
automatically running as a part of installation, PSC 3-5, PSC 3-6
configuring listener for Oracle Enterprise Manager, NET 4-23
creating a database, PSC 4-4
creating a database with, PSC 4-4
error message, PSC 4-6
failing on Windows NT, PSC C-2
initialization files, PSC 1-11
minimum size, PSC 2-6
running after installation, PSC 3-7
troubleshooting, PSC 4-4, PSC 4-6
Oracle Database Configuration Assistant, configuring the listener, NET 4-23
Oracle datatypes, OCI 3-2, PCO 2-8
mapping to C, OCI 11-2
Oracle DCE Integration
compatibility with Net8, NET 7-29
described, NET 7-29
Oracle Designer, STU 28-9
Oracle Diagnostics Pack
described, PSC 2-4
Oracle Performance Manager, PSC 2-4
Oracle Diagnostics Pack, installing, PSC 5-28
Oracle dynamic SQL
when to use, PCO 10-1
Oracle Enterprise Manager, OAS 7-5, LEG 4-3, SBR 3-10
architecture, PSC 5-8
auto-discovery, PSC 5-18, PSC C-3
components, PSC 2-3
Configuration Assistant, PSC 5-13
configuring, PSC 5-11 to PSC 5-28
configuring Net8 on Console, PSC 5-11
configuring Net8 on Oracle Performance Manager machine, PSC 5-29
configuring OPSCTL, PSC 5-12
configuring repository, PSC 5-13
configuring static information in the listener, NET 4-23
connect-time failover, NET 2-29, NET 6-71, NET 7-12
Console, PSC 2-3, PSC 5-2, PSC 5-15
discovering nodes, PSC 5-18
hardware requirements, PSC 2-3
installation, PSC 5-10
installation requirements, PSC 2-3
installing repository database, PSC 5-10
managed targets, PSC 2-4
Management Server, PSC 2-3, PSC 5-2, PSC 5-14
NMICONF.LOG file, PSC C-9
NMICONF.LST file, PSC C-10
OPS Communication Daemon (OPSD), PSC 5-4
OPSCTL utility, PSC 5-4
Oracle Data Gatherer, PSC 5-3
Oracle Diagnostics Pack, PSC 2-4
Oracle Intelligent Agents, PSC 5-3
Oracle Parallel Server Management, PSC 1-3
Oracle Performance Manager, PSC 5-3
Oracle8, LEG 1-10
repository database, PSC 2-4, PSC 5-3
scheduling jobs, PSC 6-31
SERVICES.ORA file, PSC C-9
setting up preferred credentials, PSC 5-21
setup scenarios, PSC 5-8
SID_LIST parameter in LISTENER.ORA, NET 2-29, NET 4-13, NET 5-20, NET 6-71, NET 7-12, NET C-40
SID_LIST_listener_name parameter, PSC 4-12, PSC 4-37, PSC C-6
software requirements, PSC 2-3
solving auto-discovery failures, PSC C-3
specifying preferred credentials, PSC 5-21
starting, PSC 5-13
starting Oracle Data Gatherer, PSC 5-30
starting Oracle Intelligent Agents, PSC 5-13, PSC 6-14
starting Oracle Intelligent Agents, PSC B-12
starting Oracle Parallel Server database, PSC 6-18
starting Oracle Performance Manager, PSC 7-4
starting the Console, PSC 5-15, PSC 6-14
starting the Management Server, PSC 5-14, PSC 6-14
static service information in LISTENER.ORA, NET 2-29, NET 5-20, NET 6-71, NET 7-12, NET C-40
stopping Oracle Parallel Server database, PSC 6-21
super administrator account, PSC 5-15
SYSDBA privilege, PSC 5-28
SYSOPER privilege, PSC 5-28
understanding auto-discovery failures, PSC C-3
User Manager, PSC 5-22
version 2 changes, PSC 5-11
viewing Oracle Parallel Server status, PSC 6-27
viewing shutdown results, PSC 6-24
viewing startup results, PSC 6-24
See Enterprise Manager
Oracle errors, ADG 10 - 3
Oracle Expert, STU 2-1, STU 12-11
Oracle Express Objects, STU 28-9
Oracle Forms, STU 14-5
control of parsing and private SQL areas, STU 19-10
object dependencies and, SCN 21-13
PL/SQL, SCN 16-16
using EXEC TOOLS statements, PCO 12-14
Oracle home
non-shared on UNIX, PSC B-12
shared on UNIX, PSC B-12
Oracle Home Directory
configuring on the listener, NET 6-72
described, NET 6-72
Oracle Home Directory option
Net8 Assistant
Oracle Home Directory, NET 6-72
Oracle Home option, NET 7-69
ORACLE identifiers
how to form, PC_ F-11, PCO F-10
Oracle Intelligent Agents
defined, PSC 5-3
setup and location on UNIX, PSC B-11 to PSC B-12
starting, PSC 5-13, PSC 6-14, PSC B-12
Oracle Internet Directory, GTK 2-70, GTK 2-74, SCN 29-5
Oracle Internet File System, GTK 2-2
Oracle JDBC
accessing Oracle object data, ADG 19 - 19
definition, ADG 1 - 26
example, ADG 1 - 27
OCI driver, ADG 1 - 26
Oracle extensions, ADG 1 - 27
server driver, ADG 1 - 27
stored procedures, ADG 1 - 29
thin driver, ADG 1 - 26
Oracle Management Server (OMS), GTK 2-61
Oracle Media Management API
compatibility, MIG 8-13
proxy copy requirement, MIG 8-44
proxy copy and downgrading, MIG 12-37
Oracle Names
administrative regions, NET 2-33
advantages and disadvantages, NET 3-9
architecture, NET 2-31
centralized naming, NET 3-5
client cache, NET 8-4
coexistence, NET 5-10
configure clients and servers, NET 6-37
configuring, NET 6-21 to NET 6-50
configuring a region database, NET 6-26, NET 6-31
configuring multiple domains, NET 6-29, NET 6-34
connecting with, NET 8-8
creating Oracle Names servers, NET 6-25
default domain, NET 2-38
delegated administrative regions, NET 2-42
delegating domains
Oracle Names server
delegating domains, NET 6-50
described, NET 2-31, NET 4-30, NET 6-5
differences between versions, NET 2-42
discovering Oracle Names servers, NET 6-36, NET 6-37
discovery, NET 2-45
domains, NET 2-33
Dynamic Discovery Option, NET 2-43
establishing a connection with, NET 3-5
global directory service, SCN 33-4
hierarchical naming model, NET 2-38
installing, NET 6-24
listener configuration for, NET 6-40
loading TNSNAMES.ORA file into Oracle Names, NET 5-25
log files, NET 11-21
migrating, NET 5-23 to NET 5-30
migration, NET 5-10
multiple domains, NET 2-39
NAMESINI.SQL script, NET 5-24, NET 5-29, NET 6-26
NAMESUPG.SQL script, NET 5-23, NET 5-27, NET 5-29, NET 6-26
naming network components, NET 2-37
querying objects, NET 8-17
recommended for, NET 3-9
region database, NET 2-34
regions, NET 2-33
registering global database link qualifiers, NET 6-44, NET 6-46
registering global database links, NET 6-44
registering net service names, NET 6-41
registering objects, NET 6-41
replicating data, NET 2-34, NET 6-32
root administrative region, NET 2-40
.SDNS.ORA file, NET 2-45
SDNS.ORA file, NET 2-45
single domain naming mode, NET 2-37
starting from the command line, NET 8-17
starting from the Control Panel, NET 8-7
storing aliases, NET 2-36, NET 6-22
storing database global database names and addresses, NET 2-35, NET 6-21
storing database links, NET 2-36, NET 6-22
storing information in a region database, NET 6-26
storing net service names, NET 2-35, NET 6-22
storing Oracle Connection Manager information, NET 2-36, NET 6-22
storing other Oracle Names server names and addresses, NET 2-35, NET 6-21
trace files, NET 11-37
upgrading, NET 5-23, NET 5-23 to NET 5-30, NET 5-30
using, NET 6-21
using a database as a repository for information, NET 2-34
using multiple regions, NET 2-40
using with external naming, NET 3-7
version 1, NET 2-42
version 2, NET 2-43
version 8, NET 2-44
Oracle Names Control Utility (NAMESCTL)
command reference, NET A-34 to NET A-88
confirmation mode, NET A-33
delegating domains, NET 6-50
description of and types of commands, NET A-31
discovering Oracle Names servers, NET 6-36, NET 6-37
distributed operation, NET A-32
loading TNSNAMES.ORA into Oracle Names, NET 5-25, NET 5-28, NET 6-43
modes of operation, NET A-2
parameter options, NET A-31
querying objects, NET 8-17
registering aliases, NET 6-49
registering global database links, NET 6-45
registering net service names, NET 6-42
security, NET A-3, NET A-32
SET and SHOW modifiers, NET A-3, NET A-31
starting an Oracle Names server, NET 6-31, NET 6-36, NET 8-3
testing network objects with, NET 8-17
testing the network, NET 8-15
Oracle Names server
CKCFG.ORA file, NET 6-25
CKPCCH.ORA file, NET 6-25
CKPREG.ORA file, NET 6-25
configuring address, NET 6-76
configuring multiple domains, NET 6-29, NET 6-34
loading TNSNAMES.ORA file into Oracle Names, NET 5-25
Oracle Names servers
configuration file sample, NET B-7
configuration file, described, NET 6-6
configuration parameter reference, NET C-65 to NET C-75
configuring protocols addresses, NET 6-64
creating, NET 6-25
creating for a region database, NET 6-27
creating for replication, NET 6-32
data it can store, NET 2-35
data stored, NET 2-35
described, NET 1-5, NET 2-31
discovery of Oracle Names servers, NET 6-36
in delegated administrative regions, NET 2-40
in root administrative region, NET 2-40
log files, NET 11-21
preferred, NET 2-42
registering
global database link qualifiers, NET 6-46
registering global database link qualifiers, NET 6-44
registering global database links, NET 6-44
registering net service names, NET 6-41
registering objects, NET 6-41
replicating data, NET 6-32
starting, NET 6-31, NET 8-3
starting client cache, NET 8-4
storing aliases, NET 2-36, NET 6-22
storing database global database names and addresses, NET 2-35, NET 6-21
storing database links, NET 2-36, NET 6-22
storing net service names, NET 2-35, NET 6-22
storing Oracle Connection Manager information, NET 2-36, NET 6-22
storing other Oracle Names server names and addresses, NET 2-35, NET 6-21
testing, NET 8-16
testing with TNSPING, NET 8-22
trace files, NET 11-37
well-known, NET 2-43
Oracle namespaces, PCO C-4
Oracle Network Manager, STU 22-3
Oracle Network Manager, described, NET 5-2
Oracle Objects for OLE
automation server, ADG 1 - 12
C++ Class Library, ADG 1 - 19
data control, ADG 1 - 19
LOB and object support, ADG 1 - 17
object model, ADG 1 - 13
OraCollection interface, ADG 19 - 18
OraObject interface, ADG 19 - 17
OraRef interface, ADG 19 - 17
overview, ADG 1 - 11
with Oracle objects, ADG 19 - 16
Oracle objects, See object-relational model
Oracle Open Gateway
using ROWID datatype, PCO 4-14
Oracle Open Gateways, SCN 33-8
Oracle Parallel Query
defined, PSC 1-15
described, PSC 1-20
issuing SQL statements, PSC 1-22
Oracle Parallel Server, SCN 1-8, STU 3-8, STU 11-6
architecture, PSC 1-2
client load balancing, NET 4-10
compatibility requirements, MIG 8-34
configuring connect-time failover
Oracle Parallel Server
configuring client load balancing, NET 7-12
connect-time failover, NET 2-29, NET 4-15
CPU, STU 18-13
data files, PSC 1-11, PSC 1-14
database creation, PSC 3-5, PSC 3-6, PSC 4-3
database files, PSC 1-14
Destination Type tasks, PSC 6-36
disk affinity, STU 27-16
downgrading, MIG 12-49
enabling client load balancing, NET 4-10
enabling connect-time failover, NET 4-12
FAILOVER parameter, NET 4-15, NET C-40
FAILOVER_MODE parameter, NET C-43
folder in Console Navigator window, PSC 6-14
hardware requirements, PSC 2-2
INITDB_NAME.ORA file, PSC 1-11
installation requirements, PSC 2-2
installing, PSC 3-1
instance affinity for jobs
compatibility, MIG 8-12
INSTANCE_NAME parameter, NET 4-16, NET C-47
instances, PSC 1-9
Integrated Distributed Lock Manager (IDLM), PSC 1-15
LOAD_BALANCE parameter, NET 4-17, NET C-41
migration, MIG 3-7
not supported by Oracle Data Migration Assistant, MIG 2-9, MIG 4-3
Operating System Dependent layer, PSC 1-3
Oracle Parallel Query, PSC 1-15, PSC 1-20
Oracle Parallel Server Management, PSC 1-3
Oracle Parallel Server Option, PSC 1-3
Oracle8i Enterprise Edition, PSC 1-3
overview, PSC 1-1 to PSC 1-22
Parallel Cache Management (PCM), PSC 1-15
parallel execution, STU 27-13
parallel load, STU 26-69
pre-installation, PSC 2-1 to PSC 2-15
raw device setup, PSC 2-6 to PSC 2-12
rolling upgrade, MIG 1-5
software requirements, PSC 2-2
ST enqueue, STU 27-12
synchronization points, STU 2-8
upgrading, MIG 7-1, MIG 7-24
not supported by Oracle Data Migration Assistant, MIG 7-6
See also Parallel Server
Oracle Parallel Server database
creation, PSC 4-4, PSC 8-4
shutdown, PSC 6-24
starting, PSC 4-9, PSC 8-5
Oracle Parallel Server Management
administration of instances, PSC 6-13
architecture, PSC 5-2
configuring, PSC 5-1 to PSC 5-37
defined, PSC 1-3
LISTENER.ORA file, PSC 5-7
node requirements, PSC 5-7
OPS Communication Daemon (OPSD), PSC 5-4
OPSCTL utility, PSC 5-4
Oracle Enterprise Manager, PSC 1-3, PSC 5-2
Oracle Performance Manager, PSC 5-28
requirements, PSC 5-7
SIDs, PSC 5-7
TNSNAMES.ORA file, PSC 5-7
Oracle Parallel Server Management (OPSM), GTK 2-62, STU 12-12, SPS A-4
Group Membership Services (GMS), GTK 2-62
OPS Assistant, GTK 2-62
Parallel Server Manager, GTK 2-62
Oracle Parallel Server Option
defined, PSC 1-3
installing, PSC 3-3, PSC 8-4
Oracle parameter SID, OAS 13-15
Oracle parameters
necessary for authentication, OAS 1-13
Oracle Performance Manager, STU 12-10
accessing Oracle Parallel Server charts, PSC 5-34
charts, PSC 7-1 to PSC 7-19
configuring, PSC 5-29 to PSC 5-37
Databases folder, PSC 5-36
defined, PSC 2-4, PSC 5-3
displaying charts, PSC 7-4
installing, PSC 5-28
installing Oracle Data Gatherer, PSC 5-28
installing Oracle Diagnostics Pack, PSC 5-28
Oracle Diagnostics Pack, PSC 2-4
overview, PSC 7-2
Parallel Server Instance folder, PSC 5-34
starting, PSC 5-31, PSC 7-4
Oracle Precompilers
advantages, PCO 1-3
calling stored procedures and packages, ADG 10 - 52
control of parsing and private SQL areas, STU 19-10
language support, PCO 1-3
NLS support, PCO 4-40
running, PCO 14-1
using PL/SQL, PCO 6-7
Oracle precompilers, SQL 1-3
anonymous blocks, SCN 16-17
bind variables, SCN 16-13
cursors, SCN 16-11
embedded SQL, SCN 16-5
FIPS flagger, SCN 16-6
stored procedures, SCN 16-18
Oracle Program Interface (OPI), NET 2-13
Oracle program interface (OPI), SCN 8-25
Oracle Program Interface (OPI), described, NET 2-13
Oracle protocols
Bequeath, NET 4-27
configuring addresses, NET 6-78
described, NET 2-12, NET 4-25
LU6.2, NET 4-26
Named Pipes, NET 4-26
SPX, NET 4-25
TCP/IP, NET 4-25
TCP/IP with SSL, NET 4-6, NET 4-25
Oracle Rdb database
configuring for connection, NET 7-71
described, NET 7-71
Oracle RDB Database option, NET 7-8
Oracle Replication Manager, REP 1-13, SCN 34-15
Oracle reserved words, SQL C -1
Oracle Sales Analyzer, STU 28-9
Oracle Security Manager, SCN 29-5, SCN 33-18
Oracle Security Server, GTK 2-70, GTK 2-72, GTK 6-8
Oracle Server
client/server configuration, STU 3-9
configurations, STU 3-6
events, STU 15-5
Oracle server, SCN 1-4
hostname, LEG 2-22
See also Oracle
Oracle service names, registering in CDS, OAS 11-4
Oracle Software Packager, GTK 2-58
Oracle SQLJ
advantages over JDBC, ADG 1 - 32
compiling custom Java classes, ADG 19 - 24
creating custom Java classes, ADG 19 - 24
custom Java classes, ADG 19 - 21
CustomDatum interface, ADG 19 - 21
definition, ADG 1 - 31
design, ADG 1 - 32
example, ADG 1 - 34
in the server, ADG 1 - 37
JPublisher, ADG 19 - 24
Oracle object methods, ADG 19 - 23
stored programs, ADG 1 - 37
strongly types objects, ADG 19 - 25
support for Oracle objects, ADG 19 - 19
weakly types objects, ADG 19 - 26
Oracle striping, STU 26-39
Oracle supplied packages, ADG 10 - 16
Oracle System Identifier (SID), configuring on the listener, NET 6-71
Oracle System Identifier (SID), defined, PSC 1-11
Oracle Tools
support of SQL, SQL 1-5
Oracle Toolset, PCO 12-14
Oracle Trace, STU 15-1, STU 19-39, STU 32-16
accessing collected data, STU 15-5
binary files, STU 15-5
collection results, STU 15-25
collections, STU 15-4, STU 15-22
command-line interface, STU 15-19
data views, STU 15-6
Average Elapsed Time, STU 15-10
CPU Statistics, STU 15-11
Disk Reads, STU 15-9
Disk Reads/Execution Ratio, STU 15-9
Disk Reads/Logical Reads Ratio, STU 15-9
Disk Reads/Rows Fetched Ratio, STU 15-9
Execute Elapsed Time, STU 15-10
Fetch Elapsed Time, STU 15-11
Logical Reads, STU 15-9
Logical Reads/Rows Fetched Ratio, STU 15-9
Number of Rows Processed, STU 15-11
Parse Elapsed Time, STU 15-10
Parse/Execution Ratio, STU 15-10
Re-Parse Frequency, STU 15-10
Rows Fetched/Fetch Count Ratio, STU 15-11
Rows Sorted, STU 15-11
Sorts in Memory, STU 15-11
Sorts on Disk, STU 15-11
Total Elapsed Time, STU 15-10
Waits by Average Wait Time, STU 15-12
Waits by Event Frequency, STU 15-12
Waits by Total Wait Time, STU 15-12
deleting files, STU 15-21
details property sheet, STU 15-14
drilldown data views, STU 15-16, STU 15-18
Basic Statistics for Parse/Execute/Fetch, STU 15-18
CPU Statistics for Parse/Execute/Fetch, STU 15-18
Parse Statistics, STU 15-18
Row Statistics for Execute/Fetch, STU 15-19
duration events, STU 15-5
events, STU 15-5
FORMAT statement, STU 15-19, STU 15-20
formatter tables, STU 15-5
formatting data, STU 15-25
Oracle Trace Data Viewer, STU 15-6
parameters, STU 15-21
point events, STU 15-5
predefined data views, STU 15-6
reporting utility, STU 15-6, STU 15-26
SQL statement property sheet, STU 15-14
START statement, STU 15-19, STU 15-20
STOP statement, STU 15-19, STU 15-20
stored procedures, STU 15-24
using to collect workload data, STU 15-3
viewing data, STU 15-12
Oracle Trace Data Viewer, STU 15-6
Oracle Trace Manager, STU 15-4, STU 15-22
used for formatting collections, STU 15-5
Oracle type translator (OTT), SCN 13-15
Oracle Universal Installer, GTK 2-59, GTK 2-63
using, PSC 3-3
Oracle Version 6
exporting database objects, SUT 2-65
Oracle wallet, GTK 2-74
Oracle Wallet Manager, GTK 2-73, SCN 29-5
Oracle Wallet Manager, starting, OAS 9-30
Oracle wallets, SCN 29-5
Oracle XA
session memory in the large pool, SCN 7-12
Oracle, Trusted, PLS 2-10
ORACLE_HOME environment variable, PSC B-6
ORACLE_HOME parameter, NET 6-72, NET 7-66, NET 7-69, NET C-58
oracle_home parameter, PSC B-5
oracle_pid, SPS 11-13
ORACLE_PSRV environment variable, PSC B-3, PSC B-6
ORACLE_SID environment variable, PSC 1-11
ORACLE_SID registry entry, PSC 1-11
ORACLE_TRACE_COLLECTION_NAME parameter, SRF 1-89, STU 15-21, STU 15-22
ORACLE_TRACE_COLLECTION_PATH parameter, SRF 1-90, STU 15-21
ORACLE_TRACE_COLLECTION_SIZE parameter, SRF 1-90, STU 15-21
ORACLE_TRACE_ENABLE parameter, SRF 1-90, STU 15-21, STU 15-22
ORACLE_TRACE_FACILITY_NAME parameter, SRF 1-91, STU 15-21, STU 15-22
ORACLE_TRACE_FACILITY_PATH parameter, SRF 1-91, STU 15-21
Oracle7
and min_communication, REP 5-11
creating export files with, SUT 1-60
downgrading to, MIG 13-1
Enterprise Backup Utility (EBU), LEG 4-2
Oracle Enterprise Manager, LEG 4-3
prepare for migration, MIG 3-9, MIG 4-7
upgrading applications to Oracle8i, MIG 9-1
Oracle8
backup and recovery system, LEG 1-8, LEG 1-9, LEG 1-10
features and migration, REP B-12
Media Management Library (MML), LEG 1-11
MM API, LEG 1-11
Oracle Enterprise Manager, LEG 1-10, LEG 4-3
Recovery Catalog, LEG 1-9, LEG 1-10
Recovery Manager (RMAN), LEG 1-9, LEG 1-10, LEG 4-2
Oracle8 datatypes
binding and defining, OCI 12-6
Oracle8 SQL Reference, PCO 4-46
Oracle8i
installing, SAD 1-18
Oracle8i
changes to initialization parameters, MIG B-1
new features
adding after migration, MIG 6-7
new internal types, MIG E-1
new SQL functions, MIG E-1
Oracle8i Enterprise Edition
defined, PSC 1-3
installing, PSC 3-3, PSC 8-4
Oracle8i Server
complying with license agreement, SAD 23-2
identifying releases, SAD 1-21
processes
checkpoint (CKPT), SAD 4-12
monitoring, SAD 4-8
operating-system names, SAD 4-9
trace files fpr, SAD 4-10
Oracle8i Server processes
processes
dedicated server processes, SAD 4-2
identifying and managing, SAD 4-7
Oracle8i Spatial, GTK 2-10
Oracle8i Time Series, GTK 2-13
Oracle8i utilities
Recovery Manager, SBR 4-2
Oracle8i Visual Information Retrieval, GTK 2-12
oracle.aurora.server.GiopServer, NET 9-7
oracle.aurora.server.SGiopServer, NET 7-52
OracleHOME_NAMEAgent service, PSC 5-13
OracleHOME_NAMEDataGatherer service, PSC 5-30
OracleHOME_NAMEManagementServer service, PSC 5-14
OracleServiceSID registry key
registry
OracleServiceSID key, PSC C-2
OracleServiceSID service, PSC 4-9
OraCLOB object, ADG 1 - 18
ORACOC
in ORACA, PCO 8-41
ORACOC field, PCO 8-41
OraCollection interface, ADG 19 - 18
OraDatabase object, ADG 1 - 14
ORADBGF flag, PCO 8-39
Oradebug, GTK 2-62, SPS A-4
OraDynaset object, ADG 1 - 15
OraField object, ADG 1 - 15
ORAHCHF flag, PCO 8-39
ORAHOC field, PCO 8-41
OraMeta Data object, ADG 1 - 15
ORAMOC field, PCO 8-41
ORANEX
in ORACA, PCO 8-41
ORANEX field, PCO 8-41
ORANLS option, NLS B-13, NLS B-16
ORANOR field, PCO 8-41
ORANPR field, PCO 8-41
OraObject interface, ADG 19 - 17
OraParamArray object, ADG 1 - 16
OraParameter object, ADG 1 - 15
ORAPWD utility, SAD 1-9
OraRef interface, ADG 19 - 17
OraServer object, ADG 1 - 14
OraSession object, ADG 1 - 13
ORASFNM, in ORACA, PCO 8-40
ORASFNMC field, PCO 8-40
ORASFNML field, PCO 8-40
ORASLNR
in ORACA, PCO 8-40
ORASLNR field, PCO 8-40
OraSQLStmt object, ADG 1 - 16
ORASTXTC field, PCO 8-40
ORASTXTF flag, PCO 8-39
ORASTXTL field, PCO 8-40
oratypes.h
contents, OCI 3-27
ORAXXXXX.TRC file, PSC C-12
ORDBMS, SCN 1-22, SCN 13-2
order
preserving, STU 13-26
ORDER BY, STU 13-26
decreasing demand for, STU 27-7
ORDER BY clause, NLS 4-8
of CREATE TABLE, SQL 7-384
of queries, SQL 5-20
of SELECT, SQL 5-20, SQL 7-543, SQL 7-551
with ROWNUM, SQL 2-56
of subqueries in CREATE TABLE, SQL 7-384
sorting character data, NLS 2-25
ORDER clause
of ALTER SEQUENCE. See CREATE SEQUENCE.
of CREATE SEQUENCE, SQL 7-352
ORDER MEMBER clause
of ALTER TYPE, SQL 7-175
of CREATE TYPE, SQL 7-417
of CREATE TYPE BODY, SQL 7-423
order method, PLS 9-10
ORDER methods
specifying, SQL 7-175
order methods, ADG 16 - 19, ADG 16 - 25, ADG 18 - 8, DCI 3-5, SCN 1-57, SCN 13-7
order of evaluation, PLS 2-42, PLS 2-43
ORDER option, SPS 6-6, SPS 6-7
ORDERED hint, SCN 24-9, SQL 2-60, STU 7-51
ORDERED_PREDICATES hint, SQL 2-59, STU 7-67
ordering
conflict resolution methods for column groups, REP 6-17
ordering conflicts
avoiding, REP 6-40
ordinal numbers
specifying, SQL 2-45
spelling out, SQL 2-45
ORE. See object runtime environment
ORECLEN precompiler option, PCO 14-34
ORGANIZATION HEAP clause
of CREATE TABLE, SQL 7-372
ORGANIZATION INDEX clause
of CREATE TABLE, SQL 7-372
ORLON calls
obsolete, MIG 8-18
OS authentication, SAD 1-7
O/S backups, SBR 13-3 to SBR 13-18
O/S utilities
copying files with, SBR 8-25
OS_AUTHENT_PREFIX parameter, OAS 1-14, SRF 1-92
OS_ROLES parameter, SRF 1-92
operating-system authorization and, SAD 24-7
REMOTE_OS_ROLES and, SAD 24-19
using, SAD 24-17
OS_ROLES parameter, setting, OAS 13-6
OSS. See Oracle Security Server.
OSS.MY.WALLET parameter, NET C-15
OSS.SOURCE.CERTIFICATES parameter, NET C-15
OSS.SOURCE.MY_WALLET parameter, NET 7-64
OTHER column
PLAN_TABLE table, STU 13-5
OTHERS exception handler, PLS 6-2, PLS 6-15
OTT, SCN 13-15
command line, OCI 14-6
command line syntax, OCI 14-23
creating types in the database, OCI 14-5
datatype mapping, OCI 14-10
intype file, OCI 14-29
outtype file, OCI 14-16
overview, OCI 14-2
parameters, OCI 14-24
providing an intype file, OCI 14-8
reference, OCI 14-22
restriction, OCI 14-37
using, OCI 14-1
OTT initialization function
calling, OCI 14-20
tasks of, OCI 14-22
OTT parameters
CASE, OCI 14-27, PC_ 19-30
CODE, OCI 14-26, PC_ 19-28
CONFIG, OCI 14-27, PC_ 19-29
ERRTYPE, OCI 14-27, PC_ 19-30
HFILE, OCI 14-26, PC_ 19-29
INITFILE, OCI 14-26, PC_ 19-29
INITFUNC, OCI 14-26, PC_ 19-29
INTYPE, OCI 14-25, PC_ 19-27
OUTTYPE, OCI 14-25, PC_ 19-28
SCHEMA_NAMES, OCI 14-28, PC_ 19-31
USERID, OCI 14-24, PC_ 19-27
where they appear, OCI 14-28, PC_ 19-31
OTT. See Object Type Translator
OTT. See object type translator
OUT Bind Variables, DDS 7-6
OUT bind variables, DDS 7-6
OUT parameter
of CREATE FUNCTION, SQL 7-269
of CREATE PROCEDURE, SQL 7-334
OUT parameter mode, ADG 10 - 6, PC_ 7-3, PCO 6-5, PLS 7-14
OUT_OF_RELAY, NET A-91
outer joins, ADG 3 - 33, SQL 5-22, SQL 7-548, STU 31-22
defined, SCN 23-3
key-preserved tables in, ADG 3 - 34
non-null values for nulls, SCN 24-11
restrictions, SQL 5-22
outlines
assigning category names to, STU 7-28
assigning to a different category, SQL 7-58
automatically creating and storing, SQL 7-101
CREATE OUTLINE statement, STU 7-28
creating, SQL 7-322
creating and using, STU 7-28
creating, using, STU 7-28
dropping, STU 7-30
dropping from the database, SQL 7-464
dropping unused, STU 7-30
enabling and disabling dynamically, SQL 7-322
execution plans and Plan Stability, STU 7-25
granting
system privileges on, SQL 7-497
hints, STU 7-26
managing with OUTLN_PKG, STU 7-30
matching with SQL statements, STU 7-27
reassigning categories, STU 7-31
rebuilding, SQL 7-58
renaming, SQL 7-58
replacing, SQL 7-322
storage requirements, STU 7-27
storing during the session, SQL 7-81
storing for the instance, SQL 7-108
tables, moving, STU 7-31
use by the optimizer, SQL 7-89, SQL 7-108
used to generate execution plans, SQL 7-322
using, STU 7-28
using to move to the cost-based optimizer, STU 7-32
viewing data for, STU 7-29
OUTLN schema
DBA privileges, SCN 22-6
OUTLN user
avoid, MIG 3-10, MIG 4-8, MIG 7-4
change password, MIG 6-4, MIG 7-35
OUTLN_PKG
package to manage outlines, STU 7-30
OUTLN_PKG package, SPR 55 - 1
output file
specifying for Export, SUT 1-19
output host variable, PCO 5-2
output host variables
assigning values to, PC_ 6-2
definition of, PC_ 6-2
Output tab
from Parallel Server Operation Results dialog box, PSC 6-26
output vs input, PCO 5-2
outtype file, OCI 14-29, PC_ 19-32
when running OTT, OCI 14-16, PC_ 19-17
OUTTYPE OTT parameter, OCI 14-25, PC_ 19-28
OVERFLOW clause
of ALTER INDEX, SQL 7-33
of ALTER TABLE, SQL 7-144
of CREATE TABLE, SQL 7-372
overhead
calculating non-PCM resources, SPS 16-4
reducing, PC_ C-2
overhead, process, STU 27-3
overloaded disks, STU 20-20
overloading, PLS 7-23
object method, PLS 9-10
of packaged functions, ADG 10 - 70
packaged subprogram, PLS 8-14
restrictions, PLS 7-24
stored procedure names, ADG 10 - 12
using RESTRICT_REFERENCES, ADG 10 - 70
using subtypes, PLS 7-24
Overriding Language and Territory Specifications, NLS 2-6
oversubscribing resources, STU 27-5, STU 27-9
overview
LSM, LEG 1-2
LSM Features, LEG 1-3, LEG 1-4, LEG 1-5
Oracle backup and recovery system, LEG 1-8
overwrite
conflict resolution method
use of, REP 6-39
conflict resolution methods, RAR 6-3, REP 6-21
OWNER
Export parameter, SUT 1-21
owner of a queued job, SAD 8-7
OWNER# column
SYS.INCEXP table, SUT 1-51



Prev

Top

Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index