Go to main content
1/25
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
What's Changed in this Guide?
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$COMPLIANT_TARGETS
4.32
MGMT$COMPLIANCE_SUMMARY
4.33
MGMT$COMPLIANCE_TREND
5
Configuration Management Views
5.1
Configuration Management Views
5.1.1
MGMT$CSA_COLLECTIONS
5.1.2
MGMT$CSA_FAILED
5.1.3
MGMT$CSA_HOST_OS_COMPONENTS
5.1.4
MGMT$CSA_HOST_SW
5.1.5
MGMT$CSA_HOST_COOKIES
5.1.6
MGMT$CSA_HOST_CUSTOM
5.1.7
MGMT$CSA_HOST_RULES
5.1.8
MGMT$CSA_HOST_CPUS
5.1.9
MGMT$CSA_HOST_IOCARDS
5.1.10
MGMT$CSA_HOST_NICS
5.1.11
MGMT$CSA_HOST_OS_PROPERTIES
5.1.12
MGMT$CSA_HOST_OS_FILESYSEMS
5.2
Custom Configuration Specification Views
5.2.1
MGMT$CCS_DATA
5.2.2
MGMT$CCS_DATA_SOURCE
5.2.3
MGMT$CCS_DATA_VISIBLE
5.2.4
MGMT$CCS_DATA
5.3
Database Configuration Views
5.3.1
MGMT$DB_TABLESPACES
5.3.2
MGMT$DB_DATAFILES
5.3.3
MGMT$DB_CONTROLFILES
5.3.4
MGMT$DB_DBNINSTANCEINFO
5.3.5
MGMT$DB_FEATUREUSAGE
5.3.6
MGMT$DB_INIT_PARAMS
5.3.7
MGMT$DB_LICENSE
5.3.8
MGMT$DB_REDOLOGS
5.3.9
MGMT$DB_ROLLBACK_SEGS
5.3.10
MGMT$DB_SGA
5.3.11
MGMT$DB_TABLESPACES_ALL
5.3.12
MGMT$DB_OPTIONS
5.4
Enterprise Configuration Management Views
5.4.1
MGMT$ECM_CMP_JOBS
5.4.2
MGMT$ECM_CMP_JOB_LAST_RESULTS
5.4.3
MGMT$ECM_CMP_RPT_CCS_DS
5.4.4
MGMT$ECM_CMP_RPT_CCS_DS_DTLS
5.4.5
MGMT$ECM_CMP_RPT_CCS_PD_ALL
5.4.6
MGMT$ECM_CMP_RPT_CCS_PD_DIFFS
5.4.7
MGMT$ECM_CMP_RPT_CI_DIFFS
5.4.8
MGMT$ECM_CMP_VISIBLE_CONFIGS
5.4.9
MGMT$ECM_CURRENT_SNAPSHOTS
5.4.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 the listener port for each database?
20.5.4
How do I get the number of databases for each category version?
20.5.5
How do I get the number of databases for each category version and CPU count?
20.5.6
How do I get the number of databases for each category version and OS platform?
20.5.7
How do I find the number of hosts grouped by operating system?
20.5.8
How do I view a list of targets used in the Oracle Enterprise Manager Cloud Control website definition?
20.5.9
How do I find the number of targets grouped for each type for the Cloud Control Infrastructure group?
20.5.10
How do I find the number of Management Agents grouped for each version?
20.5.11
How do I view a list of all metrics for the Management Agent on the oms.test.com system?
20.5.12
How do I view a list of all clustered targets in the repository?
20.5.13
How do I view a list of all the installed Management Agent bundle patches?
20.5.14
How do I view a list of all the Management Agents that do not have Oracle 12c Release 4 Bundle Patch 9 installed?
20.5.15
How do I view the details of every Management Agent installation?
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
Operating System Views
20.10.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.