
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_VW1Views 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_VW1Views 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_VW1Views 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_VW1Views Used:
64 Repository Views
Comentarios a estos manuales