This chapter provides a description of each operating system view and its columns.It contains the following sections:
For examples of how to use views, see Examples.
The MGMT$OS_SUMMARY view contains the summary of targets installed in the Oracle home directories.
Table 15-1 MGMT$OS_SUMMARY
Column | Description |
---|---|
VENDOR_NAME |
The name of the vendor |
BASE_VERSION |
The OS base version |
UPDATE_LEVEL |
The OS update level |
DISTRIBUTOR_VERSION |
The OS distributor version |
MAX_SWAP_SPACE_IN_MB |
The maximum amount of swap space |
SNAPSHOT_GUID |
The globally unique identifier of the operating system snapshot |
ADDRESS_LENGTH_IN_BITS |
The OS address length in bits |
TARGET_GUID |
The globally unique identifier of the target |
PLATFORM_ID |
The platform ID of the host |
TARGET_NAME |
The name of the target |
TARGET_TYPE |
The type of the target |
START_TIMESTAMP |
The time when the target availability status change was first detected. |
RUN_LEVEL |
The run level of the operating system |
DEFAULT_RUN_LEVEL |
The default run level of the operating system |
PLATFORM_VERSION_ID |
The platform version ID number of the application system |
DBM_MEMBER |
Indicates whether the host is part of an Exadata configuration |
EXALOGIC_MEMBER |
Indicates whether the host is part of an Exalogic configuration |
The MGMT$OS_COMPONENTS view returns performance information for host OS components.
Table 15-2 MGMT$OS_COMPONENTS
Column | Description |
---|---|
HOST |
The name of the host. |
NAME |
The name of the component. |
TYPE |
The type of component. |
VERSION |
The version of the component. |
DESCRIPTION |
The description of the component. |
INSTALLATION_DATE |
The installation date of the component. |
SNAPSHOT_GUID |
The globally unique identifier for the configuration snapshot. |
TARGET_GUID |
The globally unique identifier for the target. |
TARGET_NAME |
The name of this target. |
TARGET_TYPE |
The type of target for this view. |
LAST_COLLECTION_TIMESTAMP |
The date and time when the data was last collected. |
The MGMT$OS_HW_SUMMARY view displays summary information for both operating systems and hardware.
Table 15-3 MGMT$OS_HW_SUMMARY
Column | Description |
---|---|
TARGET_NAME |
Type of the target for this metric |
DOMAIN |
The domain of the host |
OS_NAME |
The operating system name |
SYSTEM_CONFIGURATION |
A summary of the system configuration information |
MACHINE_ARCHITECTURE |
A summary of the system architecture |
CLOCK_FREQUENCY_IN_MHZ |
The clock frequency measured in MHz |
MEMORY_SIZE_IN_MB |
The memory size measured in MB |
LOCAL_DISK_SPACE_IN_GB |
The local disk space measured in GBs |
CPU_COUNT |
The number of CPUs |
HARDWARE_VENDOR_NAME |
The name of the hardware vendor |
OS_VENDOR_NAME |
The name of the system vendor |
OS_DISTRIBUTOR_VERSION |
The distribution version |
SNAPSHOT_GUID |
The globally unique identifier of the configuration snapshot |
TARGET_GUID |
The globally unique identifier of the target |
PHYSICAL_CPU_COUNT |
The number of physical CPUs |
LOGICAL_CPU_COUNT |
The number of logical CPUs |
PLATFORM_ID |
The identification number of the platform |
TARGET_TYPE |
The type of target |
LAST_COLLECTION_TIMESTAMP |
The date-time of the last collection |
OS_RUN_LEVEL |
The run level of the operating system |
OS_DEFAULT_RUN_LEVEL |
The default run level of the operating system |
HOST_ID |
The host ID number |
OS_PLATFORM_VERSION_ID |
The operating system platform version number |
OS_DBM_MEMBER |
Indicates whether the host is part of an Exadata configuration |
OS_EXALOGIC_MEMBER |
Indicates whether the host is part of an Exalogic configuration |
VIRTUAL |
The identification for the given host is virtual or physical |
SYSTEM_SERIAL_NUMBER |
The system serial number of the host |
TOTAL_CPU_CORES |
Total CPU cores |
The MGMT$OS_PATCH_SUMMARY view provides a summary of the patches applied to the operating system.
Table 15-4 MGMT$OS_PATCH_SUMMARY
Column | Description |
---|---|
TARGET_NAME |
Type of the target for this metric |
VENDOR_NAME |
The name of the vendor |
BASE_VERSION |
The base version of the operating system |
UPDATE_LEVEL |
The update level of the operating system |
DISTRIBUTOR_VERSION |
The distributor version of the OS |
MAX_SWAP_SPACE_IN_MB |
The maximum swap space measured in MB |
SNAPSHOT_GUID |
The globally unique identifier of the snapshot |
NUM_PATCHES |
The number of OS patches found |
TARGET_GUID |
The globally unique identifier of the target |
TARGET_TYPE |
The type of the target |
START_TIMESTAMP |
The date-time of the last collection |
NAME |
The name of the patch |
The MGMT$OS_FS_MOUNT view displays performance information for mounted file systems.
Table 15-5 MGMT$OS_FS_MOUNT
Column | Description |
---|---|
TARGET_TYPE |
Type of the target for this metric |
RESOURCE_NAME |
The name of the mounted resource |
TYPE |
The file system mount |
MOUNT_LOCATION |
The mount location |
MOUNT_OPTIONS |
The mount options |
SNAPSHOT_GUID |
The globally unique identifier of the snapshot |
TARGET_GUID |
The globally unique identifier of the target |
START_TIMESTAMP |
The date-time of the last collection |
The MGMT$OS_KERNEL_PARAMS view returns a summary for operating system kernel parameters.
Table 15-6 MGMT$OS_KERNEL_PARAMS
Column | Description |
---|---|
TARGET_TYPE |
Type of the target for this metric |
TARGET_NAME |
The name of this target |
TARGET_GUID |
The globally unique identifier of the target |
VALUE |
The value of the parameter |
NAME |
The name of the parameter |
SOURCE |
The source of the parameter |
START_TIMESTAMP |
The date-time of the last collection |
HOST |
The name of the host |
The MGMT$OS_PATCHES view returns a summary of the operating system patches.
Table 15-7 MGMT$OS_PATCHES
Column | Description |
---|---|
TARGET_TYPE |
The type of target |
TARGET_NAME |
The name of the target |
TARGET_GUID |
The globally unique identifier for the configuration target |
START_TIMESTAMP |
The time-date of the last collection |
SNAPSHOT_GUID |
The globally unique identifier of the snapshot |
VENDOR_NAME |
The name of the vendor |
NAME |
The name of the patch |
The MGMT$OS_PROPERTIES view returns a summary of the operating system properties.
Table 15-8 MGMT$OS_PROPERTIES
Column | Description |
---|---|
TARGET_TYPE |
Type of the target for this metric |
TARGET_NAME |
The name of the target |
NAME |
The name of the property |
SOURCE |
The source of the property |
VALUE |
The value of the property |
SNAPSHOT_GUID |
The globally unique identifier of the snapshot |
START_TIMESTAMP |
The date-time of the last collection |
The MGMT$OS_MODULES view returns a summary of the operating system module details.
Table 15-9 MGMT$OS_MODULES
Column | Description |
---|---|
TARGET_TYPE |
Type of the target for this metric |
NAME |
The name of the module |
SIZE_IN_BYTES |
The size in bytes of the module |
REFERRING_MODULES |
The list of referring modules |
SNAPSHOT_GUID |
The globally unique identifier of the snapshot |
TARGET_NAME |
The name of the target |
START_TIMESTAMP |
The date-time of the last collection |
The MGMT$OS_LIMITS view returns a summary of operating system limit values
Table 15-10 MGMT$OS_LIMITS
Column | Description |
---|---|
TARGET_TYPE |
Type of target for this metric |
SNAPSHOT_GUID |
The globally unique identifier of the snapshot |
TARGET_NAME |
The target name |
TARGET_GUID |
The globally unique identifier of the target |
START_TIMESTAMP |
The date-time of the last collection |
The MGMT$OS_INIT_SERVICES view returns a summary of operating system init service details.
Table 15-11 MGMT$OS_INIT_SERVICES
Column | Description |
---|---|
TARGET_TYPE |
Type of target for this metric |
TARGET_NAME |
The name of the target |
APPLICATION_ID |
The application ID of the service |
RUN_STATE |
The run state of the service |
MAPPER_VERSION |
The mapper version of the service |
SNAPSHOT_GUID |
The globally unique identifier of the snapshot |
TARGET_GUID |
The globally unique identifier of the target |
START_TIMESTAMP |
The date-time of the last collection |