beautypg.com

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

background image

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