Skip Headers
Oracle® Database Licensing Information
10g Release 2 (10.2)

Part Number B14199-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

2 Options and Packs

This chapter describes the separately licensed Oracle Database options, management packs, and other products you can purchase to enhance the capabilities of Oracle Database in specific application environments. This chapter contains the following sections:

You may not use the options, packs, or products described below without separately purchased licenses. The fact that these options, packs, or products may be included in product CDs or downloads or described in documentation that you receive does not authorize you to use them without purchasing appropriate licenses.

Oracle Database Options

All the Oracle Database options can be purchased with Oracle Database Enterprise Edition. Real Application Clusters is included with Oracle Database Standard Edition. You cannot purchase any options with Oracle Database Standard Edition One. The Personal Edition includes all options except Real Application Clusters at no additional cost.

Oracle Real Application Clusters

Oracle Real Application Clusters (RAC) is a database computing environment that harnesses the processing power of multiple interconnected computers using clustering technology. RAC provides unlimited scalability and high availability for all applications. RAC makes the database highly available in the presence of computer hardware or software failure: in the event any computer in the cluster fails, the database continues to provide service on the surviving computers in the cluster. RAC provides scalable performance: as demand for database throughput grows, additional computers can be added to the database cluster with no downtime. RAC supports a single-system image for ease of management. RAC also provides a complete and integrated stack of clustering software on all platforms; third-party clusterware software is not required. Finally, RAC provides cluster file system capability on the Windows, Linux, and Solaris platforms.

Oracle Partitioning

Oracle Partitioning enhances the data management environment for OLTP, data mart, data warehouse, and content management applications by adding significant manageability, availability, and performance capabilities to large underlying database tables and indexes. Oracle Partitioning lets you store large tables as individually managed smaller pieces, while retaining a single application-level view of the data. Range, hash, list, and composite (range combined with hash and range combined with list) partitioning methods are supported.

Oracle Data Mining

Oracle Data Mining enables companies to build advanced business intelligence applications that mine corporate databases, reveal new patterns and relationships, and integrate that information into business applications. This option embeds data mining functionality into Oracle Database for making classifications, predictions, and associations. All model-building, scoring, and metadata management operations are accessible by way of either a Java or PL/SQL API.

Oracle Advanced Security

Oracle Advanced Security provides transparent data encryption of data stored in the database, the encryption and optimized compression of disk-based backups of the database, and also network encryption for data traveling across the network between the database and client or mid-tier applications. In addition it provide a complete suite of strong authentication services to Oracle Database. Network encryption is implemented using industry-standard data encryption and data integrity algorithms. This feature provides a choice of algorithms and cipher strengths for deployment. Strong authentication services support a comprehensive suite of industry-standard third-party authentication options. The authentication options include single sign-on services to the Oracle Database by interoperating with existing authentication frameworks and two-factor authentication choices such as smart cards and token cards.

Users wishing to use Enterprise User Security in Oracle Database Enterprise Edition no longer need to license the Oracle Advanced Security Option for password-based authentication. However, they must license the Oracle Identity Management Option, which includes Oracle Internet Directory (OID). Users wishing to use stronger authentication alternatives (such as Kerberos or PKI) for Enterprise User Security must license Oracle Advanced Security and Oracle Identity Management. Oracle Identity Management is an option to the Oracle Application Server 10g Standard Edition product. Any Oracle Advanced Security licenses purchased on or before January 31, 2004, have restricted use of the Oracle Identity Management option to support enterprise user security. Please contact your Oracle sales representative for additional information.

Oracle Label Security

Oracle Label Security provides sophisticated and flexible security based on row labels for fine-grained access control. This option employs labeling concepts used by government, defense, and commercial organizations to protect sensitive information and provide data separation. It includes a powerful tool to manage policies, labels, and user label authorizations.

By default, Oracle Label Security is configured to use Oracle Database for all policy management. Users interested in centralized policy management using the Oracle Identity Management infrastructure must additionally license Oracle Identity Management. Please contact your Oracle sales representative for additional information.

Oracle On-Line Analytical Processing (OLAP)

Oracle OLAP is a scalable, high-performance calculation engine with fully integrated management and administration for delivering analytic applications. Fully integrated in the database, this option provides a complete set of analytic functions. Predictive analysis can be used, for example, to forecast market trends, predict product manufacturing requirements, and build enterprise budgeting and financial analysis systems. Using complex, multidimensional queries and calculations, information such as market shares and net present value can be derived. The Java OLAP API provides efficient object-orientation for building applications that require complex analytic queries.

Oracle Spatial

Oracle Spatial provides advanced spatial analysis features for complex geographic information systems (GIS) applications, enterprise applications, and location-based services applications. It augments the Oracle Locator feature, which provides storage, analysis, and indexing of location data accessible through SQL and standard programming languages, supporting seamless integration of location data into enterprise applications, and use of any leading third-party GIS tool to access location data. Oracle Spatial advanced features include GeoRaster for storage, indexing, and analysis of image and gridded raster data, such as satellite imagery and remotely sensed data; a network data model that allows users to model and analyze link-node networks (graphs) for applications; a topology data model and schema to persistently manage topology; a fully functional geocoding engine and routing engine; and location-based analysis functions for business intelligence applications, including location-based classification, binning, association, and correlation. Oracle Spatial also supports spatial data manipulation and analysis such as buffer generation, area/distance calculations, linear referencing, and more.

Oracle Management Packs

The sections that follow describe the Oracle management packs. The management packs can be purchased only with Enterprise Edition. The features in these packs are accessible through Oracle Enterprise Manager Database Control, Oracle Enterprise Manager Grid Control, and APIs provided with Oracle Database software.

Oracle Change Management Pack

The Oracle Change Management Pack enables administrators to evaluate, plan, and implement database schema changes. Using the Change Management Pack, administrators can investigate and track changes, compare and synchronize objects and schemas, modify schema objects, evaluate the change impact, and if required undo changes that have been made previously. The Change Management Pack makes change management simple and efficient and minimizes chances for error, thereby reducing the opportunity for data loss and system down-time.

The Change Management Pack includes the following features:

  • Reverse engineer database and schema definitions

  • Capture and version baselines

  • Compare databases and schemas, or baselines

  • Copy database objects with data, with a subset of the data, or without data

  • Update database object definitions (ALTER TABLE)

  • Synchronize objects and schemas

  • Evaluate the impact of changes

  • Clone or propagate application schemas

In order to use the features listed above you must install the Java console version of Enterprise Manager, which you can find in the /companion directory of the installation medium. The use of this interface requires licensing of the Change Management Pack.

Oracle Diagnostic Pack

The Oracle Diagnostic Pack provides automatic performance diagnostic and advanced system monitoring functionality. The Diagnostic Pack includes the following features:

  • Automatic Workload Repository

  • Automatic Database Diagnostic Monitor (ADDM)

  • Performance monitoring (database and host)

  • Event notifications: notification methods, rules, and schedules

  • Event history and metric history (database and host)

  • Blackouts

  • Dynamic metric baselines

  • Monitoring templates

  • Memory-access based performance monitoring

In order to use the features listed above, you must purchase licenses for the Diagnostic Pack. The Diagnostics Pack functionality can be accessed by Enterprise Manager links as well as through the database server command-line APIs. The use of either interface requires a Diagnostic Pack license.

Enterprise Manager

To determine which links in Enterprise Manager Grid Control and Database Control are part of the Diagnostics Packs, click the Setup link on the top right-hand part of the Enterprise Manager Home page.

  • When you click the Setup link, the navigation bar contains the Management Pack Access link. Click this link.

  • This will take you to the Management Pack Access page, which allows you to grant and remove access from all the management packs.

    • For Enterprise Manager Database Control, click the Remove Access radio button for the Diagnostic Pack and click Apply.

    • For Enterprise Manager Grid Control, click the appropriate check box for the Diagnostic Pack and click Apply.

This will disable all the links and tabs associated with the Diagnostics Pack in Enterprise Manager. All the disabled links and tabs are part of the Diagnostics Pack and therefore require pack license.

Command-Line APIs

Diagnostics Pack features can also be accessed by way of database server APIs and command-line interfaces:

  • The DBMS_WORKLOAD_REPOSITORY package is part of this pack.

  • The DBMS_ADVISOR package is part of this pack if you specify ADDM as the value of the advisor_name parameter, or if you specify for the value of the task_name parameter any value starting with the ADDM prefix.

  • The V$ACTIVE_SESSION_HISTORY dynamic performance view is part of this pack.

  • All data dictionary views beginning with the prefix DBA_HIST_ are part of this pack, along with their underlying tables.

  • All data dictionary views with the prefix DBA_ADVISOR_ are part of this pack if queries to these views return rows with the value ADDM in the ADVISOR_NAME column or a value of ADDM* in the TASK_NAME column or the corresponding TASK_ID.

  • The following reports found in the /rdbms/admin/ directory of the Oracle home directory are part of this pack: awrrpt.sql, awrrpti.sql, addmrtp.sql, addmrpti.sql, awrrpt.sql, awrrpti.sql, addmrpt.sql, addmrpti.sql, ashrpt.sql, ashrpti.sql, awrddrpt.sql, awrddrpi.sql, awrsqrpi.sql, awrsqrpt.sql.

Oracle Diagnostics Pack Enterprise Manager Repository Views

  • Monitoring Views

    • MGMT$BLACKOUT_HISTORY

    • MGMT$BLACKOUTS

    • MGMT$ALERT_ANNOTATIONS

    • MGMT$ALERT_NOTIF_LOG

    • MGMT$TARGET_METRIC_COLLECTIONS

    • MGMT$METRIC_COLLECTIONS

    • MGMT$TARGET_METRIC_SETTINGS

    • MGMT$AVAILABILITY_CURRENT

    • MGMT$AVAILABILITY_HISTORY

    • MGMT$ALERT_CURRENT

    • MGMT$ALERT_HISTORY

    • MGMT$METRIC_DETAILS

    • MGMT$METRIC_CURRENT

    • MGMT$METRIC_HOURLY

    • MGMT$METRIC_DAILY

  • Template Views

    • MGMT$TEMPLATES

    • MGMT$TEMPLATE_POLICY_SETTINGS

    • MGMT$TEMPLATE_METRIC_COLLECTION

    • MGMT$TEMPLATE_METRIC_SETTINGS

Oracle Tuning Pack

The Oracle Tuning Pack provides database administrators with expert performance management for the Oracle environment, including SQL tuning and storage optimizations. The Oracle Diagnostic Pack is a prerequisite product to the Oracle Tuning Pack. Therefore, to use the Tuning Pack, you must also have a Diagnostic Pack. The Tuning Pack includes the following features:

  • SQL Access Advisor

  • SQL Tuning Advisor

  • SQL Tuning Sets

  • Reorganize objects

In order to use the features listed above, you must purchase licenses for the Tuning Pack. The Tuning Pack functionality can be accessed by the Enterprise Manager links as well as through the database server command-line APIs. The use of either interface requires licensing of the Tuning Pack.

Enterprise Manager

To determine which links in Enterprise Manager Grid Control and Database Control are part of the Diagnostics Packs, click the Setup link on the top right-hand part of the Enterprise Manager Home page.

  • When you click the Setup link, the navigation bar contains the Management Pack Access link. Click this link.

  • This will take you to the Management Pack Access page, which allows you to grant and remove access from all the management packs.

    • For Enterprise Manager Database Control, click the Remove Access radio button for the Tuning Pack and click Apply.

    • For Enterprise Manager Grid Control, click the appropriate check box for the Tuning Pack and click Apply.

This will disable all the links and tabs associated with the Tuning Pack in Enterprise Manager. All the disabled links and tabs are part of the Tuning Pack and therefore require pack license.

Command-Line APIs

Tuning Pack features can also be accessed by way of database server APIs. Use of the following PL/SQL packages requires a license for the Oracle Tuning Pack:

  • DBMS_SQLTUNE

  • DBMS_ADVISOR, when the value of the advisor_name parameter is either SQL Tuning Advisor or SQL Access Advisor.

  • The following report found in the /rdbms/admin/ directory of the Oracle home directory is part of this pack: sqltrpt.sql.

Oracle Configuration Management Pack

The Oracle Configuration Management Pack automates the time-consuming and often error prone process of software configuration, software and hardware inventory tracking, patching, cloning and policy management. The Configuration Management Pack includes the following features:

  • Database and Host Configuration

  • Deployments

  • Search configuration

  • Compare configuration

  • Policies, including Security checks and scoring

In order to use the features listed above, you must purchase licenses for the Configuration Management Pack. The Configuration Management Pack functionality can be accessed by the Enterprise Manager and through the Enterprise Manager repository views. The use of either interface requires licensing of the Configuration Management Pack.

In earlier releases, three additional features were part of this pack: Patch Deployment (Patch Database and View Patch Cache, Patch staging), Clone Oracle Home, and Clone Database. These features are no longer part of the Configuration Management Pack. They are now part of the Oracle Provisioning Pack, which is licensed with Enterprise Manager. However, if you have previously licensed the Configuration Management Pack for Oracle Database, you are entitled to use these features without licensing the Provisioning Pack.

Enterprise Manager

To determine which links in Enterprise Manager Grid Control and Database Control are part of the Configuration Management Pack click the Setup link on the top right hand part of the Enterprise Manager Home page.

  • When you click the Setup link, the navigation bar contains the Management Pack Access link. Click this link.

  • This will take you to the Management Pack Access page, which allows you to grant and remove access from all the management packs.

    • For Enterprise Manager Database Control, click the Remove Access radio button for the Configuration Management Pack and press the Apply button.

    • For Enterprise Manager Grid Control, click the appropriate check box for the Configuration Management Pack and press the Apply button.

This will disable all the links and tabs associated with the Configuration Management Pack in Enterprise Manager. All the disabled links and tabs are part of the Configuration Management Pack and therefore require pack license.

Configuration Management Pack Enterprise Manager Repository Views

  • Inventory Views

    • MGMT$TARGET

    • MGMT$TARGET_TYPE

    • MGMT$TARGET_TYPE_DEF

    • MGMT$TARGET_ASSOCIATIONS

    • MGMT$TARGET_MEMBERS

    • MGMT$TARGET_FLAT_MEMBERS

    • MGMT$TARGET_TYPE_PROPERTIES

    • MGMT$TARGET_PROPERTIES

    • MGMT$METRIC_CATEGORIES

    • MGMT$GROUP_FLAT_MEMBERSHIPS

  • Policy Definition Views

    • MGMT$POLICIES

    • MGMT$POLICY_PARAMETERS

    • MGMT$POLICY_VIOLATION_CTXT

    • MGMT$POLICY_VIOL_ANNOTATIONS

    • MGMT$POLICY_VIOL_NOTIF_LOG

  • Policy Association Views

    • MGMT$TARGET_POLICIES

    • MGMT$TARGET_POLICY_SETTINGS

    • MGMT$TARGET_POLICY_EVAL_SUM

    • MGMT$TARGET_COMPLIANCE_SCORE

  • Policy Violation Views

    • MGMT$POLICY_VIOLATION_CURRENT

    • MGMT$POLICY_VIOLATION_HISTORY

    • MGMT$POLICY_VIOLATION_CONTEXT

  • Configuration Views

    • MGMT$DB_TABLESPACES

    • MGMT$DB_DATAFILES

    • MGMT$DB_CONTROLFILES

  • Oracle Home Patching

    • MGMT$CPF_ADVISORY_INFO

    • MGMT$CPF_HOMES_INFO

    • MGMT$CPF_PATCH_INFO

    • MGMT$EM_HOMES_PLATFORM

    • MGMT$HOMES_AFFECTED

    • MGMT$PATCH_ADVISORIES

    • MGMT$APPL_PATCH_AND_PATCHSET

    • MGMT$APPLIED_PATCHES

    • MGMT$APPLIED_PATCHSETS

  • Linux Patching

    • MGMT$HOSTPATCH_HOSTS

    • MGMT$HOSTPATCH_GROUPS

    • MGMT$HOSTPATCH_GRP_COMPL_HIST

    • MGMT$HOSTPATCH_HOST_COMPL

  • Security Views

    • MGMT$ESA_ALL_PRIVS_REPORT

    • MGMT$ESA_ANY_DICT_REPORT

    • MGMT$ESA_ANY_PRIV_REPORT

    • MGMT$ESA_AUDIT_SYSTEM_REPORT

    • MGMT$ESA_BECOME_USER_REPORT

    • MGMT$ESA_CATALOG_REPORT

    • MGMT$ESA_CONN_PRIV_REPORT

    • MGMT$ESA_CREATE_PRIV_REPORT

    • MGMT$ESA_DBA_GROUP_REPORT

    • MGMT$ESA_DBA_ROLE_REPORT

    • MGMT$ESA_DIRECT_PRIV_REPORT

    • MGMT$ESA_EXMPT_ACCESS_REPORT

    • MGMT$ESA_KEY_OBJECTS_REPORT

    • MGMT$ESA_OH_OWNERSHIP_REPORT

    • MGMT$ESA_OH_PERMISSION_REPORT

    • MGMT$ESA_POWER_PRIV_REPORT

    • MGMT$ESA_PUB_PRIV_REPORT

    • MGMT$ESA_ROLE_ACCESS_REPORT

    • MGMT$ESA_SYS_PUB_PKG_REPORT

    • MGMT$ESA_TABSP_OWNERS_REPORT

    • MGMT$ESA_TABSP_OWNER_REPORT

    • MGMT$ESA_TRC_AUD_PERM_REPORT

    • MGMT$ESA_WITH_ADMIN_REPORT

    • MGMT$ESA_WITH_GRANT_REPORT

Other Oracle Products

In addition to the options and packs described in this chapter, Oracle provides two additional products for specific customer environments.

Oracle Programmer

Oracle Programmer is a separate Oracle product that provides a programmatic interface to any edition of Oracle Database for application programmers. Programmer provides a rich set of interfaces for developers who build enterprise applications that access and manipulate Oracle Database. This product is licensed separately from the Oracle Database products. Oracle Programmer is a family of the following products:

  • Three embedded SQL-style interfaces: precompilers, SQL*Module, and SQLJ

  • Two utilities to generate host-language bindings from database schemas: Object Type Translator and JPub

Oracle Database Lite

Oracle Database Lite provides efficient, reliable, and secure data management for applications running locally on mobile and small-footprint devices (handhelds, laptops, communicators, and so forth). Oracle Database Lite supports scalable synchronization of data between devices and any Oracle Database while offering complete management of users, devices, and applications. Oracle Database Lite requires a minimum of one Named User Plus license or the total number of actual users, whichever is greater.