| Oracle® Database Licensing Information 10g Release 2 (10.2) Part Number B14199-02 |
|
|
View PDF |
| Oracle® Database Licensing Information 10g Release 2 (10.2) Part Number B14199-02 |
|
|
View PDF |
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.
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 (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 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 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 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 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 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 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.
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.
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.
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.
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.
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.
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
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.
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.
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.
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.
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.
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
In addition to the options and packs described in this chapter, Oracle provides two additional products for specific customer environments.
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 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.
