Hp Neoview Release 2.5 Software Manuale Utente Scaricare il pdf (Pagina 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_VW1Views 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_VW1Views 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_VW1Views 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_VW1Views Used:

Space Management Views and Sample Query Views for Space Management 57

1 2 ... 52 53 54 55 56 57 58 59 60 61 62 ... 141 142

Commenti su questo manuale

Nessun commento

Hp Neoview Release 2.5 Software Manuale Utente Pagina 57

Commenti su questo manuale

Prodotti e manuali riguardandi Software Hp Neoview Release 2.5 Software