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
- Keygen Crack Patch.com is a world famous website to download latest softwares full version with Activator such as cracks, patches, keygens, license keys for free. TablePlus 1.0 Build 126 + Crack Langsung ke konten utama.
- Need to find your product license key? Please enter the email address you used when you bought your software. We'll then email you the license key.
- Microsoft Office Professional 2016 is the most famous office software in the world. A Microsoft Office 2016 product key can be used to activate your trial or final version of Office 2016 suite. After successful activation, you can take advantage of all features of the MS Office 2016 suite for.
Table Plus macro — add numbering and totaling, CSS styling, and more advanced functions to your tables. Extend your trial by generating a new evaluation license key from Atlassian Marketplace. Click Try it free and you'll be directed to generate a new license. Paste this license key into the app listing in UPM from your Atlassian product.
All the Oracle Database options can be purchased with Oracle Database Enterprise Edition. Oracle Real Application Clusters (Oracle RAC) 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 RAC at no additional cost.
Oracle Active Data Guard
Oracle Active Data Guard enhances the Quality of Service (QoS) for production databases by off-loading resource-intensive operations to one or more standby databases, which are synchronized copies of the production database. With Oracle Active Data Guard, a physical standby database can be used for real-time reporting, with minimal latency between reporting and production data. Compared with traditional replication methods, Active Data Guard is very simple to use, transparently supports all data types, and offers very high performance. Oracle Active Data Guard also allows backup operations to be off-loaded to the standby database, and be done very fast using intelligent incremental backups. Oracle Active Data Guard thus is a very effective way to insulate interactive users and critical business tasks on the production system from the impact of such long-running operations. Oracle Active Data Guard provides the additional benefit of high availability and disaster protection by quickly failing over to the standby database in the event of a planned or an unplanned outage at the production site.
The Active Data Guard option contains the following features:
Physical Standby with Real-time Query
Fast Incremental Backup on Physical Standby
If a physical standby database in a Data Guard configuration has any of the above features enabled, then the Active Data Guard option must be licensed for every such physical standby, and also for the primary database.
Oracle Advanced Compression
Oracle Advanced Compression provides comprehensive data compression capabilities to compress all types of data, backups, and network traffic in an application transparent manner. With Advanced Compression, Oracle includes table compression targeted at OLTP workloads, resulting in reduced storage consumption and improved query performance while incurring minimal write performance overhead. Advanced Compression can be used to compress any unstructured content using SecureFile Compression. Deduplication provides the ability to automatically eliminate redundant copies of SecureFile data. A new faster compression algorithm is included in the Advanced Compression to speed up RMAN backups. With Advanced Compression, Data Pump exports can now be compressed to reduce disk space requirements. Finally, Data Guard can compress redo data resulting in reduced network traffic and faster gap resolution.
The Oracle Advanced Compression option contains the following features:
Data Guard Network Compression
Data Pump Compression
Fast RMAN Compression
OLTP Table Compression
SecureFile Compression and Deduplication
Flashback Data Archive (Total Recall)
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
Transparent Data Encryption (TDE) for tablespace
Transparent Data Encryption (TDE) for securefiles
DataPump Export File encryption
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
Logistic Regression
Regression
Multivariate Linear 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
Profile
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 or later. However, it has also been provided for earlier releases as well, including 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)
The OLAP option to Oracle Database is a full-featured OLAP server embedded in Oracle Database Enterprise Edition. Oracle OLAP cube data types improve business intelligence tools and applications by providing excellent query performance, rich analysis, and fast incremental updates of data sets. OLAP cubes are easily queried by SQL-based business intelligence tools through cube-organized materialized views and OLAP cube views. Cube-organized materialized views provide an alternative summary management solution to table-based materialized views. As with a table-based materialized view, an OLAP cube is accessed by SQL-based tools transparently using the automatic SQL query rewrite feature of the materialized views. SQL-based tools can access both summary data and rich analytic content directly through OLAP cube views. Multidimensional OLAP tools can provides a full-dimensional OLAP experience using the Oracle OLAP multidimensional API to cubes. A single OLAP cube can service each of these types of applications.
The Oracle OLAP option includes the following features:
OLAP Cube Definition, Storage, and Querying
OLAP API and Metadata
OLAP Cube Materialized Views
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.
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
Interval Partitioning
Reference Partitioning
System Partitioning
Virtual Column-based Partitioning
Composite Partitioning
Subpartition Template
Fast Partition Split
Partition Exchange
Oracle Real Application Clusters (Oracle RAC)
Oracle Real Application Clusters (Oracle RAC) is a database computing environment that harnesses the processing power of multiple interconnected computers using clustering technology. Oracle RAC provides unlimited scalability and high availability for all applications. Oracle 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. Oracle RAC provides scalable performance: as demand for database throughput grows, additional computers can be added to the database cluster with no downtime. Oracle RAC supports a single-system image for ease of management. Oracle RAC also provides a complete and integrated stack of clustering software on all platforms; third-party clusterware software is not required. Finally, Oracle 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 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 unexpected problems encountered when a change is finally made in the production systems 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, with one exception: SQL Tuning Sets (STS) can be used if you have licensed either the Tuning Pack or Oracle Real Application Testing. Oracle Real Application Testing 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 Database Replay feature can also be accessed by way of database server APIs and command-line interfaces:
DBMS_WORKLOAD_CAPTURE
package is part of the Oracle Real Application Testing optionDBMS_WORKLOAD_REPLAY
package is part of the Oracle Real Application Testing option
The SQL Performance Analyzer feature can also be accessed by way of database server APIs and command-line interfaces:
DBMS_SQLPA
package is part of Oracle Real Application Testing option
SQL Tuning Sets can also be accessed by way of database server APIs and command-line interfaces. The following subprograms, part of the DBMS_SQLTUNE
package, provide an interface to manage SQL tuning sets and are part of the Oracle Real Application Testing option:
ADD_SQLSET_REFERENCE
CAPTURE_CURSOR_CACHE_SQLSET
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
The Oracle Real Application Testing license is required on both capture and replay systems for Database Replay and is charged by the total number of CPUs on those systems.
Oracle Spatial and Graph
The Oracle Spatial and Graph option includes advanced features for spatial data and analysis and for physical, network, and social graph applications.
Spatial Features
The geospatial data features support complex geographic information systems (GIS) applications, enterprise applications, and location-based services applications, augmenting the Oracle Database Locator feature, which provides storage, analysis, and indexing of 2D location data accessible through SQL and standard programming languages.
These advanced spatial features include:
Selected Spatial Functions, including the
SDO_AGGR_UNION
spatial aggregate functionThe following
SDO_GEOM
package subprograms:SDO_GEOM.RELATE
,SDO_GEOM.SDO_DIFFERENCE
,SDO_GEOM.SDO_INTERSECTION
,SDO_GEOM.SDO_UNION
,SDO_GEOM.SDO_VOLUME
, andSDO_GEOM.SDO_XOR
Classes in packages other than the
oracle
.spatial
.geometry
(sdoapi
.jar
) andoracle
.spatial
.util
(sdoutil
.jar
) packages of the Spatial Java APILinear Referencing System (LRS) support
GeoRaster Storage, Indexing, and Querying
Network Data Model
Topology Data Model
Spatial analysis and mining subprograms (
SDO_SAM
package)Spatial Routing Engine
Geocoding Engine
Spatial Web Services including OpenLS support, including support for geocoding, mapping, business directory (Yellow Pages), and driving directions (routing) services, Web feature service (WFS) support (
SDO_WFS_PROCESS
andSDO_WFS_LOCK
packages), and Catalog services for the Web (CSW) support (SDO_CSW_PROCESS
package)3-D Geometry, Surface, Triangulated irregular network (TIN), and Point Cloud Storage, Indexing, and Querying
Semantic Content Storage, Indexing, and Querying (RDF/OWL Support), and ontology management
Note:
Oracle Locator, a feature of Oracle Database 11Graph Features
The graph database features include two graph models:
A network data model (NDM) graph to model and analyze link-node graphs to represent physical and logical networks used in transportation, utilities and telco
A semantic RDF graph to model and analyze data represented as triples for social network, linked data, and other semantic applications
The Network Data Model graph features include:
A storage model to represent graphs and networks in link and node tables
Java APIs to perform analysis in memory
Numerous graph analysis functions including shortest path, within cost, nearest neighbors, traveling salesman, spanning tree, and more
Explicit storage and connectivity of the graph with link- and node-level attributes
Support for directed and undirected graphs with or without cost
The RDF Semantic graph features include:
Graph relationships represented as triples in compressed, partitioned tables
Indexing, querying, and ontology management
RDFS, OWL, and user-defined inferencing (parallel, batch, and incremental)
Support for SPARQL 1.1 and mixed SPARQL and SQL queries
Enhanced Open Source Tools including Jena, Sesame, Joseki Web Services
Note:
The RDF Semantic graph features require the Oracle Partitioning option.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
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:
The source database server, i.e., the databases from which the data originates.
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 Enterprisemenu, then QualityManagement, then Application Data Models. From the Oracle database or cluster database target home page, click the Schemamenu, 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 Enterprisemenu, then QualityManagement, then DataMaskingDefinitions. From the Oracle database or cluster database target home page, click the Schemamenu, then DataMaskingDefinitions. 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 Enterprisemenu, then QualityManagement, then DataMaskingFormats. From the Oracle database or cluster database target home page, click the Schemamenu, then DataMaskingFormatLibrary. 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 Enterprisemenu, then QualityManagement, then DataSubsetDefinitions. From the Oracle database or cluster database target home page, click the Schemamenu, then DataSubsetting. All features, functions, links, buttons, and drill-downs on these menus are licensed as part of the Oracle Data Masking and Subsetting Pack. |
Note:
Oracle Data Masking and Subsetting Pack incorporates the previous Oracle Data Masking Pack and Oracle Test Data Management Pack.
Application Data Modeling was previously called Data Discovery and Modeling.
Table Plus License Keys
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)
Active Session History (ASH)
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
Supporting functionality to perform per stream bottleneck detection and per component top wait event analysis
In order to use the features listed above, you must purchase licenses for the Diagnostic Pack. A new initialization parameter, CONTROL_MANAGEMENT_PACK_ACCESS
, controls access to the Diagnostic Pack and Tuning Pack. This parameter can be set to one of three values:
DIAGNOSTIC+TUNING
: Diagnostic Pack and Tuning Pack functionally is enabled in the database server.DIAGNOSTIC
: Only Diagnostic Pack functionality is enabled in the server.NONE
: Diagnostic Pack and Tuning pack functionally is disabled in the database server.
The Diagnostic 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 procedure disables all the links and tabs associated with the Diagnostic Pack in Enterprise Manager. All the disabled links and tabs are part of the Diagnostic Pack and therefore require pack license.
Command-Line APIs
Diagnostic 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_ADDM
package is part of this pack.The
DBMS_ADVISOR
package is part of this pack if you specify ADDM as the value of theadvisor_name
parameter, or if you specify for the value of thetask_name
parameter any value starting with the ADDM prefix.The
V$ACTIVE_SESSION_HISTORY
dynamic performance view and its underlying table,X$ASH
, are part of this pack.The
DBA_STREAMS_TP_PATH_BOTTLENECK
view is part of this pack.All views beginning with
DBA_ADDM_
are part of this pack.Some data in
DBA_STREAMS_TP_COMPONENT_STAT
requires the Diagnostic Pack. The following filter clause to any query onDBA_STREAMS_TP_COMPONENT_STAT
shows Diagnostic-Pack-dependent data:For example, the following query shows Diagnostic-Pack-dependent data only:
All data dictionary views beginning with the prefix
DBA_HIST_
are part of this pack, along with their underlying tables.The only exception are the views:DBA_HIST_SNAPSHOT, DBA_HIST_DATABASE_INSTANCE, DBA_HIST_SNAP_ERROR, DBA_HIST_SEG_STAT, DBA_HIST_SEG_STAT_OBJ,
andDBA_HIST_UNDOSTAT
. They can be used without the Diagnostic Pack license.All data dictionary views with the prefix
DBA_ADVISOR_
are part of this pack if queries to these views return rows with the valueADDM
in theADVISOR_NAME
column or a value ofADDM*
in theTASK_NAME
column or the correspondingTASK_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, ashrpt.sql, ashrpti.sql, awrddrpt.sql, awrddrpi.sql, awrsqrpi.sql, awrsqrpt.sql, awrextr.sql, and awrload.sql, awrextr.sql, awrload.sql, awrinfo.sql, spawrrac.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
Automatic SQL Tuning
SQL Tuning Sets
SQL Monitoring
Reorganize objects
In order to use the features listed above, you must purchase licenses for the Tuning Pack, with one exception: SQL Tuning Sets can be used if you have licensed either the Tuning Pack or Oracle Real Application Testing. A new initialization parameter, CONTROL_MANAGEMENT_PACK_ACCESS
, is introduced to control access to the Diagnostic Pack and Tuning Pack in the database server. This parameter can be set to one of three values:
DIAGNOSTIC+TUNING
: Diagnostic Pack and Tuning Pack functionally is enabled in the database server.DIAGNOSTIC
: Only Diagnostic Pack functionality is enabled in the server.NONE
: Diagnostic Pack and Tuning pack functionally is disabled in the database server.
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 procedure disables 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 and command-line interfaces:
DBMS_SQLTUNE
DBMS_ADVISOR
, when the value of theadvisor_name
parameter is either SQL Tuning Advisor or SQL Access Advisor.V$SQL_MONITOR
V$SQL_PLAN_MONITOR
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.
As an MPN Partner, you have access to yearly subscriptions to software, support, and benefits your businesses if you want to begin, build, and grow your Microsoft practice in the cloud-first, mobile-first world through MAPS, Silver and/or Gold competencies.
Once you have acquired a subscription, in your Benefits tab, in your Partner Center dashboard, you can review, activate, sort or download the benefits of interest belonging to one of the categories available to you, by clicking on either of the following tabs, if you are an user with Global Admin or an MPN Partner Admin role:
Software products - See below
If you are unsure on where to find your MPN benefits in your Partner Center dashboard, please follow the guidance outlined here.
If you are looking for what benefits are offered to you through MAPS, Silver and/ or Gold Competencies, you can find them here:
If you are looking to find a general overview of the Benefits offered through our MPN offers, please read our Benefits Overview in Partner Center article
Software Products
This tab shows all the on-premises software products that you are entitled to as part of the active enrollment offer you have in your account – MAPS, Silver and/or Gold -, the license quantity for each product, the offer type that provisioned you this benefit, the benefit type (whether it comes from core, or incremental) and the date of expiry of that benefit.
Select the software product of interest and see the special instructions for each product, by clicking the dropdown symbol in line with the product name.
If a product requires a product key for installation, you will be prompted to enter a product key during the installation process, which you can obtain from the same pane in Partner Center from where you have chosen the version of software that you want to download.
Although some products require the entry of a product key during the installation process, not all products require product activation. Product activation is required for Windows server and client operating systems and all Microsoft Office client applications.
The product key activation behavior is based on following scenario:
If the software is installed on a new machine, one product activation is consumed against the product key.
If the software is installed on the same machine with no significant hardware changes, product activation is not consumed against the product key.
If the software is installed on the same machine with significant hardware changes, product activation is consumed against the product key.
Troubleshooting scenarios
1. 'No further details available' message displayed for CALs benefits
CALs are not a downloadable product. The activation of CALs is managed on the Server product itself and the activation of an RDS License Server.
2. You receive a message states that you have reached the maximum available activations for a product key when trying to activate software
Partners are provided a specific number of activations per product through their MPN membership benefits. If you have met or exceeded the maximum number of activations, you will be unable to activate more licenses by using the provided product key.
3.How to filter benefits?
There are added filtering capabilities in all of the benefits tabs (Azure & Cloud products, Software products, Visual Studio Subscriptions, Technical benefits and Go-to-Market) that are Benefit type and Offer type. With these filtering capabilities you can:
Choose to see what benefits were provisioned to you by Benefit type (Core/ Incremental).
Tableplus License Key
Choose to see what benefits were provisioned to you by all active offers in your account or by individual offers in your account.
Also, a Search box has been added where the partner can search a specific product.
Tableplus License Key Free
Note: To access, view and manage MPN Benefits, Guest users need to have Global Admin/MPN Partner Admin roles. Please find below the experience in Partner Center for a Guest user with no admin privileges on the tenant.