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 Chapter 20, "Examples".

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

The MGMT$OS_COMPONENTS view returns performance information for host OS components.

Table 15-2 MGMT$OS_COMPONENTS

Column	Description
TARGET_NAME	The name of this target
COMPONENT_NAME	The name of the software component.
TARGET_TYPE	The type of target for this view
TARGET_GUID	The globally unique identifier for the target
SNAPSHOT_GUID	The globally unique identifier for the snapshot
START_TIMESTAMP	The date-time when the data was first collected
INSTALLATION_DATE	The installation date of the component
VERSION	The version of the component
DESCRIPTION	The description of the component

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

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