Getting to Know Oracle8
i
Release 2 (8.1.6)
A76962-01
Library
Product
Contents
Index
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
W
X
Z
A
Advanced Networking Option, 3-70
Advanced Queuing, 3-37 to
3-40,
4-6
database event publication, 3-39
multiple consumer queues, 3-39
nonpersistent queues, 3-40
object level and system level privileges, 3-39
object type support, 2-5
parallel server mode, 3-40
propagation, enhanced, 3-39
addition of a sender's ID column, 3-39
history management information, 3-39
single view, 3-39
statistics, 3-39
rules engine, 3-38
see also
publish/subscribe
advanced replication, 3-64 to
3-66
column level snapshot subsetting, 3-65
internal apply packages, 3-64
mass deployment support, 3-65
offline snapshot instantiation, 3-65
Oracle Lite integration, improved, 3-66
Replication Manager, 3-66
security, improved, 3-66
snapshot deployment templates, parameterized, 3-65
snapshot refresh, 3-64
Advanced Security option. See Oracle Advanced Security.
aggregate distinct queries, parallelization of, 3-25
ALTER INDEX statement
COMPUTE STATISTICS clause, 3-27
online rebuild, 3-41
ALTER TABLE statement
drop column support, 3-41
ENABLE ROW MOVEMENT, 3-46
merging partitions, 3-45
MODIFY CONSTRAINT clause, 3-28
MOVE clause for IOT or non-partitioned table, 3-29
no longer invalidates bitmap indexes, 3-25
ANALYZE statement
dangling REFs, 3-36
parallel, 4-2
ANO. See Advanced Networking Option.
application context
CREATE CONTEXT statement, 3-69
application development, 3-69
Application Generator for Microsoft Visual Studio, 3-85
application schema, 2-9
automated parallel query tuning, 3-27
automated standby databases, 3-50
automatic archival, 3-50
read-only databases, 3-51
autonomous PL/SQL blocks, 3-78
B
backup and recovery, incremental, 4-6
bitmap indexes, 4-4
ALTER TABLE no longer invalidates, 3-25
new ALTER TABLE clauses
MINIMIZE RECORDS PER BLOCK, 3-25
NOMINIMIZE RECORDS PER BLOCK, 3-25
C
cache fusion, 3-61
CACHE READS option, 2-13
call specs, 3-19,
3-44
cartridge services, 3-32
CASE expressions, 2-14
certificate authority, 3-74
collections
collection unnesting, 3-35
SQL*Loader support, 3-36
COM Cartridge, 3-87
compatibility flag, 7-6
composite partitioning, 3-46
COMPUTE STATISTICS clause of CREATE and ALTER INDEX statements, 3-27
CONNECT INTERNAL desupported, 7-6
Connection Manager, Oracle, 4-6
connection multiplexing, 4-6
connection pooling, 4-6
constraint processing, 4-15
constraints
constraint modification with ALTER TABLE, 3-28
DISABLE VALIDATE constraint state, 3-28
control files, 3-52
CORBA, 3-19
CREATE CONTEXT statement, 3-69
CREATE MATERIALIZED VIEW statement, 3-22
CREATE OUTLINE statement, 3-37
CREATE_STORED_OUTLINES session parameter, 3-37
Cryptographic Toolkit, 7-8
CUBE operation, GROUP BY clause, 3-24
D
Data Migration Assistant, 2-4,
3-60
data mining, 3-24
data warehousing, 3-21 to
3-30
Database Resource Manager, 3-48
DISABLE VALIDATE state, 3-28
function-based indexes, 3-24
materialized views, 3-21
related features, 3-30
SAMPLE function, 3-24
statistics gathering
COMPUTE STATISTICS clause of CREATE and ALTER INDEX statements, 3-27
DBMS_STATS package, 3-26
transportable tablespaces, 3-23
Database Configuration Assistant, 2-4,
3-59
database instance registration
client load balancing, 3-76
Database Resource Manager, 3-48
DBMS_RESOURCE_MANAGER package, 3-49
DBMS_RESOURCE_MANAGER_PRIVS package, 3-49
resource allocation methods, 3-49
resource consumer groups, 3-49
resource plan directives, 3-49
resource plans, 3-49
database SUSPEND/RESUME, 3-52
date format strings, 7-2
DBA Management Pack, 2-3
direct path load API, 3-23
distributed lock manager (DLM), 3-62
distributed systems, 3-64 to
3-68
documentation
online, 6-2
drop column, 3-41
dynamic (connection) load balancing, Net8, 3-77
E
Enterprise Java Beans, 3-19
enterprise roles, 2-9
Export/Import utilities, 3-57
extended aggregate operators, 3-24
extensibility, 4-14
extensibility framework, 3-30 to
3-33
cartridge services, 3-32
extensible indexing, 3-31
extensible optimizer, 3-32
heterogeneous services, 3-66
user-defined operators, 3-31
extensible indexing, 3-31
extensible optimizer, 3-32
external procedures (routines)
call specification, 3-44
DLL Caching, 3-45
object support, 3-45
Pro*C/C++, 3-82
external procedures. See external routines
external routines, 4-12
external routines. See external procedures (external routines)
F
factoring matrix
features, 5-4
options, 5-2
failover
with Oracle Enterprise Manager, 3-76
Fast-Start fault recovery, 3-51
see also
transaction recovery
feature factoring matrix, 5-4
fine-grained access control, 3-69
DBMS_RLS package, 3-69
free lists
reducing contention, 2-13,
2-17
function-based indexes, 3-24
G
global roles, 2-9
Group Membership Services (GMS), 3-62
H
hash clusters
single-table-only, 3-26
hash partitioning, 3-46
heterogeneous services
agent self-registration, 3-67
agent shared library, 3-67
fixed views, 3-67
high availability, 2-2
I
i
FS.
See Internet File System
IIOP, 3-70
indexes
building online, 3-41
defragment using COALESCE, 3-42
descending, 3-25
extensible indexing, 3-31
function-based, 3-24
secondary for index-organized tables, 3-29
see also
bitmap indexes
index-organized tables, 4-14
full table functionality, 3-29
key compression, 3-29
LOB column support, 3-29
logical ROWIDs, 3-29
nested table data, 3-34
parallel loading of, 3-29
partitioning, 3-47
rebuilding with ALTER TABLE MOVE, 3-29
secondary indexes, 3-29
instance affinity for jobs, 3-63
DBMS_JOB package, 3-63
INSTEAD OF trigger, 4-15
inter
Media, 2-6
Audio, Image, and Video, 3-8
Audio, Image, and Video Java Client, 3-9
Locator, 3-9
Text, 3-6
Web based tools, 3-3
Internet File System, 3-3
invoker rights, 3-79
IOTs. See index-organized tables
J
Java, 4-13
JDBC drivers, 3-17
SQLJ translator, 3-18
Java development tools/utilities
JDeveloper, 3-20
JPublisher, 3-20
loadjava and dropjava, 3-21
Java Message Service, 2-5
Java VM, 2-5,
3-16
development models
CORBA, 3-18
EJBs, 3-18
Java stored procedures, 3-18
JServer Accelerator, 3-18
JavaASO, 2-8
JDBC, 4-13
JDeveloper, 2-5,
3-20
JPublisher, 3-20
JServer Accelerator, 3-16
JServer. See Java VM
JSQL, 4-13
JVM.
See
Java VM
L
LDAP, 2-10,
3-74
Legato Storage Manager, 4-6
Lightweight Directory Access Protocol. See LDAP.
listener
configuring for Oracle Enterprise Manager, 3-76
loadjava and dropjava, 3-21
LOBs
convert LONG to LOB, 3-33
DBMS_LOB API to append data to LOBs, 3-34
in index-organized tables, 3-29
LOB chunk size, 3-34
Open/Close/IsOpen APIs, 3-34
partitioning of tables with, 3-47
SQL*Loader support, 3-36
temporary, 3-33
variable width character sets for CLOBs and NCLOBs, 3-34
locally managed tablespaces, 3-41
LOG_ARCHIVE_DEST_n initialization parameter, 3-50
logical ROWIDs, 3-29
LogMiner, redo log analysis, 3-40
long running operations, statistics generation for, 3-27
M
materialized views, 2-11
materialized views.
See
summary management
Media Management API
version 2.0, 3-53
Microsoft Transaction Server integration, 3-87
migration utility, 4-14
multimedia data, 4-13
multiplexing, connection, 4-6
multi-tier authentication and authorization, 3-78
N
national language support, 3-43
native authentication on Windows NT, 3-77
NCHAR datatype, 4-15
nested tables
collection locators, 3-34
data stored in indexed-organized table, 3-34
OCICollIsLocator(), 3-34
triggers on view columns, 3-35
user-specified storage clauses for, 3-34
UTL _COLL package, 3-34
Net8, 3-64,
3-70,
3-75
dynamic (connection) load balancing, 3-77
native authentication on Windows NT, 3-77
Net8 Assistant, 3-75
Net8 Easy Config, 3-75
service naming, 3-75
Net8 Configuration Assistant, 2-4,
3-77
NOCOPY parameter passing mode, 3-80
non-deferred linking, 7-4
O
object cache, 3-35,
3-36,
4-12
Object Database Designer, 4-13
object identifiers, 7-8
object relational enhancements, 2-12,
3-33 to
3-37
ANALYZE statement, dangling REFs, 3-36
collection unnesting, 3-35
object cache enhancements, 3-36
object identifiers, user defined, 3-34
object views, 3-35
parallel query support, 3-37
partitioning of tables containing user-defined types, 3-37
referential integrity constraint on REF column, 3-34
SQL*Loader support, 3-36
value subqueries, 3-36
see also
LOBs
see also
nested tables
see also
varrays
Object Type Translator (OTT), 4-12
object types, 4-11
object views, 3-35,
4-11,
4-12
object-relational technology, 4-10
Objects for OLE, 3-86
OCI enhancements, 3-84
API to append data to LOBs, 3-34
AQ support, 3-38
array DMLs, 3-84
asynchronous event notification, 3-85
collection locator, 3-34
direct path load, 3-23
DML returning, 3-84
LOBs, 3-34
NLS interface, 3-43
non-blocking OCI, 3-85
object cache, 3-36
OCI callback registrations, 3-84
OCIDescribeAny, 3-85
Open/Close/IsOpen API for LOBS, 3-34
UCS2 (fixed-width Unicode) support, 3-43
OCI non-deferred linking, 7-4
OCI single-task linking, 7-5
OCI support for client notification, 3-38
see also
OCI enhancements, asynchronous event notification
OiD. See Oracle Internet Directory.
online index builds, 3-41
online read-only tablespaces, 3-42
optimizer
and remote join enhancement, 3-68
and ROLAP enhancement, 3-24
extensible, 3-32
plan stability, 3-37
option factoring matrix, 5-2
Oracle Advanced Security, 3-70
integrated security and directory services, 3-72
RADIUS, 3-72
SSL, 3-70
Oracle Advanced Security option, 7-8
Oracle Connection Manager, 4-6
Oracle Database Configuration Assistant, 3-59,
3-62
Oracle Enterprise Login Assistant, 2-9
Oracle Enterprise Manager, 2-3,
3-60
connect-time failover, 3-76
static service information in LISTENER.ORA, 3-76
Oracle Enterprise Security Manager, 2-9
Oracle Internet Directory, 3-70,
3-74
Oracle Management Server (OMS), 3-60
Oracle Parallel Server, 3-61 to
3-63
cache fusion, 3-61
database configuration, 3-62
distributed lock manager (DLM), 3-62
Group Membership Services (GMS), 3-62
installation, 3-62
instance affinity for jobs, 3-63
inter-process communication protocol, 3-62
Oracle Parallel Server Assistant, 3-63
Oradebug, 3-62
see also,
OPSM
Oracle Parallel Server Assistant, 3-62
Oracle Parallel Server Management (OPSM), 3-62
Group Membership Services (GMS), 3-62
Oracle Parallel Server Assistant, 3-62
Parallel Server Manager, Oracle, 3-62
Oracle Security Server, 3-70,
3-72,
7-8
Oracle Software Packager, 3-58
Oracle Spatial, 2-7,
3-10
Oracle Time Series, 3-13
Oracle Universal Installer, 2-4,
3-58,
3-62
Oracle Visual Information Retrieval, 3-12
Oracle Wallet Manager, 2-8,
3-73
Oradebug, 3-62
OSS. See Oracle Security Server.
P
packages
DBMS_APPLICATION_INFO, 3-28
DBMS_DEBUG, 3-80
DBMS_JOB, 3-63
DBMS_LOB, 3-34
DBMS_OLAP, 3-22
DBMS_PROFILER, 3-80
DBMS_REPAIR, 3-40
DBMS_RESOURCE_MANAGER, 3-49
DBMS_RESOURCE_MANAGER_PRIVS, 3-49
DBMS_RLS, 3-69
DBMS_SQL, 3-79
DBMS_STATS, 3-26
DBMS_TRACE, 3-80
OUTLN_PKG, 3-37
UTL_COLL, 3-34
UTL_REF, 3-80
parallel ANALYZE, 4-2
parallel DML, 3-46,
4-4
parallel index scans, 4-4
parallel query, 4-4
automated tuning, 3-27
Parallel Server Manager, Oracle, 3-62
parallelization of aggregate distinct queries, 3-25
parameters
passing by reference, 3-80
partition views, 7-6
partitioning, 2-11,
4-2
"rolling window", 2-11
new partitioning methods
composite, 3-46
hash, 3-46
local indexes, 3-46
queries, DML, and DDL for, 3-46
of index-organized tables, 3-47
of object tables, 3-37
of tables containing user defined types, 3-37
of tables with LOBs, 3-47
range partitioning enhancements
merging partitions, 3-45
updatable partition keys, 3-46
partitions
elimination, 3-47
plan stability for optimizer, 3-37
PL/SQL, 3-78
autonomous blocks, 3-78
bulk binds, 3-79
dynamic SQL
DBMS_SQL package, 3-79
increased package body size, 3-81
invoker rights, 3-79
monitoring and analysis of program execution
DBMS_DEBUG, 3-80
DBMS_PROFILER, 3-80
DBMS_TRACE, 3-80
NOCOPY parameter passing mode, 3-80
parameter passing by reference, 3-80
procedures for supporting REF-based operations
UTL_REF package, 3-80
purity rules relaxed, 3-81
see also
external procedures (routines)
PL/SQL Server Pages, 2-6
precompilers
enhancements, 3-81
Pro*C/C++, 3-81
Pro*COBOL, 3-82
program interfaces, 3-78 to
3-87
publish/subscribe
client notification, 3-38
database event publication, 3-39
publishers, 3-38
rules-based subscriptions, 3-38
subscribers, 3-38
publish/subscribe, AQ based, 3-38
Q
query rewrite, 2-12
R
RADIUS, 3-72
range partitioning, 3-45
read-only databases, 3-51
recoverability and availability enhancements
multiple ARCH processes, 3-50
multiple, remote archive destinations, 3-50
see also
automated standby databases
Remote Authentication Dial-In User Service. See RADIUS
remote join enhancements, 3-67
Reorganizing non-partitioned table with ALTER TABLE MOVE clause, 3-42
replication, 4-9
Replication Manager, 3-66
see also
advanced replication
Replication Manager, 3-66
reverse key indexes, 4-14
ROLAP enhancements, 3-24
ROLLUP operation, GROUP BY clause, 3-24
ROWIDs
logical, 3-29
universal, 3-29
S
SAMPLE function, 3-24
Secure Socket Layer. See SSL
security enhancements, 3-68 to
3-77
application development, 3-69
fine-grained access control, 3-69
integrated security and directory services, 3-72
multi-tier authentication and authorization, 3-78
native authentication on Windows NT, 3-77
SERIALIZABLE=TRUE, 7-2
Server Manager, 7-7
service naming, Net8, 3-75
SGADEF file, 7-7
single sign-on, 4-9
single-table-only hash clusters, 3-26
single-task linking, 7-5
Software Packager, Oracle, 3-58
sort improvements, 3-26
spatial data, 3-10
SQL, 2-14
analytic functions, 2-10
SQL*Loader, 3-36,
3-47,
3-56
SQL92_SECURITY initialization parameter, 7-2
SSL, 2-8,
3-70
Public Key Infrastructure, 3-73
X.509v3 certificates, 3-71
star-query optimization, 4-3
statistics generation for long running operations, 3-27
stored procedures, Java, 3-18
summary management, 3-21
CREATE MATERIALIZED VIEW statement, 3-22
dimensions (dimension schema object), 3-22
materialized views, 3-21
query rewrite, 3-22
refreshing materialized views, 3-22
summary advisory functions package (DBMS_OLAP), 3-22
T
tables
drop column support, 3-41
temporary, 3-42
tablespace point-in-time recovery, 4-6
tablespaces
locally managed, 3-41
online read-only, 3-42
point-in-time recovery, 4-6
transportable, 3-23
temporary tables, 3-42
THE keyword for subqueries, 7-7
Time Series, 3-13
transaction recovery
fast-start checkpointing, 3-51
Fast-Start on-demand rollback, 3-51
Fast-Start parallel rollback, 3-52
inter-transaction, 3-52
intra-transaction, 3-52
transparent application failover, 4-8
transportable tablespaces, 3-23
triggers
on DATABASE and SCHEMA, 3-39
on nested table view columns, 3-35
with CALL to a procedure as trigger body, 3-39
TRIM function, 3-44
U
Universal Installer, 3-58,
3-62
universal ROWIDs (UROWIDs), 3-29
UROWID datatype, 3-29
USE_STORED_OUTLINES session parameter, 3-37
user defined object identifiers, 3-34
user-defined operators, 3-31
V
V$OPTION table, 5-13
V$SESSIONS_LONGOPS view, 3-27
Version 6, 7-6
value subqueries
argument to a type constructor or function, 3-36
in VALUES clause of INSERT statement, 3-36
varrays
storage parameters for storing as LOBs, 3-35
virtual private database, 3-45,
3-68
Visual Information Retrieval, 3-12
W
Wallet Manager, Oracle, 2-8,
3-73
WebDB, 2-6,
3-2,
3-5
X
X.509 certificates, 3-72
X.509v3 certificates, 3-71,
3-73
XA support, 4-9
XML Class Generator, 2-6
XML Parser for Java, 2-6
Z
zero-length strings, 7-2
Copyright © 1999 Oracle Corporation.
All Rights Reserved.
Library
Product
Contents