HP Neoview Release 2.4 Software - Manual (Page 63)

SPACE_Q_OBJECT_GROWTH_VW1
Table 3-16 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_Q_PARTITION_FULL_VW1
Table 3-17 SPACE_Q_PARTITION_FULL_VW1
This report provides partition fullness information, including the percentage of partition space
that is currently full for each partition, from biggest to smallest. Description:
LAST_CHECK_NOUPDATE_LCT_TS
LAST_CHECK_NOUPDATE_UTC_TS
SEGMENT_NAME
PARTITION_NAME
PARTITION_FULL_PCT Columns Included:
NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1 Views Used:
SPACE_Q_SYSTEM_DETAILS_VW1
Table 3-18 SPACE_Q_SYSTEM_DETAILS_VW1
This report provides detailed space information for the schemas on the Neoview platform,
including whether the objects in the schema are partitioned or non-partitioned, the number
of objects in the schema, the schema size in megabytes from biggest to smallest, and the
percentage of schema space that is currently full for each schema. Description:
LAST_CHECK_NOUPDATE_LCT_TS
LAST_CHECK_NOUPDATE_UTC_TS
CATALOG_NAME
SCHEMA_NAME
SPACE_TYPE
NUM_OBJECTS
SCHEMA_SIZE_MB
SCHEMA_FULL_PCT Columns Included:
NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1 Views Used:
SPACE_Q_SYSTEM_TOTAL_SIZE_VW1
Table 3-19 SPACE_Q_SYSTEM_TOTAL_SIZE_VW1
This report displays the total amount, in gigabytes, of system-wide storage space for users. Description:
SYSTEM_SIZE_GB Columns Included:
None (internal tables only) Views Used:
Space Management Views and Sample Query Views for Space Management 63