Unexpected EOF

Cause
Issue is addressed using the following bug:
BUG 27579283 – oracledb.pl: Can’t use string as a HASH
Solution
Issue is fixed in future version of EM.
The fix is getting included in EM-DB-BP 13.2.2.0.180731 Bundle Patch.
该问题由于代理引起:重新部署代理,或修改代理路径,或修改/etc/oratab,清空实例信息

#testb:/u01/app/oracle/product/12.2.0/db_1:N
#testc:/u01/app/oracle/product/12.2.0/db_1:N
[root@db02:/]{20180712+0 14:39:02}#
Posted in 学习 | Unexpected EOF已关闭评论

How do I get the current CPU utilization of a host

20.9.6 How do I get the current CPU utilization of a host

SQL> SELECT column_label, value
  2    FROM mgmt$metric_current
  3   WHERE metric_name = 'Load'
  4     AND metric_column = 'cpuUtil'
  5     AND target_name = 'dba';
COLUMN_LABEL            VALUE
----------------------- -------
CPU Utilization (%)     .77
SQL>

获取一台主机上所有监控信息

SELECT DISTINCT metric_group_label as metric_group,
                metric_column_label metric_name,
                nvl(warning_threshold, ' ') as warning_threshold,
                nvl(critical_threshold, ' ') as critical_threshold,
                decode(mc.is_enabled, 1, 'Yes', 0, 'No') is_enabled,
                emc.entity_type
  FROM sysman.gc_metric_columns_target emc,
       (SELECT policy_guid metric_guid,
               NVL(warn_threshold, ' ') warning_threshold,
               NVL(crit_threshold, ' ') critical_threshold,
               coll_name
          FROM sysman.mgmt_policy_assoc_cfg_params
         WHERE object_guid IN
               (SELECT target_guid
                  FROM sysman.mgmt_targets
                 where (target_name, target_type) in
                       (SELECT a.target_name, a.target_type
                          FROM mgmt$target a
                         where host_name = 'dba'))
           AND param_name = ' ') thr,
       sysman.MGMT_COLLECTIONS mc
 WHERE (entity_name, entity_type) in
       (SELECT a.target_name, a.target_type
          FROM mgmt$target a
         where host_name = 'dba')
   AND usage_type = 0
   and entity_guid = mc.object_guid
   and thr.coll_name = mc.coll_name
   AND emc.metric_column_guid = thr.metric_guid(+)
 order by metric_group asc;

很多How To

Posted in Em & Oem | How do I get the current CPU utilization of a host已关闭评论