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 Chapter 20, "Examples".
This section provides a description of each inventory view and its columns. It contains the following sections:
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.
| 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 |
Timestamp 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 |
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.
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.
| 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:
|
|
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 |
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.
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 |
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 |
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.
The MGMT$TARGET_MEMBERS view displays the list of direct members for a target.
| 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 |
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.
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 |
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.
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 |
List the properties applicable to the target and the default values.
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. |
This section provides a description of each Oracle home directory patching view. It includes the following sections:
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.
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 |
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.
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 |
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 |
This section provides a description of each Oracle home directory view and its columns. It includes the following sections:
The MGMT$OH_HOME_INFO view contains properties of the Oracle home targets.
| 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 |
The MGMT$OH_DEP_HOMES view contains information about other homes on which an Oracle home depends.
| 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 |
The MGMT$OH_CRS_NODES view contains information about member nodes of a CRS Oracle home.
| 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 |
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 |
The MGMT$OH_COMPONENT view contains information about components installed in an Oracle home.
| 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 |
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 |
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 |
The MGMT$OH_PATCHSET view contains information about patchsets applied on an Oracle home directory.
| 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 |
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 |
The MGMT$OH_PATCH view contains information about patches applied on an Oracle home directory.
| 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_PSU |
Is it a PSU? [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 |
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 |
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 |
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 |
The MGMT$OH_FILE view contains information about all the files affected by one or more patches applied on an Oracle home directory.
| 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 |
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. |
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 |
The MGMT$OH_INSTALLED_TARGETS view contains summary of targets installed in the Oracle home directories.
| 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 |