Operating System Views

15.1 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
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

15.2 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.

15.3 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

15.4 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

15.5 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
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

15.6 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

15.7 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

15.8 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

15.9 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

15.10 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

15.11 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

15 Operating System Views