This chapter provides a description of each target view and its columns. It contains the following sections:
For examples of how to use views, see Examples.
The MGMT$AGENTS_MONITORING_TARGETS view shows the available Management Agents for targets.
Table 18-1 MGMT$AGENTS_MONITORING_TARGETS
Column | Description |
---|---|
TARGET_NAME |
Name of the target |
TARGET_TYPE |
Type of the target |
TARGET_GUID |
Unique ID of the target |
AGENT_NAME |
Name of the Management Agent monitoring the target |
AGENT_TYPE |
Type of Management Agent |
AGENT_GUID |
Unique ID of the Management Agent |
AGENT_IS_MASTER |
Specifies whether the Management Agent is a master or slave. Possible values:
|
EMD_URL |
URL of the emd monitoring the target |
HOST_NAME |
Host on which the target or Management Agent resides |
MONITORING |
Indicates how the target is monitored. Possible values:
|
The MGMT$EM_ECM_MOS_PROPERTIES view exposes target information useful for My Oracle Support and Patching. It returns values from the EM_ECM_MOS_PROPERTIES table.
Table 18-2 MGMT$EM_ECM_MOS_PROPERTIES
Column | Description |
---|---|
TARGET_GUID |
The GUID of the target |
HOST_TARGET_GUID |
The GUID of the host that is hosting this target. The value is NULL for host targets. |
ORACLE_HOME_TARGET_GUID |
The GUID of the Oracle home target where this target is installed |
PLATFORM_ID |
The platform ID of the host that is hosting this target |
PLATFORM_VERSION_ID |
The platform version ID of the host that is hosting this target |
The MGMT$EM_ECM_TARGET_FRESHNESS view exposes the newest and oldest configuration snapshot information on a per target basis. It returns the collection timestamp and snapshot GUID for the most recently collected (newest) and least recently (oldest) collected snapshot for the target. If the target is a system, then the values will be valid across all snapshots of all member targets of the system.
Table 18-3 MGMT$EM_ECM_TARGET_FRESHNESS
Column | Description |
---|---|
TARGET_GUID |
The GUID of the target |
NEWEST_SNAPSHOT_GUID |
The snapshot GUID of the most recent collection |
NEWEST_SNAPSHOT_TIMESTAMP |
The date and time of the most recent collection |
OLDEST_SNAPSHOT_GUID |
The snapshot GUID of the oldest collection |
OLDEST_SNAPSHOT_TIMESTAMP |
The date and time of the oldest collection |
The MGMT$MANAGEABLE_ENTITIES view contains a list of all the Manageable Entities in Enterprise Manager.
Table 18-4 MGMT$MANAGEABLE_ENTITIES
Column | Description |
---|---|
ENTITY_GUID |
Unique ID corresponding to the Manageable Entity.
|
ENTITY_TYPE |
Type of the Manageable Entity.
|
ENTITY_NAME |
Name of the Manageable Entity.
|
PARENT_ME_GUID |
Parent entity containing the target component. For non-target components, this column is equal to ENTITY_GUID. |
PARENT_ME_TYPE |
Type of the parent target. (Valid for target components only) |
PARENT_ME_NAME |
Name of the parent target. (Valid for target components only) |
MANAGE_STATUS |
Manage status of the entity. Possible values:
|
PROMOTE_STATUS |
Promote status of the target
|
DYNAMIC_PROPERTY_STATUS |
Status of the dynamic properties Possible values:
|
TYPE_META_VER |
Metadata version number |
CATEGORY_PROP_N |
Up to five category properties can be used to distinguish different metric definitions based on different configurations. For example, OS version, database version, Oracle RAC configuration, and so on. |
TIMEZONE_REGION |
Name of the time zone region that the target operates in. Note: Component will be in same time zone as the target |
DISPLAY_NAME |
User-friendly name for the Manageable Entity |
OWNER |
Enterprise Manager administrator that owns the target |
HOST_NAME |
Host on which the target resides |
EMD_URL |
The URL for the EMD where the target is being collected |
BROKEN_REASON |
Code representing a reason why a target is broken Possible values:
|
BROKEN_STR |
String associated with the broken reason |
MONITORING_MODE |
Indicates how the target is monitored. Possible values:
|
IS_PROPAGATING |
Specifies whether the Manageable Entity is privilege propagating |
DISCOVERED_NAME |
Name with which the Manageable Entity was discovered |
ORG_ID |
Organization ID used by the Oracle Configuration Manager (OCM) Harvseter. This ID is used to uniquely identify customers. Note: A large customer might have multiple organization IDs to represent different lines of business within the company. |
ORACLE_HOME |
Oracle home of the target |
ORACLE_CONFIG_HOME |
This value is used by the OCM collector and CCR to indicate targets that might share a single Oracle home but have their configuration state kept in separate directories |
LOAD_TIMESTAMP |
The date and time when the Manageable Entity record was first loaded (in the time zone of the Management Repository) |