Inventory Views

8 Inventory Views

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

For examples of how to use views, see Examples.

Inventory Views

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

MGMT$TARGET

The MGMT$TARGET view displays information about the managed targets that are known to the Management Repository. These targets may or may not be actively monitored.

Table 8-1 MGMT$TARGET

Column	Description
TARGET_NAME	Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE	The type of the target. Types of targets may include databases, hosts, web servers, applications, or Application Servers. The definer of the collection definition at the Management Agent defines the target type. The target type defines the set of metrics that are collected for a managed target within the Management Repository.
TARGET_GUID	The unique global identifier for the target.
TYPE_VERSION	The target type meta version of the metadata set. Metadata versions may be updated when applying patches or upon new releases of Enterprise Manager Grid Control.
TYPE_QUALIFIER1-5	Up to five qualifiers can be used to distinguish different metric definitions based on different system configurations. Example qualifier entries might include operating system version, database version, or Oracle RAC configuration.
EMD_URL	The URL address of the Management Agent that is managing the target
TIMEZONE_REGION	The time zone region in which the target operates
DISPLAY_NAME	User-friendly name for the target
HOST_NAME	Name of the host where the target is running. For composite targets or targets that span a host, this column will be NULL.
LAST_METRIC_LOAD_TIME	Time stamp of when information for this target was last loaded into the Management Repository. If metrics have not been loaded into the Management Repository for the target, this column will be NULL.
TYPE_DISPLAY_NAME	User-friendly name of the target type
OWNER VARCHAR2	Enterprise Manager administrator that owns the target
LAST_LOAD_TIME_UTC	The UTC date and time when the data was last loaded for the target
CREATION_DATE	Date when target was first added to the repository in the Database's timezone
BROKEN_REASON	May indicate a reason for target not getting monitored by the Agent Note: For Oracle support use only, contact your Oracle representative
BROKEN_STR	May indicate a reason for target not getting monitored by the Agent Note: For Oracle support use only, contact your Oracle representative

Usage Notes

Display a list of the targets known to the Management Repository.
Display administration and monitoring information in the context of a managed target.
Order the targets by last load time for customers to get a sense on how recent the information is for a target in the Management Repository. To access this information in an ordered way, customers should use the appropriate ORDER BY clause with the view.
Access to this view will use an index if the query references the target name and target type.
There is an implicit assumption that customers will not use this view to identify the targets that are owned by a Management Agent or the targets that reside on a specific host.

MGMT$TARGET_TYPE

The MGMT$TARGET_TYPE view displays metric descriptions for a given target name and target type. This information is available for the metrics for the managed targets that have been loaded into the Management Repository. Metrics are specific to the target type.

Table 8-2 MGMT$TARGET_TYPE

Column	Description
TARGET_NAME	Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE	The target type defines the set of metrics that are applicable for the target
TARGET_GUID	The unique global identifier for the target
TYPE_VERSION	The target type meta version of the metadata set. Metadata versions may be updated when applying patches or upon new releases of Enterprise Manager Grid Control.
TYPE_QUALIFIER1-5	Up to five qualifiers can be used to distinguish different metric definitions based on different system configurations. Example qualifier entries may include operating system version, database version, or Oracle RAC configuration.
METRIC_NAME	The name of the metric that is being defined
METRIC_COLUMN	For table metrics, the metric column contains the name of the column in the table that is being defined. If the metric that is being defined is not a table metric, the value in this column is a single space. For example, if a table describing the MGMT$TARGET_TYPE view is to be defined as a table metric, Column Name, Data Type, and Description would be metric columns.
KEY_COLUMN	For table metrics, the key column contains the name of the column in the table that represents the primary key. Values in this column must uniquely identify rows in the table. If the metric that is being defined is not a table metric, the value in this column is a single space; For example, the Column Name would be the key column if this table describing the MGMT$TARGET_TYPE view was being defined as a table metric.
METRIC_TYPE	A DECODE of the internal numeric type of the metric that is being defined. This column will contain one of the following values: Number String Table Raw External Repository Metric
METRIC_LABEL	A intuitive display name for the metric that is being defined
COLUMN_LABEL	For table metrics, the column label contains a user understandable display name for the metric column
DESCRIPTION	A description of the metric that is being defined
DESCRIPTION_NLSID	The NLSid of the description of the metric
UNIT	The unit of the metric that is being defined
UNIT_NLSID	The NLSid of the unit of the metric being defined
SHORT_NAME	This is a shortened version of the metric display name for the "dense" UI concept
SHORT_NAME_NLSID	The NLSid of the short name of the metric being defined

Usage Notes

List the set of metrics that have been defined for a target type.
Display intuitive metric names and associated attributes such as unit in a general way during portal, web application, or custom 4GL report generation.
Access to this view will use an index if the query references the metric name, metric column. The query should also qualify the target name and target type in order to restrict the amount of information returned.

MGMT$TARGET_TYPE_DEF

The MGMT$TARGET_TYPE_DEF view displays definition information for a target type.

Table 8-3 MGMT$TARGET_TYPE_DEF

Column	Description
TARGET_TYPE	The target type defines the set of metrics that are applicable for the target
TYPE_DISPLAY_NAME	User-friendly name of the target type
TARGET_TYPE_GUID	The unique global identifier (GUID) of the target type
MAX_TYPE_META_VER	The maximum version of the target type stored in the Management Repository

MGMT$TARGET_ASSOCIATIONS

The MGMT$TARGET_ASSOCIATIONS view displays the various associations between targets. This view can be used to find all types of associations for a given target.

Table 8-4 MGMT$TARGET_ASSOCIATIONS

Column	Description
ASSOC_DEF_NAME	Name of the association definition
SOURCE_TARGET_NAME	Target name of the target to which the association is being defined
SOURCE_TARGET_TYPE	The target type of the target for which the association is being defined. “ANY" can be used to specify that any target type be used.
ASSOC_TARGET_NAME	Target Name of the target which is being associated with the source target
ASSOC_TARGET_TYPE	The target type of the associated target. “ANY" can be used to specify that any target type be used
SCOPE_TARGET_NAME	The target under whose scope the association is valid This applies to non-global associations only. For example: A database may be part of a composite target only for a particular service.
SCOPE_TARGET_TYPE	The target type for which the association is valid. This applies to non-global associations only.
ASSOCIATION_TYPE	The type of association

Usage Notes

Can be used to list the associations defined for a specific target.
Queries using this view will use an index if either (source_target_name, source_target_type) or (assoc_target_name, assoc_target_type) is specified.

MGMT$TARGET_MEMBERS

The MGMT$TARGET_MEMBERS view displays the list of direct members for a target.

Table 8-5 MGMT$TARGET_MEMBERS

Column	Description
AGGREGATE_TARGET_NAME	Target name of the aggregate target
AGGREGATE_TARGET_TYPE	Target type of the aggregate target
AGGREGATE_TARGET_GUID	Target GUID of the aggregate target
MEMBER_TARGET_NAME	Target name of the member target
MEMBER_TARGET_TYPE	Target type of the member target
MEMBER_TARGET_GUID	Target GUID of the member target

Usage Notes

Find the members for a aggregate target.
Find the aggregate targets for which a given target is a direct member.
Queries, which specify values for (AGGREGATE_TARGET_NAME, AGGREGATE_TARGET_TYPE) or (MEMBER_TARGET_NAME, MEMBER_TARGET_TYPE) will use index.
Joins using AGGREGATE_TARGET_GUID and MEMBER_TARGET_GUID will be efficient.

MGMT$TARGET_FLAT_MEMBERS

The MGMT$TARGET_FLAT_MEMBERS view displays the list of all direct and indirect members of the target.

Table 8-6 MGMT$TARGET_FLAT_MEMBERS

Column	Description
AGGREGATE_TARGET_NAME	The target name of the aggregate target
AGGREGATE_TARGET_TYPE	The target type of the aggregate target
AGGREGATE_TARGET_GUID	Target GUID of the aggregate target
MEMBER_TARGET_NAME	Target Name of the member target
MEMBER_TARGET_TYPE	Target type of the member target
MEMBER_TARGET_GUID	Target GUID of the member target

Usage Notes

Find the members for an aggregate target.
Find the aggregate targets for which a given target is a member either directly or indirectly.
Queries, which specify values for (AGGREGATE_TARGET_NAME, AGGREGATE_TARGET_TYPE) or (MEMBER_TARGET_NAME, MEMBER_TARGET_TYPE), will use index.
Joins using AGGREGATE_TARGET_GUID and MEMBER_TARGET_GUID will be the most efficient on this view.

MGMT$TARGET_TYPE_PROPERTIES

The MGMT$TARGET_TYPE_PROPERTIES view displays the default list of properties that are applicable to the target based on the target type to which the target belongs.

Table 8-7 MGMT$TARGET_TYPE_PROPERTIES

Column	Description
TARGET_NAME	Name of the target
TARGET_TYPE	Name of the target type
PROPERTY_NAME	Name of the property, such as is_aggregate, is_service, IsBaselineable
PROPERTY_VALUE	Value of the property

Usage Notes

List the properties applicable to the target and the default values.

MGMT$TARGET_PROPERTIES

The MGMT$TARGET_PROPERTIES view displays detailed target properties.

Table 8-8 MGMT$TARGET_PROPERTIES

Column	Description
TARGET_NAME	Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE	The target type defines the set of metrics that are applicable for the target
TARGET_GUID	The unique global identifier for the target
PROPERTY_NAME	The name of the target property being defined
PROPERTY_VALUE	The value of the target property being defined
PROPERTY_TYPE	The type of the target property being defined. Possible values are: INSTANCE, if the property is applicable to the target instance. DYNAMIC, if the property is calculated dynamically.

Oracle Home Directory Patching Views

This section provides a description of each Oracle home directory patching view. It includes the following sections:

MGMT$EM_HOMES_PLATFORM

The MGMT$EM_HOMES_PLATFORM view displays the platform information about the home directories. If the home directory does not have an ARU platform ID, then the platform of the Operating System is considered as the platform of the home directory.

Table 8-9 MGMT$EM_HOMES_PLATFORM

Column	Description
HOME_ID	Unique ID for the home directory
PLATFORM_ID	If the home directory has an ARU platform it is used, otherwise the platform ID of the host is picked
PLATFORM	The platform corresponding to the platform_id

MGMT$APPL_PATCH_AND_PATCHSET

The MGMT$APPL_PATCH_AND_PATCHSET view displays the list of interim patches and patchsets that are applicable to the home directories.

Table 8-10 MGMT$APPL_PATCH_AND_PATCHSET

Column	Description
PATCH_ID	The patch ID
TYPE	Patch or patchset
PRODUCT	The product pertaining to the patch
PATCH_RELEASE	Release version
PLATFORM	Platform on which patch is applicable
ADVISORY	The alert name
HOST_NAME	Host name
HOME_LOCATION	Home directory location
PATCH_GUID	Unique ID for the patch or patchset
TARGET_GUID	Unique ID for the target

MGMT$HOMES_AFFECTED

The MGMT$HOMES_AFFECTED view displays the list of home directories, vulnerable to bugs, which are fixed by the critical patches released. The number of alerts which are applicable to the home directory are calculated.

Table 8-11 MGMT$HOMES_AFFECTED

Column	Description
HOST	Host name
HOME_DIRECTORY	Home directory location
TARGET_GUID	Unique ID for target
ALERTS	Number of alerts for this home directory

MGMT$APPLIED_PATCHES

The MGMT$APPLIED_PATCHES view displays the list of patches that have been applied on the home directories along with the installation time. Each patch can fix more than one bug. The bugs are listed in a comma-separated string.

Table 8-12 MGMT$APPLIED_PATCHES

Column	Description
PATCH	Patch name
BUGS	The bugs fixed by this patch
INSTALLATION_TIME	Time of installation (time zone of the target)
HOST	Host name
HOME_LOCATION	Home location
HOME_NAME	Name of the home
CONTAINER_GUID	Name of the home
TARGET_GUID	Unique ID for target

MGMT$APPLIED_PATCHSETS

The MGMT$APPLIED_PATCHSETS view displays the list of patchsets that have been applied on the home directories along with the installation time.

Table 8-13 MGMT$APPLIED_PATCHSETS

Column	Description
VERSION	The version to which the home will get upgraded to when this patchset is applied
NAME	Patchset external name
TIMESTAMP	Time of Installation (time zone of the target)
HOST	Host name
HOME_LOCATION	Home location
HOME_NAME	Name of the home directory
CONTAINER_GUID	Name of the home directory
TARGET_GUID	Unique ID for target

Oracle Home Directory Views

This section provides a description of each Oracle home directory view and its columns. It includes the following sections:

MGMT$OH_HOME_INFO

The MGMT$OH_HOME_INFO view contains properties of the Oracle home targets.

Table 8-14 MGMT$OH_HOME_INFO

Column	Description
ECM_SNAPSHOT_ID	ECM Snapshot ID of the current snapshot for Oracle home target
TARGET_NAME	Name of Oracle home target
TARGET_GUID	Oracle home target globally unique identifier
HOST_NAME	Name of the host on which the Oracle home directory is installed
EMD_URL	EMD_URL of the agent monitoring this Oracle home target
HOME_LOCATION	Complete path to the Oracle home directory
OUI_HOME_NAME	OUI home name
OUI_HOME_GUID	OUI Oracle home globally unique identifier. This is unique across all Oracle product installations.
HOME_TYPE	Type of the HOME ('O' [OUI] or 'W' [WebLogic])
HOME_POINTER	OUI Central Inventory/ Composite Home / BEA Home that contains this home
IS_CLONABLE	Is this home clonable? [0/1]
IS_CRS	Is it a Cluster Ready Services (CRS) home [0/1]
ARU_ID	ARU Platform ID of the Oracle home directory
OUI_PLATFORM_ID	OUI Platform ID of the host
HOME_SIZE	Size of the Oracle home directory (in KBytes)
HOME_RW_STATUS	Read write status of home[NRNW/RO/WO/RW]
ORACLE_BASE	Oracle Base (for OUI homes only)
OH_OWNER_ID	Oracle home owner ID
OH_OWNER	Oracle home owner
OH_GROUP_ID	Oracle home group ID
OH_GROUP	Oracle home group
OH_OWNER_GROUPS_ID	Semi colon separated list of groups IDs to which the Oracle home owner belong
OH_OWNER_GROUPS	Semi colon separated list of groups to which the Oracle home owner belongs

MGMT$OH_DEP_HOMES

The MGMT$OH_DEP_HOMES view contains information about other homes on which an Oracle home depends.

Table 8-15 MGMT$OH_DEP_HOMES

Column	Description
ECM_SNAPSHOT_ID	ECM Snapshot ID of the current snapshot for Oracle home target
TARGET_NAME	Name of Oracle home target
TARGET_GUID	Oracle home target globally unique identifier
HOST_NAME	Name of the host on which Oracle home is installed
HOME_LOCATION	Complete path to the Oracle home
HOME_NAME	OUI home name
DEP_HOME_LOCATION	Install location of dependee home

MGMT$OH_CRS_NODES

The MGMT$OH_CRS_NODES view contains information about member nodes of a CRS Oracle home.

Table 8-16 MGMT$OH_CRS_NODES

Column	Description
ECM_SNAPSHOT_ID	ECM Snapshot ID of the current snapshot for Oracle home target
TARGET_NAME	Name of Oracle home target
TARGET_GUID	Oracle home target globally unique identifier
HOST_NAME	Name of the host on which Oracle home is installed
HOME_LOCATION	Complete path to the Oracle home
HOME_NAME	OUI home name
NODE	Node host name

MGMT$OH_CLONE_PROPERTIES

The MGMT$OH_CLONE_PROPERTIES view contains information about clone properties of an Oracle home.

Table 8-17 MGMT$OH_CLONE_PROPERTIES

Column	Description
ECM_SNAPSHOT_ID	ECM Snapshot ID of the current snapshot for the Oracle home target
TARGET_NAME	Name of the Oracle home target
TARGET_GUID	Oracle home target globally unique identifier
HOST_NAME	Name of the host on which the Oracle home is installed
HOME_LOCATION	Complete path to the Oracle home
HOME_NAME	OUI home name
PROPERTY_NAME	Clone property name
PROPERTY_VALUE	Property value

MGMT$OH_COMPONENT

The MGMT$OH_COMPONENT view contains information about components installed in an Oracle home.

Table 8-18 MGMT$OH_COMPONENT

Column	Description
ECM_SNAPSHOT_ID	ECM Snapshot ID of the current snapshot for the Oracle home target
TARGET_NAME	Name of the Oracle home target
TARGET_GUID	Oracle home target globally unique identifier
HOST_NAME	Name of the host on which the Oracle home is installed
HOME_LOCATION	Complete path to the Oracle Home
HOME_NAME	OUI home name
COMPONENT_NAME	Component name
VERSION	Current version of component
BASE_VERSION	Component base version
INSTALL_TIME	Installation time of component
IS_TOP_LEVEL	Is it a top level component [0/1]
EXTERNAL_NAME	External name of the component
DESCRIPTION	A brief description of the component
LANGUAGES	Languages supported by this component installation
INSTALLED_LOCATION	Component install location
INSTALLER_VERSION	Installer version
MIN_DEINSTALLER_VERSION	Minimum OUI version required to deinstall this component

MGMT$OH_COMP_INST_TYPE

The MGMT$OH_COMP_INST_TYPE view contains Install Type information about components installed in an Oracle home directory.

Table 8-19 MGMT$OH_COMP_INST_TYPE

Column	Description
ECM_SNAPSHOT_ID	ECM Snapshot ID of the current snapshot for the Oracle home target
TARGET_NAME	Name of the Oracle home target
TARGET_GUID	Oracle home target globally unique identifier
HOST_NAME	Name of the host on which Oracle home is installed
HOME_LOCATION	Complete path to the Oracle home
HOME_NAME	OUI home name
COMPONENT_NAME	Component name
COMPONENT_VERSION	Component base version
NAME_ID	Install type name ID
INSTALL_TYPE_NAME	Install type name
DESC_ID	Install type desc ID

MGMT$OH_COMP_DEP_RULE

The MGMT$OH_COMP_DEP_RULE view contains information about a dependency relationship between components installed in an Oracle home.

Table 8-20 MGMT$OH_COMP_DEP_RULE

Column	Description
ECM_SNAPSHOT_ID	ECM Snapshot ID of the current snapshot for the Oracle home target
TARGET_NAME	Name of the Oracle home target
TARGET_GUID	Oracle home target globally unique identifier
HOST_NAME	Name of the host on which the Oracle home is installed
HOME_LOCATION	Complete path to the Oracle home
HOME_NAME	OUI home name
COMPONENT_NAME	Component name
COMPONENT_VERSION	Component base version
DEPENDEE_NAME	Dependee component name
DEPENDEE_VERSION	Dependee component version
DEPENDEE_HOME_GUID	Oracle home dependee component globally unique identifier

MGMT$OH_PATCHSET

The MGMT$OH_PATCHSET view contains information about patchsets applied on an Oracle home directory.

Table 8-21 MGMT$OH_PATCHSET

Column	Description
ECM_SNAPSHOT_ID	ECM Snapshot ID of the current snapshot for the Oracle home target
TARGET_NAME	Name of the Oracle home target
TARGET_GUID	Oracle home target globally unique identifier
HOST_NAME	Name of the host on which the Oracle home is installed
HOME_LOCATION	Complete path to the Oracle home
HOME_NAME	OUI home name
PATCHSET_NAME	Patchset name
PATCHSET_VERSION	Patchset version
INSTALL_TIME	Installation time of patchset
EXTERNAL_NAME	External name of the patchset
DESCRIPTION	A brief description of the patchset
INV_LOCATION	Patchset inventory location
INSTALLER_VERSION	Installer version
MIN_DEINSTALLER_VERSION	Minimum OUI version required to deinstall this patchset

MGMT$OH_VERSIONED_PATCH

The MGMT$OH_VERSIONED_PATCH view contains information about versioned patches applied on an Oracle home directory.

Table 8-22 MGMT$OH_VERSIONED_PATCH

Column	Description
ECM_SNAPSHOT_ID	ECM Snapshot ID of the current snapshot for the Oracle home target
TARGET_NAME	Name of Oracle home target
TARGET_GUID	Oracle home target globally unique identifier
HOST_NAME	Name of the host on which the Oracle home is installed
HOME_LOCATION	Complete path to the Oracle home
HOME_NAME	OUI home name
VPATCH_NAME	Versioned patch name (should be same as the component name, on which the versioned patch is applied)
VPATCH_VERSION	Versioned patch version
BASE_COMP_VERSION	Base component version, on which the versioned patch is applied
PATCHSET_NAME	Name of the patchset this versioned patch is part of
PATCHSET_VERSION	Version of the patchset this versioned patch is part of
INSTALL_TIME	Installation time of the versioned patch
EXTERNAL_NAME	External name of the versioned patch
DESCRIPTION	A brief description of the versioned patch
LANGUAGES	Languages supported by this versioned patch
INSTALLED_LOCATION	Install location of the versioned patch
INSTALLER_VERSION	Installer version
MIN_DEINSTALLER_VERSION	Minimum OUI version required to remove this versioned patch

MGMT$OH_PATCH

The MGMT$OH_PATCH view contains information about patches applied on an Oracle home directory.

Table 8-23 MGMT$OH_PATCH

Column	Description
ECM_SNAPSHOT_ID	ECM Snapshot ID of the current snapshot for the Oracle home target
TARGET_NAME	Name of the Oracle home target
TARGET_GUID	Oracle home target globally unique identifier
HOST_NAME	Name of the host on which the Oracle home is installed
HOME_LOCATION	Complete path to the Oracle home
HOME_NAME	OUI home name
PATCH_ID	Patch ID (may be same for more than one patches)
PATCH_UPI	Unique patch identifier (putting N/A when not available in metadata)
PATCH_LANG	Patch language
BUGS_FIXED	Comma separated list of bugs fixed by the patch
INSTALL_TIME	Installation time of the patch
IS_ROLLBACKABLE	Can the patch be rolled back? [0/1]
IS_ONLINE_PATCH	Is it an online patch?
PROFILE	Profile used to install the patch (only for WebLogic)
PATCH_TYPE	Patch type
DESCRIPTION	A brief description of the patch
XML_INV_LOCATION	Patch XML inventory location
INSTALLER_VERSION	Installer version of the patch

MGMT$OH_PATCHED_COMPONENT

The MGMT$OH_PATCHED_COMPONENT view contains information about components affected by a patch applied on an Oracle home directory.

Table 8-24 MGMT$OH_PATCHED_COMPONENT

Column	Description
ECM_SNAPSHOT_ID	ECM Snapshot ID of the current snapshot for the Oracle home target
TARGET_NAME	Name of the Oracle home target
TARGET_GUID	Oracle home target globally unique identifier
HOST_NAME	Name of the host on which the Oracle home is installed
HOME_LOCATION	Complete path to the Oracle home
HOME_NAME	OUI home name
PATCH_ID	Patch ID (may be the same for more than one patch)
PATCH_UPI	Unique Patch Identifier (putting N/A when not available in metadata)
PATCH_LANG	Patch language
COMPONENT_NAME	Affected component name
COMPONENT_VERSION	Current version of the affected component
COMPONENT_BASE_VERSION	Base version of the affected component
COMPONENT_EXTERNAL_NAME	External name of the affected component
FROM_VERSION	Version of the affected component before applying PSU
TO_VERSION	Version of the affected component after applying PSU

MGMT$OH_PATCH_FIXED_BUG

The MGMT$OH_PATCH_FIXED_BUG view contains information about bugs fixed by a patch applied on an Oracle home directory.

Table 8-25 MGMT$OH_PATCH_FIXED_BUG

Column	Description
ECM_SNAPSHOT_ID	ECM Snapshot ID of the current snapshot for the Oracle home target
TARGET_NAME	Name of the Oracle home target
TARGET_GUID	Oracle home target globally unique identifier
HOST_NAME	Name of the host on which the Oracle home is installed
HOME_LOCATION	Complete path to the Oracle home
HOME_NAME	OUI home name
PATCH_ID	Patch ID (may be the same for more than one patch)
PATCH_UPI	Unique Patch Identifier (putting N/A when not available in metadata)
PATCH_LANG	Patch language
BUG_NUMBER	Bug number of a bug fixed by a patch
BUG_DESC	Bug description of a bug fixed by a patch

MGMT$OH_PATCHED_FILE

The MGMT$OH_PATCHED_FILE view contains information about the files affected by a patch applied on an Oracle home directory.

Table 8-26 MGMT$OH_PATCHED_FILE

Column	Description
ECM_SNAPSHOT_ID	ECM Snapshot ID of the current snapshot for the Oracle home target
TARGET_NAME	Name of the Oracle home target
TARGET_GUID	Oracle home target globally unique identifier
HOST_NAME	Name of the host on which the Oracle home is installed
HOME_LOCATION	Complete path to the Oracle home
HOME_NAME	OUI home name
PATCH_ID	Patch ID (may be the same for more than one patch)
PATCH_UPI	Unique Patch Identifier (putting N/A when not available in metadata)
PATCH_LANG	Installation time of the patchset
TIMESTAMP	Patch timestamp
FILE_NAME	Name of a patched file
COMP_NAME	Name of the OUI component this file is part of
COMP_VERSION	InstaVersion of the OUI component this file is part of

MGMT$OH_FILE

The MGMT$OH_FILE view contains information about all the files affected by one or more patches applied on an Oracle home directory.

Table 8-27 MGMT$OH_FILE

Column	Description
ECM_SNAPSHOT_ID	ECM Snapshot ID of the current snapshot for the Oracle home target
TARGET_NAME	Name of the Oracle home target
TARGET_GUID	Oracle home target globally unique identifier
HOST_NAME	Name of the host on which the Oracle home is installed
HOME_LOCATION	Complete path to the Oracle home
HOME_NAME	OUI home name
FILE_NAME	Patched file name
LAST_PATCH_ID	Patch ID of the last patch applied on the file
LAST_PATCH_UPI	UPI of the last patch applied on the file
LAST_PATCH_LANG	Language of the last patch applied on the file
LAST_PATCH_TIMESTAMP	Timestamp of the last patch applied on the file

MGMT$PA_RECOM_METRIC_SOURCE

The MGMT$PA_RECOM_METRIC_SOURCE view contains data for the patch recommendations metric source.

Table 8-28 MGMT$PA_RECOM_METRIC_SOURCE

Column	Description
PATCH_GUID	The GUID of the patch
PATCH	The patch number
ABSTRACT	The abstract information of the patch
CLASSIFICATION	The classification information of the patch
PA_TGT_GUID	The GUID of a target which is applicable to the recommended patch
PA_TGT_NAME	The name of a target which is applicable to the recommended patch
PA_TGT_TYPE	The type id of a target, such as 'host' or 'oracle_database'
PA_TGT_TYPE_DISPLAY_NAME	The display name of a target type such as 'Host' or 'Database Instance'
HOST_NAME	The name of a host target which host this target
TARGET_GUID	The GUID of a host target which host this target. It is the target GUID of a policy violation.

MGMT$OH_INV_SUMMARY

The MGMT$OH_INV_SUMMARY view contains summary of Oracle products and corresponding target types.

Table 8-29 MGMT$OH_INV_SUMMARY

Column	Description
ECM_SNAPSHOT_ID	ECM Snapshot ID of the current snapshot for the Oracle home target
OH_TARGET_GUID	Oracle home target globally unique identifier
HOST_NAME	Name of the host on which the Oracle home is installed
HOME_LOCATION	Complete path to the Oracle home
COMP_NAME	Component name
COMP_EXTERNAL_NAME	Component external name
COMP_VERSION	Component version
IS_PATCHED	Is this Oracle home patched?[0/1]
MAP_TARGET_TYPE	Map target type
MAP_PROPERTY_NAME	Map property name
MAP_PROPERTY_VALUE	Map property value

MGMT$OH_INSTALLED_TARGETS

The MGMT$OH_INSTALLED_TARGETS view contains summary of targets installed in the Oracle home directories.

Table 8-30 MGMT$OH_PATCHSET

Column	Description
OH_TARGET_NAME	Name of the Oracle home target
OH_TARGET_GUID	Oracle home target globally unique identifier
HOST_NAME	Name of the host on which the Oracle home is installed
HOME_LOCATION	Complete path to the Oracle home
HOME_TYPE	OUI home type
INST_TARGET_NAME	Installed target name
INST_TARGET_TYPE	Installed target type