A
Oracle8i Options and Features

This appendix contains the following sections:

• Oracle8i Options

• Oracle8i Features

• The V$OPTION Table

  Note: This information is from Oracle8i, Release 3 (8.1.7). When information for Oracle9i is available for Oracle9i Features and Options by Edition, the information about Oracle8i, Release 3 (8.1.7) will replace this information. Oracle9i Features and Options by Edition is located in the Oracle9i Release 1 README. Oracle8i Releases 1 and 2 are different from Release 3. Users should consult the version of the document corresponding to the software being used.

Oracle8i Options

Table A-1 describes options available in each edition of Oracle8i, Release 3 (8.1.7).

See Also: Oracle8i documentation at http://technet.oracle.com for detailed information about specific options

Table A-1 Oracle8i Release 3 (8.1.7) Options  

Option	Oracle8i Standard Edition	Oracle8i Enterprise Edition	Notes
Oracle Advanced Security	N	Y	Oracle Advanced Security provides a comprehensive range of network security features that increase security and user reliability in distributed networks. Through support of industry standards such as SSL and X.509 for public key infrastructure and RADIUS for integration with existing infrastructures and enhanced authentication choices, Oracle Advanced Security protects your investment in hardware and software. Through support of single sign-on services such as Kerberos, and enhanced user authentication devices including smartcards and biometric devices, Oracle Advanced Security ensures user reliability and simplifies account management. Encryption technology provided by Oracle Advanced Security provides strong protection for all data in your network. Oracle Advanced Security also includes a restricted use license of Oracle Internet Directory for enterprise user and authorization management.
Oracle interMedia	Y	Y	Oracle interMedia enables Oracle8i to manage text, documents, image, audio, video, and locator data in an integrated fashion with other enterprise information. It includes Internet services supporting popular Web client interfaces, Web development tools, Web servers, and streaming media servers. It provides a higher level of services for database applications written in Java, C++, and traditional 3GLs using modern class library interfaces, or PL/SQL and Oracle Call Interface, through native support for image, audio and video data types, data attribute management, and operators. Functionality previously found in separate Oracle products, such as ConText, has been significantly enhanced and is now part of the interMedia product.
Oracle Internet Directory	Y	Y	Oracle Internet Directory is an LDAP (Lightweight Directory Access Protocol) v3 compliant directory server built on top of Oracle8i Enterprise Edition. A directory server is an object-oriented database repository and application that maintains hierarchically organized information. LDAP directory services are used to manage information about network objects such as user information (user names, group names, security/authorization information, preferences), application information (interfaces, locations, load-balancing information), and network asset information (databases, application servers, printers, file servers, hardware). Oracle Internet Directory is designed to leverage the scalability, availability, and security features of the Oracle8i platform to meet the needs of carriers, service providers, and large extranet sites. Oracle Internet Directory is a stand-alone product that includes a restricted use license of Oracle8i Enterprise Edition. However, all editions of the Oracle8i database include a restricted use license of Oracle Internet Directory v2.0.6 for the purposes of storing RDBMS instance names, enterprise domains, user-schema mappings, enterprise roles, and storage of Net8 naming and connect descriptor information.
Oracle Internet File System (iFS)	Y	Y	Oracle iFS brings the worlds of structured and unstructured data together into a powerful, easy-to-manage document-centric repository accessible via all major Internet protocols. Oracle iFS makes it possible to treat an Oracle8i database like a shared network drive. This means that users can store and retrieve files managed by the database as if they were files managed by a file server. End users can easily access files and folders in Oracle iFS via a variety of protocols, such as HTML, FTP, and IMAP4, giving them universal access to their data. Advanced searching capabilities make it easy to rapidly locate information contained in Oracle iFS, other content management features help organize and manage data in ways not possible on other file systems. The iFS development environment makes it easy to develop applications using a wide range of content, all with a single skill set using Internet standard languages like XML and Java. And, finally, everything in Oracle iFS is built on top of the reliable, portable, scalable, and secure Oracle8i server. iFS is included at no charge with all editions of the Oracle8i database.
Oracle8i JVM	Y	Y	Oracle has integrated a fast, scalable, highly available, and secure Java Virtual Machine (Java VM) with the Oracle8i database server. The Oracle8i JVM, formerly known as Oracle JServer, provides an ideal platform on which to deploy enterprise applications written in Java. Oracle8i JVM supports a variety of application programming models including Java stored procedures and triggers, Java methods of object-relational types, CORBA objects, Enterprise JavaBeans, Java Servlets and JavaServer Pages. It also supports a variety of standards-based protocols such as IIOP and HTTP, in addition to Net8. The Oracle8i JVM also includes the JVM Accelerator, which provides the ability to deploy Java code in natively compiled form for execution on the Oracle8i server, producing significant performance enhancement.
Oracle8i Lite	N	N	Oracle8i Lite is a small footprint Java-enabled database that brings enterprise applications to mobile devices such as laptops, handheld computers, PDAs, information appliances, or wherever a persistent network connection is unavailable. Oracle8i Lite provides the following services: Internet Lite, a set of services that facilitate deployment, development, and management of mobile Web applications. EnterpriseSync Lite, a set of services that enables reliable and scalable synchronization of data and applications between Oracle8i Lite and central database servers. Advanced Queuing Lite provides application messaging services that are compatible with Oracle8i advanced queuing and enables development of mobile and message based applications. Oracle8i Lite can replicate to Oracle8i and Oracle8i Enterprise Edition and is an optional product.
Oracle Parallel Server	N	Y	The Oracle Parallel Server architecture and management infrastructure combines the benefits of cluster scalability and availability with single system management capabilities. Oracle Parallel Server fully exploits clustered systems for database applications by delivering the following benefits: High Availability: Cluster technology insulates application and database users from hardware and software failures. Oracle Parallel Server architecture enables all the nodes of the system to access all the data and provides inherent fault resilience. Cluster Scalability: Clustering enables more users and greater transaction throughput, especially for enterprise applications and Internet commerce applications. Oracle Parallel Server achieves greater scalability by fully exploiting the expanded CPU, memory and disk resources of the clustered system to drive more transactions. Single System Manageability: Oracle Parallel Server's Single System View technology simplifies manageability by reducing the complexity of managing a server cluster. With Single System View, an entire cluster of servers appears as one system to the administrator.
Oracle Partitioning	N	Y	Oracle Partitioning enhances the data management environment for OLTP, data mart, and data warehouse applications by adding significant manageability, availability, and performance capabilities to large underlying database tables and indexes. Oracle Partitioning permits large tables to be broken into individually managed smaller pieces, while retaining a single application-level view of the data. Range, hash, and composite (range combined with hash) partitioning methods are supported. Oracle Partitioning is also especially useful in an Oracle Parallel Server configuration, improving performance in clustered environments, as well as large OLTP and data warehouse sites.
Oracle Portal	Y	Y	Oracle Portal (formerly WebDB) offers a complete solution for configuring and deploying an Enterprise Information Portal. It provides a framework for integration and secure access to corporate information, a customizable environment for personalization, and a set of services to manage portal deployment and expansion.
Oracle Programmer	N	N	Oracle Programmer provides a rich set of interfaces for developers who build enterprise applications that access and manipulate Oracle8i data and schemas. To fully support Java, Oracle Programmer includes SQLJ, the embedded SQL interface for Java that simplifies Java access to the Oracle8i database, and JPub, which is used to map SQL objects and collections to Java and vice versa. Oracle Programmer is a family of products consisting of: Three embedded SQL-style interfaces: Precompilers, SQL*Module, and SQLJ Three call level interfaces: Oracle Call Interface, ODBC, and JDBC Oracle Objects for OLE Two utilities to generate host-language bindings from database schemas: Object Type Translator and JPub
Oracle Spatial	N	Y	Oracle Spatial allows users and application developers to seamlessly integrate their spatial data into enterprise applications. Oracle Spatial facilitates analysis based on the spatial relationships of associated data, like the proximity of store locations to customers within a given distance and sales revenue per territory. Oracle Spatial manages spatial data in an industry-standard database, resulting in application integration that takes place at the data server. This enables vendor tools and applications to access spatial data directly from Oracle8i, increasing interoperability and minimizing costs.
Oracle Enterprise Manager Packs
Oracle DBA Management Pack	Y	Y	Oracle Enterprise Manager includes at no charge the DBA Management Pack, which is a set of assistants and database management tools that automate and simplify the common tasks of database administration.
Oracle Tuning Pack	N	Y	Oracle Tuning Pack provides database administrators with expert performance management for the Oracle environment, including SQL tuning and storage optimization.
Oracle Diagnostics Pack	N	Y	Oracle Diagnostics Pack enables database administrators to perform advanced monitoring, diagnosis, and planning for the Oracle environment.
Oracle Change Management Pack	N	Y	Oracle Change Management Pack eliminates errors and loss of data when upgrading databases to support new applications. The pack analyzes the impact and complex dependencies associated with application change and automatically performs database upgrades.
Oracle Standard Management Pack	Y		Oracle Standard Management Pack is a subset of Oracle Tuning Pack, Oracle Change Management Pack and Oracle Diagnostics Pack. It provides advanced functionality to assist in managing and tuning Oracle8i standard edition databases and applications.

Oracle8i Features

Table A-2 lists the features available in Oracle8i, Release 3 (8.1.7).

See Also: Oracle8i documentation at http://technet.oracle.com for detailed information about specific features, and "Oracle8i Lite" for Oracle8i Lite features and functionality

Area	Feature	Oracle8i Standard Edition	Oracle8i Enterprise Edition	Notes
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

The V$OPTION Table

To check the values for different options on your database, query the V$OPTION table as in the following example:

SQL> SELECT * FROM V$OPTION;

The response, of course, varies depending upon the specific installation. A sample result might be as follows:

PARAMETER	VALUE
Partitioning	TRUE
Objects	TRUE
Oracle Parallel Server	FALSE
Advanced replication	TRUE
Bit-mapped indexes	TRUE
Connection multiplexing	TRUE
Connection pooling	TRUE
Database queuing	TRUE
Incremental backup and recovery	TRUE
Instead-of triggers	TRUE
Parallel backup and recovery	TRUE
Parallel execution	TRUE
Parallel load	TRUE
Point-in-time tablespace recovery	TRUE
N-tier authentication/authorization	TRUE
Function-based indexes	TRUE
Plan Stability	TRUE
Online index segment creation	TRUE
Index segment coalesce	TRUE
Managed Standby	TRUE
Materialized view rewrite	TRUE
Materialized view warehouse refresh	TRUE
Database Resource Manager	TRUE
Spatial	TRUE
Export transportable tablespaces	TRUE
Transparent Application Failover	TRUE
Fast start recovery	TRUE