Java Support |
SQLJ |
Y |
Y |
Requires Oracle Programmer |
Java Support |
JDBC Drivers |
Y |
Y |
|
Java Support |
Oracle8i JVM |
Y |
Y |
Includes support for Java2 (JDK 1.2); Java triggers, functions, and procedures; Enterprise Java Beans 1.1; JavaServer Pages 1.1 ; Servlets 2.2; and CORBA 2.0 |
OLTP/High Availability |
Optimizer statistics management |
Y |
Y |
|
OLTP/High Availability |
Readable standby database |
Y |
Y |
|
OLTP/High Availability |
Database resource management |
|
Y |
|
OLTP/High Availability |
Transparent Application Failover |
|
Y |
|
OLTP/High Availability |
Automated standby database |
|
Y |
|
OLTP/High Availability |
Online index build |
|
Y |
|
OLTP/High Availability |
Fast-start fault recovery |
|
Y |
|
OLTP/High Availability |
Advanced queuing |
|
Y |
|
OLTP/High Availability |
Plan stability |
|
Y |
|
OLTP/High Availability |
Oracle Parallel Server |
|
Y |
Extra cost option |
Data Warehouse and Very Large Database Support |
Star query optimization |
Y |
Y |
|
Data Warehouse and Very Large Database Support |
Parallel load |
Y |
Y |
|
Data Warehouse and Very Large Database Support |
CUBE and ROLLUP |
Y |
Y |
|
Data Warehouse and Very Large Database Support |
Import transportable tablespaces |
Y |
Y |
|
Data Warehouse and Very Large Database Support |
Direct Path Load API |
Y |
Y |
|
Data Warehouse and Very Large Database Support |
Analytic functions (such as rank, moving average, and ratio-to-report) |
|
Y |
|
Data Warehouse and Very Large Database Support |
Export transportable tablespaces |
|
Y |
|
Data Warehouse and Very Large Database Support |
Materialized views |
|
Y |
|
Data Warehouse and Very Large Database Support |
Parallel bitmap star query optimization |
|
Y |
|
Data Warehouse and Very Large Database Support |
Bitmap indexes |
|
Y |
|
Data Warehouse and Very Large Database Support |
Sample scan |
|
Y |
|
Data Warehouse and Very Large Database Support |
Parallel query |
|
Y |
|
Data Warehouse and Very Large Database Support |
Automated parallel query degree |
|
Y |
|
Data Warehouse and Very Large Database Support |
Parallel data manipulation language (DML) |
|
Y |
Requires Oracle Partitioning |
Data Warehouse and Very Large Database Support |
Parallel index scans |
|
Y |
Requires Oracle Partitioning |
Data Warehouse and Very Large Database Support |
Parallel index build |
|
Y |
|
Data Warehouse and Very Large Database Support |
Parallel collection of table statistics |
|
Y |
|
Data Warehouse and Very Large Database Support |
Oracle Partitioning |
|
Y |
Extra cost option |
Manageability |
Oracle Enterprise Manager |
Y |
Y |
|
Manageability |
Oracle Workflow Standard Edition |
Y |
|
|
Manageability |
Oracle Workflow Enterprise Edition |
|
Y |
|
Manageability |
Server managed backup and recovery |
Y |
Y |
|
Manageability |
Recovery Manager |
Y |
Y |
|
Manageability |
Online backup and recovery |
Y |
Y |
|
Manageability |
Legato Storage Manager |
Y |
Y |
|
Manageability |
Oracle Fail Safe for Oracle8i on NT |
Y |
Y |
|
Manageability |
Parallel backup and recovery |
|
Y |
|
Manageability |
Incremental backup and recovery |
|
Y |
|
Manageability |
Point-in-time tablespace recovery |
|
Y |
|
Manageability |
Duplexed backup sets |
|
Y |
|
Manageability |
Oracle DBA Management Pack |
Y |
Y |
|
Manageability |
Oracle Standard Management Pack |
Y |
|
|
Manageability |
Oracle Diagnostics Pack |
|
Y |
Extra cost option |
Manageability |
Oracle Tuning Pack |
|
Y |
Extra cost option |
Manageability |
Oracle Change Management Pack |
|
Y |
Extra cost option |
Distributed |
Replication to Oracle8i Lite |
Y |
Y |
Extra cost product |
Distributed |
Distributed queries |
Y |
Y |
|
Distributed |
Distributed transactions |
Y |
Y |
|
Distributed |
Heterogeneous services |
Y |
Y |
|
Distributed |
Single master replication |
Y |
Y |
Single master replication fully supports bi-directional replication between a single, updatable master site and multiple, updatable snapshot sites. The entire replicated environment can be controlled from Oracle Replication Manager. |
Distributed |
Multiple master replication |
|
Y |
Multiple master replication supports multiple, n-way connected, updatable master sites, each capable of supporting multiple, updatable snapshot sites for improved scalability and availability. Oracle Replication Manager also provides support for multiple masters. |
Networking and Security |
Net8 |
Y |
Y |
|
Networking and Security |
Oracle Internet Directory |
Y |
Y |
Restricted use license of Oracle Internet Directory v2.0.6 for the purposes of storing RDBMS instance names, enterprise domains and user-schema mappings, enterprise roles, and storage of Net8 naming and connect descriptor information |
Networking and Security |
Oracle HTTP Listener Powered by Apache |
Y |
Y |
|
Networking and Security |
Oracle Names |
Y |
Y |
|
Networking and Security |
Connection pooling |
Y |
Y |
|
Networking and Security |
Oracle Connection Manager: Multiplexing, multi-protocol connectivity, network access control |
|
Y |
|
Networking and Security |
N-tier authentication/ authorization |
|
Y |
|
Networking and Security |
Oracle Advanced Security |
|
Y |
Extra cost option |
Database Features |
Objects and extensibility |
Y |
Y |
|
Database Features |
LOB (large object) support |
Y |
Y |
|
Database Features |
National language support (NLS) |
Y |
Y |
|
Database Features |
PL/SQL stored procedures, triggers |
Y |
Y |
|
Database Features |
PL/SQL Server Pages |
Y |
Y |
|
Database Features |
Database event triggers |
Y |
Y |
|
Database Features |
Instead-of triggers |
Y |
Y |
|
Database Features |
Password management |
Y |
Y |
|
Database Features |
Long operations monitor |
Y |
Y |
|
Database Features |
Temporary tables |
Y |
Y |
|
Database Features |
Index-organized tables |
Y |
Y |
|
Database Features |
LogMiner |
Y |
Y |
|
Database Features |
Locally managed tablespaces |
Y |
Y |
|
Database Features |
Descending indexes |
Y |
Y |
|
Database Features |
Reverse key indexes |
Y |
Y |
|
Database Features |
Drop column |
Y |
Y |
|
Database Features |
Virtual private database |
|
Y |
|
Database Features |
Index coalesce |
|
Y |
|
Database Features |
Function-based indexes |
|
Y |
|
Database Features |
Indexes on NLS collating sequences |
|
Y |
|
Database Features |
Automatic literal conversion |
|
Y |
This feature automatically converts literal strings in a WHERE clause to bind variables, improving performance in some packaged applications. |
Programming Interfaces |
Pro*C and other precompilers |
Y |
Y |
Requires Oracle Programmer |
Programming Interfaces |
XML SQL Utility |
Y |
Y |
|
Programming Interfaces |
Native ODBC/OLEDB driver |
Y |
Y |
|
Programming Interfaces |
Microsoft Transaction Server integration |
Y |
Y |
This feature is available on Windows NT. |
Programming Interfaces |
COM Automation Feature |
Y |
Y |
This feature is available on Windows NT and Windows98. |
Programming Interfaces |
AppWizard for Visual Studio |
Y |
Y |
This feature is available on Windows NT and Windows98. |
Programming Interfaces |
Objects for OLE |
Y |
Y |
Requires Oracle Programmer |
Programming Interfaces |
Oracle Call Interface (OCI) |
Y |
Y |
Requires Oracle Programmer |
Programming Interfaces |
Oracle Programmer |
Y |
Y |
Extra cost option |
Content Management |
Oracle Internet File System (iFS) |
Y |
Y |
|
Content Management |
Oracle interMedia |
Y |
Y |
|
Content Management |
Oracle Portal |
Y |
Y |
|
Content Management |
Oracle Spatial |
|
Y |
Extra cost option |