19 Virtualization Views
This chapter provides a description of each virtualization target view and its columns. It contains the following sections:
For examples of how to use views, see Examples.
MGMT$VT_VM_CONFIG
The MGMT$VT_VM_CONFIG retrieves the Oracle VM Guest configuration.
Table 19-1 MGMT$VT_VM_CONFIG
| Column | Description |
|---|---|
|
ECM_SNAPSHOT_ID |
The ECM Snapshot ID corresponding to the latest ECM snapshot uploaded |
|
TARGET_GUID |
GUID of the target instance |
|
BOOT_TYPE |
Boot Type cdrom/disk/network |
|
CPU_COUNT |
Number of CPUs for this virtual machine |
|
CPU_PRIORITY |
Priority value for scheduling. Range 1-100 |
|
DOMAIN_TYPE |
Domain type (hvm or pvm) of the virtual machine |
|
HA_FLAG |
Current state of the High Availability flag |
|
MEM_REQD_MB |
Amount of memory required to run this virtual machine |
|
MOUSE_TYPE |
The type of mouse device to be used with this virtual machine |
|
REBOOT_LIMIT |
Reboot limit |
|
ALLOC_MEM_MB |
Allocated memory in MB for this virtual machine |
|
ALLOC_DISK_MB |
Allocated diskspace in MB for this virtual machine |
MGMT$VT_VM_SW_CFG
The MGMT$VT_VM_SW_CFG retrieves the software related configuration for the Oracle VM Guest target
Table 19-2 MGMT$VT_VM_SW_CFG
| Column | Description |
|---|---|
|
ECM_SNAPSHOT_ID |
The ECM Snapshot ID corresponding to the latest ECM snapshot uploaded |
|
TARGET_GUID |
GUID of the target instance |
|
OS_NAME |
Name of the operating system |
|
KERNEL_VER |
Kernel version |
|
USE_VS_TOOLS |
Are VS tools used for this virtual machine? |
|
VS_TOOLS_OS |
Operating system as returned by VS tools |
|
VS_TOOLS_VER |
VS tools version |
|
GUEST_UUID |
UUID of the virtual machine in OVM Manager |
|
VS_UUID |
UUID of the server the virtual machine is running on |
|
VSP_UUID |
UUID of the server pool the virtual machine is contained in |
|
OVMM_UUID |
UUID of the OVM Manager the virtual machine is registered with. Has data only if the virtual machine is not part of a server pool. |
|
OVM_DISPLAY_NAME |
The current display name of the virtual machine in OVM. Need not be the same as OEM's target name. |
MGMT$VT_VM_VNIC
The MGMT$VT_VM_VNIC retrieves Virtual Network Interface Card information for the virtual machine.
Table 19-3 MGMT$VT_VM_VNIC
| Column | Description |
|---|---|
|
ECM_SNAPSHOT_ID |
The ECM Snapshot ID corresponding to the latest ECM snapshot uploaded |
|
TARGET_GUID |
GUID of the target instance |
|
MAC_ADDRESS |
MAC address |
|
ETH_NET |
Ethernet network the VNIC is connected to |
|
IP_ADDRESS |
IP address. Each VNIC can have multiple IP addresses |
|
IP_ADDRESS_TYPE |
Address type - static/dhcp |
MGMT$VT_VM_VNIC_QOS
The MGMT$VT_VM_VNIC_QOS displays the quality of service associated with the VNIC.
Table 19-4 MGMT$VT_VM_VNIC_QOS
| Column | Description |
|---|---|
|
ECM_SNAPSHOT_ID |
The ECM Snapshot ID corresponding to the latest ECM snapshot uploaded |
|
TARGET_GUID |
GUID of the target instance |
|
MAC_ADDRESS |
MAC address |
|
QOS_NAME |
Quality of service name |
MGMT$VT_VM_EM_CFG
The MGMT$VT_VM_EM_CFG displays the OEM specified configuration for this virtual machine
Table 19-5 MGMT$VT_VM_EM_CFG
| Column | Description |
|---|---|
|
ECM_SNAPSHOT_ID |
The ECM Snapshot ID corresponding to the latest ECM snapshot uploaded |
|
TARGET_GUID |
GUID of the target instance |
|
VM_TYPE |
Type of virtual machine. For example, small/medium/large. These values are defined in OEM |
MGMT$VT_VM_VDISKS
The MGMT$VT_VM_VDISKS displays virtual disk information for the virtual machine.
Table 19-6 MGMT$VT_VM_VDISKS
| Column | Description |
|---|---|
|
ECM_SNAPSHOT_ID |
The ECM Snapshot ID corresponding to the latest ECM snapshot uploaded |
|
TARGET_GUID |
GUID of the target instance |
|
UUID |
The UUID of the virtual disk in OVM Manager |
|
NAME |
Display name of the virtual disk in OVM Manager |
|
SIZE_MB |
Size in MB |
|
TYPE |
Type of virtual disk |
|
SHAREABLE |
Is the virtual disk shareable or not? |
|
REPO |
The repository that the virtual disk comes from |
|
DISK_MODE |
Mode. For example, read-only or read-write. |
MGMT$VT_VM_VDISK_QOS
The MGMT$VT_VM_VDISK_QOS displays virtual disk quality of service information.
Table 19-7 MGMT$VT_VM_VDISK_QOS
| Column | Description |
|---|---|
|
ECM_SNAPSHOT_ID |
The ECM Snapshot ID corresponding to the latest ECM snapshot uploaded |
|
TARGET_GUID |
GUID of the target instance |
|
UUID |
The UUID of the virtual disk in OVM Manager |
|
QOS_NAME |
Quality of service associated with the virtual disk |
MGMT$VT_EXA_CTRL_VSERVER_TAGS
The MGMT$VT_EXA_CTRL_VSERVER_TAGS displays Exalogic Control VServer Tags.
Table 19-8 MGMT$VT_EXA_CTRL_VSERVER_TAGS
| Column | Description |
|---|---|
|
ECM_SNAPSHOT_ID |
The ECM Snapshot ID corresponding to the latest ECM snapshot uploaded |
|
ID |
The Identifier for the Tag |
|
TYPE |
Type of VServer |
|
DESCRIPTION |
Description for the VServer |
|
SOFTWARE_NAME |
Software Name on the VServer |
|
URL |
URL of the Software |
|
VERSION |
Version |
MGMT$VT_VSP_CONFIG
The MGMT$VT_VSP_CONFIG view displays the server pool configuration.
Table 19-9 MGMT$VT_VSP_CONFIG
| Column | Description |
|---|---|
|
ECM_SNAPSHOT_ID |
The ECM Snapshot ID corresponding to the latest ECM snapshot uploaded |
|
TARGET_GUID |
GUID of the target instance |
|
MASTER_VIP |
Master Virtual IP Address |
|
IS_DRS_ENABLED |
Is Distributed Resource Scheduler enabled for this server pool? |
|
IS_DPM_ENABLED |
Is Distributed Power Management enabled for this server pool? |
|
TOTAL_MEMORY_MB |
Total memory across all servers in the server pool in MB |
|
TOTAL_DISKSPACE_MB |
Total storage across all servers in the server pool in MB |
|
TOTAL_PHYSICAL_CPUS |
Total number of physical CPUs across all servers in the server pool |
|
TOTAL_VCPUS |
Total number of VCPUs allocated across all virtual machines in the server pool |
|
TOTAL_NICS |
Total number of network interface cards across all servers in the server pool |
|
CLSTR_ENABLED |
Is the pool cluster enabled? |
|
VM_MIGRATE_SECURE |
Is secure virtual machine migration enabled? |
|
POOL_FILESYSTEM |
Server Pool filesystem information |
|
VSP_UUID |
The UUID of the server pool in OVM Manager |
|
ZONE_UUID |
The UUID of the parent zone in OVM Manager |
|
OVMM_UUID |
The UUID of the OVM Manager managing the server pool. Only collected if the server pool is not part of a zone. |
|
OVM_DISPLAY_NAME |
The display name of the server pool in OVM Manager. Need not be the same as OEM's target name |
MGMT$VT_VS_HW_CFG
The MGMT$VT_VS_HW_CFG view displays the Oracle VM Server hardware configuration.
Table 19-10 MGMT$VT_VS_HW_CFG
| Column | Description |
|---|---|
|
ECM_SNAPSHOT_ID |
The ECM Snapshot ID corresponding to the latest ECM snapshot uploaded |
|
TARGET_GUID |
GUID of the target instance |
|
VENDOR |
Vendor |
|
PROCESSOR_SPEED |
CPU speed |
|
PROCESSOR_TYPE |
CPU type |
|
NO_EXECUTE_FLAG |
Is the no execute flag set? |
|
NUM_POP_PROC_SOCKS |
Sockets filled |
|
NUM_PROC_SOCKS |
Sockets per NUMA node |
|
NUM_THREADS_PER_CORE |
Threads per core |
|
BIOS_RELEASE_DATE |
BIOS release date |
|
BIOS_VENDOR |
BIOS vendor |
|
BIOS_VERSION |
BIOS version |
|
MEMORY_MB |
Server memory in MB |
|
AVAILABLE_MEM_MB |
Available memory on the server in MB |
|
MEM_OVERHEAD_MB |
Control domain memory in MB |
|
USABLE_MEM_MB |
Memory usable by virtual machines in MB |
|
SWAP_SPACE_MB |
Swap space on the server in MB |
|
ADDR_LENGTH_BITS |
Address length - for example, 32 bit and 64 bit |
|
LOCAL_DISK_GB |
Local disk space in GB |
|
ENABLED_PROCESSORS |
Number of enabled processors |
|
ENABLED_CORES |
Number of enabled cores |
|
NUM_VCPUS |
Number of VCPUs allocated on the server |
|
CD_CPU_COUNT |
Number of CPUS for the control domain |
|
NUM_CORES |
Number of cores |
|
NUM_CORES_PER_SOCK |
Number of cores per socket |
MGMT$VT_VS_HYPERVISOR
The MGMT$VT_VS_HYPERVISOR view displays Hypervisor related information.
Table 19-11 MGMT$VT_VS_HYPERVISOR
| Column | Description |
|---|---|
|
ECM_SNAPSHOT_ID |
The ECM Snapshot ID corresponding to the latest ECM snapshot uploaded |
|
TARGET_GUID |
GUID of the target instance |
|
VERSION |
Version |
|
HVM_CAPABLE |
Is the hypervisor HVM capable? |
|
CAPABILITY |
Capability supported by the hypervisor |
|
TYPE |
Type - for example, LDOM, VBOX, XEN |
MGMT$VT_VS_PROCESSORS
The MGMT$VT_VS_PROCESSORS view displays information about processors on the server.
Table 19-12 MGMT$VT_VS_PROCESSORS
| Column | Description |
|---|---|
|
ECM_SNAPSHOT_ID |
The ECM Snapshot ID corresponding to the latest ECM snapshot uploaded |
|
TARGET_GUID |
GUID of the target instance |
|
PROC_ID |
Processor ID |
|
CPU_FAMILY |
CPU family the processor belongs to |
|
CPU_MODEL |
CPU Model |
|
FAMILY |
Family |
|
FLAGS |
CPU flags |
|
L1CACHE_KB |
Size of L1 cache in KB |
|
L2CACHE_KB |
Size of L2 cache in KB |
|
L3CACHE_KB |
Size of L3 cache in KB |
|
MANUFACTURER |
Name of the manufacturer |
|
MODEL_NAME |
Model name |
|
VENDOR_ID |
Vendor ID |
MGMT$VT_VS_SW_CFG
The MGMT$VT_VS_SW_CFG view displays
Table 19-13 MGMT$VT_VS_SW_CFG
| Column | Description |
|---|---|
|
ECM_SNAPSHOT_ID |
The ECM Snapshot ID corresponding to the latest ECM snapshot uploaded |
|
TARGET_GUID |
GUID of the target instance |
|
AGENT_PORT |
OVS agent port |
|
AGENT_VERSION |
OVS agent version |
|
OVM_VERSION |
OVM version |
|
CONSOLE_SHELL_FLAG |
Is the console shell flag set? |
|
DISABLE_USB_FLAG |
Is the disable USB flag set? |
|
HALT_ON_ERROR_FLAG |
Is the halt on error flag set? |
|
KERNEL_RELEASE |
Kernel release |
|
KERNEL_VERSION |
Kernel version |
|
ASSOC_CLUSTER |
Associated cluster |
|
PROTECTED_FLAG |
Is the protected flag set? |
|
PYTHON_BIND_VER |
Python binding version |
|
RPM_VER |
RPM version |
|
VS_UUID |
UUID of the server in OVM Manager |
|
VSP_UUID |
UUID of the parent server pool in OVM Manager |
|
OVMM_UUID |
UUID of the OVM Manager where the server is registered. Only contains data if the server is not part of a pool. |
|
OVM_DISPLAY_NAME |
The display name of the server in OVM Manager. Need not correspond to OEM target name. |
|
CD_HOST_OS_NAME |
Control domain host OS name |
|
CD_HOST_OS_TYPE |
Control domain host OS type |
|
CD_HOST_OS_MAJOR_VER |
Control domain host OS major version |
|
CD_HOST_OS_MINOR_VER |
Control domain host OS minor version |
MGMT$VT_VS_ATTRIBUTES
The MGMT$VT_VS_ATTRIBUTES view displays miscellaneous server configuration information.
Table 19-14 MGMT$VT_VS_ATTRIBUTES
| Column | Description |
|---|---|
|
ECM_SNAPSHOT_ID |
The ECM Snapshot ID corresponding to the latest ECM snapshot uploaded |
|
TARGET_GUID |
GUID of the target instance |
|
IS_MASTER |
Is the server running as the master in the parent server pool? |
|
UPGRADE_REQUIRED |
Is upgrade required on the server? |
MGMT$VT_VS_FS_MOUNTS
The MGMT$VT_VS_FS_MOUNTS view displays filesystem mounts on the server.
Table 19-15 MGMT$VT_VS_FS_MOUNTS
| Column | Description |
|---|---|
|
ECM_SNAPSHOT_ID |
The ECM Snapshot ID corresponding to the latest ECM snapshot uploaded |
|
TARGET_GUID |
GUID of the target instance |
|
FILESERVER_UUID |
UUID of the file server the file system is being served from |
|
MOUNT_POINT |
Filesystem mount point |
|
REMOTE_PATH |
The remote path of the filesystem |
|
OPTIONS |
Mount options |
|
PHYSICAL_SIZE |
Physical size of the filesystem |
MGMT$VT_VS_NET_DEVICE
The MGMT$VT_VS_NET_DEVICE view displays information about network devices on the server.
Table 19-16 MGMT$VT_VS_NET_DEVICE
| Column | Description |
|---|---|
|
ECM_SNAPSHOT_ID |
The ECM Snapshot ID corresponding to the latest ECM snapshot uploaded |
|
TARGET_GUID |
GUID of the target instance |
|
MAC_ADDRESS |
MAC address |
|
IP_ADDRESS |
IP address |
|
INTERFACE_NAME |
Name of the interface |
|
MTU |
Maximum tranmission unit |
|
BANDWIDTH_MBPS |
Bandwidth in MB/S |
|
NETMASK |
Netmask |
|
ADDRESS_TYPE |
Address type |
MGMT$VT_VS_FILESERVERS
The MGMT$VT_VS_FILESERVERS view displays information about file servers associated with the server.
Table 19-17 MGMT$VT_VS_FILESERVERS
| Column | Description |
|---|---|
|
ECM_SNAPSHOT_ID |
The ECM Snapshot ID corresponding to the latest ECM snapshot uploaded |
|
TARGET_GUID |
GUID of the target instance |
|
FILESERVER_UUID |
UUID of the fileserver |
|
FILESERVER |
Name of the fileserver |
|
FSNAME |
Name of the filesystem (for example, nfs) |
|
FSTYPE |
Type (for example, networkfs) |
MGMT$VT_VS_REPOS
The MGMT$VT_VS_REPOS view displays storage repositories visible to the server.
Table 19-18 MGMT$VT_VS_REPOS
| Column | Description |
|---|---|
|
ECM_SNAPSHOT_ID |
The ECM Snapshot ID corresponding to the latest ECM snapshot uploaded |
|
TARGET_GUID |
GUID of the target instance |
|
FILESERVER_UUID |
UUID of the fileserver |
|
MOUNT_POINT |
mountpoints on the virtual server from the fileserver |
|
REPOSITORY_UUID |
UUID of the repository |
|
REPOSITORY |
Name of the repository |
MGMT$VT_VS_ABILITIES
The MGMT$VT_VS_ABILITIES view displays
Table 19-19 MGMT$VT_VS_ABILITIES
| Column | Description |
|---|---|
|
ECM_SNAPSHOT_ID |
The ECM Snapshot ID corresponding to the latest ECM snapshot uploaded |
|
TARGET_GUID |
GUID of the target instance |
|
ABILITY |
Name of the ability |
|
ENABLED |
Is the above ability enabled or not? |
MGMT$VT_ZONE_CONFIG
The MGMT$VT_ZONE_CONFIG view displays the Oracle VM Zone configuration.
Table 19-20 MGMT$VT_ZONE_CONFIG
| Column | Description |
|---|---|
|
ECM_SNAPSHOT_ID |
The ECM Snapshot ID corresponding to the latest ECM snapshot uploaded |
|
TARGET_GUID |
GUID of the target instance |
|
TOTAL_MEMORY_MB |
Total memory across servers in the zone in MB |
|
TOTAL_DISKSPACE_MB |
Total diskspace across servers in the zone in MB |
|
TOTAL_PHYSICAL_CPUS |
Total number of physical CPUs across servers in the zone |
|
TOTAL_NICS |
Total number of NICS across servers in the zone |
|
ZONE_UUID |
UUID of the zone in OVM Manager |
|
OVMM_UUID |
UUID of the OVM Manager where this zone is registered |
|
OVM_DISPLAY_NAME |
OVM display name |