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