beautypg.com

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

background image

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