Space_q_top_10_non_partition_detail_vw1, Space_q_top_10_partition_detail_vw1, Space_q_top_10_schema_size_vw1 – HP Neoview Release 2.4 Software User Manual
Page 65: Space_q_top_10_table_size_vw1
SPACE_Q_TOP_10_NON_PARTITION_DETAIL_VW1
Table 3-24 SPACE_Q_TOP_10_NON_PARTITION_DETAIL_VW1
This report lists the non-partitioned objects with the top 10 sizes, in megabytes, from biggest
to smallest.
Description:
LAST_CHECK_NOUPDATE_LCT_TS
LAST_CHECK_NOUPDATE_UTC_TS
CATALOG_NAME
SCHEMA_NAME
OBJECT_NAME
OBJECT_SIZE_MB
Columns Included:
NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1
Views Used:
SPACE_Q_TOP_10_PARTITION_DETAIL_VW1
Table 3-25 SPACE_Q_TOP_10_PARTITION_DETAIL_VW1
This report lists the partitioned objects with the top 10 sizes, in megabytes, from biggest to
smallest.
Description:
LAST_CHECK_NOUPDATE_LCT_TS
LAST_CHECK_NOUPDATE_UTC_TS
CATALOG_NAME
SCHEMA_NAME
OBJECT_NAME
OBJECT_SIZE_MB
Columns Included:
NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1
Views Used:
SPACE_Q_TOP_10_SCHEMA_SIZE_VW1
Table 3-26 SPACE_Q_TOP_10_SCHEMA_SIZE_VW1
This report lists the schemas with the top 10 sizes, in megabytes, from biggest to smallest.
Description:
CATALOG_NAME
SCHEMA_NAME
SCHEMA_SIZE_MB
Columns Included:
NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1
Views Used:
SPACE_Q_TOP_10_TABLE_SIZE_VW1
Table 3-27 SPACE_Q_TOP_10_TABLE_SIZE_VW1
This report lists the tables with the top 10 sizes, in megabytes, from biggest to smallest.
Description:
CATALOG_NAME
SCHEMA_NAME
TABLE_NAME
TABLE_SIZE_MB
Columns Included:
NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1
Views Used:
Space Management Views and Sample Query Views for Space Management
65