This chapter provides a description ofconfiguration management views. It contains the following sections:
For examples of how to use views, see Examples.
This section provides a description of each custom configuration specification (CCS) view and its columns. It contains the following sections:
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:
|
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 |
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:
|
EXPR_TYPE |
The type of expression Possible values:
|
SOURCE_ORDER |
Numeric order in which the source was obtained |
EXPR_NAME |
The name of the expression
|
EXPR_VALUE |
The value of the expression
|
FULL_PATH |
The full 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 |
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:
|
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:
|
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 |
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:
|
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 |
This section provides a description of each database configuration view and its columns. It includes the following sections:
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) |
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 |
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 |
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.
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.
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.
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.
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.
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.
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.
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.
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) |
This section provides a description of each enterprise configuration management view and its columns. It contains the following sections.
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:
|
SECOND_TARGET |
The name of the second target specified for this comparison. |
SECOND_CONFIG_TYPE |
The type of the second configuration. Possible values:
|
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:
|
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. |
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:
|
SECOND_TARGET |
The name of the second target specified for this comparison. |
SECOND_CONFIG_TYPE |
The type of the second configuration. Possible values:
|
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:
|
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 |
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:
|
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:
|
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:
|
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:
|
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:
|
SECOND_ATTR_VALUE |
The value of the attribute on the second target. |
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:
|
PARSED_DIFF_TYPE |
The type of CCS-parsed data difference: Possible values:
|
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:
|
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:
|
SECOND_ATTR_VALUE |
The value of the attribute on the second target. |
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:
|
PARSED_DIFF_TYPE |
The type of CCS-parsed data difference: Possible values:
|
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:
|
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:
|
SECOND_ATTR_VALUE |
The value of the attribute on the second target. |
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:
|
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:
|
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:
|
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. |
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:
|
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. |
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. |
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:
|
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. |