HP Neoview Release 2.5 Software - Manual (Page 57)

SPACE_Q_TABLE_FULL_VW1
Table 3-18 SPACE_Q_TABLE_FULL_VW1
This report provides table fullness information, including the percentage of table space that
is currently full for each table, from biggest to smallest. Description:
LAST_CHECK_NOUPDATE_LCT_TS
LAST_CHECK_NOUPDATE_UTC_TS
TABLE_NAME
TABLE_FULL_PCT Columns Included:
NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1 Views Used:
SPACE_Q_TABLE_SIZE_VW1
Table 3-19 SPACE_Q_TABLE_SIZE_VW1
This report lists the tables and their 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_CATEGORY_SIZE_VW1
Table 3-20 SPACE_Q_TOP_10_CATEGORY_SIZE_VW1
This report lists the categories with the top 10 sizes, in bytes, from biggest to smallest. The
categories include:
SQL Permanent Space
SQL System Space
SQL Volatile Space
Transform Ghost Objects
Transporter Staging Tables
Description:
CATEGORY_TYPE
CATEGORY_SIZE_BYTES Columns Included:
NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1 Views Used:
SPACE_Q_TOP_10_NON_PARTITION_DETAIL_VW1
Table 3-21 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 Management Views and Sample Query Views for Space Management 57