Licensing Information (2023)

Oracle Cloud Management Pack for Oracle Database

Extra cost pack: EE, EE-ES

Included pack: DBCS EE-HP, DBCS EE-EP, ExaCS/CC

Features:

Oracle Cloud Management Pack for Oracle Database includes the following features:

• Database-as-a-Service comprising self-service database provisioning on physical or virtual infrastructure

• DBaaS Rapid Start Kit allowing users to set up and configure Enterprise Manager Cloud Control 12c in under a minute.

• Pluggable Database-as-a-Service (PDBaaS) providing self-service provisioning on a pool of multitenant container databases (CDBs).

• Support shared server, shared cluster, and shared database (Schema-as-a-Service) deployment models

• Virtual assembly provisioning. For example, if there is an assembly topology of three VMs (two WebLogic Server-managed servers and one database), you will need both packs to cover the respective tiers.

• Snap Clone, a fast, storage efficient way of cloning Oracle databases

• Full clones using RMAN backups

• Role based access and resource control through quotas and retirement policies

• Schedule- and performance-based resource management policies

• Metering and chargeback based on fixed cost, utilization metrics and configuration parameters of the database

• Programmatic access to the Self-Service Portal

• Blueprint driven orchestration of cloud operations

Prerequisites:

Oracle Cloud Management Pack for Oracle Database requires Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Links:

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Cloud Management Pack for Oracle Database.

Starting on the Enterprise Summary home page, click the Enterprise menu. Select:

• Cloud, then Infrastructure Home

• Cloud, then Infrastructure Request Dashboard

• Cloud, then Infrastructure Policies

• Cloud, then Middleware and Database Home

• Cloud, then Middleware and Database Request Dashboard

• Cloud, then Self Service Portal

• Cloud, then Service Instances

• Chargeback

• Provisioning and Patching, then Database Provisioning. In the Database Provisioning page, in the Related Links section of the left menu pane, click Provision Pluggable Databases. Next, from the PDB Operations section, select Create New Pluggable Databases. Click Launch, and from Pluggable Database Creation Options, select Clone an Existing PDB -> Snap Clone.

Starting on the Enterprise Summary home page, click the Setup menu. Select:

• Cloud. Select Infrastructure

• Cloud. Select Database

• Provisioning and Patching, then Storage Registration

On the Multitenant container database's home page, from the Oracle Database menu, select Provisioning, then Provision Pluggable Database. Next, from the PDB Operations section, select Create New Pluggable Databases. Click Launch, and from Pluggable Database Creation Options, select Clone an Existing PDB -> Snap Clone.

Licensed APIs:

Use of the following APIs requires a license for Oracle Cloud Management Pack for Oracle Database:

• Assembly Operations — Any POST/GET/PUT/DELETE on /em/cloud/iaas URI space for Resources Assembly Template and Assembly Instance

• DBaaS Operations — Any POST/GET/PUT/DELETE on /em/cloud/dbaas URI space

• DBaaS Setup Operations — Any POST/GET/PUT/DELETE on /em/websvcs/restful/extws/cloudservices/admin/cfw/v1 URI space.

Licensed Command Line Interface (CLI) Verbs:

The following Enterprise Manager Command Line Interface (CLI) verbs are licensed as part of Oracle Cloud Management Pack for Oracle Database. These verbs operate on a database pool.

• add_pool_members

• create_charge_item

• create_dbaas_quota

• create_dbprofile

• create_pool

• create_service_template

• delete_charge_item

• delete_dbaas_quota

• delete_pool

• delete_service_template

• get_dbaas_quota

• get_dbaas_request_settings

• get_metering_data

• get_pool_capacity_data

• get_pool_capacity_summary_data

• get_pool_constraints

• get_pool_criteria

• get_pool_detail

• get_pool_instance_data

• get_pool_target_type

• get_pools

• get_service_template

• list_charge_item_candidates

• remove_pool_members

• update_dbaas_quota

• update_dbaas_request_settings

• update_pool

Licensed Views and Tables:

The following objects within the repository schema are licensed under Oracle Cloud Management Pack for Oracle Database:

• Tables starting with EMCT_CBA

• Views starting with EMCT$CBA

• The GP_EMCT_CBA_TARGET_CHARGE views

• The MGMT$EMCT_CBA_CHARGE_DAILY view

• The MGMT$EMCT_CBA_CHARGE_HOURLY view

Licensed Chargeback Reports:

The following BI Publisher reports are licensed under Oracle Cloud Management Pack for Oracle Database:

• Charge Trend Report

• Charge Summary Report

• Usage Trend Report

• Usage Summary Report

Also, any report created using the "create-like" feature of BI publisher referring the preceding reports, falls under this license.

Oracle Database Lifecycle Management Pack for Oracle Database

Extra cost pack: EE, EE-ES

Included pack: DBCS EE-HP, DBCS EE-EP, ExaCS/CC

Features:

Oracle Database Lifecycle Management Pack for Oracle Database includes the following features:

• Change Activity Plans

• Client system analyzer

• Compliance

• Configuration Collection Extensibility

• Configuration Compare

• Configuration History

• Configuration Instance Browser

• Configuration Save

• Configuration Search

• Configuration Topology

• Copy Objects

• Database Patching

• Database Provisioning

• Database Upgrade

• Disaster Recovery via Site Guard

• Enterprise Data Governance

• File Synchronization

• Notifications

  (Video) Microsoft Licensing Basics, Models, Fundamentals Training 2021

• Pluggable Database (PDB) Clone

• PDB Create/Plug/Unplug (Multiple target operations or performed using a customized deployment procedure.)

• PDB Migrate

• RAC Scale Back

• RAC Scale Out

• Real-time configuration change detection

• Real-time schema change detection

• Schema and Data Comparisons

• Schema and Data Synchronization

• Schema Change Plans

• Schema Comparisons

• User Defined Deployment Procedures (UDDP)

With the purchase of Oracle Database Lifecycle Management Pack for Oracle Database, you also are entitled to the features described in the following sections. These features are restricted to the Oracle Database targets in the Oracle Database Home and the Platform (hardware and operating system) for the CPUs you have licensed.

• Application Configuration Console

• The oplan Utility (The basic OPlan feature is free for everyone that has an Oracle Support contract. Use of OPlan metadata to drive orchestration logic from either Enterprise Manager or custom/third-party scripts is part of Oracle Database Lifecycle Management Pack for Oracle Database.)

• Migrate to ASM

• Self Update

Licensed Parameters:

The init.ora parameter ENABLE_DDL_LOGGING is licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database when set to TRUE. When set to TRUE, the database reports schema changes in real time into the database alert log under the message group schema_ddl. The default setting is FALSE.

Licensed Links:

The Licensed Links, features, and functions listed in the following sections apply only to the Oracle Database target and the associated host an Oracle Database is deployed on. For management on non-Oracle Database targets, you must purchase the appropriate management pack.

Licensed Links – Database Provisioning Procedures:

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:

• From the Enterprise Manager home page, click the Enterprise menu, Provisioning and Patching, then Procedure Library. All Procedures that Clone and Provision a Database are licensed with Oracle Database Lifecycle Management Pack for Oracle Database.

• From the Enterprise Manager home page, click the Enterprise menu, Provisioning and Patching, then Database Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

• From the Oracle database or cluster database target home page, click the Oracle Database menu, then Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Links – Database Upgrade:

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:

• From the Enterprise Manager home page, click the Enterprise menu, Provisioning and Patching, then Procedure Library. All Procedures that Upgrade a Database are licensed with Oracle Database Lifecycle Management Pack for Oracle Database.

• From the Oracle database or cluster database target home page, click the Oracle Database menu, then Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Links – User Defined Deployment Procedures (UDDP)

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:

• From the Enterprise Manager home page, click the Enterprise menu, Provisioning and Patching, then Procedure Library. On the Provisioning Library page, from the list of actions, the Create New option is licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Links – RAC Scale Out and Scale Back

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:

• From the Enterprise Manager home page, click the Enterprise menu, Provisioning and Patching, then Procedure Library. All Procedures that Extend or Scale a database or RAC are licensed with Oracle Database Lifecycle Management Pack for Oracle Database.

• From the Enterprise Manager home page, click the Enterprise menu, Provisioning and Patching, then Database Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

• From the Oracle cluster database target home page, click the Oracle Database menu, then Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Links – Database Patching

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:

• From the Enterprise Manager home page, click the Enterprise menu, Provisioning and Patching, then Procedure Library. All Procedures that patch a database, Clusterware or Real Application Clusters are licensed with Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Links – Offline Patching

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:

• From the Enterprise Manager home page, click the Setup menu, Provisioning and Patching, then Offline Patching. From the Online and Offline Setting tab, the Connection, Offline setting is licensed with Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Links – Configuration Instance Browser

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:

• From the Enterprise Manager home page, click on Targets, Databases, and select a Database. From the database home page, click on Oracle Database, Configuration. All features, functions, links, buttons, and drill-downs on this menu, excluding Topology, are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

• If the Target Home Page is accessed directly or by other paths:

  • From the database home page, click on Oracle Database, Configuration. All features, functions, links, buttons, and drill-downs on this menu, excluding Topology, are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Links – Configuration Search

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:

• From the Enterprise Manager home page, click the Enterprise menu, then Configuration and Search. All features, functions, links, buttons, and drill-downs on this page are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Links – Configuration History

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:

• From the Enterprise Manager home page, click the Enterprise menu, then Configuration and History. All features, functions, links, buttons, and drill-downs on this page are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Links – Configuration Compare

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:

• From the Enterprise Manager home page, click the Enterprise menu, then Configuration and Compare. All features, functions, links, buttons, and drill-downs on this page are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Links – Configuration Save

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:

• From the Enterprise Manager home page, click the Enterprise menu, then Configuration and Save. All features, functions, links, buttons, and drill-downs on this page are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Links – Configuration Topology

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:

• From the Target Home Page, click on Oracle Database, Configuration, Topology. In the View Dropdown, Used By is licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

• From the Target Home Page, click on Oracle Database, Configuration, Topology, Customization. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

• If the Target Home Page is accessed directly or by other paths:

  • From the Target Home Page, click on Oracle Database, Configuration, Topology. In the View drop-down, Used By is licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

  • From the Target Home Page, click on Oracle Database, Configuration, Topology, Customization. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Links – Configuration Collection Extensibility

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:

• From the Enterprise Manager home page, click the Enterprise menu, then Configuration and Custom. All features, functions, links, buttons, and drill-downs on this page are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Links – File Synchronization

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:

• When viewing comparison results differences as described in the Configuration Compare feature, select the configuration specification in the tree on the left. Select Enable File Synchronization. All features, functions, links, buttons, and drill-downs on this page are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Links – Schema Comparison:

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:

• From the Enterprise Manager home page, click on Targets, Databases, and then select a Database. From the database home page, click on Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

• If the Target Home Page is accessed directly or by other paths:

  • From the database home page, click on Schema, Change Management. All features, unctions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Links – Schema and Data Comparisons:

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:

• From the Enterprise Manager home page, click on Targets, Databases, and then select a Database. From the database home page, click on Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

• If the Target Home Page is accessed directly or by other paths:

  • From the database home page, click on Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Links – Schema and Data Synchronization:

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:

• From the Enterprise Manager home page, click on Targets, Databases, and then select a Database. From the database home page, click on Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

• If the Target Home Page is accessed directly or by other paths:

  • From the database home page, click on Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Links – Copy Objects:

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:

• From the Enterprise Manager home page, click on Targets, Databases, and then select a Database. From the database home page, click on Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

• If the Target Home Page is accessed directly or by other paths:

  • From the database home page, click on Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Links – Real-Time Schema Change Detection:

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:

• From the Enterprise Manager home page, click on Targets, Databases, and then select a Database. From the database home page, click on Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

• If the Target Home Page is accessed directly or by other paths:

  • From the database home page, click on Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Links – Real-time Configuration Change Detection and Compliance:

Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:

• From the Enterprise Manager home page, click the Enterprise menu and Compliance. All features, functions, links, buttons, and drill-downs associated with the Library, Results and Real-Time Observations pages are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

Licensed Reports:

The following reports are part of Oracle Database Lifecycle Management Pack for Oracle Database. All reports in each of these sections are licensed as part of this pack. To access the reports go to the Enterprise Manager home page, click the Reports, Information Publisher Reports or BI Publisher Enterprise Reports.

The following reporting areas, reports, and sub-reports under Information Publisher Reports are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database:

• Compliance

• Deployment and Configuration

• Sample Host reports, Configuration Reports

  (Video) Free Certification + Power Platform Licensing Explained

• Security

The following reporting areas, reports and sub-reports under BI Publisher Enterprise Reports are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database:

• Compliance

• Deployment and Configuration

• Sample Host reports, Configuration Reports

• Security

Licensed Command Line Interface (CLI) Verbs:

The following Enterprise Manager Command Line Interface (CLI) verbs are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

• associate_cs_targets

• clone_database

• config_compare

• config_db_service_target

• configure_log_archive_locations

• confirm_instance

• create_database

• describe_instance

• describe_procedure_input

• disable_config_history

• enable_config_history

• export_compliance_group

• export_compliance_standard_rule

• export_facet

• export_standard

• fix_compliance_state

• get_config_searches

• get_config_templates

• get_executions

• get_instance_data

• get_instance_status

• get_instances

• get_oms_config_property

• get_procedure_types

• get_procedure_xml

• get_procedures

• get_retry_argument

• get_saved_configs

• ignore_instance

• import_compliance_object

• list_oms_config_properties

• remove_cs_target_association

• reschedule_instance

• resume_instance

• run_config_search

• save_procedure

• set_config_history_retention_period

• stop_instance

• submit_procedure

• suspend_instance

• update_and_retry_step

• update_procedure_input

• upgrade_database

Licensed Repository Views – Compliance Views:

The following compliance views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:

• MGMT$CCC_ALL_OBS_BUNDLES

  See Also

  Child protection privacy and information sharingHow Important Is Physical Contact with Your Infant?Drunken Noodles (Pad Kee Mao)Passport "Place of Issue"? - What does this mean? Who issues Passports?

• MGMT$CCC_ALL_OBSERVATIONS

• MGMT$CCC_DIAG_ANALYTICS

• MGMT$CCC_DIAG_QUEUEBACKLOG

• MGMT$COMPLIANCE_STANDARD

• MGMT$COMPLIANCE_STANDARD_GROUP

• MGMT$COMPLIANCE_STANDARD_RULE

• MGMT$COMPOSITE_CS_EVAL_SUMMARY

• MGMT$CS_ASM_DISKGRP_SETTINGS

• MGMT$CS_DB_CONTROL_FILE_COUNT

• MGMT$CS_DB_INIT_PARAMS

• MGMT$CS_DB_RBS_IN_SYSTEM

• MGMT$CS_DB_REC_SEG_SETTINGS

• MGMT$CS_DB_REC_TS_SETTINGS

• MGMT$CS_DB_REC_USER_SETTINGS

• MGMT$CS_DB_REDO_LOG_COUNT

• MGMT$CS_DB_REDO_LOGS

• MGMT$CS_DB_TABLESPACES

• MGMT$CS_DB_TBSP_SEGSPACE_MGMT

• MGMT$CS_EVAL_SUMMARY

• MGMT$CS_FEATURE_USAGE

• MGMT$CS_GROUP_EVAL_SUMMARY

• MGMT$CS_GROUP_KEYWORD

• MGMT$CS_HA_INFO

• MGMT$CS_HIERARCHY

• MGMT$CS_KEYWORD

• MGMT$CS_RQS_HIERARCHY

• MGMT$CS_RULE_ATTRS

• MGMT$CS_RULE_EVAL_SUMMARY

• MGMT$CS_RULEFOLDER

• MGMT$CS_TARGET_ASSOC

• MGMT$CS_TGT_ASSOC_TXF_REQ

• MGMT$CSG_HIERARCHY

• MGMT$CSG_SUBGROUP

• MGMT$CSR_CURRENT_VIOLATION

• MGMT$CSR_TARGET_ASSOC

• MGMT$CSR_VIOLATION_CONTEXT

• MGMT$CSRF_TARGET_ASSOC

• MGMT$EM_CS_RULE_EVENT_ERROR

• MGMT$EM_RULE_VIOL_CTXT_DEF

• MGMT$ICS_TARGET_ASSOC

• MGMT$REPO_RULE_CHK_DETAILS

• MGMT$REPOSITORY_RULE_BIND_VARS

• MGMT$REPOSITORY_RULE_PARAMS

• MGMT$RULE_KEYWORD

Licensed Repository Views – Provisioning and Patching Views:

The following provisioning and patching views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:

• EM$PROV_APPTYPES

• EM$PROVAPP_METADATA

• EM$PROVAPP_METADATA_VERSION

• EM$PROVAPP_TAG_PROPERTIES

• EM$PROVAPP_TAGS

• MGMT$PA_RECOM_METRIC_SOURCE

Licensed Repository Views – Patching Views:

The following patching views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:

• GC$EM_PC_PLAN_PATCHES

• GC$EM_PC_PLANS

• GC$EM_PC_PLAN_TARGETS

• GC_PC_EXECUTION_INSTANCES

• GC_PC_PLAN_ANALYSIS_RS

• GC_PC_PLAN_REMEDY

• GC_PC_PLAN_REMEDY_DETAILS

• GC_PC_PLAN_USERS

• GC_PC_TARGETS

• MGMT$APPLIED_PATCHES

• MGMT$APPLIED_PATCHSETS

• MGMT$ARU_FAMILY_PRODUCT_MAP

• MGMT$ARU_LANGUAGES

• MGMT$ARU_PATCH_RECOMMENDATIONS

• MGMT$ARU_PLATFORMS

• MGMT$ARU_PRODUCT_RELEASE_MAP

• MGMT$ARU_PRODUCTS

• MGMT$ARU_RELEASES

• MGMT$ARU_TARGETS

• MGMT$PA_AFFTED_HOST_GUID_OH

• MGMT$PA_AFFTED_HOST_OH

• MGMT$PA_AFFTED_TARGETS

• MGMT$PA_FINAL_PATCH_LIST

• MGMT$PA_TARGET_MAPPING

• MGMT$PR_APPL_PATCHES_TO_OH

• MGMT$PR_APPL_PATCHES_TO_OH_TGT

• MGMT$PR_HOME_INFO

• MGMT$PR_HOMES_AFFECTED_COUNT

• MGMT$RECOM_METRIC_SOURCE

Licensed Repository Views – Configuration Views:

The following configuration views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:

• GC$ECM_COMP_PROPERTIES

• GC$ECM_CONFIG_SUMMARY

• GC$ECM_CURR_CONFIG

• GC$ECM_CURR_CONFIG_FLAT_MEMS

• GC$ECM_CURR_CONFIG_SNAPSHOTS

• GC$ECM_CURR_TARGET_SNAPSHOTS

• GC$ECM_DATA_RETENTION_TIME

• GC$ECM_GEN_SNAPSHOT

• GC$ECM_SAVED_CONFIG

• GC$ECM_SAVED_CONFIG_FLAT_MEMS

• GC$ECM_SAVED_CONFIG_SNAPSHOTS

• GC$ECM_SAVED_CONFIG_TARGETS

• GC$ECM_SAVED_TARGET_SNAPSHOTS

• MGMT$CCS_DATA

• MGMT$CCS_DATA_SOURCE

• MGMT$CCS_DATA_SOURCE_VISIBLE

• MGMT$CCS_DATA_VISIBLE

• MGMT$DB_CONTROLFILES

• MGMT$DB_DATAFILES

• MGMT$DB_DBNINSTANCEINFO

• MGMT$DB_FEATUREUSAGE

• MGMT$DB_INIT_PARAMS

• MGMT$DB_LICENSE

• MGMT$DB_OPTIONS

• MGMT$DB_REDOLOGS

• MGMT$DB_ROLLBACK_SEGS

• MGMT$DB_SGA

• MGMT$DB_TABLESPACES

• MGMT$DB_TABLESPACES_ALL

• MGMT$ECM_CMP_JOB_LAST_RESULTS

• MGMT$ECM_CMP_JOBS

• MGMT$ECM_CMP_RPT_CCS_DS

• MGMT$ECM_CMP_RPT_CCS_DS_DTLS

• MGMT$ECM_CMP_RPT_CCS_PD_ALL

• MGMT$ECM_CMP_RPT_CCS_PD_DIFFS

• MGMT$ECM_CMP_RPT_CI_DIFFS

• MGMT$ECM_CMP_VISIBLE_CONFIGS

• MGMT$ECM_CURRENT_SNAPSHOTS

• MGMT$ECM_VISIBLE_SNAPSHOTS

• MGMT$SERVICETAG_INSTANCES

• MGMT$SERVICETAG_REGISTRY

• MGMT$UNPATCHABLE_DB_TARGETS

Licensed Repository Views – Oracle Home Patching Views:

The following Oracle home patching views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:

• MGMT$APPLIED_PATCHES

• MGMT$APPLIED_PATCHSETS

• MGMT$APPL_PATCH_AND_PATCHSET

• MGMT$CPF_ADVISORY_INFO

• MGMT$CPF_HOMES_INFO

• MGMT$CPF_PATCH_INFO

  See Also

  Work in Germany | Prospects.ac.uk30 Side Hustles Perfect for College StudentsWhat it means to be black in the American educational system4 Ethical Dilemmas in Nursing

• MGMT$EM_HOMES_PLATFORM

• MGMT$HOMES_AFFECTED

• MGMT$OH_CLONE_PROPERTIES

• MGMT$OH_COMP_DEP_RULE

• MGMT$OH_COMP_INST_TYPE

• MGMT$OH_COMPONENT

• MGMT$OH_CRS_NODES

• MGMT$OH_DEP_HOMES

• MGMT$OH_FILE

• MGMT$OH_HOME_INFO

• MGMT$OH_INSTALLED_TARGETS

• MGMT$OH_INV_SUMMARY

• MGMT$OH_PATCH

• MGMT$OH_PATCHED_COMPONENT

• MGMT$OH_PATCHED_FILE

• MGMT$OH_PATCH_FIXED_BUG

• MGMT$OH_PATCHSET

• MGMT$OH_VERSIONED_PATCHV

• MGMT$PATCH_ADVISORIES

Licensed Repository Views – Security Views:

The following security views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:

• 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

  (Video) Power Apps Licensing Explained

• 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

Licensed Repository Views – Client Configuration Views:

The following client configuration views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:

• MGMT$CSA_COLLECTIONS

• MGMT$CSA_FAILED

• MGMT$CSA_HOST_COOKIES

• MGMT$CSA_HOST_CPUS

• MGMT$CSA_HOST_CUSTOM

• MGMT$CSA_HOST_IOCARDS

• MGMT$CSA_HOST_NICS

• MGMT$CSA_HOST_OS_COMPONENTS

• MGMT$CSA_HOST_OS_FILESYSEMS

• MGMT$CSA_HOST_OS_PROPERTIES

• MGMT$CSA_HOST_RULES

• MGMT$CSA_HOST_SW

• MGMT$ECM_CONFIG_HISTORY

Oracle Diagnostics Pack

Extra cost pack: EE, EE-ES

Included pack: DBCS EE, DBCS EE-HP, DBCS EE-EP, ExaCS/CC

Features:

Oracle Diagnostics Pack includes the following features:

• Performance monitoring and diagnostics (database and host)

• Automatic Workload Repository (AWR)

• AWR Warehouse

• Automatic Database Diagnostic Monitor (ADDM)

• Compare Period ADDM

• Real Time ADDM

• Active Session History (ASH)

• ASH analytics

• Performance Hub

• Exadata Cell Grid Administration

• Exadata Cell Grid Performance

• Exadata Cell Group Health Overview page

• Exadata Resource Utilization

• Blackouts

• Notifications

• Metric and Alert/Event history

• User-Defined Metrics and Metric Extensions

• Management Connectors

• Dynamic metric baselines and Adaptive metric thresholds

• Monitoring templates and Template Collections

• Replay Compare Period Report

• 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 Oracle Diagnostics Pack. A new initialization parameter, CONTROL_MANAGEMENT_PACK_ACCESS, controls access to Oracle Diagnostics Pack and Oracle Tuning Pack. This parameter can be set to one of three values:

• DIAGNOSTIC+TUNING: Oracle Diagnostics Pack and Oracle Tuning Pack functionally is enabled in the database server.

• DIAGNOSTIC: Only Oracle Diagnostics Pack functionality is enabled in the server.

• NONE: Oracle Diagnostics Pack and Oracle Tuning Pack functionally is disabled in the database server.

Any and all methods of accessing Oracle Diagnostics Pack functionality, whether through Enterprise Manager Console, Desktop Widgets, command-line APIs, or direct access to the underlying data, requires an Oracle Diagnostics Pack license.

Licensed Links:

To determine which links in Enterprise Manager are part of Oracle Diagnostics 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 Diagnostics Pack and click Apply.

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

This procedure disables all the links and tabs associated with Oracle Diagnostics Pack in Enterprise Manager. All the disabled links and tabs are part of Oracle Diagnostics Pack and therefore require a pack license.

Licensed Command-Line APIs:

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

• The DBMS_ADDM, DBMS_PERF, DBMS_UMF, and DBMS_WORKLOAD_REPOSITORY packages are 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 DBMS_WORKLOAD_REPLAY.COMPARE_PERIOD_REPORT function is part of this pack.

• 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 Oracle Diagnostics Pack. The following filter clause to any query on DBA_STREAMS_TP_COMPONENT_STAT shows Diagnostics-Pack-dependent data:

  where STATISTIC_UNIT = 'PERCENT'

  For example, the following query shows Diagnostics-Pack-dependent data only:

  SELECT * FROM DBA_STREAMS_TP_COMPONENT_STAT where STATISTIC_UNIT = 'PERCENT';

• 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, and DBA_HIST_UNDOSTAT. They can be used without the Oracle Diagnostics 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 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, awrgrpt.sql, awrgrpti.sql, awrgdrpt.sql, awrgdrpi.sql, addmrpt.sql, addmrpti.sql, ashrpt.sql, ashrpti.sql, awrddrpt.sql, awrddrpi.sql, awrsqrpi.sql, awrsqrpt.sql, awrextr.sql, awrload.sql, awrinfo.sql, spawrio.sql, and spawrrac.sql.

Licensed Repository Views – Monitoring Views:

The following monitoring views are licensed under Oracle Diagnostics Pack:

• MGMT$ALERT_ANNOTATIONS

• MGMT$ALERT_CURRENT

• MGMT$ALERT_HISTORY

• MGMT$ALERT_NOTIF_LOG

• MGMT$AVAILABILITY_CURRENT

• MGMT$AVAILABILITY_HISTORY

• MGMT$BLACKOUT_HISTORY

• MGMT$BLACKOUTS

• MGMT$METRIC_COLLECTIONS

• MGMT$ALERT_CURRENT

• MGMT$METRIC_DAILY

• MGMT$METRIC_DETAILS

• MGMT$METRIC_HOURLY

• MGMT$TARGET_METRIC_COLLECTIONS

• MGMT$TARGET_METRIC_SETTINGS

Licensed Repository Views – Template Views:

The following template views are licensed under Oracle Diagnostics Pack:

• MGMT$TEMPLATES

• MGMT$TEMPLATE_METRIC_COLLECTION

• MGMT$TEMPLATE_METRIC_SETTINGS

• MGMT$TEMPLATE_POLICY_SETTINGS

Additional Licensing Information:

• The use of Automatic Workload Repository Hub (AWR Hub) features in the database requires both an Oracle Diagnostics Pack license and an OCI Operations Insights Service license subscription.

• The use of PL/SQL APIs through the DBMS_AWRHUB package requires both an Oracle Diagnostics Pack license and an OCI Operations Insights Service license subscription.