Skip to end of metadata
Go to start of metadata

HANA_Tables_ColumnStore_Merges

Displays delta merge information during a specified time. This can be used when you need to investigate a delta merge issue or investigating an issue where there is high CPU usage (e.g. during a specific time a lot of delta merges occur causing high CPU usage)

Input Parameters

BEGIN_TIME

END_TIME

HOST

PORT

SCHEMA_NAME

TABLE_NAME          

MIN_MERGE_DURATION_S

MIN_RECORDS_MERGED

MERGE_TYPE

MERGE_MOTIVATION

MERGE_ERROR

ONLY_FAILED_MERGES

DATA_SOURCE

AGGREGATE_BY

AGGREGATION_TYPE

TIME_AGGREGATE_BY

ORDER_BY

Output Parameters

START_TIME:      Start time of merge

HOST:            Host name

PORT:            Port

NUM:             Number of merges

TYPE:            Merge type and motivation

SCHEMA_NAME:     Schema name

TABLE_NAME:      Table name

DURATION_S:      Merge duration (s)

ROWS_MERGED:     Number of records merged

TIME_PER_ROW_MS: Merge time per record (ms)

LAST_ERROR:      Last error message (0 if no error)

 

  • No labels