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. Oracle Real Application Clusters is included with Oracle Database Standard Edition. You cannot purchase any options with Oracle Database Standard Edition One or Oracle Express Edition. The Personal Edition includes all options except Oracle Real Application Clusters at no additional cost.

Oracle Advanced Security

Oracle Advanced Security helps you protect sensitive information and comply with various privacy and compliance regulations including breach notification laws and the Payment Card Industry Data Security Standard (PCI-DSS) by enabling encryption inside the database that is transparent to applications.

If you wish to use Enterprise User Security in Oracle Database Enterprise Edition, you no longer need to license the Oracle Advanced Security Option for password-based authentication. However, you must license Oracle Internet Directory (OID). Any Oracle Advanced Security licenses purchased on or before January 31, 2004, have restricted use of the Oracle Internet Directory (OID) to support enterprise user security. Please contact your Oracle sales representative for additional information.

Oracle Advanced Security includes the following features:

  • Transparent Data Encryption (TDE) for columns

  • RMAN backup encryption

Network encryption (native network encryption and SSL/TLS) and strong authentication services (Kerberos, PKI, and RADIUS) are no longer part of Oracle Advanced Security and are available in all licensed editions of all supported releases of the Oracle database.

Oracle Data Mining

Oracle Data Mining enables you 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.

The Oracle Data Mining option includes the following features:

APIs and GUIs Supported to Access Algorithms:

  • PL/SQL API—for model build, model apply, and data transformations

  • Java API—for model build, model apply & data transformations

  • Oracle Data Miner (GUI)

  • Spreadsheet Add-in for Predictive Analytics

Algorithm Category and Supported Algorithms:

  • Classification

    • Naive Bayes

    • Decision Trees

    • Support Vector Machines

  • Regression

    • Support Vector Machines

  • Anomaly Detection

    • One Class Support Vector Machines

  • Attribute Importance

    • Minimum Description Length

  • Association Rules

    • A Priori

  • Clustering

    • Hierarchical K-Means Clustering

    • Hierarchical O-Clustering

  • Predictive Analytics (PL/SQL Packages)

    • Predict

    • Explain

  • Feature Extraction

    • Nonnegative Matrix Factorization

Oracle Database Vault

Oracle Database Vault lets you control who, when, and where data and applications can be accessed—protecting your business against the most common security threat: malicious internal users. Enforcing separation of duties, even among administrators, Oracle Database Vault additionally serves as a powerful preventive control to help comply with today's stringent compliance and privacy requirements.

  • It improves your ability to meet compliance requirements like Sarbanes-Oxley and other regulations that mandate control of access to, and release of, sensitive information

  • It controls access to application and database data, even by super-users and other highly privileged users

  • It enforces multi factor authorization via flexible business rules

  • It shows who is accessing what and when via over three dozen out-of-the-box security reports

Oracle Database Vault is an option for Oracle Database 10g. However, it has also been provided for an earlier release as well, specifically Oracle9i Database Release 2 (9.2.0.8), on a limited number of platforms. Please contact your Oracle Sales Representative if you are interested in Oracle Database Vault as an option on Oracle9i Database.

The Oracle Database Vault option includes the following features:

  • Realms

  • Separation of Duty

  • Factors

  • Command Rules

  • Rule Sets

Oracle In-Memory Database Cache

Oracle In-Memory Database Cache enables you to improve application transaction response time by caching a performance-critical subset of tables and table fragments from an Oracle database to the application tier. The table fragments are described through an extended SQL syntax and are cached into Oracle In-Memory Database Cache tables. Cache tables can be specified as read-only or updatable. Applications read and update the cache tables using standard SQL. Cache table hierarchy for related tables with foreign key constraints is maintained for data consistency. Automatic data synchronization between the cache and the Oracle database is provided.

Cache tables are managed like regular relational database tables within the TimesTen In-Memory Database. Thus, Oracle In-Memory Database Cache offers applications the full generality and functionality of a relational database, the transparent maintenance of cache consistency with the Oracle Database, and the real-time performance of an in-memory database. This Database option is ideal for caching performance-critical subsets of an Oracle database for improved response time in the application tier.

Oracle In-Memory Database Cache includes the following features:

  • Static and dynamic caching of Oracle database tables

  • Automatic data refresh from Oracle database to the in-memory cache

  • Automatic transaction write-through from the in-memory cache to the Oracle database

  • Automatic data aging with user-defined policies

  • Standard SQL functionality and database transaction semantics

  • Transactional replication with Active-Standby Pair topology

  • Real-time change notification using Transaction Log API (XLA)

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 and Access Management Suite. Please contact your Oracle sales representative for additional information.

The Oracle Label Security option includes the following features:

  • Label based access control (LBAC)

  • Multi-level security (MLS)

  • Label factors for Database Vault (Confidential, Sensitive)

  • User label authorizations (Confidential, Sensitive:PII)

  • Data labels (Sensitive: PII)

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.

The Oracle OLAP option includes the following features:

  • OLAP Cube Definition, Storage, and Querying

  • OLAP API and Metadata

  • Analytic Workspaces

  • SQL Access to OLAP Cubes

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.

The Oracle Partitioning option includes the following features:

  • Table Partitions and Subpartitions

  • Local Index Partitions and Subpartitions

  • Global Index Partitions and Subpartitions

  • Range Partitioning

  • Hash Partitioning

  • List Partitioning

  • Composite Partitioning

  • Subpartition Template

  • Fast Partition Split

  • Partition Exchange

Oracle Real Application Clusters

Oracle Real Application Clusters (Oracle 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 and Linux platforms.

Oracle Real Application Clusters includes the following features:

  • Real Application Clusters

  • Cluster Verification Utility

  • Automatic Workload Management

  • Connection Load Balancing

  • Fast Connection Failover

  • Hot Cluster Failover

  • Oracle Advanced Security SSL/TLS

Oracle Standard Edition and Oracle Real Application Clusters (Oracle RAC)

The license restrictions for Standard Edition must be adhered to. The maximum number of CPUs defined is for the entire cluster; it is not a per node maximum.

Oracle Clusterware is required; third-party clusterware is not permitted.

Automatic Storage Management (ASM) must be used to manage all database-related files. Third-party volume managers and file systems are not supported for this purpose. ASM is required for the storage of:

  • Database data files

  • Online logs

  • Archive logs

  • Control files

  • Server parameter files (spfiles)

  • Flash Recovery Area

RAW disk partitions are required for:

  • Voting disk

  • Oracle Cluster Registry

Local storage must be used for:

  • Oracle Home

  • Trace files

  • Dump files

No Oracle-maintained copies of any of the above files can exist in any other locations, with the following exception: Customers who want to manually script maintenance of a standby database can create a second copy of their archive logs outside of ASM on a local file system only, designated by the LOG_ARCHIVE_DEST_n parameter.

RMAN backups of files can reside on either a local or network mounted file system.

No other cluster software can be installed on the system, including, OCFS, OCFS2, third-party clusterware, third-party cluster volume managers, and third-party cluster file systems.

Oracle Real Application Testing

The Oracle Real Application Testing option comprises a suite of features that help protect database applications from undesirable impact of routine changes, such as hardware/software upgrades, configuration changes, platform migrations, and so forth. These features enable comprehensive testing of real-world applications so that any issues resulting from system changes are fully identified and addressed during testing, and when a change is finally made to the production system unexpected problems are minimized.

The Oracle Real Application Testing option includes the following features:

  • Database Replay

  • SQL Performance Analyzer (SPA)

  • SQL Tuning Sets (STS)

In order to use the features listed above, you must purchase licenses for the Oracle Real Application Testing option.

Note:

Use of SQL Tuning Set is also permitted with the Database Tuning Pack license. If you have either the Database Tuning Pack or Real Application Testing option, you are permitted to use SQL Tuning Sets.

Only partial Oracle Real Application Testing functionality is available with this release of Oracle Database. This functionality is provided is so that you can use this option to test database upgrades to Oracle Database 11g from Oracle Database 10.2.0.4 onward. The functionality available is:

  • Database Replay: Only Workload Capture capability is supported.

  • SQL Performance Analyzer: Only SQL capture into SQL Tuning Set capability is supported.

The above functionality can be accessed by Enterprise Manager as well as through the database server command-line APIs. The use of either interface requires an Oracle Real Application Testing option license.

Command-Line APIs

The Real Application Testing features can be accessed by way of the following database server APIs and command-line interfaces:

  • The DBMS_WORKLOAD_CAPTURE package is part of the Real Application Testing option.

  • The following subprograms of the DBMS_SQLTUNE package provide an interface to manage SQL tuning sets and are part of the Real Application Testing option as well as the Database Tuning Pack:

    • ADD_SQLSET_REFERENCE

    • CAPTURE_CURSOR_CACHE_SQLSETS

    • CREATE_SQLSET

    • CREATE_STGTAB_SQLSET

    • DELETE_SQLSET

    • DROP_SQLSET

    • LOAD_SQLSET

    • PACK_STGTAB_SQLSET

    • REMOVE_SQLSET_REFERENCE

    • SELECT_CURSOR_CACHE

    • SELECT_SQLSET

    • SELECT_WORKLOAD_REPOSITORY

    • UNPACK_STGTAB_SQLSET

    • UPDATE_SQLSET

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.

The Oracle Spatial option includes the following features:

  • Selected Spatial Functions

  • Linear Referencing System

  • GeoRaster Storage, Indexing and Querying

  • Network Data Model

  • Topology Data Model

  • Spatial Analysis and Mining Functions

  • Spatial Routing Engine

  • Geocoding Engine

  • Semantic Content Storage, Indexing and Querying (RDF/OWL Support)

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.

This section describes the following management packs:

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 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 and Patch Automation 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 Oracle Provisioning and Patch Automation 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 click Apply.

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

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 Database Reports

The following reports found are part of this pack:

  • On the Deployment and Configuration page: all reports

  • From the Monitoring page, the Alerts and Policy Violations link: all reports.

  • From the Monitoring page, the Disabled Policies link: all reports.

  • From the Security page, the Security Policy Overview link: all reports.

Configuration Management Pack Enterprise Manager Repository Views

  • 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_SYS_PUB_PKG_REPORT

    • MGMT$ESA_TABSP_OWNERS_REPORT

    • MGMT$ESA_TRC_AUD_PERM_REPORT

    • MGMT$ESA_WITH_ADMIN_REPORT

    • MGMT$ESA_WITH_GRANT_REPORT

  • Client Configuration Views

    • MGMT$CSA_COLLECTIONS

    • MGMT$CSA_FAILED

    • MGMT$CSA_HOST_OS_COMPONENTS

    • MGMT$CSA_HOST_SW

    • MGMT$CSA_HOST_COOKIES

    • MGMT$CSA_HOST_CUSTOM

    • MGMT$CSA_HOST_RULES

    • MGMT$CSA_HOST_CPUS

    • MGMT$CSA_HOST_IOCARDS

    • MGMT$CSA_HOST_NICS

    • MGMT$CSA_HOST_OS_PROPERTIES

    • MGMT$CSA_HOST_OS_FILESYSEMS

    • MGMT$ECM_CONFIG_HISTORY

    • MGMT$ECM_CONFIG_HISTORY_KEY1

    • MGMT$ECM_CONFIG_HISTORY_KEY2

    • MGMT$ECM_CONFIG_HISTORY_KEY3

    • MGMT$ECM_CONFIG_HISTORY_KEY4

    • MGMT$ECM_CONFIG_HISTORY_KEY5

    • MGMT$ECM_CONFIG_HISTORY_KEY6

    • MGMT$HW_NIC

    • MGMT$OS_COMPONENTS

    • MGMT$OS_FS_MOUNT

    • MGMT$OS_HW_SUMMARY

    • MGMT$OS_HW_SUMMARY

    • MGMT$OS_PATCHES

    • MGMT$OS_SUMMARY

    • MGMT$SOFTWARE_COMP_PATCHSET

    • MGMT$SOFTWARE_COMPONENT_ONEOFF

    • MGMT$SOFTWARE_COMPONENTS

    • MGMT$SOFTWARE_DEPENDENCIES

    • MGMT$SOFTWARE_HOMES

    • MGMT$SOFTWARE_ONEOFF_PATCHES

    • MGMT$SOFTWARE_OTHERS

    • MGMT$SOFTWARE_PATCHES_IN_HOMES

    • MGMT$SOFTWARE_PATCHSETS

Oracle Data Masking and Subsetting Pack for Oracle and non-Oracle Databases

The Oracle Data Masking and Subsetting Pack facilitates the creation of production- like data for non-production environments by replacing production data with fictitious yet realistic values. Generation of the fictitious data can be performed during export or on a separate staging server. The Subsetting functionality provides the ability to mask a portion of the original data. Subsetting can also be used without masking to extract a portion of the original data

Features

Oracle Data Masking and Subsetting Pack includes the following components and features:

  • Application Data Modeling

  • Data Masking Formats Library

  • Data Masking Definitions

  • Data Subsetting Definitions

  • Application Data Modeling, Data Masking and Subsetting Enterprise Manager Command Line Interface (CLI) verbs

  • Application Data Modeling accelerator for select versions of Oracle E-Business Suite

  • Application Data Modeling accelerator for select versions of Oracle Fusion Applications

  • Data Masking templates for select versions of Oracle Fusion Applications

  • Data Masking templates for select versions of Oracle E-Business Suite

The Oracle Data Masking and Subsetting Pack for non-Oracle Databases includes the following restricted-use licenses:

  • Database Gateway for APPC

  • Database Gateway for DRDA

  • Database Gateway for Informix

  • Database Gateway for SQLServer

  • Database Gateway for Sybase

  • Database Gateway for Teradata

If you want to use the Oracle Database Gateways listed above not solely for the purposes of Oracle Data Masking and Subsetting Pack, then you must purchase full-use licenses for the Oracle Database Gateways. When using the Oracle Data Masking and Subsetting Pack for non-Oracle databases, the Oracle Database Gateways stage the data in a separately licensed Oracle database. Oracle Data Masking and Subsetting functionality cannot be executed directly against the non-Oracle database.

Oracle Data Masking and Subsetting Pack must be licensed for:

  1. The source database server, i.e., the databases from which the data originates.

  2. The staging database server on which masking and subsetting operations are executed.

Licensed Links

The following are the licensed pages and links for the Oracle Data Masking and Subsetting Pack within Oracle Enterprise Manager.

Licensed Page/Link How to Access
Application Data Models From the Enterprise Summary home page, click the Enterprise menu, then Quality Management, then Application Data Models.

From the Oracle database or cluster database target home page, click the Schema menu, then Application Data Models.

All features, functions, links, buttons, and drill-downs on these menus are licensed as part of the Oracle Data Masking and Subsetting Pack.

Data Masking Definitions From the Enterprise Summary home page, click the Enterprise menu, then Quality Management, then Data Masking Definitions.

From the Oracle database or cluster database target home page, click the Schema menu, then Data Masking Definitions.

All features, functions, links, buttons, and drill-downs on these menus are licensed as part of the Oracle Data Masking and Subsetting Pack.

Data Masking Format Library From the Enterprise Summary home page, click the Enterprise menu, then Quality Management, then Data Masking Formats.

From the Oracle database or cluster database target home page, click the Schema menu, then Data Masking Format Library.

All features, functions, links, buttons, and drill-downs on these menus are licensed as part of the Oracle Data Masking and Subsetting Pack.

Data Subset Definitions From the Enterprise Summary home page, click the Enterprise menu, then Quality Management, then Data Subset Definitions.

From the Oracle database or cluster database target home page, click the Schema menu, then Data Subsetting.

All features, functions, links, buttons, and drill-downs on these menus are licensed as part of the Oracle Data Masking and Subsetting Pack.


Note:

  1. Oracle Data Masking and Subsetting Pack incorporates the previous Oracle Data Masking Pack and Oracle Test Data Management Pack.

  2. Application Data Modeling was previously called Data Discovery and Modeling.

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 Provisioning and Patch Automation Pack

The Oracle Provisioning and Patch Automation Pack automates the deployment of software, applications, and patches for the database and underlying operating system. It makes critical data center operations easy, efficient and scalable resulting in lower operational risk and cost of ownership. The ability to provision the entire software stack that includes the operating system and the database, supplemented by comprehensive reporting tools make Oracle Provisioning and Patch Automation Pack an extremely significant entity in overall System Management space.

The Oracle Provisioning and Patch Automation Pack contains the following features:

  • Automated patching for Oracle database products and the operating system

  • Critical Patch Facility

  • Software Image Library

  • Bare metal OS provisioning

  • Single instance and RAC provisioning

  • Single click cluster scale up and scale down

  • Single instance-to-RAC conversion

  • CLI driven runtime

  • Enterprise Security Advisor

  • Provisioning and deployment reports

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.

Other Oracle Products

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

Oracle Database Lite

Oracle Database Lite Client Oracle Database Lite Client is a small general-purpose relational database used for mobile and embedded applications. Oracle Database Lite client can be used as a standalone database in embedded hardware and software applications or may be used as the data store for disconnected mobile applications when used with the Oracle Database Lite Mobile Server.

Each user must purchase a Named User Plus license.

Oracle Database Lite Mobile Server Oracle Database Lite Mobile Server is middle-tier infrastructure for mobile and disconnected applications that performs data synchronization and provides management for applications, users, and devices. Oracle Database Lite Mobile Server can use the Oracle Database Lite client as a data store for mobile and disconnected applications, providing efficient, reliable, and secure data management running locally on mobile and small-footprint devices (handhelds, notebooks, communicators, and so forth). The Lite Mobile Server supports scalable synchronization of data between devices and an Oracle Database.

Oracle Database Lite Mobile Server is licensed by CPU.

Note:

When Lite Mobile Server is used with Lite Client, customers must purchase at least one CPU license for Lite Mobile Server and a Named User Plus license for each client user.

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 Secure Backup

Oracle Secure Backup provides tape backup management for the entire Oracle environment. You can use Oracle Secure Backup to back up Oracle databases and host file systems to tape through direct-attached or network-attached tape drives. Oracle Secure Backup provides centralized management and control over backup and restore operations.

Oracle Secure Backup is available in the following forms, each suitable for different development and deployment scenarios:

Oracle Secure Backup  For environments that consist of many servers, Oracle Secure Backup offers high performance data protection from server to tape. This protection is crucial for local and offsite storage of business-critical data.

Oracle Secure Backup Express  For environments that consist of a single server, Oracle Secure Backup Express offers the same tape backup functionality as Oracle Secure Backup, but is limited to a single host with one direct-attached tape drive.