HP Neoview Release 2.4 Software - Manual (Page 64)

SPACE_Q_TABLES_BY_SCHEMA_VW1
Table 3-20 SPACE_Q_TABLES_BY_SCHEMA_VW1
This report lists the tables in each schema on the Neoview platform. Description:
SCHEMA_NAME
OBJECT_NAME Columns Included:
NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1 Views Used:
SPACE_Q_TABLE_FULL_VW1
Table 3-21 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-22 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-23 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:
64 Repository Views