Space_q_disk_full_vw1, Space_q_num_guardian_files_vw1, Space_q_object_growth_vw1 – HP Neoview Release 2.5 Software User Manual
Page 55
SPACE_Q_DISK_FULL_VW1
Table 3-11 SPACE_Q_DISK_FULL_VW1
This report provides disk fullness information, including the percentage of disk space that is
currently in use from biggest to smallest and the percentage of user-allocated space that is
currently full.
Description:
LAST_CHECK_NOUPDATE_LCT_TS
LAST_CHECK_NOUPDATE_UTC_TS
SEGMENT_NAME
DISK_NAME
DISK_FULL_PCT
USER_FULL_PCT
Columns Included:
NEO.HP_METRICS.DISK_STATS_V1
NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1
(and an internal table)
Views Used:
SPACE_Q_NUM_GUARDIAN_FILES_VW1
Table 3-12 SPACE_Q_NUM_GUARDIAN_FILES_VW1
This report provides the number of files on each segment.
Description:
SEGMENT_NAME
NUM_GUARDIAN_FILES_PER_SEG
Columns Included:
NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1 (and an internal table)
Views Used:
SPACE_Q_OBJECT_GROWTH_VW1
Table 3-13 SPACE_Q_OBJECT_GROWTH_VW1
This report provides historical data of object growth for a given time period, from the earliest
to the most recent time, and includes the current, average, maximum, and minimum sizes, in
megabytes, of the objects on the Neoview platform.
Description:
LAST_CHECK_NOUPDATE_LCT_TS
LAST_CHECK_NOUPDATE_UTC_TS
CATALOG_NAME
SCHEMA_NAME
OBJECT_NAME
OBJECT_NAME_SPACE
OBJECT_TYPE
ROW_TYPE
OBJECT_CURR_SIZE_MB
OBJECT_AVG_SIZE_MB
OBJECT_MAX_SIZE_MB
OBJECT_MIN_SIZE_MB
Columns Included:
NEO.HP_METRICS.SPACE_PARTITION_DETAIL_HISTORY_VW1
Views Used:
Space Management Views and Sample Query Views for Space Management
55