15 Operating System Views
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.
MGMT$OS_SUMMARY
The MGMT$OS_SUMMARY view contains the summary of targets installed in the Oracle home directories.
Table 15-1 MGMT$OS_SUMMARY
| Column | Description |
|---|---|
| HOST | The name of the host. |
| NAME | The name of the component. |
| 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 date-time of the last collection. |
| 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. |
MGMT$OS_COMPONENTS
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. |
MGMT$OS_HW_SUMMARY
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 |
MGMT$OS_PATCH_SUMMARY
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 |
MGMT$OS_FS_MOUNT
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. Supported filesystem type: |
|
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 |
MGMT$OS_KERNEL_PARAMS
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 |
MGMT$OS_PATCHES
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 |
MGMT$OS_PROPERTIES
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 |
MGMT$OS_MODULES
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 |
MGMT$OS_LIMITS
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 |
MGMT$OS_INIT_SERVICES
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 |