This chapter provides a description of each storage reporting view and its columns. It contains the following sections:
For examples of how to use views, see Chapter 20, "Examples".
The MGMT$STORAGE_REPORT_DATA view displays the Storage Data metric attributes which are common across all instrumented Storage Entities.
Table 17-1 MGMT$STORAGE_REPORT_DATA
| Column | Description |
|---|---|
|
TARGET_NAME |
Target Name in Enterprise Manager |
|
TARGET_TYPE |
Target Type in Enterprise Manager |
|
KEY_VALUE |
Unique Key Value for the Storage Entity |
|
GLOBAL_UNIQUE_ID |
A globally unique persistent identifier for a storage entity. All instances of a shared Storage Entity will have the same global_unique_identifier |
|
NAME |
Name of the storage entity |
|
STORAGE_LAYER |
Storage layer of the storage entity. Sample Usage: - OS_DISK - VOLUME_MANAGER - LOCAL_FILESYSTEM - NFS |
|
ENTITY_TYPE |
Indicates the type of Entity. Value is vendor specific. Example: Plex, Sub Disk, Diskgroup, Volume group, Metadevice and so on. |
|
RAWSIZEB |
Total space in bytes |
|
SIZEB |
Size in bytes |
|
USEDB |
Used size in bytes |
|
FREEB |
Free size in bytes |
The MGMT$STORAGE_REPORT_KEYS view displays the relationship between instrumented Storage Entities.
The MGMT$STORAGE_REPORT_PATHS view displays the OS paths for all instrumented storage entities.
Table 17-3 MGMT$STORAGE_REPORT_PATHS
| Column | Description |
|---|---|
|
TARGET_NAME |
Target name in Enterprise Manager |
|
TARGET_TYPE |
Target type in Enterprise Manager |
|
KEY_VALUE |
Unique key value for the storage entity |
|
NAME |
Name of the storage entity |
|
PATH |
OS path to the storage entity |
|
FILE_TYPE |
Type of file Examples: - _BLOCKSPECIAL - _DIRECTORY - _REGULAR |
|
STORAGE_LAYER |
Storage layer of the storage entity. Sample Usage: - OS_DISK - VOLUME_MANAGER - LOCAL_FILESYSTEM - NFS |
|
ENTITY_TYPE |
Indicates the type of entity. Value is vendor-specific. Examples: Plex, Sub Disk, Diskgroup, Volume group, Metadevice, and so on. |
The MGMT$STORAGE_REPORT_ISSUES view displays the consistency issues encountered when analyzing the instrumented storage metrics.
The MGMT$STORAGE_REPORT_DISK view displays Additional Storage Data Metric Attributes for all physical disk device storage entities.
Table 17-5 MGMT$STORAGE_REPORT_DISK
| Column | Description |
|---|---|
|
TARGET_NAME |
Target name in Enterprise Manager |
|
TARGET_TYPE |
Target type in Enterprise Manager |
|
ENTITY_TYPE |
Indicates the type of disk device such as disk or disk partition |
|
USED_PATH |
The OS path to the disk or partition. If the disk or partition is allocated, then this is the path that is in use. |
|
FILE_TYPE |
Type of file Examples:- _BLOCKSPECIAL- _REGULAR |
|
SIZEB |
Size in bytes |
|
USEDB |
Used size in bytes |
|
FREEB |
Free size in bytes |
|
VENDOR |
Name of the disk vendor; detected through SCSI enquiry |
|
PRODUCT |
Product family from the vendor; detected through SCSI enquiry |
The MGMT$STORAGE_REPORT_VOLUME view displays Additional Storage Data Metric attributes for all volume manager storage entities.
Table 17-6 MGMT$STORAGE_REPORT_VOLUME
| Column | Description |
|---|---|
|
TARGET_NAME |
Target name in Enterprise Manager |
|
TARGET_TYPE |
Target type in Enterprise Manager |
|
VENDOR |
Vendor name of the volume or software raid manager |
|
PRODUCT |
Vendor name of the volume or software raid manager |
|
TYPE |
Indicates the type of volume entity. It can be vendor specific. For example, in the case of Veritas Volume Manager for Volume, Plex, VM Disk, Diskgroup, Sub Disk, Metadevice, Metadevice Partition, Array, Raiddevice, Submirror, Diskset, Slice, raid-disk, spare-disk, Hot spare, and so on. |
|
DISK_GROUP |
Disk group or volume group name |
|
NAME |
The name of the entity in the volume manager namespace |
|
USED_PATH |
The OS path to the device. If the device is allocated, then this is the path that is in use. |
|
FILE_TYPE |
Type of file Examples:- _BLOCKSPECIAL- _REGULAR |
|
RAWSIZEB |
In bytes. For a 2-way mirrored Veritas Volume. It is the sum of the size of each plex. |
|
SIZEB |
Size in bytes |
|
USEDB |
Used size in bytes |
|
FREEB |
Free size in bytes |
|
CONFIGURATION |
A string describing the configuration of the volume. |
The MGMT$STORAGE_REPORT_LOCALFS view displays Additional Storage Data Metric attributes for all local file system storage entities.
Table 17-7 MGMT$STORAGE_REPORT_LOCALFS
| Column | Description |
|---|---|
|
TARGET_NAME |
Target name in Enterprise Manager |
|
TARGET_TYPE |
Target type in Enterprise Manager |
|
FILESYSTEM_TYPE |
The type of file system |
|
FILESYSTEM |
The file system path on the operating system |
|
MOUNTPOINT |
The mount point path on the operating system |
|
SIZEB |
Number |
|
USEDB |
Used size in bytes |
|
FREEB |
Free size in bytes |
The MGMT$STORAGE_REPORT_NFS view displays Additional Storage Data Metric attributes for all network file systems.
Table 17-8 MGMT$STORAGE_REPORT_NFS
| Column | Description |
|---|---|
|
TARGET_NAME |
Target name in Enterprise Manager |
|
TARGET_TYPE |
Target type in Enterprise Manager |
|
FILESYSTEM |
The file system name as seen on the operating system. For NFS file systems the file system name should be in the format nfs_server:/filesystem_name |
|
MOUNTPOINT |
The mountpoint path on the operating system |
|
SIZEB |
Size in bytes |
|
USEDB |
Used size in bytes, |
|
FREEB |
Free size in bytes |
|
NFS_SERVER |
The server name for the NFS Server |
|
NFS_SERVER_IP_ADDRESS |
The IP address of the NFS Server |
|
NFS_VENDOR |
The NFS Server vendor |
|
MOUNT_PRIVILEGE |
This is the mount privilege of the file system Possible values:
|