Hp Neoview Release 2.5 Software Bedienungsanleitung PDF herunterladen (Seite 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

Kommentare zu diesen Handbüchern

Keine Kommentare

Hp Neoview Release 2.5 Software Bedienungsanleitung Seite 57

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software Hp Neoview Release 2.5 Software