Go to main content
1/25
Contents
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Introducing Management Repository Views
1.1
About Management Repository Views
1.2
Using Management Repository Views
2
Blackout Views
2.1
MGMT$BLACKOUT_HISTORY
2.2
MGMT$BLACKOUTS
3
Chargeback Views
3.1
MGMT$EMCT_CBA_CHARGE_HOURLY
3.2
MGMT$EMCT_CBA_CHARGE_DAILY
4
Compliance Views
4.1
MGMT$COMPLIANCE_STANDARD_RULE
4.2
MGMT$COMPLIANCE_STANDARD
4.3
MGMT$COMPLIANCE_STANDARD_GROUP
4.4
MGMT$CS_EVAL_SUMMARY
4.5
MGMT$COMPOSITE_CS_EVAL_SUMMARY
4.6
MGMT$CS_RULE_EVAL_SUMMARY
4.7
MGMT$CS_GROUP_EVAL_SUMMARY
4.8
MGMT$CS_TARGET_ASSOC
4.9
MGMT$CSR_CURRENT_VIOLATION
4.10
MGMT$CSR_VIOLATION_CONTEXT
4.11
MGMT$EM_RULE_VIOL_CTXT_DEF
4.12
MGMT$RULE_KEYWORD
4.13
MGMT$CS_KEYWORD
4.14
MGMT$CS_GROUP_KEYWORD
4.15
MGMT$CS_RULE_ATTRS
4.16
MGMT$CS_HIERARCHY
4.17
MGMT$CS_RQS_HIERARCHY
4.18
MGMT$CS_RULEFOLDER
4.19
MGMT$CSG_HIERARCHY
4.20
MGMT$CSG_SUBGROUP
4.21
MGMT$CSR_TARGET_ASSOC
4.22
MGMT$CSRF_TARGET_ASSOC
4.23
MGMT$REPO_RULE_CHK_DETAILS
4.24
MGMT$REPOSITORY_RULE_BIND_VARS
4.25
MGMT$REPOSITORY_RULE_PARAMS
4.26
MGMT$CS_TGT_ASSOC_TXF_REQ
4.27
MGMT$EM_CS_RULE_EVENT_ERROR
4.28
MGMT$CCC_ALL_OBS_BUNDLES
4.29
MGMT$CCC_ALL_OBSERVATIONS
4.30
MGMT$CCC_ALL_VIOLATIONS
4.31
MGMT$CCC_ALL_AGENT_WARNINGS
4.32
MGMT$CCC_ALL_WATCHDOG_ALERTS
4.33
MGMT$COMPLIANT_TARGETS
4.34
MGMT$COMPLIANCE_SUMMARY
4.35
MGMT$COMPLIANCE_TREND
4.36
MGMT$CCC_DIAG_ANALYTICS
4.37
MGMT$CCC_DIAG_QUEUEBACKLOG
5
Configuration Management Views
5.1
Custom Configuration Specification Views
5.1.1
MGMT$CCS_DATA
5.1.2
MGMT$CCS_DATA_SOURCE
5.1.3
MGMT$CCS_DATA_VISIBLE
5.1.4
MGMT$CCS_DATA
5.2
Database Configuration Views
5.2.1
MGMT$DB_TABLESPACES
5.2.2
MGMT$DB_DATAFILES
5.2.3
MGMT$DB_CONTROLFILES
5.2.4
MGMT$DB_DBNINSTANCEINFO
5.2.5
MGMT$DB_FEATUREUSAGE
5.2.6
MGMT$DB_INIT_PARAMS
5.2.7
MGMT$DB_LICENSE
5.2.8
MGMT$DB_REDOLOGS
5.2.9
MGMT$DB_ROLLBACK_SEGS
5.2.10
MGMT$DB_SGA
5.2.11
MGMT$DB_TABLESPACES_ALL
5.2.12
MGMT$DB_OPTIONS
5.3
Enterprise Configuration Management Views
5.3.1
MGMT$ECM_CMP_JOBS
5.3.2
MGMT$ECM_CMP_JOB_LAST_RESULTS
5.3.3
MGMT$ECM_CMP_RPT_CCS_DS
5.3.4
MGMT$ECM_CMP_RPT_CCS_DS_DTLS
5.3.5
MGMT$ECM_CMP_RPT_CCS_PD_ALL
5.3.6
MGMT$ECM_CMP_RPT_CCS_PD_DIFFS
5.3.7
MGMT$ECM_CMP_RPT_CI_DIFFS
5.3.8
MGMT$ECM_CMP_VISIBLE_CONFIGS
5.3.9
MGMT$ECM_CURRENT_SNAPSHOTS
5.3.10
MGMT$ECM_VISIBLE_SNAPSHOTS
6
Events Views
6.1
MGMT$INCIDENTS
6.2
MGMT$INCIDENT_CATEGORY
6.3
MGMT$INCIDENT_TARGET
6.4
MGMT$INCIDENT_ANNOTATION
6.5
MGMT$EVENTS_LATEST
6.6
MGMT$EVENTS
6.7
MGMT$EVENT_ANNOTATION
6.8
MGMT$PROBLEMS
6.9
MGMT$PROBLEM_ANNOTATION
7
Hardware Views
7.1
Hardware Views
7.1.1
MGMT$HW_CPU_DETAILS
7.1.2
MGMT$HW_NIC
7.1.3
MGMT$HW_NIC_BONDS
7.1.4
MGMT$HW_IO_DEVICES
7.1.5
MGMT$EM_ECM_HOST_VIRTUAL
7.1.6
MGMT$HW_HOSTS_FILE
7.2
Service Tag Views
7.2.1
MGMT$SERVICETAG_INSTANCES
7.2.2
MGMT$SERVICETAG_REGISTRY
8
Inventory Views
8.1
Inventory Views
8.1.1
MGMT$TARGET
8.1.2
MGMT$TARGET_TYPE
8.1.3
MGMT$TARGET_TYPE_DEF
8.1.4
MGMT$TARGET_ASSOCIATIONS
8.1.5
MGMT$TARGET_MEMBERS
8.1.6
MGMT$TARGET_FLAT_MEMBERS
8.1.7
MGMT$TARGET_TYPE_PROPERTIES
8.1.8
MGMT$TARGET_PROPERTIES
8.2
Oracle Home Directory Patching Views
8.2.1
MGMT$EM_HOMES_PLATFORM
8.2.2
MGMT$APPL_PATCH_AND_PATCHSET
8.2.3
MGMT$HOMES_AFFECTED
8.2.4
MGMT$APPLIED_PATCHES
8.2.5
MGMT$APPLIED_PATCHSETS
8.3
Oracle Home Directory Views
8.3.1
MGMT$OH_HOME_INFO
8.3.2
MGMT$OH_DEP_HOMES
8.3.3
MGMT$OH_CRS_NODES
8.3.4
MGMT$OH_CLONE_PROPERTIES
8.3.5
MGMT$OH_COMPONENT
8.3.6
MGMT$OH_COMP_INST_TYPE
8.3.7
MGMT$OH_COMP_DEP_RULE
8.3.8
MGMT$OH_PATCHSET
8.3.9
MGMT$OH_VERSIONED_PATCH
8.3.10
MGMT$OH_PATCH
8.3.11
MGMT$OH_PATCHED_COMPONENT
8.3.12
MGMT$OH_PATCH_FIXED_BUG
8.3.13
MGMT$OH_PATCHED_FILE
8.3.14
MGMT$OH_FILE
8.3.15
MGMT$PA_RECOM_METRIC_SOURCE
8.3.16
MGMT$OH_INV_SUMMARY
8.3.17
MGMT$OH_INSTALLED_TARGETS
9
Job Views
9.1
MGMT$CA_TARGETS
9.2
MGMT$CA_EXECUTIONS
9.3
MGMT$JOBS
9.4
MGMT$JOB_TARGETS
9.5
MGMT$JOB_EXECUTION_HISTORY
9.6
MGMT$JOB_STEP_HISTORY
9.7
MGMT$JOB_ANNOTATIONS
9.8
MGMT$JOB_NOTIFICATION_LOG
10
Linux Patching Views
10.1
MGMT$HOSTPATCH_HOSTS
10.2
MGMT$HOSTPATCH_GROUPS
10.3
MGMT$HOSTPATCH_GRP_COMPL_HIST
10.4
MGMT$HOSTPATCH_HOST_COMPL
11
Management Template Views
11.1
MGMT$TEMPLATES
11.2
MGMT$TEMPLATE_POLICY_SETTINGS
11.3
MGMT$TEMPLATE_METRICCOLLECTION
11.4
MGMT$TEMPLATE_METRIC_SETTINGS
12
Metric Views
12.1
MGMT$METRIC_CATEGORIES
12.2
MGMT$METRIC_COLLECTION
12.3
MGMT$METRIC_ERROR_CURRENT
12.4
MGMT$METRIC_ERROR_HISTORY
13
Middleware Management Views
13.1
Application Deployment Views
13.1.1
MGMT$J2EE_APPLICATION
13.1.2
MGMT$J2EEAPP_EJBCOMPONENT
13.1.3
MGMT$J2EEAPP_JRFWS
13.1.4
MGMT$J2EEAPP_JRFWSOPER
13.1.5
MGMT$J2EEAPP_JRFWSPOLICY
13.1.6
MGMT$J2EEAPP_JRFWSPORT
13.1.7
MGMT$J2EEAPP_WEBAPPCOMPONENT
13.1.8
MGMT$J2EEAPP_WSCONFIG
13.1.9
MGMT$J2EEAPP_WSPORTCONFIG
13.2
Glassfish Views
13.2.1
MGMT$EMAS_GLASSFISH_DOMAIN
13.2.2
MGMT$EMAS_GLASSFISH_NODES
13.2.3
MGMT$EMAS_GLASSFISH_SERVER
13.2.4
MGMT$EMAS_GLASSFISH_SVR_PROP
13.2.5
MMGMT$EMAS_GLASSFISH_NW_LSTNR
13.2.6
MGMT$EMAS_GLASSFISH_DATASOURCE
13.2.7
MGMT$EMAS_GLASSFISH_DS_PROP
13.3
Oracle WebLogic Server Views
13.3.1
MGMT$WEBLOGIC_APPLICATIONS
13.3.2
MGMT$WEBLOGIC_EJBCOMPONENT
13.3.3
MGMT$WEBLOGIC_FILESTORE
13.3.4
MGMT$WEBLOGIC_JDBCDATASOURCE
13.3.5
MGMT$WEBLOGIC_JDBCMULTIDS
13.3.6
MGMT$WEBLOGIC_JMSCONNFACTORY
13.3.7
MGMT$WEBLOGIC_JMSQUEUE
13.3.8
MGMT$WEBLOGIC_JMSSERVER
13.3.9
MGMT$WEBLOGIC_JMSTOPIC
13.3.10
MGMT$WEBLOGIC_JOLTCONNPOOL
13.3.11
MGMT$WEBLOGIC_JVMSYSPROPS
13.3.12
MGMT$WEBLOGIC_MACHINE
13.3.13
MGMT$WEBLOGIC_NETWORK_CHANNELS
13.3.14
MGMT$WEBLOGIC_NODEMANAGER
13.3.15
MGMT$WEBLOGIC_RACONFIG
13.3.16
MGMT$WEBLOGIC_RAOUTBOUNDCONFIG
13.3.17
MGMT$WEBLOGIC_RESOURCECONFIG
13.3.18
MGMT$WEBLOGIC_SERVER
13.3.19
MGMT$WEBLOGIC_STARTSHUTCLASSES
13.3.20
MGMT$WEBLOGIC_VIRTUALHOST
13.3.21
MGMT$WEBLOGIC_WEBAPPCOMPONENT
13.3.22
MGMT$WEBLOGIC_WORKMANAGER
13.3.23
MGMT$WEBLOGIC_WSCONFIG
13.3.24
MGMT$WEBLOGIC_WSPORTCONFIG
13.4
Oracle WebLogic Domain Views
13.4.1
MGMT$WEBLOGIC_DOMAIN
13.4.2
MGMT$WEBLOGIC_OPSSSYSPROP
13.4.3
MGMT$WEBLOGIC_OAMCONFIG
13.5
Oracle WebLogic Cluster View
13.5.1
MGMT$WEBLOGIC_CLUSTER
14
Monitoring Views
14.1
MGMT$ALERT_CURRENT
14.2
MGMT$TARGET_METRIC_COLLECTIONS
14.3
MGMT$TARGET_METRIC_SETTINGS
14.4
MGMT$AVAILABILITY_CURRENT
14.5
MGMT$AVAILABILITY_HISTORY
14.6
MGMT$ALERT_HISTORY
14.7
MGMT$AVAIL_ALERT_HISTORY
14.8
MGMT$METRIC_DETAILS
14.9
MGMT$METRIC_CURRENT
14.10
MGMT$METRIC_HOURLY
14.11
MGMT$METRIC_DAILY
15
Operating System Views
15.1
MGMT$OS_SUMMARY
15.2
MGMT$OS_COMPONENTS
15.3
MGMT$OS_HW_SUMMARY
15.4
MGMT$OS_PATCH_SUMMARY
15.5
MGMT$OS_FS_MOUNT
15.6
MGMT$OS_KERNEL_PARAMS
15.7
MGMT$OS_PATCHES
15.8
MGMT$OS_PROPERTIES
15.9
MGMT$OS_MODULES
15.10
MGMT$OS_LIMITS
15.11
MGMT$OS_INIT_SERVICES
16
Security Views
16.1
MGMT$ESA_ALL_PRIVS_REPORT
16.2
MGMT$ESA_ANY_DICT_REPORT
16.3
MGMT$ESA_ANY_PRIV_REPORT
16.4
MGMT$ESA_AUDIT_SYSTEM_REPORT
16.5
MGMT$ESA_BECOME_USER_REPORT
16.6
MGMT$ESA_CATALOG_REPORT
16.7
MGMT$ESA_CONN_PRIV_REPORT
16.8
MGMT$ESA_CREATE_PRIV_REPORT
16.9
MGMT$ESA_DBA_GROUP_REPORT
16.10
MGMT$ESA_DBA_ROLE_REPORT
16.11
MGMT$ESA_DIRECT_PRIV_REPORT
16.12
MGMT$ESA_EXMPT_ACCESS_REPORT
16.13
MGMT$ESA_KEY_OBJECTS_REPORT
16.14
MGMT$ESA_OH_OWNERSHIP_REPORT
16.15
MGMT$ESA_OH_PERMISSION_REPORT
16.16
MGMT$ESA_POWER_PRIV_REPORT
16.17
MGMT$ESA_PUB_PRIV_REPORT
16.18
MGMT$ESA_SYS_PUB_PKG_REPORT
16.19
MGMT$ESA_TABSP_OWNERS_REPORT
16.20
MGMT$ESA_TRC_AUD_PERM_REPORT
16.21
MGMT$ESA_WITH_ADMIN_REPORT
16.22
MGMT$ESA_WITH_GRANT_REPORT
16.23
MGMT$ESM_COLLECTION_LATEST
16.24
MGMT$ESM_FILE_SYSTEM_LATEST
16.25
MGMT$ESM_PORTS_LATEST
16.26
MGMT$ESM_SERVICE_LATEST
16.27
MGMT$ESM_STACK_LATEST
17
Storage Reporting Views
17.1
MGMT$STORAGE_REPORT_DATA
17.2
MGMT$STORAGE_REPORT_KEYS
17.3
MGMT$STORAGE_REPORT_PATHS
17.4
MGMT$STORAGE_REPORT_ISSUES
17.5
MGMT$STORAGE_REPORT_DISK
17.6
MGMT$STORAGE_REPORT_VOLUME
17.7
MGMT$STORAGE_REPORT_LOCALFS
17.8
MGMT$STORAGE_REPORT_NFS
18
Target Views
18.1
MGMT$AGENTS_MONITORING_TARGETS
18.2
MGMT$EM_ECM_MOS_PROPERTIES
18.3
MGMT$EM_ECM_TARGET_FRESHNESS
18.4
MGMT$MANAGEABLE_ENTITIES
19
Virtualization Views
19.1
MGMT$VT_VM_CONFIG
19.2
MGMT$VT_VM_SW_CFG
19.3
MGMT$VT_VM_VNIC
19.4
MGMT$VT_VM_VNIC_QOS
19.5
MGMT$VT_VM_EM_CFG
19.6
MGMT$VT_VM_VDISKS
19.7
MGMT$VT_VM_VDISK_QOS
19.8
MGMT$VT_EXA_CTRL_VSERVER_TAGS
19.9
MGMT$VT_VSP_CONFIG
19.10
MGMT$VT_VS_HW_CFG
19.11
MGMT$VT_VS_HYPERVISOR
19.12
MGMT$VT_VS_PROCESSORS
19.13
MGMT$VT_VS_SW_CFG
19.14
MGMT$VT_VS_ATTRIBUTES
19.15
MGMT$VT_VS_FS_MOUNTS
19.16
MGMT$VT_VS_NET_DEVICE
19.17
MGMT$VT_VS_FILESERVERS
19.18
MGMT$VT_VS_REPOS
19.19
MGMT$VT_VS_ABILITIES
19.20
MGMT$VT_ZONE_CONFIG
20
Examples
20.1
Blackout Views
20.1.1
How do I return all targets under a blackout?
20.1.2
How can I view a list of future scheduled blackouts?
20.1.3
How can I view the number of targets blacked out in the last 30 days?
20.2
Compliance Views
20.2.1
How do I view a list of all the compliance rules?
20.2.2
How do I view the monitoring compliance rules only?
20.2.3
How do I view all the repository compliance rules for a specific author?
20.2.4
How do I view a list of all the compliance standards?
20.2.5
How do I view all compliance standards owned by a specific user
20.2.6
How do I view a list of all the compliance standard groups?
20.2.7
How do I view all compliance standard groups in production?
20.2.8
How do I query results for compliance standards with no included standards
20.2.9
How do I obtain the results for compliance standards with included standards?
20.2.10
How do I obtain the results for compliance standard rules in a compliance standard for a target?
20.2.11
How do I obtain the results for compliance standard groups?
20.2.12
How do I obtain association information for compliance standards and targets?
20.2.13
How do I obtain the violation ID for an active violation of a compliance rule?
20.2.14
How do I obtain the violation column information?
20.2.15
How do I access the compliance rule violation context definition-related metadata?
20.2.16
How do I find all bundles that are in violation?
20.2.17
How do I find all observations (all states) for all bundles in violation?
20.2.18
How do I get a list of all the actions that occurred on all targets during a specific time range?
20.2.19
How do I get a list of all actions that occurred on a single target during a specific time range?
20.2.20
How do I get a list of all the file changes that occurred on a single target during a specific time range?
20.2.21
How do I get a list of all unauthorized actions that occurred during a specific time range?
20.2.22
How do I get a list of all occurrences of sudo?
20.3
Enterprise Configuration Management Views
20.3.1
How do I view a list of all the Enterprise Configuration Management snapshots visible to the current Enterprise Manager user, including both current and saved snapshots?
20.3.2
How do I get a list of all current configuration snapshots and limit the access to the snapshots based on the logged in user?
20.3.3
How do I view the targets involved in a comparison?
20.3.4
How do I view the latest comparison job results for a first target, second target combination?
20.3.5
How do I view all the comparison jobs that ran for a first target, second target combination?
20.3.6
How do I view the number of comparison differences for each configuration item in a comparison?
20.3.7
How do I view the comparison CCS data source information, such as CCS file name and difference status?
20.3.8
How do I view comparison CCS data source detail information?
20.3.9
How do I retrieve the comparison CCS data?
20.3.10
How do I get a list of all the CCS data sources or collected CCS files visible to the current Enterprise Manager user?
20.3.11
How do I get a list of the current CCS data sources or collected CCS files visible to current Enterprise Manager user?
20.3.12
How do I view the CCS-parsed data visible to the current Enterprise Manager user?
20.3.13
How do I view the current CCS-parsed data?
20.4
Hardware Views
20.4.1
How do I create a derived associations rule which establishes associations between a host and an Oracle VM Guest target on which it is deployed?
20.5
Inventory Views
20.5.1
How do I get the number of targets for a metric?
20.5.2
How do I get the number of Management Agents for a version?
20.5.3
How do I get a list of all the Agent-side targets?
20.5.4
How do I get a list of the secure and unsecure Management Agents for each operating system?
20.5.5
How do I get a list of the Management Agents with the most discovered targets of a given target type?
20.5.6
How do I get a list of all the Management Agent-side targets that are discovered today?
20.5.7
How do I get the number of broken targets for each host?
20.5.8
How do I get the number of discovered systems for each operating system?
20.5.9
How do I get the maximum number of targets of the same type that are discovered on a single system?
20.5.10
How do I get the listener port for each database?
20.5.11
How do I get the number of databases for each category version?
20.5.12
How do I get the number of databases for each category version and CPU count?
20.5.13
How do I get the number of databases for each category version and OS platform?
20.5.14
How do I find the number of hosts grouped by operating system?
20.5.15
How do I view a list of targets used in the Oracle Enterprise Manager Cloud Control website definition?
20.5.16
How do I find the number of targets grouped for each type for the Cloud Control Infrastructure group?
20.5.17
How do I find the number of Management Agents grouped for each version?
20.5.18
How do I view a list of all metrics for the Management Agent on the oms.test.com system?
20.5.19
How do I view a list of all clustered targets in the repository?
20.6
Jobs Views
20.6.1
How can I view a list of all running repeating jobs?
20.6.2
How do I view the number of notifications sent for failed jobs for each job owner?
20.6.3
How do I view a list of all jobs that have the Management Repository itself as a target?
20.7
Management Template Views
20.7.1
How do I view a list of all public templates?
20.8
Metric Views
20.8.1
How do I return the current thresholds for the alertlog metric?
20.8.2
How do I view a list of all metric errors for metrics on Management Agents?
20.8.3
How do I find the number of UDM metric errors on host targets in the last 30 days?
20.9
Monitoring Views
20.9.1
How do I get database metrics with outstanding severities?
20.9.2
How do I get a list of all disabled metrics on Management Agents?
20.9.3
How do I get the number of down targets?
20.9.4
How do I get the availability information for the Enterprise Manager website?
20.9.5
How do I get the number of alertlog severities for the database in the last 24 hours?
20.9.6
How do I get the current CPU utilization of a host?
20.9.7
How do I get a list of all the collected user-defined metrics (UDMs)?
20.9.8
How do I get the first byte response for the Enterprise Manager website at a specific time?
20.9.9
How do I obtain the average number of connections for a listener for a specific period?
20.9.10
How do I find the reasons for host outages lasting longer than one day?
20.9.11
How do I generate a list of all targets currently blacked out?
20.9.12
How do I view a list of availability state changes made to targets in the repository in the last 30 days?
20.9.13
How do I find all hosts with more than 90 percent CPU utilization?
20.9.14
How do I find the minimum and maximum number of sessions for all OMS applications in the last 30 days?
20.9.15
How do I find the loader throughput of the OMS on the last day?
20.9.16
How do I find the minimum and maximum number from the last full day for the performance of Oracle Enterprise Manager Cloud Control?
20.9.17
How do I view a list of all targets with the Response metric disabled?
20.9.18
How do I view a list of all database or RAC targets that have the tablespace thresholds set to less than 85 for warning and 95 for critical?
20.10
Oracle Home Directory Views
20.10.1
How do I find information about every Management Agent installation?
20.10.2
How do I get a list of the installed Management Agent bundle patches?
20.10.3
How do I get a list of Management Agents that don't have a specific patch installed?
20.11
Operating System Views
20.11.1
How do I retrieve information from MGMT$OS_SUMMARY for a specific host from the Management Repository?
Index
Scripting on this page enhances content navigation, but does not change the content in any way.