Oracle8i Generic Documentation Master Index
Release 8.1.5

A68826-01

Library

Product

Contents

Index

Prev Top Next


I

I date format element, SQL 2-41
I variable in SQLDA
how value is set, PC_ 15-10
purpose of, PC_ 15-10
IAF GET statement
example, PCO 12-6
example of using, PC_ 20-5
in user exits, PC_ 20-4
purpose of, PC_ 20-4
specifying block and field names, PCO 12-6
specifying block and field names in, PC_ 20-5
syntax for, PC_ 20-4
using in user exit, PCO 12-5
IAF PUT statement
example, PCO 12-7
example of using, PC_ 20-6
in user exits, PC_ 20-5
purpose of, PC_ 20-5
specifying block and field names, PCO 12-7
specifying block and field names in, PC_ 20-6
syntax for, PC_ 20-5
using in user exit, PCO 12-6
IAP, PCO 12-12
IAP in SQL*Forms
purpose of, PC_ 20-13
IBM's NetView/6000, SCN 33-20
IBMsNetView/6000', DDS 1-20
ID column
PLAN_TABLE table, STU 13-4
identification
users, SAD 23-7
IDENTIFIED BY clause
of ALTER ROLE. See CREATE ROLE.
of CREATE ROLE, SQL 7-344
IDENTIFIED BY password clause
of CREATE DATABASE LINK, SQL 7-257
of CREATE USER, SQL 7-426
of SET ROLE, SQL 7-571
IDENTIFIED EXTERNALLY clause
of ALTER ROLE. See CREATE ROLE.
of ALTER USER. See CREATE USER.
of CREATE ROLE, SQL 7-344
of CREATE USER, SQL 7-426
IDENTIFIED GLOBALLY clause
of ALTER ROLE. See CREATE ROLE.
of ALTER USER, SQL 7-181
of CREATE ROLE, SQL 7-344
of CREATE USER, SQL 7-427
of CREATE USERIDENTIFIED BY clause
of ALTER USER. See CREATE USER.
identifier
forming, PLS 2-4
maximum length, PLS 2-5
quoted, PLS 2-6
scope rules, PLS 2-37
identifier, lock, SPS 7-8
identifiers, ORACLE
how to form, PC_ F-11, PCO F-10
identity, definition, OAS Glossary-3
Identix authentication method
see Oracle Advanced Security
Identix Biometric, system requirements, OAS 1-12
Identix TouchNet II Desktop Sensor, OAS 7-15
Identix TouchNet II Hardware Interface, OAS 7-4
IDEPTREE view, SRF 2-171
IDLE_TIME parameter
of ALTER PROFILE, SQL 7-64
of CREATE PROFILE, SQL 7-339
IDLM, SPS 8-1
block access synchronization, PSC 1-16
deadlock detection, PSC 1-16
defined, PSC 1-15
described, PSC 1-15
interacting with CM, PSC 1-6, PSC 1-16
LMDN process, PSC 1-15
LMON process, PSC 1-15
modification synchronization, PSC 1-16
IDLM parameters, SPS 18-12
IF statement, PLS 3-2
ELSE clause, PLS 3-3
ELSIF clause, PLS 3-4
syntax, PLS 11-86
THEN clause, PLS 3-3
IFILE, SRF 1-4
IFILE keyword
nested files, SRF 1-50
IFILE parameter, PSC 6-4, PSC 6-5, SPS 18-5, SRF 1-50
multiple files, SPS 18-7
overriding values, SPS 18-7
specifying identical parameters, SPS 18-6
iFS. See Internet File System
IGNORE
Import parameter, SUT 2-24, SUT 2-57
existing objects, SUT 2-48
IIOP, GTK 2-71, NET 4-13
configuring for SSL, NET 7-64
configuring the MTS_DISPATCHER parameter, NET 7-54
described, NET 7-50, NET 7-51
GIOP presentation layer, NET 2-14, NET 4-13
no session layer, NET 2-14
IIOP (Internet Inter-ORB Protocol), OAS Glossary-4
secured by SSL, OAS 9-7
IIOP clients
2481 port for listener, NET 4-23, NET 7-59
2482 port for listener, NET 4-23, NET 7-59
configuring, NET 7-50, NET 7-51 to NET 7-64
configuring a non-default listener port, NET 4-23, NET 7-59
configuring for SSL, NET 7-64
connections directly to dispatchers, NET 7-53, NET 7-63
connections through listeners, NET 7-52
CORBA Servers, NET 7-50
Enterprise Java Beans (EJBs), NET 7-50
GIOP presentation layer, NET 2-14, NET 4-13, NET 9-7, NET C-55
Java Stored Procedures, NET 7-50
no session layer, NET 2-14
oracle.aurora.server.GiopServer presentation layer, NET 7-52
oracle.aurora.server.SGiopServer presentation layer, NET 7-52
regular IIOP connections, NET 7-52
session-based connections, NET 7-52
SSL support
SSL support for IIOP clients, NET 7-53
IIOP clients connections through listeners, NET 7-54
IIOP stack communications
described
ILMS, SCN 16-20
image copies, SBR 4-45
crosschecking, SBR 6-12
testing restore of, SBR 6-18
IMG, SMS 48-1
immediate (CR) block cleanout applications statistic, SRF C-11
immediate (CURRENT) block cleanout applications statistic, SRF C-11
IMMEDIATE clause
of SET CONSTRAINTS, SQL 7-568
immediate constraints, SCN 28-20
IMP, PSC 8-5, SMS 17-1
IMP_FULL_DATABASE role, SAD 24-5, SCN 30-22, SQL 7-503, SUT 2-7, SUT 2-11, SUT 2-23
Import, SUT 2-31
Implementing, NET 6-71, NET 7-12
implementing database design, SAD 1-20
implicit connections, PC_ 3-14
multiple, PC_ 3-15
single, PC_ 3-14
implicit cursor, PLS 5-11
attribute, PLS 5-38
implicit data conversion, SQL 2-31, SQL 2-33
implicit datatype conversion, PLS 2-27
effect on performance, PLS 5-67
implicit declaration
cursor FOR loop record, PLS 5-13
FOR loop counter, PLS 3-13
implicit dereferencing, ADG 16 - 24, SCN 13-10
implicit logons, PCO 3-15
multiple, PCO 3-16
single, PCO 3-15
implicit VARCHAR, PCO 4-30
Import, SUT 2-1
ANALYZE parameter, SUT 2-19
backup files, SUT 2-51
BUFFER parameter, SUT 2-19
CATEXP.SQL
preparing the database, SUT 2-7
character set conversion, SUT 1-53, SUT 2-56
character sets, SUT 2-55
COMMIT parameter, SUT 2-20
committing after array insert, SUT 2-20
compatibility, SUT 2-5
complete export file, SUT 2-43
consolidated extents, SUT 2-53
controlling size of rollback segments, SUT 2-20
conversion of Version 6 CHAR columns to VARCHAR2, SUT 2-65
creating an index-creation SQL script, SUT 2-26
cumulative, SUT 2-43
data files
reusing, SUT 2-21
database
reusing existing data files, SUT 2-21
DESTROY parameter, SUT 2-21
disabling referential constraints, SUT 2-14
displaying online help, SUT 2-24
dropping a tablespace, SUT 2-54
error handling, SUT 2-47
errors importing database objects, SUT 2-48
example session, SUT 2-34
export COMPRESS parameter, SUT 2-53
export file
importing the entire file, SUT 2-23
listing contents before import, SUT 2-28
failed integrity constraints, SUT 2-48
fatal errors, SUT 2-48, SUT 2-49
FEEDBACK parameter, SUT 2-22
FILE parameter, SUT 2-22
FROMUSER parameter, SUT 2-23
grants
specifying for import, SUT 2-23
GRANTS parameter, SUT 2-23
HELP parameter, SUT 2-9, SUT 2-24
IGNORE parameter, SUT 2-24, SUT 2-48
importing grants, SUT 2-13, SUT 2-23
importing objects into other schemas, SUT 2-13
importing rows, SUT 2-27
importing tables, SUT 2-28
incremental, SUT 2-43
specifying, SUT 2-25
INCTYPE parameter, SUT 2-25
INDEXES parameter, SUT 2-25
INDEXFILE parameter, SUT 2-26
INSERT errors, SUT 2-48
interactive method, SUT 2-41
invalid data, SUT 2-48
invoking, SUT 2-7
length of Oracle Version 6 export file DEFAULT columns, SUT 2-65
log files
LOG parameter, SUT 2-26
LONG columns, SUT 2-61
manually ordering tables, SUT 2-15
modes, SUT 2-5
NLS considerations, SUT 2-55
NLS_LANG environment variable, SUT 2-56
object creation errors, SUT 2-24
objects imported, SUT 1-5
OPTIMAL storage parameter, SUT 2-53
Oracle objects, ADG 18 - 41
Oracle Version 6 integrity constraints, SUT 2-65
parameter file, SUT 2-10, SUT 2-27
parameters, SUT 2-16
preparing the database, SUT 2-7
read-only tablespaces, SUT 2-54
recompiling stored procedures, SUT 2-61
RECORDLENGTH parameter, SUT 2-27
records
specifying length, SUT 2-27
reducing database fragmentation, SUT 2-46
refresh error, SUT 2-51
reorganizing tablespace during, SUT 2-54
resource errors, SUT 2-49
rows
specifying for import, SUT 2-27
ROWS parameter, SUT 2-27
schema objects, SUT 2-11, SUT 2-13
sequences, SUT 2-49
SHOW parameter, SUT 1-4, SUT 2-28
single-byte character sets, SUT 2-56
snapshot log, SUT 2-50
snapshot master table, SUT 2-51
snapshots, SUT 2-50
restoring dropped, SUT 2-51
specifying by user, SUT 2-23
specifying index creation commands, SUT 2-26
specifying the export file, SUT 2-22
storage parameters
overriding, SUT 2-53
stored functions, SUT 2-61
stored packages, SUT 2-61
stored procedures, SUT 2-61
system objects, SUT 2-13
table objects
import order, SUT 2-4
tables created before import, SUT 2-14
TABLES parameter, SUT 2-28
TOUSER parameter, SUT 2-31
transferring files across networks, SUT 2-50
unique indexes, SUT 2-25
uniqueness constraints
preventing import errors, SUT 2-20
user definitions, SUT 2-14
USERID parameter, SUT 2-32
using Oracle Version 6 files, SUT 2-65
import data, PSC 8-5
Import utility, PSC 8-5, SBR 13-16, SCN 1-6
about, SAD 1-17
Compatibility, SPS B-1
copying statistics, SCN 22-8
data definition conversion, MIG 2-13
database recovery, SBR 13-18
free lists, SPS A-20
migration, MIG 2-10, MIG 5-1
offline instantiation of master site, REP 8-17
partition maintenance operations, SCN 11-48
procedure for using, SBR 13-18
requirements for migration, MIG 5-2
restoring data, SPS B-1
restricted mode and, SAD 3-4
use in recovery, SCN 32-25
user-defined types, SCN 14-20
import_check, REP 7-17
importing
jobs, SAD 8-7
object groups
offline instantiation and, SPR 21 - 3, SPR 21 - 5, RAR 8-46, RAR 8-50
snapshots
offline instantiation and, SPR 22 - 2, SPR 22 - 3, RAR 8-55, RAR 8-57
status check, SPR 34 - 70, RAR 8-154
improving network performance
by adjusting SDU size, NET 3-13
by client load balancing, NET 3-12
by connection pooling, NET 2-50, NET 3-11
by randomizing client requests, NET 2-30, NET C-41
by using connection concentration, NET 3-11
with listener queuesize, NET 3-14
in avoiding dynamic extension, STU 20-28
in basic replication, REP 1-11, SCN 34-12
IN bind variables, DDS 7-5
IN comparison operator, PLS 2-46, PLS 5-5
IN operator, SCN 23-5
merging views, SCN 23-18
IN OUT bind variables, DDS 7-6
IN OUT parameter
of CREATE FUNCTION, SQL 7-269
of CREATE PROCEDURE, SQL 7-334
IN OUT parameter mode, ADG 10 - 6, PC_ 7-3, PCO 6-5, PLS 7-16
IN parameter
of CREATE function, SQL 7-269
of CREATE PROCEDURE, SQL 7-334
IN parameter mode, ADG 10 - 6, PC_ 7-3, PCO 6-5, PLS 7-14
in progress save set, LEG 2-8
IN subquery, SCN 23-17
inactive destination state
for archived redo logs, SAD 7-14
inactive online redo log
loss of, SBR 15-7
inactive session wait event, SRF A-33
inactive transaction branch wait event, SRF A-34
INAME option
when a file extension is required, PCO 14-2
INAME precompiler option, PCO 14-25, PC_ 10-25
incarnation of database option (RMAN)
list command, SBR 6-7
incarnation option (RMAN)
reset database command, SBR 6-7
INCLUDE
precompiler option, use of, PC_ 5-34
using to include the SQLCA, PC_ 9-16
INCLUDE precompiler option, PC_ E-3, PCO 14-25
INCLUDE statement
case-sensitive operating systems, PCO 2-23
declaring the ORACA, PCO 8-37
declaring the SQLCA, PCO 8-21
declaring the SQLDA, PCO 11-7
effect of, PCO 2-22
INCLUDE statements, PCO B-2
INCLUDING clause
of ALTER TABLE, SQL 7-144
INCLUDING CONTENTS clause
of DROP TABLESPACE, SQL 7-477
INCLUDING NEW VALUES clause
of ALTER MATERIALIZED VIEW LOG, SQL 7-57
of CREATE MATERIALIZED VIEW LOG / SNAPSHOT LOG, SQL 7-316
INCLUDING TABLES clause
of DROP CLUSTER, SQL 7-447
incompatibilities
removing, MIG 12-2
system-defined, MIG 12-4
incompatibilities, system-defined, MIG 8-6
incomplete media recovery
change-based, SBR 14-32 to SBR 14-35
definition, SBR 1-20, SBR 3-28
in OPS configuration, SBR 14-13
procedures for, SBR 14-26 to SBR 14-35
time-based, SBR 14-29 to SBR 14-31
using backup control file, SBR 14-13
incomplete object type, PLS 9-29
incomplete object types, ADG 16 - 16, SCN 14-17
creating, SQL 7-413
incomplete recovery
change-based (RMAN), SBR 9-25
log sequence-based (RMAN), SBR 9-26
time-based (RMAN), SBR 9-24
using RMAN, SBR 9-23
with a recovery catalog, SBR 9-24
without a recovery catalog, SBR 9-27
incomplete types, SQL 7-413
creating, SQL 7-411
inconsistent backups
definition, SBR 1-16
inconsistent whole database backups
definition, SBR 3-4
INCREMENT BY clause
of ALTER SEQUENCE. See CREATE SEQUENCE.
of CREATE SEQUENCE, SQL 7-351
incremental backups, SBR 8-21
differential, SBR 4-40
using RMAN, SBR 8-9
incremental checkpoint, SCN 8-8
incremental export, SBR 13-17, SUT 1-44
backing up data, SUT 1-49
command syntax, SUT 1-20
data selected, SUT 1-48
recording, SUT 1-23
restrictions, SUT 1-44
session example, SUT 1-49
specifying, SUT 1-20
SYS.INCFIL table, SUT 1-51
SYS.INCVID table, SUT 1-52
incremental growth, SPS 17-13
incremental import
parameter, SUT 2-25
specifying, SUT 2-25
incremental migration, REP B-4
incremental refresh, SCN 10-18
INCTYPE
Export parameter, SUT 1-20
Import parameter, SUT 2-25
IND synonym for USER_INDEXES, SRF 2-172
index
client, LEG 2-5
contention, SPS 19-6
creating, SPS 17-8
data partitioning, SPS 11-12, SPS 15-5
domain
creating, DCI 11-15
FREELISTS option, SPS 17-8
key compression, MIG 8-10
media, LEG 2-5
metadata for, DCI 11-37
PCM locks, SPS 15-5
save set status value in client index, LEG 2-9
using to improve performance, PCO D-6
index block split wait event, SRF A-34
INDEX clause
of CREATE CLUSTER, SQL 7-239
INDEX hint, SQL 2-59, STU 6-7, STU 6-16, STU 7-44
index join, STU 27-7
index joins, SCN 23-36, SCN 23-49
INDEX object privilege, SQL 7-508
index on physical ROWID, MIG 11-8
index options
SORTED INDEXES with SQL*Loader, SUT 5-43
SQL*Loader SINGLEROW keyword, SUT 5-43
index partition
dropping, SAD 13-14
moving, SAD 13-11
rebuilding, SAD 13-20
splitting, SAD 13-18
index partitions
changing physical attributes of, SQL 7-35
deallocating unused space from, SQL 7-34
dropping, SQL 7-40
marking UNUSABLE, SQL 7-146
modifying the real characteristics of, SQL 7-39
rebuilding, SQL 7-36
unusable, SQL 7-146
renaming, SQL 7-40
specifying tablespace for, SQL 7-37
splitting, SQL 7-40
index rebuilding
physical ROWIDs, MIG 11-8
index segments, SCN 1-11, SCN 4-17
index subpartitions
allocating extents for, SQL 7-40
changing physical attributes of, SQL 7-35
deallocating unused space from, SQL 7-34, SQL 7-40
marking UNUSABLE, SQL 7-40
rebuilding, SQL 7-36
renaming, SQL 7-40
specifying tablespace for, SQL 7-37
Index Unusable state
indexes left in Index Unusable state, SUT 8-11
index, cursor FOR loop, PLS 5-13
INDEX_ASC hint, SQL 2-59, STU 7-46
INDEX_COMBINE hint, SQL 2-59, STU 6-7, STU 6-16
INDEX_DESC hint, SQL 2-59, STU 7-46, STU 7-47
INDEX_FFS hint, SCN 23-36, SQL 2-59, STU 6-9, STU 7-48, STU 11-3
INDEX_HISTOGRAM view, SRF 2-172
INDEX_JOIN hint, SCN 23-36
INDEX_STATS view, SRF 2-172
index-by table
versus nested table, PLS 4-3
indexed clusters
creating, SQL 7-239
INDEXES
Export parameter, SUT 1-21
Import parameter, SUT 2-25
indexes, SCN 1-26, SCN 10-21
adding partition, SAD 13-12
allocating new extents for, SQL 7-34
altering, SAD 16-13
analyzing statistics, SAD 20-3
application-specific, SQL 7-290
ascending, SQL 7-281
auditing partitions, SCN 11-63
avoiding the use of, STU 6-7
B*-tree structure of, SCN 10-27
based on indextypes, SQL 7-285
bitmap, MIG 6-3, STU 6-13, STU 6-16, STU 6-18, STU 11-7
bitmap indexes, SCN 10-32, SCN 10-36
nulls and, SCN 10-8
parallel query and DML, SCN 10-33
bitmapped, SQL 7-279
branch blocks, SCN 10-28
building
using an existing index, SCN 10-22
building online, GTK 2-41
cardinality, SCN 10-33
changing attributes of, SQL 7-35
choosing columns for, STU 6-4
cluster, SCN 10-50, SQL 7-279
altering, SAD 17-9
cannot be partitioned, SCN 11-2
contrasted with table, SCN 10-50
creating, SAD 17-6
dropping, SAD 17-10, SCN 10-50
managing, SAD 17-1
scans of, SCN 23-41
collecting statistics on, SQL 7-38, SQL 7-186
compatibility, MIG 8-10
composite, SCN 10-22, STU 6-5
scans of, SCN 23-42
on composite-partitioned tables, SQL 7-285
concatenated, SCN 10-22
correct tables and columns, SAD 16-8
creating, ADG 6 - 5, SQL 7-277
after inserting table data, SAD 16-3
explicitly, SAD 16-8
unrecoverably, SAD 16-5
creating in parallel, STU 27-20
creating manually, SUT 2-26
deallocating unused space from, SQL 7-34
defragment using COALESCE, GTK 2-42
descending, GTK 2-25, SQL 7-281
and query rewrite, SQL 7-281
as function-based indexes, SQL 7-281
described, SCN 1-26, SCN 10-21
design, STU 2-9
direct path load
left in direct load state, SUT 8-11
disabling and dropping constraints and, SAD 16-7
disassociating statistics types from, SQL 7-454
domain, SCN 10-42, SQL 7-277, SQL 7-285, SQL 7-290
dropping, MIG 12-13
domain indexes
extensible optimization, SCN 22-16
user-defined statistics, SCN 22-17
domain, using, STU 6-23
dropped tables and, ADG 3 - 10, SAD 14-12
dropping, ADG 6 - 6, SAD 16-15
SQL*Loader, SUT 8-20
dropping before continuing a direct path load, SUT 5-34
dropping index partitions of, SQL 7-454
enforcing integrity constraints, SCN 28-10, SCN 28-12
enforcing uniqueness, STU 6-10
ensuring the use of, STU 6-6
estimating size, SAD 16-5
example, STU 4-8
examples, SQL 7-286
exporting, SUT 1-21
extensible, SCN 10-42
extensible indexing, GTK 2-31
extent allocation for, SAD 16-6
fast full scan, STU 6-8, STU 11-3
fast full scans of, SCN 23-36
FREELISTS option, SRF 1-28
function-based, ADG 6 - 6, GTK 2-24, SCN 10-24, SQL 7-277, STU 6-12
creating, SQL 7-280
dependencies, SCN 10-26, SCN 21-7, SCN 21-9
DETERMINISTIC functions, SCN 21-8
DISABLED, SCN 21-8
dropping, MIG 12-13
optimization with, SCN 10-25
privileges, SCN 10-26, SCN 21-8
global, STU 26-74
global partitioned indexes, SCN 11-32
managing partitions, SCN 11-33, SCN 11-60
globally partitioned, SQL 7-283, SQL 7-284
granting
system privileges on, SQL 7-496
guidelines, ADG 6 - 3
guidelines for managing, SAD 16-2
on hash-partitioned tables, SQL 7-284
importing, SUT 2-25
index joins, SCN 23-36, SCN 23-49
index unusable (IU), SCN 11-61
index-creation commands
Import, SUT 2-26
index-organized tables, SCN 10-36
logical rowids, SCN 10-39, SCN 12-20
secondary indexes, SCN 10-39
INITRANS for, SAD 16-4
internal structure of, SCN 10-27
key compression, SCN 10-29
key compression of, SQL 7-37, SQL 7-282
keys and, SCN 10-23
primary key constraints, SCN 28-12
unique key constraints, SCN 28-10
leaf blocks, SCN 10-28
left direct load state
SQL*Loader, SUT 8-17
limiting per table, SAD 16-3
local, STU 26-74
local indexes, SCN 11-29, SCN 11-59
building partitions in parallel, SCN 11-30
locally partitioned, SQL 7-284
location of, SCN 10-26
logging attributes of, SQL 7-282
logging rebuild operations on, SQL 7-38
LONG RAW datatypes prohibit, SCN 12-15
managing, SAD 16-1, SAD 16-15
managing partitions, SCN 11-59
marking as UNUSABLE, SQL 7-39
MAXTRANS for, SAD 16-4
merging contents of index blocks, SQL 7-39
modifying values of, STU 6-5
monitoring space use of, SAD 16-14
multiple column
SQL*Loader, SUT 8-17
no-logging mode, SCN 25-7
non-unique, STU 6-10
nonunique, SCN 10-22
nulls and, SCN 10-8, SCN 10-24, SCN 10-35
on attribute of object column, SCN 14-6
on complex data types, SCN 10-42
on REFs, SCN 14-6
online, SQL 7-283
optimization and, SCN 23-10
order of columns, ADG 6 - 4
overview of, SAD 16-2, SCN 1-26, SCN 10-21
parallel, STU 11-3
parallel creation, STU 27-20, STU 27-21
parallel DDL storage, SCN 26-33
parallel index scans, SCN 26-5
parallel local, STU 27-20
parallel queries and DML on, SQL 7-35
parallelizing creation of, SQL 7-286
parallelizing index creation, SAD 16-5
partition pruning, SCN 11-4
partitioned, NLS 4-8, SQL 2-64, SQL 7-277
user-defined, SQL 7-283
partitioned tables, SCN 10-36
partitioned tables and, REP A-4
partitioning, STU 26-46
partitioning guidelines, SCN 11-36
partitions, SCN 11-2, SCN 11-29
adding new, SQL 7-40
PCTFREE for, SAD 16-4
PCTUSED for, SAD 16-4
performance and, SCN 10-22
physical attributes of, SQL 7-281
placement on disk, STU 20-22
presorting data, SUT 4-25
SQL*Loader, SUT 8-16
privileges, ADG 6 - 5
for altering, SAD 16-13
for dropping, SAD 16-15
privileges for partitions, SCN 11-62
range scans, SCN 23-35
on range-partitioned tables, SQL 7-284
rebuild partition, SCN 11-60
rebuilding, SQL 7-36, STU 6-9
rebuilding while online, SQL 7-38
rebuilt after direct-load INSERT, SCN 25-8
recreating, STU 6-9
removing from the database, SQL 7-454
renaming, SQL 7-39
reverse, SQL 7-37, SQL 7-282
reverse key indexes, SCN 10-31
rowids and, SCN 10-28
scans of, SCN 23-35
bounded range, SCN 23-44
cluster key, SCN 23-41
composite, SCN 23-42
MAX or MIN, SCN 23-46
ORDER BY, SCN 23-47
restrictions, SCN 23-48
single-column, SCN 23-42
unbounded range, SCN 23-45
secondary for index-organized tables, GTK 2-29
selectivity of, STU 6-4
separating from a table, SAD 14-6
setting storage parameters for, SAD 16-5
skipping unusable, SUT 2-28
specifying PCTFREE for, ADG 3 - 6
specifying tablespace for, SQL 7-37
SQL*Loader, SUT 5-43
SQL*Loader and, ADG 6 - 2, SAD 16-3
state after discontinued load, SUT 5-34
statement conversion and, SCN 23-10
statistics on, SQL 7-283
statistics, gathering, STU 7-9
storage characteristics of, SQL 7-281, SQL 7-575
STORAGE clause, STU 27-21
storage format of, SCN 10-26
storage parameters, SAD 12-10
tablespace containing, SQL 7-282
tablespace for, SAD 16-4
temporary segments and, ADG 6 - 2, SAD 16-3
unique, SCN 10-22, SQL 7-278, SUT 2-25
unique scans, SCN 23-35
unsorted, SQL 7-282
user-defined types, SCN 14-6
using to improve performance, PC_ C-6
validating structure, SAD 20-8
validating structure of, SQL 7-191
when to create, ADG 6 - 2, STU 6-2
when used with views, SCN 10-14
see also bitmap indexes
INDEXES clause
of ASSOCIATE STATISTICS, SQL 7-194, SQL 7-196
indexes partitions
marking UNUSABLE, SQL 7-40
INDEXFILE
Import parameter, SUT 2-26
indexing
extensible
queries benefitting, DCI 11-14
queries not benefitting, DCI 11-14
index-organized table, PCO 4-37, SAD 14-14
not used in power demand example, DCI 11-48
index-organized table clause
of CREATE TABLE, SQL 7-361, SQL 7-372
index-organized tables, GTK 3-14, SCN 10-36
applications, SCN 10-40
benefits, SCN 10-38
compatibility, MIG 8-10
creating, SQL 7-365, SQL 7-372
full table functionality, GTK 2-29
key compression, GTK 2-29
key compression in, SCN 10-30, SCN 10-38
LOB column support, GTK 2-29
logical ROWIDs, GTK 2-29
logical rowids, SCN 10-39, SCN 12-20
modifying, SQL 7-143
nested table data, GTK 2-34
parallel CREATE, SCN 26-31
parallel loading of, GTK 2-29
parallel queries, SCN 26-29
partition of, SCN 11-42
partitioned secondary indexes on, SCN 11-45
partitioning, GTK 2-47
queue tables, SCN 19-12
rebuild of, SCN 10-39
rebuilding, SQL 7-134
rebuilding with ALTER TABLE MOVE, GTK 2-29
removing LOBs from, MIG 12-7
removing partitions from, MIG 12-14
reserving space in the index block, SQL 7-144
row overflow area, SCN 10-38
rowids of, SQL 2-23
secondary indexes, GTK 2-29
secondary indexes on, SCN 10-39
storing nested tables as, ADG 18 - 17
indextype, SCN 10-43
INDEXTYPE clause
of CREATE INDEX, SQL 7-285
indextype implementation methods, DCI 11-22
indextypes
associating statistics with, SQL 7-196
creating, SQL 7-290
disassociating from statistics types, SQL 7-456
drop routines, invoking, SQL 7-454
dropping, MIG 12-13
granting
system privileges on, SQL 7-496
indexes based on, SQL 7-285
instances of, SQL 7-277
removing from the database, SQL 7-456
INDEXTYPES clause
of ASSOCIATE STATISTICS, SQL 7-194, SQL 7-196
indicator arrays, PC_ 8-4
example of using, PC_ 8-4
uses for, PC_ 8-4
INDICATOR keyword, PC_ 4-16
INDICATOR property, ADG 11 - 23
indicator table, PCO 7-2
indicator tables
example, PCO 7-4
purpose, PCO 7-4
indicator variable, OCI 2-31
arrays of structures, OCI 5-20
for named datatypes, OCI 2-31, OCI 2-33
for REF, OCI 2-31
for REFs, OCI 2-33
named datatype defines, OCI 12-5
PL/SQL OUT binds, OCI 12-5
REF defines, OCI 12-5
using to handle NULLs, PCO 5-4, PCO 5-5
with named datatype bind, OCI 12-3
with REF bind, OCI 12-3
indicator variables, PCO 5-3
assigning values to, PC_ 6-3, PCO 4-26
association with host variables, PC_ 6-3, PCO 4-26
declarations, PC_ 18-4
declaring, PC_ 4-16, PC_ 18-4, PCO 2-11, PCO 4-26
definition of, PC_ 2-6
function, PCO 4-26
function of, PC_ 6-3, PCO 4-26
guidelines, PC_ 4-18
interpreting value, PCO 5-3
interpreting values of, PC_ 6-3, PCO 4-26
naming of, PC_ 4-43
NULLs, PCO 6-2
referencing, PC_ 4-16, PCO 4-27
required size, PCO 4-26
requirements for, PC_ 6-4
truncated values, PCO 6-2
used with multi-byte character strings, PCO 4-43
used with multibyte character strings, PC_ 4-52
using in PL/SQL, PC_ 7-12, PCO 6-12
using to detect NULLs, PC_ 6-4, PCO 4-26
using to detect truncated values, PC_ 6-4, PCO 4-26, PCO 5-4
using to handle NULLs, PCO 5-4
using to insert NULLs, PC_ 6-4
using to return NULLs, PC_ 6-5
using to test for NULLs, PC_ 6-5, PCO 5-6
with PL/SQL, PCO 6-2
with structures, PC_ 4-42
in-doubt transaction, PC_ 3-26, PCO 3-30
in-doubt transactions, DDS 3-4, SCN 4-24, SCN 5-8
after a system failure, DDS 3-19
forcing, SQL 7-215
forcing a commit, DDS 3-31
forcing a rollback, DDS 3-31
forcing commit of, SQL 7-215
forcing rollback, SQL 7-538
forcing rollback of, SQL 7-538
intentionally creating, DDS 3-33
overriding manually, DDS 3-21
pending transactions table, DDS 3-29
recoverer process, DDS 3-34
rollback segments, DDS 3-21
rollback segments and, SAD 21-11
rolling back, DDS 3-31, SQL 7-537
INDX1 tablespace raw device, PSC 2-6
inequality test, SQL 3-5
INFILE keyword
SQL*Loader, SUT 5-22
infinite loop, PLS 3-6
information
distribution
in basic replication, REP 1-10, SCN 34-11
off-loading
in basic replication, REP 1-10, SCN 34-11
transport, REP 1-11, SCN 34-12
information distribution
basic replication for, REP 1-10, SCN 34-11
information hiding, PLS 1-15, PLS 8-4
information retrieval (IR) applications
index-organized tables, SCN 10-40
inheritance, ADG 18 - 33
dual subtype/super-type reference, ADG 18 - 38
subtype contains super-type, ADG 18 - 35
super-type contains all subtypes, ADG 18 - 37
INITCAP function, SQL 4-18
INITDB_NAME.ORA file, PSC 1-11, PSC 6-2
BACKGROUND_DUMP_DEST parameter, PSC C-11, PSC C-12
CHECKPOINT_PROCESS parameter, PSC 6-10
CONTROL_FILES parameter, PSC 6-11
CPU_COUNT parameter, PSC 6-11
DB_BLOCK_SIZE parameter, PSC 6-11
DB_DOMAIN parameter, PSC 6-7, PSC 6-11
DB_FILES parameter, PSC 6-11
DB_NAME parameter, PSC 1-11, PSC 6-3, PSC 6-7, PSC 6-11
DELAYED_LOGGING_BLOCK_
CLEANOUTS parameter, PSC 6-10
DML_LOCKS parameter, PSC 6-10, PSC 6-11
GC_FILES_TO_LOCKS parameter, PSC 1-17, PSC 6-9, PSC 6-11
GC_RELEASABLE_LOCKS parameter, PSC 1-18, PSC 6-9
GC_ROLLBACK_LOCKS parameter, PSC 6-9, PSC 6-11
Global Constant (GC) parameters, PSC 6-8
identical parameters, PSC 6-11
INSTANCE_NUMBER parameter, PSC 6-10
LM_LOCKS parameter, PSC 6-11, PSC 6-12
LM_PROCS parameter, PSC 6-11, PSC 6-12
LM_RESS parameter, PSC 6-11, PSC 6-12
LOCAL_LISTENER parameter, NET 6-67, PSC 3-6, PSC 4-17, PSC 4-37
LOG_ARCHIVE_FORMAT parameter, PSC 6-10
MAX_COMMIT_PROPAGATION_DELAY parameter, PSC 6-10, PSC 6-11
NLS_* parameters, PSC 6-10
PARALLEL_DEFAULT_MAX_INSTANCES parameter, PSC 6-11
PARALLEL_DEFAULT_MAX_SCANS parameter, PSC 6-11
PARALLEL_SERVER parameter, PSC 6-10
parameter notes, PSC 6-10
PROCESSES parameter, PSC 6-10
RECOVERY_PARALLELISM parameter, PSC 6-10
ROLLBACK_SEGMENTS parameter, PSC 6-10, PSC 6-11
ROW_LOCKING parameter, PSC 6-11
SERVICE_NAMES parameter, PSC 6-7
THREAD parameter, PSC 6-10
USER_DUMP_DEST parameter, PSC C-12
INITDW.ORA file, SRF 1-2
INITFILE OTT parameter, OCI 14-26, PC_ 19-29
INITFUNC OTT parameter, OCI 14-26, PC_ 19-29
initial
passwords for SYS and SYSTEM, SAD 1-5
INITIAL extent size, STU 26-66, STU 27-13
INITIAL parameter
of STORAGE clause, SQL 7-577
Initial Preallocated Requests option, NET 6-39
INITIAL storage parameter, SAD 12-7
altering, SAD 14-11
minimum value, SPS 17-13
rollback segments, SPS 6-8
initial ticket, OAS Glossary-3
initialization
collection, PLS 4-8
object, PLS 9-23
package, PLS 8-8
record, PLS 4-40
using DEFAULT, PLS 2-30
variable, PLS 2-40
when required, PLS 2-31
initialization files, PSC 6-1 to PSC 6-39
definition, PSC 6-2
editing, PSC 6-12
for instances, PSC 6-2
identical parameters, PSC 6-11
INITDB_NAME.ORA, PSC 6-2
INITSID.ORA, PSC 6-2
location, PSC 6-12
initialization function
calling, PC_ 19-20
tasks of, PC_ 19-22
initialization parameter
archiving, SPS 21-3
control of blocks, SPS 9-13
control of PCM locks, SPS 9-13
displaying values, SPS 18-16, SPS 18-21
duplicate values, SPS 18-7
global constant, SPS 6-1, SPS 18-9
guidelines, SPS 5-9
identical for all instances, SPS 18-11
Integrated Distributed Lock Manager, SPS 18-12
MAX_DEFAULT_PROPAGATION_DELAY, SPS 18-11
obsolete, SPS A-21
PARALLEL_DEFAULT_MAXSCANS, SPS 18-11
planning LM capacity, SPS 16-3, SPS 16-6
using default value, SPS 18-7
Initialization parameters
specifying, DDS 6-13
initialization parameters
added in Oracle8i, MIG B-2
adjusting for release 8.1, MIG 3-24, MIG 4-10, MIG 7-15
affecting sequences, SAD 15-11
ALLOW_PARTIAL_SN_RESULTS, SRF 1-13
altering, SRF 1-6
ALWAYS_ANTI_JOIN, SCN 24-13, SRF 1-14
ALWAYS_SEMI_JOIN, SCN 24-13, SRF 1-14
AQ_TM_PROCESS, SCN 19-6, SCN 19-7
AQ_TM_PROCESSES, SRF 1-15
ARCH_IO_SLAVES, SRF 1-15
archive log destination
switching to new, MIG B-13
AUDIT_FILE_DEST, SRF 1-15
AUDIT_TRAIL, SRF 1-15
B_TREE_BITMAP_PLANS, SRF 1-16
BACKGROUND_CORE_DUMP, SRF 1-16
BACKGROUND_DUMP_DEST, SRF 1-16
BACKUP_DISK_IO_SLAVES, SRF 1-17
BACKUP_TAPE_IO_SLAVES, SBR 8-23, SRF 1-17
BITMAP_MERGE_AREA_SIZE, SRF 1-18
BLANK_TRIMMING, SRF 1-18
BUFFER_POOL_KEEP, SCN 7-5, SRF 1-19
BUFFER_POOL_RECYCLE, SCN 7-5, SRF 1-19
CACHE_SIZE_THRESHOLD, SRF 1-19
case significance in filenames, SRF 1-3
changes in Oracle8i, MIG B-1
CLEANUP_ROLLBACK_ENTRIES, SRF 1-19
CLOSE_CACHED_OPEN_CURSORS, SRF 1-20
COMMIT_POINT_STRENGTH, SRF 1-20
compatibility, MIG B-8
DB_DOMAIN, MIG B-9
DML_LOCKS, MIG B-8
O7_DICTIONARY_ACCESSIBILITY, MIG B-8
COMPATIBLE, MIG 8-2, SBR 16-26, SCN 3-11, SRF 1-20, STU 28-10, STU 31-4
COMPATIBLE_NO_RECOVERY, SRF 1-21
COMPLEX_VIEW_MERGING, SRF 1-21
CONTROL_FILE_RECORD_KEEP_TIME, SRF 1-21
CONTROL_FILES, SBR 9-11, SBR 15-13, SBR 16-25, SRF 1-22
for primary and standby databases, SBR 16-25
CORE_DUMP_DEST, SRF 1-23
CPU_COUNT, SRF 1-23, STU 25-16
CREATE_BITMAP_AREA_SIZE, SRF 1-24
CURSOR_SPACE_FOR_TIME, SRF 1-24
database creation, SRF 1-33
DB_BLOCK_BUFFERS, SCN 7-5, SCN 7-13, SRF 1-25
DB_BLOCK_CHECKING, SRF 1-26
DB_BLOCK_CHECKPOINT_BATCH, SRF 1-25
DB_BLOCK_CHECKSUM, SRF 1-26
DB_BLOCK_LRU_EXTENDED_STATISTICS, SRF 1-27
DB_BLOCK_LRU_LATCHES, SCN 8-8, SRF 1-27
DB_BLOCK_LRU_STATISTICS, SRF 1-27
DB_BLOCK_MAX_DIRTY_TARGET, SRF 1-27
DB_BLOCK_SIZE, SCN 7-5, SCN 7-13, SRF 1-28
DB_DOMAIN, SRF 1-29
DB_FILE_DIRECT_IO_COUNT, SRF 1-30
DB_FILE_MULTIBLOCK_READ_COUNT, SCN 23-51, SCN 24-9, SRF 1-30
DB_FILE_NAME_CONVERT, SRF 1-31
DB_FILE_SIMULTANEOUS_WRITES, SRF 1-31
DB_FILE_STANDBY_NAME_CONVERT, SBR 16-26
for primary and standby databases, SBR 16-25
DB_FILES, SBR 16-26, SCN 7-15, SRF 1-32
DB_NAME, SCN 32-22, SRF 1-32
DB_WRITER_PROCESSES, SCN 1-18, SCN 8-8, SRF 1-33
DBLINK_ENCRYPT_LOGIN, SRF 1-34
DBWR_IO_SLAVES, SRF 1-34
DELAYED_LOGGING_BLOCK_CLEANOUTS, SRF 1-35
derived parameters, SRF 1-10
descriptions, PSC 6-12
DISCRETE_TRANSACTIONS_ENABLED, SRF 1-36
DISK_ASYNCH_IO, SRF 1-36
display current settings, SRF 1-9
DISTRIBUTED_LOCK_TIMEOUT, SRF 1-36
DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME, SRF 1-36
DISTRIBUTED_TRANSACTIONS, SCN 8-12, SRF 1-37
DML_LOCKS, ADG 8 - 11, SRF 1-37
dynamic, SRF 1-6
editing, PSC 6-12
ENQUEUE_RESOURCES, SRF 1-39
EVENT, SRF 1-40
FAST_FULL_SCAN_ENABLED, SRF 1-40
FAST_START_IO_TARGET, SCN 32-13
FAST_START_PARALLEL_ROLLBACK, SRF 1-42, STU 25-16
FIXED_DATE, SRF 1-42
for primary and standby databases, SBR 16-25
FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY, SRF 1-43
GC parameters, SRF 1-10
GC_DEFER_TIME, SRF 1-44
GC_FILES_TO_LOCKS, SRF 1-44
GC_LATCHES, SRF 1-45
GC_LCK_PROCS, SRF 1-45
GC_RELEASABLE_LOCKS, SRF 1-46
GC_ROLLBACK_LOCKS, SRF 1-46
global cache, SRF 1-10
Global Constant (GC) parameters, PSC 6-8
global constant parameters, SRF 1-10
GLOBAL_NAMES, SRF 1-47
HASH_AREA_SIZE, SCN 24-8, SRF 1-47
HASH_JOIN_ENABLED, SCN 24-7, SRF 1-47
HASH_MULTIBLOCK_IO_COUNT, SCN 24-8, SRF 1-48
HI_SHARED_MEMORY_ADDRESS, SCN 7-13, SRF 1-49
HS_AUTOREGISTER, SRF 1-49
identical, PSC 6-11
IFILE, SRF 1-50
INSTANCE_GROUPS, SRF 1-50
INSTANCE_NAME, SRF 1-51
INSTANCE_NUMBER, SRF 1-51
JAVA_POOL_SIZE, SRF 1-52
JOB_QUEUE_INTERVAL, REP 7-7, SRF 1-52, STU 28-10, STU 32-6
JOB_QUEUE_PROCESSES, REP 7-7, SCN 19-10, SRF 1-53, STU 28-10, STU 32-6
LARGE_POOL_MIN_ALLOC, SRF 1-53
LARGE_POOL_SIZE, SRF 1-53
parallel execution allocation, MIG B-9
LICENSE_MAX_SESSIONS, SCN 29-20, SRF 1-54
LICENSE_MAX_USERS, SRF 1-55
LICENSE_SESSIONS_WARNING, SCN 29-20, SRF 1-55
LM_LOCKS, SRF 1-56
LM_PROCS, SRF 1-57
LM_RESS, SRF 1-57
LOCAL_LISTENER, SRF 1-58
LOCK_NAME_SPACE, SRF 1-59
LOCK_SGA, SCN 7-13, SCN 7-17, SRF 1-59
LOCK_SGA_AREAS, SRF 1-59
LOG_ARCHIVE_BUFFER_SIZE, SAD 7-22, SAD 7-23, SRF 1-59
LOG_ARCHIVE_BUFFERS, SAD 7-22, SAD 7-23, SRF 1-59
LOG_ARCHIVE_DEST, SBR 2-19, SBR 14-8, SBR 14-10, SBR 14-28, SBR 14-31, SBR 16-7, SRF 1-60
LOG_ARCHIVE_DEST_n, SRF 1-61
LOG_ARCHIVE_DEST_n, SAD 7-11, SBR 2-19, SBR 14-8, SBR 14-10, SBR 16-6, SBR 16-10
LOG_ARCHIVE_DEST_STATE_n, SRF 1-62
LOG_ARCHIVE_DEST_STATE_n, SAD 7-13, SBR 16-11
LOG_ARCHIVE_DUPLEX_DEST, SBR 2-19, SRF 1-63
LOG_ARCHIVE_FORMAT, SBR 14-7, SBR 14-10, SRF 1-64
LOG_ARCHIVE_MAX_PROCESSES, SAD 7-20, SCN 1-19, SCN 8-12, SCN 32-19, SRF 1-64
LOG_ARCHIVE_MIN_SUCCEED_DEST, SAD 7-17, SRF 1-65
LOG_ARCHIVE_START, SAD 7-9, SAD 7-14, SCN 32-19, SRF 1-66
LOG_BLOCK_CHECKSUM, SAD 6-16, SRF 1-66
LOG_BUFFER, SCN 7-6, SCN 7-13, SRF 1-67
LOG_CHECKPOINT_INTERVAL, SCN 32-13, SRF 1-67, STU 25-4
LOG_CHECKPOINT_TIMEOUT, SCN 32-13, SRF 1-68, STU 25-3
LOG_CHECKPOINTS_TO_ALERT, SRF 1-69
LOG_FILE_NAME_CONVERT, SRF 1-69
LOG_FILES, SAD 6-10, SRF 1-70
LOG_SIMULTANEOUS_COPIES, SRF 1-70
LOG_SMALL_ENTRY_MAX_SIZE, SRF 1-70
MAX_COMMIT_PROPAGATION_DELAY, SRF 1-70
MAX_DUMP_FILE_SIZE, SRF 1-71, STU 14-4
MAX_ENABLED_ROLES, SRF 1-71
MAX_PARALLEL_SERVER parameter, SRF 3-3
MAX_ROLLBACK_SEGMENTS, SRF 1-72
MAX_TRANSACTION_BRANCHES, SRF 1-72
MTS_DISPATCHERS, SRF 1-72
MTS_LISTENER_ADDRESS, SRF 1-75
MTS_MAX_DISPATCHERS, SRF 1-75
MTS_MAX_SERVERS, SCN 8-19, SCN 8-20, SRF 1-75
MTS_MULTIPLE_LISTENERS, SRF 1-75
MTS_RATE_LOG_SIZE, SRF 1-76
MTS_RATE_SCALE, SRF 1-76
MTS_SERVERS, SCN 8-19, SRF 1-76
MTS_SERVICE, SRF 1-76
multi-threaded server and, SAD 4-4
MVIEW_REWRITE_ENABLED, SRF 1-103
NLS_CALENDAR, SRF 1-76
NLS_CALENDAR parameter, NLS 2-6, NLS 2-8, NLS 2-11, NLS 2-14, NLS 2-17, NLS 2-19, NLS 2-20, NLS 2-21, NLS 2-22, NLS 2-27, NLS 2-28
NLS_COMP, SRF 1-77
NLS_CURRENCY, SRF 1-78
NLS_DATE_FORMAT, SRF 1-78
NLS_DATE_LANGUAGE, SRF 1-79
NLS_ISO_CURRENCY, SRF 1-80
NLS_LANGUAGE, SCN 11-20, SRF 1-80
NLS_LIST_SEPARATOR parameter, NLS 2-29
NLS_MONETARY_CHARACTERS parameter, NLS 2-23
NLS_NUMERIC_CHARACTERS, SCN 12-9, SRF 1-81
NLS_SORT, SCN 11-20, SRF 1-81
NLS_TERRITORY, SRF 1-82
NLS_UNION_CURRENCY, SRF 1-79
O7_DICTIONARY_ACCESSIBILITY, SRF 1-13
OBJECT_CACHE_MAX_SIZE_PERCENT, SRF 1-83
OBJECT_CACHE_OPTIMAL_SIZE, SRF 1-83
obsolete in Oracle8i, MIG B-6
OGMS_HOME, SRF 1-83
OPEN_CURSORS, ADG 8 - 9, SCN 7-9, SCN 16-7, SRF 1-84
OPEN_LINKS, SCN 7-15, SRF 1-84
OPEN_LINKS_PER_INSTANCE, SRF 1-85
operating system dependent parameters, SRF 1-10
OPS_ADMIN_GROUP, SRF 1-85, SRF 3-3
OPTIMIZER_FEATURES_ENABLE, SCN 23-17, SCN 23-36, SCN 24-12
OPTIMIZER_FEATURES_ENABLED, SRF 1-86
OPTIMIZER_INDEX_CACHING, SRF 1-86
OPTIMIZER_INDEX_COST_ADJ, SRF 1-87
OPTIMIZER_MAX_PERMUTATIONS, SRF 1-87
OPTIMIZER_MODE, SCN 23-31, SRF 1-88, STU 7-24, STU 7-38, STU 28-10, STU 28-11, STU 31-4, STU 32-13
OPTIMIZER_PERCENT_PARALLEL, SCN 22-8, SRF 1-88, STU 28-11, STU 32-14
OPTIMIZER_SEARCH_LIMIT, SRF 1-89
ORACLE_TRACE_COLLECTION_NAME, SRF 1-89
ORACLE_TRACE_COLLECTION_PATH, SRF 1-90
ORACLE_TRACE_COLLECTION_SIZE, SRF 1-90, STU 28-11
ORACLE_TRACE_ENABLE, SRF 1-90, STU 28-11
ORACLE_TRACE_FACILITY_NAME, SRF 1-91, STU 28-11
ORACLE_TRACE_FACILITY_PATH, SRF 1-91, STU 28-11
OS_AUTHENT_PREFIX, SRF 1-92
OS_ROLES, SRF 1-92
overview, SRF 1-2
PARALLEL_ADAPTIVE_MULTI_USER, SRF 1-93
PARALLEL_AUTOMATIC_TUNING, SRF 1-94
PARALLEL_BROADCAST_ENABLED, SRF 1-94
PARALLEL_DEFAULT_MAX_INSTANCES, SRF 1-95
PARALLEL_EXECUTION_MESSAGE_SIZE, SRF 1-95
PARALLEL_INSTANCE_GROUP, SRF 1-96
PARALLEL_MAX_SERVERS, REP 2-42, SBR 14-20, SCN 26-8, SRF 1-96, STU 25-14, STU 28-11, STU 32-13
PARALLEL_MIN_MESSAGE_POOL, SRF 1-97
PARALLEL_MIN_PERCENT, SCN 26-18, SRF 1-97
PARALLEL_MIN_SERVERS, REP 2-42, SCN 26-7, SCN 26-8, SRF 1-98
PARALLEL_SERVER, SCN 5-6, SRF 1-99
PARALLEL_SERVER_IDLE_TIME, REP 2-42, SRF 1-99
PARALLEL_SERVER_INSTANCES, SRF 1-99
PARALLEL_THREADS_PER_CPU, SRF 1-99
PARALLEL_TRANSACTION_RESOURCE_TIMEOUT, SRF 1-100
PARTITION_VIEW_ENABLED, SRF 1-100
performance tuning, SRF 1-11
PLSQL_V2_COMPATIBILITY, SRF 1-101
PRE_PAGE_SGA, SRF 1-102, STU 19-5
PROCESSES, SRF 1-103
PUSH_JOIN_PREDICATE, SRF 1-103
QUERY_REWRITE_ENABLED, STU 28-10, STU 31-4
QUERY_REWRITE_INTEGRITY, STU 28-10
READ_ONLY_OPEN_DELAYED, SRF 1-105
RECOVERY_PARALLELISM, SBR 14-19, SRF 1-106, STU 25-14
REDUCE_ALARM, SRF 1-106
REMOTE_DEPENDENCIES_MODE, ADG 10 - 35, SCN 21-11, SRF 1-106
REMOTE_LOGIN_PASSWORDFILE, SRF 1-107
REMOTE_OS_AUTHENT, SRF 1-107
REMOTE_OS_ROLES, SRF 1-108
renamed in Oracle8i, MIG B-4
REPLICATION_DEPENDENCY_TRACKING, SRF 1-108
RESOURCE_LIMIT, SRF 1-108, SRF 1-109
RESOURCE_MANAGER_PLAN, SRF 1-109
REWRITE_INTEGRITY, SRF 1-104
rollback segments, SRF 1-125
ROLLBACK_SEGMENTS, SCN 4-27, SRF 1-110
ROW_CACHE_CURSORS, SRF 1-110
ROW_LOCKING, ADG 8 - 11, ADG 8 - 19, SRF 1-111
SEQUENCE_CACHE_ENTRIES, SRF 1-111
SEQUENCE_CACHE_HASH_BUCKET, SRF 1-111
SERIAL_REUSE, SRF 1-111
SERIALIZABLE, ADG 8 - 11
SERVICE_NAMES, SCN 6-6, SRF 1-112
SESSION_CACHED_CURSORS, SRF 1-113, STU 19-18
SESSION_MAX_OPEN_FILES, SRF 1-113
SESSIONS, SRF 1-114
setting, PSC 6-8
SHADOW_CORE_DUMP, SRF 1-114
SHARED_MEMORY_ADDRESS, SCN 7-13, SRF 1-115
SHARED_POOL_RESERVED_MIN_ALLOC, SRF 1-115
SHARED_POOL_RESERVED_SIZE, SRF 1-115, SRF 3-105
SHARED_POOL_SIZE, SCN 7-6, SCN 7-13, SRF 1-116
parallel execution allocation, MIG B-9
SKIP_UNUSABLE_INDEXES, SCN 21-8
SORT_AREA_RETAINED_SIZE, SCN 7-16, SRF 1-117
SORT_AREA_SIZE, SCN 4-18, SCN 7-16, SCN 24-9, SRF 1-118, STU 28-11, STU 32-13
SORT_DIRECT_WRITES, SRF 1-118
SORT_MULTIBLOCK_READ_COUNT, SRF 1-119
SORT_READ_FAC, SRF 1-119
SORT_SPACEMAP_SIZE, SRF 1-119
SORT_WRITE_BUFFER_SIZE, SRF 1-120
SORT_WRITE_BUFFERS, SRF 1-120
specifying in parameter files, SRF 1-3
SPIN_COUNT, SRF 1-120
SQL_TRACE, SCN 8-15, SRF 1-120, STU 14-5
SQL92_SECURITY, SRF 1-120
STANDBY_ARCHIVE_DEST, SBR 16-26, SRF 1-121
STAR_TRANSFORMATION_ENABLED, SCN 24-19, SRF 1-121
TEMPORARY_TABLE_LOCKS, SRF 1-122
TEXT_ENABLE, SRF 1-122
THREAD, SRF 1-122
TIMED_OS_STATISTICS, SRF 1-123
TIMED_STATISTICS, SRF 1-124, STU 14-4
TRANSACTION_AUDITING, SRF 1-124
TRANSACTIONS, SCN 4-27, SRF 1-125
TRANSACTIONS_PER_ROLLBACK_SEGMENT, SCN 4-27, SRF 1-125
USE_INDIRECT_DATA_BUFFERS, SCN 7-14, SRF 1-126
USE_ISM, SRF 1-126
USER_DUMP_DEST, SRF 1-126, STU 14-4
UTL_FILE_DIR, SRF 1-127, STU 28-10, STU 32-6
variable, SRF 1-11
initialization parameters in Oracle Trace, STU 15-21
initialize functions, OCI 15-87
INITIALLY DEFERRED clause
of constraint_clause, SQL 7-226
initially deferred constraints, SCN 28-21
INITIALLY IMMEDIATE clause
of constraint_clause, SQL 7-226
initially immediate constraints, SCN 28-21
INIT.ORA, RAR 1-3, RAR 1-4, REP 2-21
parameter files, SRF 1-2
INIT.ORA file, SRF 1-2
INIT.ORA files, SBR 4-49, SBR 9-15, SCN 5-4, SCN 5-5
INIT.ORA parameters. See initialization parameters
INITRANS parameter, ADG 8 - 26
of ALTER CLUSTER, SQL 7-4
of ALTER INDEX, SQL 7-30, SQL 7-35
of ALTER MATERIALIZED VIEW, SQL 7-46
of ALTER MATERIALIZED VIEW LOG, SQL 7-54
of CREATE CLUSTER, SQL 7-238
of CREATE INDEX. See CREATE TABLE.
of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG. See CREATE TABLE.
of CREATE MATERIALIZED VIEW/SNAPSHOT. See CREATE TABLE.
of CREATE TABLE, SQL 7-370
INITRANS storage parameter
altering, SAD 14-11
default, SAD 12-9
guidelines for setting, SAD 12-9
transaction entries and, SAD 12-9
INITSID.ORA file, PSC 1-11, PSC 6-2, PSC 6-4
DB_DOMAIN parameter, NET 5-17
DB_NAMEparameter, NET 5-17
IFILE parameter, PSC 6-4, PSC 6-5
INSTANCE_NAME parameter, NET 5-17, NET 6-4, PSC 1-11, PSC 4-24, PSC 6-4
LOCAL_LISTENER parameter, NET 4-23, NET 6-16, NET 6-66, NET 6-67
MTS_DISPATCHERS parameter, NET 9-4
REMOTE_LOGIN_PASSWORDFILE parameter, PSC 6-4
ROLLBACK_SEGMENTS parameter, PSC 1-12
SERVICE_NAMES parameter, NET 5-17, NET 6-4
THREAD parameter, PSC 1-12, PSC 6-4
inline views, SCN 10-16
example, SCN 10-16
inlists, STU 7-46, STU 7-50
inner capture, SCN 14-8
input host variable
restrictions, PCO 5-2
where allowed, PCO 5-2
input host variables
assigning values to, PC_ 6-3
definition of, PC_ 6-2
restrictions on, PC_ 6-2
uses for, PC_ 6-2
where allowed, PC_ 6-2
Input/Output (IO)
defined, PSC 1-4
described, PSC 1-7
on Windows NT, PSC 1-4
INSERT
append, STU 7-61
functionality, STU 27-22
object privilege, SQL 7-508
statement, SQL 7-512
INSERT ANY TABLE system privilege, SQL 7-500
INSERT command, SCN 16-3
column values and triggers, ADG 13 - 16
direct-load INSERT, SCN 25-2
no-logging mode, SCN 11-58, SCN 25-5, SCN 25-7
free lists and, SCN 4-9
parallelizing INSERT ... SELECT, SCN 26-23
read consistency, ADG 8 - 11
storage for parallel INSERT, SCN 25-8
triggers and, SCN 20-2, SCN 20-6
BEFORE triggers, SCN 20-9
insert errors
Import, SUT 2-48
specifying, SUT 6-5
INSERT into table
SQL*Loader, SUT 5-33
insert of no rows
cause of, PC_ 9-20
INSERT privilege
granting, SAD 24-12
revoking, SAD 24-13
INSERT privilege for object tables, SCN 14-15, SCN 14-16
INSERT SQL statement, PC_ F-68
examples, PC_ F-71
INSERT statement, PCO F-54
column list, PCO 5-9
column list in, PC_ 6-9
example, PCO 5-9
example of, PC_ 6-9
INTO clause, PCO 5-9
INTO clause in, PC_ 6-9
purpose of, PC_ 6-9
requirements for, PC_ 6-9
RETURNING clause, PLS 5-63
syntax, PLS 11-89
triggers on, SQL 7-404
using host arrays in, PC_ 8-11
using host tables, PCO 7-12
VALUES clause, PCO 5-9
VALUES clause in, PC_ 6-9
inserting
rows into tables and views, PC_ F-68, PCO F-54
inserts
concurrent, SPS 4-8, SPS 11-14, SPS 17-6
free lists, SPS 11-14, SPS 18-16
free space unavailable, SPS 17-11
locating free space, SRF 1-52
performance, SPS 11-12
piecewise, OCI 5-32, OCI 5-34
INST_ID column, SRF 3-2
inst_init_ora parameter, PSC B-5, PSC B-8
inst_oracle_sid parameter, PSC B-5, PSC B-7
inst_sid_list parameter, PSC C-7
installation, PSC 3-7
and creating a database, SAD 2-3
Custom, NET 4-21
Custom install type, PSC 3-2, PSC 4-2
Custom procedure, PSC 3-6
database creation, PSC 3-5, PSC 3-6
default configuration, NET 4-22
default configuration for local naming, NET 6-13
directory structure, PSC A-1 to PSC A-3
INITDB_NAME.ORA, PSC 3-5, PSC 4-8
INITSID.ORA, PSC 3-5, PSC 4-8
Minimal, NET 4-21
Minimal install type, PSC 3-2
Net8 Client, NET 4-24
Net8 Configuration Assistant, PSC 3-6
Net8 Server, NET 4-22
network configuration, PSC 3-6
Operating System Dependent layer, PSC 2-13, PSC 8-3
Oracle Data Gatherer, PSC 5-28
Oracle Database Configuration Assistant, PSC 3-5, PSC 3-6
Oracle Diagnostics Pack, PSC 5-28
Oracle Enterprise Manager, PSC 5-10
Oracle Enterprise Manager requirements, PSC 2-3
Oracle Names, NET 6-24
Oracle Parallel Server Option, PSC 3-3, PSC 8-4
Oracle Performance Manager, PSC 5-28
Oracle Universal Installer, PSC 3-3
Oracle8i, SAD 1-18
Oracle8i Enterprise Edition, PSC 3-3, PSC 8-4
overview, NET 4-21
pre-installation, PSC 2-1 to PSC 2-15
procedure, PSC 3-3
release 8.1 Oracle software, MIG 3-12, MIG 4-11, MIG 5-3
repository database, PSC 5-10
software requirements, PSC 2-2
tuning recommendations for, SAD 2-14
Typical, NET 4-21
Typical install type, PSC 3-2, PSC 4-2
Typical procedure, PSC 3-5
verifying raw devices, PSC 3-5, PSC 3-6
installation directory
naming conventions, DCI 2-6
installation of data cartridge, DCI 2-4
installation requirements, PSC 2-2 to PSC 2-5
disk space, PSC 2-5
hardware, PSC 2-2
hardware requirements, PSC 2-2
Oracle Enterprise Manager, PSC 2-3
shared disk partitions, PSC 2-5
software, PSC 2-2
installation type
Custom, PSC 3-2, PSC 4-2
Minimal, PSC 3-2
Typical, PSC 3-2, PSC 4-2
installing key of server, OAS 9
INSTANCE, PSC 4-29
instance, PLS 9-4
adding instances, SPS 14-4, SPS 17-13, SPS 23-2
affinity, for jobs, SPS 4-9, SPS A-4
associated with data block, SPS 11-11
associated with data file, SPS 17-13
associated with extent, SPS 17-10
background processes, SPS 4-12, SPS 5-4, SPS 5-5
changing current, SPS 18-21
changing default, SPS 18-20
current, SPS 18-20, SPS 18-21, SPS 21-9
failure, SBR 1-12, SPS 22-3
free list, SPS 11-14, SPS 17-11
global name resolution for, SQL 7-102
groups, specifying, SPS 18-23
groups, using, SPS 18-24
instance number, SPS 11-15, SPS 17-13
maximum number, SPS 6-8, SPS 11-15, SPS 14-3, SPS 14-4
number, SPS 17-10
ownership of PCM locks, SPS 9-5
parallel server characteristics, SPS 5-1
recovery, SBR 1-19, SPS 14-4, SPS 18-27, SPS 22-2
remote, SPS 18-6, SPS 18-8, SPS 18-20
rollback segment required, SPS 6-8
setting parameters for, SQL 7-100
startup order, SPS 18-16
thread number, SPS 6-3, SPS 14-8, SPS 18-15
instance affinity for jobs, GTK 2-63
DBMS_JOB package, GTK 2-63
instance attribute lock enqueue, SRF B-3
instance groups for parallel operations, SCN 26-19
instance lock, SPS 7-2
acquired by background process, SPS 7-6
acquired by foreground process, SPS 7-6
definition, SPS 7-2, SPS 7-4
types, SPS 7-5
instance menu
prevent Connections option, SAD 3-9
instance name, PSC 1-11
described, NET 6-3
verifying, NET 5-17
Instance Name option, NET 7-7
INSTANCE NAME parameter, SPS 18-6
instance number, SPS 11-13
instance number enqueue, SRF B-2
INSTANCE option
allocating, SPS 17-14
allocating extents, SRF 1-52
SET INSTANCE command, SPS 17-10, SPS 18-17
SHOW INSTANCE command, SPS 18-20
INSTANCE parameter
of ALTER SESSION, SQL 7-83
Instance recovery, SRF 1-43
instance recovery, SCN 32-4
abnormal shutdown, SPS 18-27
access to files, SPS 6-2, SPS 22-4
global checkpoint, SPS 21-9
instance failure, SCN 1-46, SCN 32-4
multiple failures, SPS 22-3
read-only tablespaces, SCN 32-6
rollback segments, SPS 6-8
SMON process, SCN 1-19, SCN 8-11, SCN 26-41
starting another instance, SPS 14-4
See also crash recovery
instance recovery enqueue, SRF B-2
instance recovery wait event, SRF A-35
instance registration, SPS A-10
purpose, SPS 18-28
instance registration lock enqueue, SRF B-3
instance state change wait event, SRF A-35
instance state enqueue, SRF B-2
INSTANCE_GROUPS parameter, SPS 18-24, SRF 1-50
INSTANCE_ID column, SPS 20-12
INSTANCE_NAME parameter, NET 4-3, NET 4-9, NET 4-16, NET 5-17, NET 6-3, NET 6-4, NET 7-7, NET C-47, PSC 1-11, PSC 4-24, PSC 4-29, PSC 6-4, SRF 1-51
INSTANCE_NUMBER parameter, PSC 6-10, SPS 17-10, SPS 18-5, SRF 1-51
and SQL options, SPS 11-11
assigning free lists to instances, SPS 11-13
conversion to multi-instance, SPS 23-7
exclusive mode, SPS 18-14
exclusive or parallel mode, SRF 1-52
exclusive or shared mode, SPS 18-16
individual parameter files, SPS 18-5
setting, SPS 17-13
unique values for instances, SPS 18-10, SPS 18-16
unspecified, SPS 18-16
instances, SCN 1-6
aborting, SAD 3-12, SCN 5-10, SCN 32-4
acquire rollback segments, SCN 4-26
administering, PSC 6-1 to PSC 6-39
associating with databases, SCN 5-2, SCN 5-6
BSPO process, PSC 1-10
checkpoint, SRF 1-68
control files, PSC 1-10
data files, PSC 1-10, PSC 1-11, PSC 1-14
DBWR process, PSC 1-10
defined, PSC 1-9, SCN 1-16
described, SCN 5-2
Destination Type tasks for, PSC 6-36
diagrammed, SCN 8-6
examples of parameters in
DB_NAME.CONF file, PSC B-7
failure in, SCN 1-46, SCN 32-4
identical parameters, PSC 6-11
initialization files, PSC 6-2
INITSID.ORA, PSC 1-11
instance groups, SCN 26-19
instance name, PSC 1-11
INSTANCE_NAME parameter, PSC 1-11, PSC 4-24
Integrated Distributed Lock Manager (IDLM), PSC 1-10
issues, PSC 6-8
LCKN process, PSC 1-10
LGWR process, PSC 1-10
LMD0 process, PSC 1-10
LMON process, PSC 1-10
management with Oracle Parallel Server Management, PSC 6-13
memory structures of, SCN 7-2
multiple-process, SCN 8-2
Oracle System Identifier (SID), PSC 1-11
ORACLE_SID environment variable, PSC 1-11
ORACLE_SID registry entry, PSC 1-11
overview of, SCN 1-6
PMON process, PSC 1-10
process structure, SCN 8-2
recovery of, SCN 5-10, SCN 32-4
Fast-Start Checkpointing, SCN 32-13
opening a database, SCN 5-8
SMON process, SCN 8-11
restricted mode, SCN 5-6
rollback segments, PSC 1-12
ROLLBACK_SEGMENTS parameter, PSC 1-12
service names, SCN 6-6
setting initialization parameters, PSC 6-8
sharing databases, SCN 1-8
shutting down, SCN 5-9, SCN 5-10
audit record, SCN 31-5
shutting down immediately, SAD 3-11
SID, PSC 1-11, PSC 6-3
SID Prefix, PSC 4-8
SID prefix, PSC 3-4
SMON process, PSC 1-10
starting, SAD 3-2, SCN 5-5
audit record, SCN 31-5
starting before database creation, SAD 2-6
startup order, SRF 1-52
system identifiers (SIDs), SCN 6-6
thread ID, PSC 1-12
THREAD parameter, PSC 1-12
verifying, PSC 4-11
viewing startup and shutdown results, PSC 6-24, PSC 6-27
virtual memory, SCN 7-17
INSTANCES keyword, SPS 18-27
removed from PARALLEL clause, MIG 8-35
INSTANCES parameter (Oracle Version 6), SPS A-21
instantiation
offline, REP 8-14
in advanced replication, REP 8-17
of an advanced replication master site, REP 8-16
instantiation offline, REP A-4
INSTEAD OF clause
of CREATE TRIGGER, SQL 7-404
INSTEAD OF trigger, GTK 3-15
INSTEAD OF triggers, ADG 13 - 7, SCN 20-12, SQL 7-404
nested tables, SCN 15-5
object views, ADG 17 - 16, ADG 17 - 17, SCN 15-5
on nested table view columns, ADG 13 - 16
INSTR function, SQL 4-18
INSTRB function, SQL 4-19
INT datatype (ANSI), SQL 2-24
INT keyword
behavior in Oracle7 and Oracle8i, MIG 8-22
INT subtype, PLS 2-13
INTCHG.ORA file, migration issues, NET 5-22
INTEGER
external datatype, OCI 3-11
INTEGER datatype, PC_ 4-6, PCO 4-11, SUT 5-59
ANSI, SQL 2-24
DB2, SQL 2-25
EXTERNAL format, SUT 5-67
SQL/DS, SQL 2-25
INTEGER subtype, PLS 2-13
integers
generating unique, SQL 7-349
in SQL syntax, SQL 2-3
precision of, SQL 2-3
specifying, SQL 2-13
syntax of, SQL 2-3
Integrated Distributed Lock Manager
capacity for locks and resources, SPS 16-2
configuring, SPS 16-3
definition, SPS 1-11
distributed architecture, SPS 8-8
failover requirements, SPS 16-2
fault tolerant, SPS 8-8
features, SPS 8-8
group-based locking, SPS 8-10
handling lock requests, SPS 8-3
instance architecture, SPS 5-2
internalized, SPS A-8
LCKn process, SPS 9-8
lock mastering, SPS 8-9
minimizing use, SPS 1-16, SPS 4-12
non-PCM lock capacity, SPS 7-6
queues, SPS 8-2
recovery phases, SPS 22-5
resource sharing, SPS 9-8
Integrated Distributed Lock Manager (IDLM)
defined, PSC 1-15
described, PSC 1-15
See IDLM
integrated operations, SPS 1-5
integrity checking, SBR 4-54
integrity constraints, SCN 28-2
application uses, ADG 5 - 2
clusters and, ADG 6 - 16
default column values and, SCN 10-8
defining, ADG 5 - 18
disabling, ADG 5 - 20, ADG 5 - 21, ADG 5 - 22, ADG 5 - 23, SAD 20-14, SAD 20-19
disabling on creation, SAD 20-18
dropping, ADG 5 - 29, SAD 20-21
dropping and disabling, SAD 16-7
dropping tablespaces and, SAD 9-15
enabling, ADG 5 - 21, SAD 20-14
enabling at creation, ADG 5 - 20
enabling on creation, SAD 20-18
enabling when violations exist, ADG 5 - 21, SAD 20-15
examples, ADG 5 - 2
exceptions to, ADG 5 - 25, SAD 20-21
failed on Import, SUT 2-48
listing definitions of, ADG 5 - 32
load method, SUT 8-9
managing, SAD 20-15
naming, ADG 5 - 20
ORA-02055
constraint violation, DDS 4-3
Oracle Version 6 export files, SUT 2-65
performance considerations, ADG 5 - 3
privileges required for creating, ADG 5 - 19
restrictions for adding or dropping, ADG 5 - 19
triggers vs., ADG 13 - 2, ADG 13 - 40
violations, ADG 5 - 21, SAD 20-15
when to disable, ADG 5 - 21, SAD 20-15
when to use, ADG 5 - 2
See also constraints
integrity constraints. See constraints.
integrity rules, SCN 1-22
parallel DML restrictions, SCN 26-45
integrity, definition, OAS Glossary-4
interactive block execution, ADG 10 - 51
interactive method
Export, SUT 1-36
interconnect, SPS 3-3
and scalability, SPS 2-2
high-speed, SPS 1-9
protocols for OPS, SPS 20-6
interface
native, PC_ 5-55, PCO 3-32
XA, PC_ 5-55, PCO 3-32
interfaces
data cartridge, DCI 1-14
DBMS, DCI 1-14
extensibility, DCI 1-13
service, DCI 1-14
inter-language call, PLS 7-27
Inter-Language Method Services (ILMS), SCN 16-20
interMedia
Audio, Image, and Video, GTK 2-8
Audio, Image, and Video Java Client, GTK 2-9
Locator, GTK 2-9
Text, GTK 2-6
Web based tools, GTK 2-3
INTERNAL
alternatives to, SAD 1-8
connecting for shutdown, SAD 3-10
OSOPER and OSDBA, SAD 1-8
security for, SAD 22-8
INTERNAL connection, SCN 5-3
statement execution not audited, SCN 31-5
internal datatype
definition, PCO 2-8
internal datatypes, OCI 3-3, OCI 3-5
CHAR, PCO 4-2
conversions, OCI 3-21
datatype codes, OCI 3-5
DATE, PCO 4-3
definition of, PC_ 2-7
dynamic SQL Method 4, PCO 11-15
lLONG, PCO 4-3
LONG RAW, PCO 4-4
NCHAR, PCO 4-3
new in Oracle8i, MIG E-2
NUMBER, PCO 4-4
NVARCHAR2, PCO 4-5
RAW, PCO 4-4
ROWID, PCO 4-5
table of, PCO 4-2
VARCHAR2, PCO 4-5
INTERNAL date function
executing jobs and, SAD 8-8
internal errors tracked in trace files, SCN 8-14
internal LOB, DCI 6-2
Internal LOBs
loading, SUT 5-99
internal LOBs, SQL 2-19
INTERNAL option
instance shutdown, SPS 18-26
internal triggers, REP A-2
internal write batch size, STU 20-43
International Standards Organization. See ISO.
Internet, NET 2-14
internet, OAS 9-7
Internet Domain Service (DNS), OAS 11-4
Internet Inter-ORB Protocol (IIOP), OAS Glossary-4
Internet Inter-Orb Protocol (IIOP)
see IIOP
inter-node communication, SPS 1-9
interoperability, MIG 8-1, MIG 8-15
Advanced Queuing, MIG 8-32
applications, MIG 8-16
Heterogeneous Services agents, MIG 8-45
native dynamic SQL, MIG 8-30
NCHAR and NLS, MIG 8-27
OCI, MIG 8-17
Oracle7 clients, MIG 8-18
shared structures, MIG 8-17
PL/SQL, MIG 8-20
precompilers, MIG 8-18
UROWIDs, MIG 8-26
user-defined datatypes, MIG 8-29
interoperability, cursor, PLS 5-16
inter-operator parallelism, SCN 26-13
Inter-Orb Protocol (IIOP)
configuring, NET 7-50
described, NET 7-50
Inter-Process Communication (IPC)
defined, PSC 1-4
described, PSC 1-7
interrupted loads
continuing with SQL*Loader, SUT 5-34
interrupting media recovery, SBR 14-16
INTERSECT operator, SQL 3-12, SQL 7-550
compound queries, SCN 23-4
example, SCN 23-29
optimizing view queries, SCN 23-16
INTERSECT set operator, PLS 5-6
intersection tables, REP 3-13
Interval Expression setting
Setup wizard, REP 2-16
Interval setting
Create Scheduled Link property sheet, REP 2-13
INTO clause, PCO 5-2, PCO 6-36, PLS 5-23
FETCH statement, PCO 5-14
for output host variables, PC_ 6-2
in FETCH statements, PC_ 6-14
in INSERT statements, PC_ 6-9
in SELECT statements, PC_ 6-8
INSERT statement, PCO 5-9
of EXPLAIN PLAN, SQL 7-487
of FETCH DESCRIPTOR statement, PC_ F-62
of FETCH statement, PC_ F-59, PCO F-46, PCO F-49
of INSERT, SQL 7-514
of SELECT statement, PC_ F-106, PCO F-81
SELECT statement, PCO 5-8
used with FETCH instead of SELECT, PC_ 6-12
INTO host_variable clause
of CALL, SQL 7-211
INTO list, PLS 5-9
INTO TABLE clause
effect on bind array size, SUT 5-80
INTO TABLE statement
column names
SQL*Loader, SUT 5-46
discards
SQL*Loader, SUT 5-29
multiple statements with SQL*Loader, SUT 5-51
SQL*Loader, SUT 5-39
intra transaction recovery, STU 25-16
intra-operator parallelism, SCN 26-13
Introducing, PSC 1-1
intype file, PC_ 19-32
providing when running OTT, OCI 14-8, PC_ 19-8
structure of, OCI 14-29, PC_ 19-32
INTYPE OTT parameter, OCI 14-25, PC_ 19-27
INTYPE precompiler option, PC_ 10-26
invalid data
Import, SUT 2-48
invalid destination state
for archived redo logs, SAD 7-13
invalid objects
warning messages
during export, SUT 1-39
INVALID status, SCN 21-2
invalid use
of precompiler preprocessor, PC_ 5-33
invalid views, ADG 3 - 27
INVALID_CURSOR exception, PLS 6-5
INVALID_NUMBER exception, PLS 6-5
invoker rights, GTK 2-78, PLS 7-29, SCN 18-9
advantages, PLS 7-30
name resolution, SCN 18-19
procedure security, SCN 30-8
supplied packages, SCN 30-8
versus definer rights, PLS 7-29
invoker rights clause
of ALTER JAVA, SQL 7-44
of CREATE FUNCTION, SQL 7-270
of CREATE JAVA, SQL 7-294
of CREATE PACKAGE, SQL 7-324
of CREATE PROCEDURE, SQL 7-332
of CREATE TYPE, SQL 7-415
invoker-rights
dynamic SQL, ADG 9 - 8
object types, ADG 18 - 30
invoking Export, SUT 1-10
direct path, SUT 1-43
I/O
analyzing needs, STU 20-2
and scalability, SPS 2-3
asynchronous, STU 26-29
balancing, STU 20-22
disk contention, SPS 4-5
distributing, SAD 2-15, STU 20-20, STU 20-24
insufficient, STU 17-5
interrupts, SPS 2-5
minimizing, SPS 1-16, SPS 4-5, SPS 4-12, SPS 15-6
multiple buffer pools, STU 19-32
parallel execution, STU 26-3
reading multiple blocks, SRF 1-30
redo log files, SRF 1-67
reducing with buffer cache, SRF 1-25
Statistics for Parse/Execute/Fetch, STU 15-18
striping to avoid bottleneck, STU 26-37
testing disk performance, STU 20-5
tuning, STU 2-11, STU 20-2
io done wait event, SRF A-35
I/O errors
effect on backups, SBR 4-36
IOTs. See index-organized tables
IP errors, troubleshooting, LEG B-1 to LEG B-2
IPC, parameters for addresses, NET 6-78
IPCs
and Cache Fusion, SPS 20-6
IRECLEN precompiler option, PCO 14-26
IS DANGLING predicate, PLS 9-33
IS NOT NULL operator, SQL 3-7
IS NULL comparison operator, PLS 2-45, PLS 5-6
IS NULL operator, SQL 3-7
for testing NULL values, PCO 2-18
IS NULL predicate, SCN 10-8
ISO, SQL B - 1
standards, SQL 1-2, SQL B - 1
ISO SQL standard, SCN 1-3, SCN 12-22
composite foreign keys, SCN 28-16
ISO standard
date format, NLS 2-16, NLS 4-9, NLS 4-10
ISO week number, NLS 4-9
ISOLATION LEVEL, STU 9-5
changing, ADG 8 - 26
SERIALIZABLE, ADG 8 - 26
ISOLATION LEVEL READ COMMITTED clause
of SET TRANSACTION, SQL 7-573
ISOLATION LEVEL SERIALIZABLE clause
of SET TRANSACTION, SQL 7-573
isolation levels
choosing, SCN 27-12
read committed, SCN 27-8
setting, SCN 27-7, SCN 27-31
ISOLATION_LEVEL parameter
of ALTER SESSION, SQL 7-83
%ISOPEN cursor attribute, PLS 5-34, PLS 5-38
iteration
scheme, PLS 3-10
versus recursion, PLS 7-41
iterative control, PLS 3-6
ITIME column
SYS.INCEXP table, SUT 1-51
IW date format element, SQL 2-41
IW format element, NLS 4-10
IY date format element, SQL 2-41
IY format element, NLS 4-10
IYY date format element, SQL 2-41
IYYY date format element, SQL 2-41



Prev

Top

Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index