Configuration Management Views

5 Configuration Management Views

This chapter provides a description ofconfiguration management views. It contains the following sections:

For examples of how to use views, see Examples.

Custom Configuration Specification Views

This section provides a description of each custom configuration specification (CCS) view and its columns. It contains the following sections:

MGMT$CCS_DATA

The MGMT$CCS_DATA view provides both current and saved data, that is data saved from configurations.

Table 5-1 MGMT$CCS_DATA

Column	Description
CM_TARGET_GUID	The unique ID for the target
CM_TARGET_TYPE	The type of the target
CM_TARGET_NAME	The name of the target
CM_SNAPSHOT_TYPE	Type of snapshot
CCS_UI_NAME	Display CCS name
CCS_DRAFT_NUMBER	Draft number of the CCS for draft CCSs. (It is 0 for nondraft CCS)
LAST_COLLECTION_TIMESTAMP	The timestamp of the collection specified in the target's time zone
ECM_SNAPSHOT_ID	The Enterprise Configuration Management (ECM) snapshot ID that can be used to join with other ECM views
DATA_SOURCE_NAME	Depending on the value for EXPR_TYPE, this is one of the following: File name (relative to the base path) OS command name Database SQL query name
CONTAINER	A slash (/) separated hierarchal container with additional identification information and order information. This column could be a single space but only if the attribute name and value are available and are at the top level of the hierarchy.
ATTR	Attribute name
ATTR_ORDER	The order of the attribute within its enclosing container
CONTAINER_ORDER	The order of the container in the data source contents
VALUE	Attribute value

MGMT$CCS_DATA_SOURCE

The MGMT$CCS_DATA_SOURCE view contains both current and saved data (that is, data from saved configurations). This view can be joined with MGMT$CCS_DATA_SOURCE_VISIBLE on ECM_SNAPSHOT_ID and DATA_SOURCE_NAME.

Table 5-2 MGMT$CCS_DATA_SOURCE

Column	Description
CM_TARGET_GUID	The unique ID for the target
CM_TARGET_TYPE	The type of the target
CM_TARGET_NAME	The name of the target
CM_SNAPSHOT_TYPE	Type of snapshot
CCS_UI_NAME	Display CCS name
CCS_DRAFT_NUMBER	Draft number of the CCS for draft CCSs. (It is 0 for nondraft CCS)
LAST_COLLECTION_TIMESTAMP	The time stamp of the collection specified in the target's time zone
ECM_SNAPSHOT_ID	The Enterprise Configuration Management (ECM) snapshot ID that can be used to join with other ECM views
DATA_SOURCE_NAME	Depending on the value for EXPR_TYPE, this is one of the following: File name (relative to the base path) OS command name Database SQL query name
EXPR_TYPE	The type of expression Possible values: F: Files O: OS commands D: Database queries
SOURCE_ORDER	Numeric order in which the source was obtained
EXPR_NAME	The name of the expression For files, this can be the wildcarded path expression from the custom configuration specification that caused the file to be collected For OS commands and database queries, this is a user-specified name for the expression
EXPR_VALUE	The value of the expression For files, this is the same as the value for EXPR_NAME For OS commands, this is the actual command For database queries, this is the actual database query
FULL_PATH	The full path For files, this is the full file path For OS commands, this is the base directory path
CONTENTS_SIZE	Byte size of contents
HASH	Hash value for collected data
CONTENTS	Character large object (CLOB) contents column with raw contents for this data source
COLLECTION_ERROR_MSG	Any relevant error message for this data source during the collection
PARSING_ERROR_MSG	Any relevant error messages generated during parsing of data contents

MGMT$CCS_DATA_VISIBLE

The MGMT$CCS_DATA_VISIBLE view contains both current and saved data (that is, data from saved configurations).

Table 5-3 MGMT$CCS_DATA_VISIBLE

Column	Description
TARGET_GUID	The unique ID for the target
TARGET_NAME	Name of the target
TARGET_TYPE	Type of target
SNAPSHOT_TYPE	Snapshot type
CCS_UI_NAME	Display CCS name
CCS_DRAFT_NUMBER	Draft number of the CCS for draft CCSs. (It is 0 for nondraft CCS)
DISPLAY_TARGET_NAME	User-friendly display name of the target
DISPLAY_TARGET_TYPE	User-friendly display name of the target type
COLLECTION_TIMESTAMP	Time stamp of the collection specified in the time zone of the target
IS_CURRENT	Specifies whether the data is current or saved Possible values: Y: Current data N: Saved data
DESCRIPTION	Snapshot description provided by the user
CREATOR	For saved snapshots, the creator is the Enterprise Manager user who saved the snapshot
SAVED_TIMESTAMP	Time stamp of when the snapshot was saved specified in the time zone of the database
LAST_UPLOAD_TIMESTAMP	Last time (specified in the time zone of the database) when a collection was processed for this snapshot type.
ECM_SNAPSHOT_ID	The Enterprise Configuration Management (ECM) snapshot ID that can be used to join with other ECM views
DATA_SOURCE_NAME	Depending on the value for EXPR_TYPE, this is one of the following: File name (relative to the base path) OS command name Database SQL query name
CONTAINER	A slash (/) separated hierarchal container with additional identification information and order information. This column could be a single space but only if the attribute name and value are available and are at the top level of the hierarchy.
ATTRIBUTE	Attribute name
VALUE	Attribute value
CONTAINER_ORDER	The order of the container in the data source contents
ATTRIBUTE_ORDER	The order of the attribute within its enclosing container

MGMT$CCS_DATA

The MGMT$CCS_DATA view is the same as the MGMT$CCS_DATA_VISIBLE view but it exposes the current most recently collected data only.

Table 5-4 MGMT$CCS_DATA

Column	Description
CM_TARGET_GUID	The unique ID for the target
CM_TARGET_TYPE	Type of the target
CM_TARGET_NAME	Name of the target
CM_SNAPSHOT_TYPE	Type of snapshot
CCS_UI_NAME	Display CCS name
CCS_DRAFT_NUMBER	Draft number of the CCS for draft CCSs. (It is 0 for nondraft CCS)
LAST_COLLECTION_TIMESTAMP	The time stamp of the collection specified in the target's time zone
ECM_SNAPSHOT_ID	The Enterprise Configuration Management (ECM) snapshot ID that can be used to join with other ECM views
DATA_SOURCE_NAME	Depending on the value for EXPR_TYPE, this is one of the following: File name (relative to the base path) OS command name Database SQL query name
CONTAINER	A slash (/) separated hierarchal container with additional identification information and order information. This column could be a single space but only if the attribute name and value are available and are at the top level of the hierarchy.
ATTR	Attribute name
ATTR_ORDER	The order of the attribute within its enclosing container
CONTAINER_ORDER	The order of the container in the data source contents
VALUE	Attribute value

Database Configuration Views

This section provides a description of each database configuration view and its columns. It includes the following sections:

MGMT$DB_TABLESPACES

The MGMT$DB_TABLESPACES view displays configuration settings for tablespaces. Tablespace settings are collected from the sys.dba_tablespaces, dba_free_space, dba_data_files, dba_temp_files, and v$temp_extent_pool tables.

Table 5-5 MGMT$DB_TABLESPACES

Column	Description
HOST_NAME	Name of the target where the metrics will be collected
TARGET_NAME	Name of the database containing the data files
TARGET_TYPE	The type of target, for example, Oracle_ database
TARGET_GUID	The unique ID for the database target
COLLECTION_ TIMESTAMP	The date and time when the metrics were collected
TABLESPACE_NAME	Name of the tablespace
CONTENTS	Tablespace contents: PERMANENT or TEMPORARY
STATUS	Tablespace status: ONLINE, OFFLINE, or READ ONLY
EXTENT_MANAGEMENT	Extent management tracking: DICTIONARY or LOCAL
ALLOCATION_TYPE	Type of extent allocation in effect for this tablespace
LOGGING	Default logging attribute
TABLESPACE_SIZE	Current size of the tablespace in bytes
INITIAL_EXT_SIZE	Default initial extent size
NEXT_EXTENT	Next extent in the sequence
INCREMENT_BY	Default percent increase for extent size
MAX_EXTENTS	Default maximum number of extents
TABLESPACE_USED_SIZE	Amount of data (in bytes) contained in the tablespace
SEGMENT_SPACE_MANAGEMENT	Indicates whether the free and used segment space in the tablespace is managed using free lists (MANUAL) or bitmaps (AUTO)
BLOCK_SIZE	Tablespace block size
MIN_EXTENTS	Default minimum number of extents
MIN_EXTLEN	Minimum extent size for this tablespace
BIGFILE	Indicates whether the tablespace is a bigfile tablespace (YES) or a smallfile tablespace (NO)

MGMT$DB_DATAFILES

The MGMT$DB_DATAFILES view displays the configuration settings for data files. The data file settings are collected from sources such as sys.dba_data_files, v$datafile, sys.dba_free_space, sys.dba_tablespaces, sys.dba_ temp_files, v$tempfile.

Table 5-6 MGMT$DB_DATAFILES

Column	Description
HOST_NAME	Name of the target where the metrics will be collected
TARGET_NAME	Name of the database containing the data files
TARGET_TYPE	The type of target, for example, Oracle_ database
TARGET_GUID	The unique ID for the database target
COLLECTION_ TIMESTAMP	The date and time when the metrics were collected
FILE_NAME	Name of the data file
TABLESPACE_NAME	Name of the tablespace containing the data file
STATUS	Data file status: ACTIVE or NOT ACTIVE
FILE_SIZE	Size of the data file
AUTOEXTENSIBLE	Autoextensible indicator
INCREMENT_BY	Autoextension increment
MAX_FILE_SIZE	Maximum file size in bytes
OS_STORAGE_ENTITY	OS level storage entity on which the file resides. For regular files it is the name of the file system on which the file resides. For character or raw files it is the name of the raw device
CREATE_BYTES	The initial size of the data file when it was created in bytes

MGMT$DB_CONTROLFILES

The MGMT$DB_CONTROLFILES view displays the configuration settings for database control files.

Table 5-7 MGMT$DB_CONTROLFILES

Column	Description
HOST_NAME	Name of the target where the metrics will be collected
TARGET_NAME	Name of the database containing the data files
TARGET_TYPE	The type of target, for example, Oracle_ database
TARGET_GUID	The unique ID for the database target
COLLECTION_ TIMESTAMP	The date and time when the metrics were collected
FILE_NAME	Name of the database control file.
STATUS	The type of control file: STANDBY - indicates database is in standby mode LOGICAL - indicates the database is a logical standby database (not a physical standby) CLONE - indicates a clone database BACKUP \| CREATED - indicates database is being recovered using a backup or created control file CURRENT - the control file changes to this type following a standby database activate or database open after recovery
CREATION_DATE	Control file creation date
SEQUENCE_NUM	Control file sequence number incremented by control file transactions
CHANGE_NUM	Last change number in the backup control file. Value is NULL if the control file is not a backup
MOD_DATE	Last timestamp in the backup control file. NULL if the control file is not a backup
OS_STORAGE_ENTITY	OS level storage entity on which the file resides. For regular files it is the name of the file system on which the file resides. For character or raw files it is the name of the raw device

MGMT$DB_DBNINSTANCEINFO

The MGMT$DB_DBNINSTANCEINFO view displays general information about database instance. The instance information is collected from v$database, v$version, v$instance, global_name, database_properties and v$nls_parameters.

Table 5-8 MGMT$DB_DBNINSTANCEINFO

Column	Description
HOST_NAME	Name of the target host where the metrics will be collected
TARGET_NAME	Name of the database target from which the metrics are collected
TARGET_TYPE	The type of target, for example, Oracle_ database
TARGET_GUID	The unique ID for the database target
COLLECTION_ TIMESTAMP	The date and time when the metrics were collected
DATABASE_NAME	Name of the database
GLOBAL_NAME	Global name of the database
BANNER	Component name and version number
HOST	Name of the host system
INSTANCE_NAME	Name of the instance
STARTUP_TIME	Time when instance was started up
LOGINS	ALLOWED or RESTRICTED
LOG_MODE	The archive log mode, either ARCHIVELOG or NOARCHIVELOG
OPEN_MODE	Open mode information
DEFAULT_TEMP_TABLESPACE	Default temporary tablespace name
CHARACTERSET	NLS parameter value for NLS_CHARACTERSET
NATIONAL_CHARACTERSET	NLS parameter value for NLS_NCHAR_CHARACTERSET

Usage Notes

This information is collected through the dbconfig metric. However, as this metric is not run for standby databases, this table is not populated for standby targets.

MGMT$DB_FEATUREUSAGE

The MGMT$DB_FEATUREUSAGE view displays information about database feature usage.

Table 5-9 MGMT$DB_FEATUREUSAGE

Column	Description
HOST	Name of the host target where the database feature usage information is collected
DATABASE_NAME	Name of the database where the database feature usage information is collected
INSTANCE_NAME	Name of the instance where the database feature usage information is collected
TARGET_TYPE	Either Oracle_database or rac_database
DBID	A unique number that identifies a database instance
NAME	The feature name
CURRENTLY_USED	TRUE if the feature is currently in use, FALSE if the feature is not in use
DETECTED_USAGES	The number of times the feature has been used by the database
FIRST_USAGE_DATE	The date that the first usage of the feature occurred
LAST_USAGE_DATE	The date of the most recent usage of the feature
VERSION	The version number of the database
LAST_SAMPLE_DATE	The date that the database was last evaluated for feature usage
LAST_SAMPLE_PERIOD	The interval between the LAST_ SAMPLE_DATE date and the database feature usage evaluation before that (by default, seven days)
SAMPLE_INTERVAL	The number of seconds between the LAST_SAMPLE_DATE date and the next database feature usage evaluation
TOTAL_SAMPLES	The total number of database feature usage evaluation samples that have been collected
AUX_COUNT	For Oracle internal use only
DESCRIPTION	The description of the feature

Usage Notes

This view can be used to gain an enterprise-wide view of database feature usage across all Oracle databases.

MGMT$DB_INIT_PARAMS

The MGMT$DB_INIT_PARAMS view displays initialization parameter settings for the database. Initialization parameter settings are collected from v$parameter.

Table 5-10 MGMT$DB_INIT_PARAMS

Column	Description
HOST_NAME	Name of the target where the metrics will be collected
TARGET_NAME	Name of the database target from which the metrics are collected
TARGET_TYPE	The type of target, such as Oracle_ database
TARGET_GUID	The unique ID for the database target
COLLECTION_ TIMESTAMP	The date and time when the metrics were collected
NAME	Name of the initialization parameter
ISDEFAULT	Indicates whether the parameter value is the default
VALUE	The parameter value
DATATYPE	The data type that the value string can be mapped to, for example, NUMBER, DATE, or TEXT

Usage Notes

This information is collected through the dbconfig metric. However, as this metric is not run for standby databases, this table is not populated for standby targets.

MGMT$DB_LICENSE

The MGMT$DB_LICENSE view displays database license configuration settings. Database license configuration settings are collected from v$license.

Table 5-11 MGMT$DB_LICENSE

Column	Description
HOST_NAME	The name of the host on which the database is running
TARGET_NAME	Name of the database containing the tablespace
TARGET_TYPE	The type of target, for example, Oracle_ database
TARGET_GUID	The unique ID for the database target
COLLECTION_ TIMESTAMP	The date and time when the metrics were collected
SESSIONS_MAX	The maximum number of sessions allowed for the database
SESSIONS_WARNING	The number of sessions which will generate a warning for the database
SESSIONS_CURRENT	The current number of sessions for the database
SESSIONS_HIGHWATER	The highest water mark of sessions for the database
USERS_MAX	The maximum number of users for the database

Usage Notes

This view can be used to obtain database license configuration settings across all database targets.

MGMT$DB_REDOLOGS

The MGMT$DB_REDOLOGS view displays redo log configuration settings for the database. Redo log configuration settings are collected from the v$log and v$logfile tables.

Table 5-12 MGMT$DB_REDOLOGS

Column	Description
HOST_NAME	Name of the target where the metrics will be collected
TARGET_NAME	Name of the database target from which the metrics are collected
TARGET_TYPE	The type of target, for example, Oracle_ database
TARGET_GUID	The unique ID for the database target
COLLECTION_ TIMESTAMP	The date and time when the metrics were collected
GROUP_NUM	Redo log group identifier number
STATUS	Log status: UNUSED - The online redo log has never been written to. This is the state of a redo log that was just added, or just after a RESETLOGS, when it is not the current redo log. CURRENT - This is the current redo log. This implies that the redo log is active. The redo log could be open or closed. ACTIVE - The log is active but is not the current log. It is needed for crash recovery. It may be in use for block recovery. It might or might not be archived. CLEARING - The log is being re-created as an empty log after an ALTER DATABASE CLEAR LOGFILE statement. After the log is cleared, the status changes to UNUSED. CLEARING_CURRENT - The current log is being cleared of a closed thread. The log can stay in this status if there is some failure in the switch such as an I/O error writing the new log header. INACTIVE - The log is no longer needed for instance recovery. It may be in use for media recovery. It might or might not be archived.
MEMBERS	Number of members in the log group
FILE_NAME	Redo log file (member) name
ARCHIVED	Archive status either YES or NO
LOGSIZE	Size of the log file in bytes
SEQUENCE_NUM	Log sequence number
FIRST_CHANGE_SCN	Lowest SCN in the log
OS_STORAGE_ENTITY	OS level storage entity on which the file resides. For regular files it is the name of the file system on which the file resides. For character or raw files it is the name of the raw device.
THREAD_NUM	Log thread number

Usage Notes

Obtain redo log group or file configuration settings across all database targets.

MGMT$DB_ROLLBACK_SEGS

The MGMT$DB_ROLLBACK_SEGS view displays rollback segments configuration settings for the database. Rollback segments configuration settings are collected from the sys.dba_rollback_segs and v$rollstat tables.

Table 5-13 MGMT$DB_ROLLBACK_SEGS

Column	Description
HOST_NAME	Name of the target where the metrics will be collected
TARGET_NAME	Name of the database containing the data files
TARGET_TYPE	The type of target, for example, Oracle_ database
TARGET_GUID	The unique ID for the database target
COLLECTION_ TIMESTAMP	The date and time when the metrics were collected
ROLLNAME	Name of the rollback segment
STATUS	Rollback segment status
TABLESPACE_NAME	Name of the tablespace containing the rollback segment
EXTENTS	Number of extents in rollback segment
ROLLSIZE	Size in bytes of rollback segment. This values differs by the number of bytes in one database block from the value of the BYTES column of the ALL/DBA/USER_ SEGMENTS views.
INITIAL_SIZE	Initial extent size in bytes
NEXT_SIZE	Secondary extent size in bytes
MAXIMUM_EXTENTS	Maximum number of extents
MINIMUM_EXTENTS	Minimum number of extents
PCT_INCREASE	Percent increase for extent size
OPTSIZE	Optimal size for rollback segments
AVEACTIVE	Current size of active extents averaged over time
WRAPS	Number of times rollback segment is wrapped
SHRINKS	Number of times the size of a rollback segment decreases
AVESHRINK	Average shrink size
HWMSIZE	High water mark of rollback segment size

Usage Notes

Obtain rollback segments configuration settings across all database targets.

MGMT$DB_SGA

The MGMT$DB_SGA view displays System Global Area (SGA) configuration settings. SGA settings are collected from the v$sga and v$sgastat tables.

Table 5-14 MGMT$DB_SGA

Column	Description
HOST_NAME	Name of the target where the metrics will be collected
TARGET_NAME	Name of the database containing the datafiles
TARGET_TYPE	The type of target, for example, Oracle_ database
TARGET_GUID	The unique ID for the database target
COLLECTION_ TIMESTAMP	The date and time when the metrics were collected
SGANAME	SGA component name
SGASIZE	SGA component size in kilobytes or megabytes

Usage Notes

Obtain System Global Area configuration settings across all database targets.

MGMT$DB_TABLESPACES_ALL

The MGMT$DB_TABLESPACES_ALL view displays configuration settings for tablespaces. Tablespace settings are collected from the sys.dba_tablespaces, dba_free_space, dba_data_files, dba_temp_files, and v$temp_extent_pool tables.

Table 5-15 MGMT$DB_TABLESPACES_ALL

Column	Description
HOST_NAME	Name of the target where the metrics will be collected
TARGET_NAME	The type of target, for example, Oracle_ database
TARGET_GUID	The unique ID for the database target
COLLECTION_ TIMESTAMP	The date and time when the metrics were collected
TABLESPACE_NAME	Name of the tablespace
CONTENTS	Tablespace contents: PERMANENT or TEMPORARY
STATUS	Tablespace status: ONLINE, OFFLINE, or READ ONLY
EXTENT_MANAGEMENT	Extent management tracking: DICTIONARY or LOCAL
ALLOCATION_TYPE	Type of extent allocation in effect for this tablespace
LOGGING	Default logging attribute
TABLESPACE_SIZE	Current size of the tablespace in bytes
INITIAL_EXT_SIZE	Default initial extent size
INCREMENT_BY	Default percent increase for extent size
MAX_EXTENTS	Default maximum number of extents

Usage Notes

Obtain tablespace configuration settings across all database targets.

MGMT$DB_OPTIONS

The MGMT$DB_OPTIONS view displays whether or not the option is currently LOADED and ACTIVE, or either the option does not exist or is NOT LOADED or INACTIVE. Options settings are collected by checking user name and status in the sys.dba_users and dba_registry tables.

Table 5-16 MGMT$DB_OPTIONS

Column	Description
HOST_NAME	Name of the target where the metrics will be collected
TARGET_NAME	Name of the database containing the data files
TARGET_TYPE	The type of target, for example, Oracle_ database
TARGET_GUID	The unique ID for the database target
COLLECTION_ TIMESTAMP	The date and time when the metrics were collected
NAME	Name of the database option
SELECTED	If the option is currently LOADED and ACTIVE (TRUE), or either the option does not exist or is NOT LOADED or INACTIVE (FALSE)

Enterprise Configuration Management Views

This section provides a description of each enterprise configuration management view and its columns. It contains the following sections.

MGMT$ECM_CMP_JOBS

The MGMT$ECM_CMP_JOBS view enables you to view all comparison jobs for a first target, second target combination. More than one result might be returned for a set of targets, if different templates or save modes were specified for the comparison. All jobs are returned (succeeded, failed, running, scheduled, and so on).

Table 5-17 MGMT$ECM_CMP_JOBS

Column	Description
JOB_NAME	The name of the job with the most recent successful results.
JOB_DESC	The description of the job.
JOB_OWNER	The owner of the job.
SCHEDULED_TIME	The time for when the job was scheduled.
COMPARE_TIME	The time when the comparison began.
JOB_STATUS	The status of the overall job.
STEP_STATUS	The status of this particular target comparison.
TARGET_TYPE	The target type of the targets specified for this comparison.
DISPLAY_TYPE	The display name of the target type (in English).
ME_CLASS	The Management Entity (ME) class of the root target type, such as system, group, target, and so on
FIRST_TARGET	The name of the first target specified for this comparison.
FIRST_CONFIG_TYPE	The type of the first configuration. Possible values: Saved: Indicates that a saved configuration was compared Latest: Indicates that a target was compared
SECOND_TARGET	The name of the second target specified for this comparison.
SECOND_CONFIG_TYPE	The type of the second configuration. Possible values: Saved: Indicates that a saved configuration was compared Latest: Indicates that a target was compared
TEMPLATE_NAME	The name of the template used by this comparison. This column returns NULL if no template was used.
SAVE_MODE	The Save mode used for this comparison. Possible values: All: Saves all content Diffs Only: Saves differences only
COMPARISON_ID	The ID of the comparison.
COMP_RESULT_ID	The ID of this comparison result.
COMP_CONFIG_RESULT_ID	The ID for this specific root target comparison results (as opposed to member target result IDs).
JOB_ID	The ID of the job.
JOB_EXECUTION_ID	The ID of the job execution.
DIFF_COUNT	The total number of all differences associated with this target and all member targets.

MGMT$ECM_CMP_JOB_LAST_RESULTS

The MGMT$ECM_CMP_JOB_LAST_RESULTS view enables you to view the latest valid comparison job results for a first target, second target combination. More than one result might be returned for a set of targets, if different templates or save modes were specified for the comparison. Successful job results are returned only.

Table 5-18 MGMT$ECM_CMP_JOB_LAST_RESULTS

Column	Description
JOB_NAME	The name of the job with the most recent successful results.
JOB_OWNER	The owner of the job.
JOB_SCHEDULED_DATE	The time for when the job was scheduled.
COMPARE_TIME	The time when the comparison began.
JOB_STATUS	The status of the overall job. For this view, the status is SUCCEEDED always.
TARGET_TYPE	The target type of the targets specified for this comparison.
DISPLAY_TYPE	The default display name of the target type (in English).
ME_CLASS	The ME class of the target type, such as system, group, target, and so on
FIRST_TARGET	The name of the first target specified for this comparison.
FIRST_CONFIG_TYPE	The type of the first configuration. Possible values: Saved: Indicates that a saved configuration was compared Latest: Indicates that a target was compared
SECOND_TARGET	The name of the second target specified for this comparison.
SECOND_CONFIG_TYPE	The type of the second configuration. Possible values: Saved: Indicates that a saved configuration was compared Latest: Indicates that a target was compared
TEMPLATE_NAME	The name of the template used by this comparison. This column returns NULL if no template was used.
SAVE_MODE	The Save mode used for this comparison. Possible values: All: Saves all content Diffs Only: Saves differences only
COMPARISON_ID	The ID of the comparison.
COMP_RESULT_ID	The ID of this comparison result.
COMP_CONFIG_RESULT_ID	The ID for this specific root target comparison results (as opposed to member target result IDs).
JOB_ID	The ID of the job.
JOB_EXECUTION_ID	The ID of the job execution.
DIFF_COUNT	The total number of all differences associated with this target and all member targets.
HAS_DIFFS	Indicates whether a non CCS configuration item has differences.
HAS_CCS_ATTR_DIFFS	Indicates whether a CCS file has attribute differences.
HAS_CCS_PARSED_DIFFS	Indicates if a CCS file is parsed and if the parsed rows are different

MGMT$ECM_CMP_RPT_CCS_DS

The MGMT$ECM_CMP_RPT_CCS_DS view enables you to view all compared CCS data source information.

Table 5-19 MGMT$ECM_CMP_RPT_CCS_DS

Column	Description
COMP_RESULT_ID	The comparison result ID represents a root target comparison.
ROOT_COMP_CONFIG_RESULT_ID	The root comparison result ID represents a single target to target comparison.
COMP_CONFIG_RESULT_ID	The comparison configuration result ID represents a target to target comparison (root or member target). This can be the same as the ROOT_COMP_CONFIG_RESULT_ID.
METADATA_ID	The snapshot metadata ID.
COMP_DELTA_SNAP_ID	The compare ID for the snapshot.
SNAPSHOT_TYPE	The type of snapshot.
DISPLAY_SNAPSHOT	The default snapshot display name (in English).
CONFIG_ITEM	The configuration item for the CCS data source information.
CCS_DS_ATTR_DIFF_TYPE	The file difference type. Possible values: FIRST_ONLY: Indicates the file is on the first target only. SECOND_ONLY: Indicates the file is on the second target only. DIFFERENT: Indicates the file is different between the two targets. SAME: Indicates the file is the same on both targets.
COMP_DELTA_ENTRY_SNAP_ID	The snapshot ID associated with this data source entry.
COMP_DELTA_ENTRY_ID	The comparison delta entry ID for the data source.
CCS_DS	The CCS data source name.
ROOT_TARGET_TYPE	The root target type.
ROOT_DISPLAY_TYPE	The default display name (in English) of the root target type.
ROOT_ME_CLASS	The ME class of the root target type, such as system, group, target, and so on.
TARGET_TYPE	The target type of the compared targets. This could be the same as the root target type.
DISPLAY_TYPE	The default display name (in English) of the compared target type.
ME_CLASS	The ME class of the compared target type, such as system, group, target, and so on.
ROOT_FIRST_TARGET	The root target for the first compared target.
FIRST_TARGET	The first target in the comparison. This can be the same as the root first target.
FIRST_CONFIG_TYPE	The type of the first configuration. Possible values: Saved: Indicates that a saved configuration was compared Latest: Indicates that a target was compared
ROOT_SECOND_TARGET	The root target for the first compared target.
SECOND_TARGET	The first target in the comparison. This can be the same as the root first target.
SECOND_CONFIG_TYPE	The type of the first configuration. Possible values: Saved: Indicates that a saved configuration was compared Latest: Indicates that a target was compared

MGMT$ECM_CMP_RPT_CCS_DS_DTLS

The MGMT$ECM_CMP_RPT_CCS_DS_DTLS view enables you to view all comparison CCS data source detail information.

Table 5-20 MGMT$ECM_CMP_RPT_CCS_DS_DTLS

Column	Description
COMP_RESULT_ID	The comparison result ID represents a root target comparison.
ROOT_COMP_CONFIG_RESULT_ID	The root comparison configuration result ID represents a target to target comparison.
COMP_CONFIG_RESULT_ID	The comparison configuration result ID represents a target to target comparison (either root or member target). This can be the same as ROOT_COMP_CONFIG_RESULT_ID.
METADATA_ID	The snapshot metadata ID.
COMP_DELTA_SNAP_ID	The comparison ID for the snapshot.
SNAPSHOT_TYPE	The type of snapshot.
DISPLAY_SNAPSHOT	The default snapshot display name (in English).
CONFIG_ITEM	The configuration item for CCS-parsed data information.
CCS_DS_ATTR_DIFF_TYPE	The comparison delta entry ID for the parsed data.
ATTR_DIFF_TYPE	From the UI, the parsed data is shown in a tree. In this case, it shows the tree nodes in a delimited list.
COMP_DELTA_ENTRY_ID	The attribute with a value that differs between the two targets.
CCS_DS	Order by this value to see the file content ordered by the tree node.
HAS_PARSED_DATA	Indicates if the CCS data source has parsed data.
HAS_PARSED_DIFFS	Indicates if the CCS data source parsed data has differences.
ROOT_TARGET_TYPE	The root target type.
ROOT_DISPLAY_TYPE	The default display name (in English) of the root target type.
ROOT_ME_CLASS	The ME class of the root target type, such as system, group, target, and so on.
TARGET_TYPE	The target type of the compared targets. This could be the same as the root target type.
DISPLAY_TYPE	The default display name (in English) of the compared target type.
ME_CLASS	The ME class of the compared target type, such as system, group, target, and so on.
ATTR_COL_ORDER	The name of the data source attribute.
DISPLAY_ATTR_COL_NAME	The default display name (in English) for the attribute name.
COLUMN_TYPE	The attribute column type.
ROOT_FIRST_TARGET	The root target for the first compared target
FIRST_TARGET	The first target in the comparison. This can be the same as the root first target.
FIRST_CONFIG_TYPE	The type of the first configuration. Possible values: Saved: Indicates that a saved configuration was compared Latest: Indicates that a target was compared
FIRST_ATTR_VALUE	The value of the attribute on the first target.
ROOT_SECOND_TARGET	The root target for the second compared target.
SECOND_TARGET	The second target in the comparison. This can be the same as the root second target.
SECOND_CONFIG_TYPE	The type of the second configuration. Possible values: Saved: Indicates that a saved configuration was compared Latest: Indicates that a target was compared
SECOND_ATTR_VALUE	The value of the attribute on the second target.

MGMT$ECM_CMP_RPT_CCS_PD_ALL

The MGMT$ECM_CMP_RPT_CCS_PD_ALL view enables you to view all compared CCS-parsed data available from the comparison.

Table 5-21 MGMT$ECM_CMP_RPT_CCS_PD_ALL

Column	Description
CCS_DS_ATTR_DIFF_TYPE	The type of file attribute differences: Possible values: FIRST_ONLY: Indicates a file is present on only one target SECOND_ONLY: Indicates a file is present on only one target DIFFERENT: Indicates file attributes (such as size) are different SAME: Indicates file attributes (such as size) are the same or ignored, but the file content could still vary.
PARSED_DIFF_TYPE	The type of CCS-parsed data difference: Possible values: FIRST_ONLY: Indicates a file is present on only one target SECOND_ONLY: Indicates a file is present on only one target DIFFERENT: Indicates file attributes (such as size) are different SAME: Indicates file attributes (such as size) are the same or ignored, but the file content could still vary.
COMP_RESULT_ID	The comparison result ID represents a root target comparison.
ROOT_COMP_CONFIG_RESULT_ID	The root comparison configuration result ID represents a target to target comparison.
COMP_CONFIG_RESULT_ID	The comparison configuration result ID represents a target to target comparison (either root or member target). This can be the same as ROOT_COMP_CONFIG_RESULT_ID.
METADATA_ID	The snapshot metadata ID.
SNAPSHOT_TYPE	The type of snapshot.
DISPLAY_SNAPSHOT	The snapshot display name (in English).
CCS_DS	The CCS data source.
CONFIG_ITEM	The configuration item for CCS-parsed data information.
COMP_DELTA_ENTRY_ID	The comparison delta entry ID for the parsed data.
PATH	From the UI, the parsed data is shown in a tree. In this case, it shows the tree nodes in a delimited list.
ATTR_COL_NAME	The attribute with a value that differs between the two targets.
PATH_ORDER	Order by this value to see the file content ordered by the tree node.
ATTR_COL_ORDER	Order by this value to see the attribute nodes in the order that they appear in the file.
ROOT_TARGET_TYPE	The root target type.
ROOT_DISPLAY_TYPE	The display name (in English) of the root target type.
ROOT_ME_CLASS	The ME class of the root target type, such as system, group, target, and so on.
TARGET_TYPE	The target type of the compared targets. This could be the same as the root target type.
DISPLAY_TYPE	The display name (in English) of the compared target type.
ME_CLASS	The ME class of the compared target type, such as system, group, target, and so on.
ROOT_FIRST_TARGET	The root target for the first compared target
FIRST_TARGET	The first target in the comparison. This can be the same as the root first target.
FIRST_CONFIG_TYPE	The type of the first configuration. Possible values: Saved: Indicates that a saved configuration was compared Latest: Indicates that a target was compared
FIRST_ATTR_VALUE	The value of the attribute on the first target.
ROOT_SECOND_TARGET	The root target for the second compared target.
SECOND_TARGET	The second target in the comparison. This can be the same as the root second target.
SECOND_CONFIG_TYPE	The type of the second configuration. Possible values: Saved: Indicates that a saved configuration was compared Latest: Indicates that a target was compared
SECOND_ATTR_VALUE	The value of the attribute on the second target.

MGMT$ECM_CMP_RPT_CCS_PD_DIFFS

The MGMT$ECM_CMP_RPT_CCS_PD_DIFFS view enables you to view all comparison CCS-parsed data differences.

A row is returned only if the following applies:

The data source file must be present on both compared targets
The data source must have parsed data
The parsed data row must differ on both compared targets

Table 5-22 MGMT$ECM_CMP_RPT_CCS_PD_DIFFS

Column	Description
CCS_DS_ATTR_DIFF_TYPE	The type of file attribute differences: Possible values: FIRST_ONLY: Indicates a file is present on only one target SECOND_ONLY: Indicates a file is present on only one target DIFFERENT: Indicates file attributes (such as size) are different SAME: Indicates file attributes (such as size) are the same or ignored, but the file content could still vary.
PARSED_DIFF_TYPE	The type of CCS-parsed data difference: Possible values: FIRST_ONLY: Indicates a file is present on only one target SECOND_ONLY: Indicates a file is present on only one target DIFFERENT: Indicates file attributes (such as size) are different SAME: Indicates file attributes (such as size) are the same or ignored, but the file content could still vary.
COMP_RESULT_ID	The comparison result ID represents a root target comparison.
ROOT_COMP_CONFIG_RESULT_ID	The root comparison configuration result ID represents a target to target comparison.
COMP_CONFIG_RESULT_ID	The comparison configuration result ID represents a target to target comparison (either root or member target). This can be the same as ROOT_COMP_CONFIG_RESULT_ID.
METADATA_ID	The snapshot metadata ID.
SNAPSHOT_TYPE	The type of snapshot.
DISPLAY_SNAPSHOT	The snapshot display name (in English).
CCS_DS	The CCS data source.
CONFIG_ITEM	The configuration item for CCS-parsed data information.
COMP_DELTA_ENTRY_ID	The comparison delta entry ID for the parsed data.
PATH	From the UI, the parsed data is shown in a tree. In this case, it shows the tree nodes in a delimited list.
ATTR_COL_NAME	The attribute with a value that differs between the two targets.
PATH_ORDER	Order by this value to see the file content ordered by the tree node.
ATTR_COL_ORDER	Order by this value to see the attribute nodes in the order that they appear in the file.
ROOT_TARGET_TYPE	The root target type.
ROOT_DISPLAY_TYPE	The default English display name of the root target type.
ROOT_ME_CLASS	The ME class of the root target type, such as system, group, target, and so on.
TARGET_TYPE	The target type of the compared targets. This could be the same as the root target type.
DISPLAY_TYPE	The default English display name of the compared target type.
ME_CLASS	The ME class of the compared target type, such as system, group, target, and so on.
ROOT_FIRST_TARGET	The root target for the first compared target
FIRST_TARGET	The first target in the comparison. This can be the same as the root first target.
FIRST_CONFIG_TYPE	The type of the first configuration. Possible values: Saved: Indicates that a saved configuration was compared Latest: Indicates that a target was compared
FIRST_ATTR_VALUE	The value of the attribute on the first target.
ROOT_SECOND_TARGET	The root target for the second compared target.
SECOND_TARGET	The second target in the comparison. This can be the same as the root second target.
SECOND_CONFIG_TYPE	The type of the second configuration. Possible values: Saved: Indicates that a saved configuration was compared Latest: Indicates that a target was compared
SECOND_ATTR_VALUE	The value of the attribute on the second target.

MGMT$ECM_CMP_RPT_CI_DIFFS

The MGMT$ECM_CMP_RPT_CI_DIFFS view enables you to view all comparison differences by configuration item.

Table 5-23 MGMT$ECM_CMP_RPT_CI_DIFFS

Column	Description
ROOT_TARGET_TYPE	The root target type of the targets specified for this comparison.
ROOT_DISPLAY_TYPE	The default English display name for the root target type.
ROOT_ME_CLASS	The ME class of the root target type, such as SYSTEM, GROUP, or TARGET.
TARGET_TYPE	The target type of the compared target (this can be the root target or a member target).
DISPLAY_TYPE	The default English display name for the compared target type.
ME_CLASS	The ME class of the compared target.
ROOT_FIRST_TARGET	The root target name of the first target specified for this comparison.
FIRST_TARGET	The compared target name of the first target specified for this comparison (this can be the root target or a member target).
FIRST_CONFIG_TYPE	The configuration type of the first target. Possible values: Latest: Indicates that the target was selected for comparison Saved: Indicates that a saved configuration was selected for comparison
ROOT_SECOND_TARGET	The root target name of the second target specified for this compare
SECOND_TARGET	The target name of the second target specified for this comparison.
SECOND_CONFIG_TYPE	The configuration type of the second target. Possible values: Latest: Indicates that the target was selected for comparison Saved: Indicates that a saved configuration was selected for comparison
SNAPSHOT_TYPE	The snapshot type with a difference list.
DISPLAY_SNAPSHOT	The English display name for the snapshot type
CONFIG_ITEM	The snapshot configuration item
DISPLAY_CONFIG_ITEM	The English display name for the configuration item
CI_IS_CCS	Indicates whether the item is a CCS configuration item. Possible values: 1: CCS configuration item 0: Not a CCS configuration item
TOTAL_CI_DIFFS	The total number of all differences associated with this target and configuration item.
NOTIFY_DIFFS_COUNT	The number of differences with notify flags.
JOB_EXECUTION_ID	The ID of this run of the compare job.
COMPARISON_ID	The ID of the comparison definition.
COMP_RESULT_ID	The ID connection the root target compare, job execution and comparison def
ROOT_COMP_CONFIG_RESULT_ID	The root target comparison configuration result ID.
COMP_CONFIG_RESULT_ID	The compared target comparison configuration result ID.

MGMT$ECM_CMP_VISIBLE_CONFIGS

The MGMT$ECM_CMP_VISIBLE_CONFIGS view provides access to the visible configuration entities used for comparison.

Table 5-24 MGMT$ECM_CMP_VISIBLE_CONFIGS

Column	Description
CONFIG_ENTITY_ID	The ID of the compared target or the saved configuration.
TARGET_TYPE	The target type of the target associated with this configuration entity ID.
DISPLAY_TYPE	The external display name of the target type of the target associated with this configuration entity ID.
CONFIG_TYPE	Specifies the configuration type selected for comparison. Possible values: Latest: Indicates that a target was selected for comparison Saved: Indicates that a saved configuration was selected for comparison
TARGET_GUID	Unique identifier of the compared target.
TARGET_NAME	Name of the compared target.
ME_CLASS	ME class of the compared target.
SAVED_CONTAINER_GUID	The saved container snapshot GUID for the compared saved snapshot. Note: This field returns NULL if a target was compared.

MGMT$ECM_CURRENT_SNAPSHOTS

The MGMT$ECM_CURRENT_SNAPSHOTS view lists all the ECM current configuration snapshots and limits access to the snapshots based on the current logged-in Enterprise Manager user.

Table 5-25 MGMT$ECM_CURRENT_SNAPSHOTS

Column	Description
ECM_SNAPSHOT_ID	Identifies the snapshot. You can use the ECM snapshot ID to join with other ECM views. This is a key column for this view.
SNAPSHOT_TYPE	Specifies the type of snapshot.
START_TIMESTAMP	Specifies the timestamp of the collection (in target time zone).
TARGET_GUID	Unique identifier of the target
TARGET_NAME	Name of the target
TARGET_TYPE	Type of the target.
DISPLAY_TARGET_NAME	Display name of the target
DISPLAY_TARGET_TYPE	Display name of the target type
ELAPSED_TIME	Not used
DESCRIPTION	Description of the snapshot provided by the user
MESSAGE	Not used.
STATUS	Not used.
SAVED_TIMESTAMP	Specifies the time stamp of when the snap shot was saved (in the Oracle Database time zone).
VERSION	Specifies the version of the snapshot metadata.
HOST_NAME	Specifies the name of the host of the target.
LAST_UPLOAD_TIMESTAMP	Specifies the last time (in the Management Repository time zone) when a collection was processed for this snapshot type.

MGMT$ECM_VISIBLE_SNAPSHOTS

The MGMT$ECM_VISIBLE_SNAPSHOTS view lists all the Enterprise Configuration Management (ECM) snapshots visible to the current Enterprise Manager user, including both current and saved snapshots.

Table 5-26 MGMT$ECM_VISIBLE_SNAPSHOTS

Column	Description
ECM_SNAPSHOT_ID	Identifies the snapshot. You can use the snapshot ID to join with other ECM views. This is a key column for this view.
SNAPSHOT_TYPE	Specifies the type of snapshot.
START_TIMESTAMP	Specifies the timestamp of the collection (in target time zone).
TARGET_GUID	Unique identifier of the target
TARGET_NAME	Name of the target
TARGET_TYPE	Type of the target.
DISPLAY_TARGET_NAME	Display name of the target
DISPLAY_TARGET_TYPE	Display name of the target type
ELAPSED_TIME	Not used
DESCRIPTION	Provides a description of the snapshot provided by the user.
IS_CURRENT	Specifies whether the data is current or saved Possible values: Y: Current data N: Saved data
MESSAGE	Not used.
STATUS	Not used.
CREATOR	Valid only for saved snapshots. Identifes the Enterprise Manager user who saved the snapshot.
SAVED_TIMESTAMP	Specifies the time stamp of when the snap shot was saved (in the Oracle Database time zone).
VERSION	Specifies the version of the snapshot metadata.
LAST_UPLOAD_TIMESTAMP	Specifies the last time (in the Management Repository time zone) when a collection was processed for this snapshot type.

MGMT$CHANGES_PER_SNAPSHOT

The MGMT$CHANGES_PER_SNAPSHOT is a diagnostic view that can be used to view changes per snapshot performed.

Table 5-27 MGMT$CHANGES_PER_SNAPSHOT

Column	Description
SNAPSHOT_TYPE	Snapshot type from historical data
DELTA_TIME	Date of comparison delta
TARGET_TYPE	Type of target
TARGET_COUNT	The number of targets that reported a change
CHANGES	Number of changes across targets