有同事问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
18 Target Views
This chapter provides a description of each target view and its columns. It contains the following sections: