Oracle9i Database New Features
Release 1 (9.0.1)
Part Number A90120-02
Go To Documentation Library
Home		 Go To Product List
Book List		 Go To Table Of Contents
Contents		 Go To Index
Index
Master Index
Feedback

Go to previous page Go to next page

B
Oracle8 Options and Features

This appendix contains the following sections:

Oracle8 Options

Table B-1 describes the options available in Oracle8.

See Also:

Oracle8 documentation at http://technet.oracle.com for more detailed information about specific options 

Table B-1 Oracle8 Options  
Feature   Oracle8   Oracle8 Enterprise Edition   Notes and References  

Oracle8 Options (available only for the Oracle8 Enterprise Edition, at extra cost)  

Objects Option 

N 

Y 

The Objects option allows data to be represented, accessed, manipulated, and stored as business objects.

It allows the definition of object types and all features that use object types, including object tables, object views, the object cache, extended Oracle Call Interface features, the object features of Pro*C, extended SQL and PL/SQL support of object capabilities.

No CREATE TYPE, ALTER TYPE, or CREATE OR REPLACE TYPE statements are possible without this option.

Note: INSTEAD OF triggers are available with the Oracle8 Enterprise Edition, even without the objects option, and can apply to relational views. Also note that LOBs (large objects) are included in both Oracle8 and the Oracle8 Enterprise Edition. 

Partitioning Option 

N 

Y 

The Partitioning option allows the definition of partitions of tables and indexes. This feature is useful for OLTP and Data Warehousing users. Note that this option is required for parallel index scans and parallel DML (insert, update, and delete). Note also that partition views, a feature of Oracle7 release 7.3, is included in the Oracle8 Enterprise Edition without this option.

No CREATE PARTITION statements are possible without this option. 

Advanced Networking Option 

N 

Y 

The Advanced Networking option provides client/server, server/server network security using encryption and data integrity checking as well as enhanced user authentication services. 

Enterprise Manager Performance Pack  

N 

Y 

The Oracle Enterprise Manager Performance Pack provides an advanced set of tools for managing database environments. It consists of six applications for advanced diagnostics, monitoring, and tuning of Oracle environments.  

Parallel Server Option 

N 

Y 

The Parallel Server option allows multiple nodes of a loosely-coupled system (such as a cluster or massively parallel platform) to share access to a single database, for increased scalability and availability. It includes client-side failover and, on some platforms, inter-node parallel query. 

Oracle8 Features

Table B-2 describes the features available in Oracle8.

See Also:

Oracle8 documentation at http://technet.oracle.com for more detailed information about specific features 

Table B-2 Oracle8 Features  
Feature   Oracle8   Oracle8 Enterprise Edition   Notes and References  

Systems Management and Availability  

Enterprise Manager  

Y 

Y 

 

Enterprise Manager Performance Pack  

N 

Y 

 

Server Managed Backup and Recovery  

Y 

Y 

 

Recovery catalog for online backup 

Y 

Y 

 

Online recovery 

Y 

Y 

 

Incremental backup and recovery 

N 

Y 

 

Parallel backup and recovery 

N 

Y 

Oracle8 can only allocate one recovery manager channel at a time, thus limiting the parallelism to one stream. The Oracle8 Enterprise Edition allows unlimited parallelism. 

Legato Storage Manager 

Y 

Y 

 

Point-in-time tablespace recovery 

N 

Y 

 

Fail Safe for Oracle8 on NT 

Y 

Y 

This feature is available on Windows NT.  

Datawarehouse/VLDB Features  

Bit-mapped indexes 

N 

Y 

 

Star Query optimization 

Y 

Y 

In Oracle8, star query processing is the algorithm that utilizes B-tree indexes. In the Oracle8 Enterprise Edition, the parallel bitmap index join algorithm can also be utilized. 

Parallel Execution 

N 

Y 

 

Parallel Load  

N 

Y 

 

Parallel Query  

N 

Y 

 

Parallel DML (INSERT, UPDATE, and DELETE) 

N 

Y 

This feature requires the Partitioning Option. 

Parallel index scans 

N 

Y 

This feature requires the Partitioning Option. 

Parallel Bitmap Star Joins 

N 

Y 

 

Parallel Index Build 

N 

Y 

 

Parallel Analyze 

N 

Y 

This feature requires the Partitioning Option. 

Programming Interfaces 

 

Oracle Call Interface  

Y 

Y 

 

Objects for OLE  

Y 

Y 

 

ODBC driver 

Y 

Y 

 

Pro*C/C++ 

Y 

Y 

This feature is available at extra cost as part of Oracle Programmer. 

Object Features  

object references (REFs) 

Y 

Y 

 

object collections 

Y 

Y 

 

nested tables 

Y 

Y 

 

    variable arrays (varrays)

 

Y 

Y 

 

object views 

Y 

Y 

 

Distributed Features  

Distributed queries  

Y 

Y 

 

Distributed transactions  

Y 

Y 

 

    Two-phase commit

 

Y 

Y 

 

    XA

 

Y 

Y 

 

Heterogeneous Services 

Y 

Y 

 

Basic Replication 

Y 

Y 

 

    Read-only snapshots

 

Y 

Y 

 

    Subquery subsetting

 

Y 

Y 

 

    Primary key based
    snapshots

 

Y 

Y 

 

    Internal triggers

 

Y 

Y 

 

    Replicated LOBs

 

Y 

Y 

 

Advanced Replication 

N 

Y 

 

    Updatable snapshots

 

N 

Y 

 

    Multimaster replication

 

N 

Y 

 

    Conflict detection and resolution

 

N 

Y 

 

    Replication Manager

 

N 

Y 

 

    Parallel propagation

 

N 

Y 

 

    Minimize communication

 

N 

Y 

 

Networking Features  

Oracle Names 

Y 

Y 

 

Oracle Connection Manager 

N 

Y 

 

Connection Pooling  

Y 

Y 

 

Connection Multiplexing  

Y 

Y 

 

MultiProtocol Connectivity  

N 

Y 

 

Oracle Security Server  

Y 

Y 

 

Other Features  

Advanced Queuing 

N 

Y 

Advanced Queuing supports two types of message payloads--RAW and structured (where the structure is specified by an object type). Without the Objects option, users can only use RAW queues. Both single-consumer and multi-consumer RAW queues are available without the objects option.

See Oracle8 Application Developer's Guide for details. 

Reverse key indexes 

Y 

Y 

 

Password management 

Y 

Y 

 

Index-organized tables 

Y 

Y 

 

PL/SQL stored procedures, triggers 

Y 

Y 

 

INSTEAD OF triggers 

N 

Y 

This feature can be used with relational views as well as object views. Object capabilities require the Objects option. 

External procedures  

Y 

Y 

 

National Language Support 

Y 

Y 

 

LOB support 

Y 

Y 

 

Data Cartridges (extended datatype support; available at extra cost)  

ConText Cartridge 

Y 

Y 

The ConText Cartridge offers full text retrieval. 

Video Cartridge 

Y 

Y 

 

Image Cartridge 

N 

Y 

For more information, see Oracle8 Image Cartridge User's Guide. 

Visual Information Retrieval Cartridge 

N 

Y 

For more information, see Oracle8 Visual Information Retrieval Cartridge User's Guide. 

Time Series Cartridge 

N 

Y 

Note: To add functions or types to the Time Series Cartridge requires the Objects option.

For more information, see Oracle8 Time Series Cartridge User's Guide. 

Spatial Data Cartridge 

N 

Y 

For more information, see Oracle8 Spatial Cartridge User's Guide and Reference. 
Go to previous page Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.
All Rights Reserved.
Go To Documentation Library
Home		 Go To Product List
Book List		 Go To Table Of Contents
Contents		 Go To Index
Index
Master Index
Feedback