Space_q_top_10_partition_detail_vw1, Space_q_top_10_schema_size_vw1, Space_q_top_10_table_size_vw1 – HP Neoview Release 2.5 Software User Manual
Page 58: Space_q_top_10_user_space_size_vw1
SPACE_Q_TOP_10_PARTITION_DETAIL_VW1
Table 3-22 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-23 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-24 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_Q_TOP_10_USER_SPACE_SIZE_VW1
Table 3-25 SPACE_Q_TOP_10_USER_SPACE_SIZE_VW1
This report lists the top 10 users who are consuming the most space, in megabytes, on the
Neoview system.
Description:
FILE_OWNER
USER_SIZE_MB
Columns Included:
NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1
Views Used:
58
Repository Views