Oracle Cloud Control 12C 中的target信息查询

来源：互联网发布：窃听软件免费下载编辑：程序博客网时间：2024/04/27 08:25

有同事问grid control中的target信息保存在哪里，怎么查。

其实登陆”Repository database“之后，就可以查询很多view了。

比如：

SQL> select distinct TARGET_TYPE from MGMT$AGENTS_MONITORING_TARGETS order by TARGET_TYPE;

TARGET_TYPE
----------------------------------------------------------------
cluster
has
host
j2ee_application
metadata_repository
mysql
oracle_apache
oracle_beacon
oracle_database
oracle_emd
oracle_emrep
oracle_home
oracle_ias_farm
oracle_listener
oracle_oms
oracle_oms_console
oracle_oms_pbs
osm_cluster
osm_instance
rac_database
weblogic_domain
weblogic_j2eeserver

22 rows selected.

SQL>

可以参考官方文档：

https://docs.oracle.com/cd/E24628_01/doc.121/e57277/ch29_targetviews.htm#EMVWS32321

Enterprise Manager Cloud Control Management Repository Views Reference

18 Target Views

This chapter provides a description of each target view and its columns. It contains the following sections:

MGMT$AGENTS_MONITORING_TARGETS
MGMT$EM_ECM_MOS_PROPERTIES
MGMT$EM_ECM_TARGET_FRESHNESS
MGMT$MANAGEABLE_ENTITIES

阅读全文

0 0