Skip to end of metadata
Go to start of metadata

HANA_Histories_RetentionTime

If there are issues with the statistics server running OOM or with alerts staying in the system too long you can run this to view what the retention time is and the size per table.

Input Parameters

TABLE_NAME          
ONLY_MODIFIED_SETTINGS
ORDER_BY

Output Parameters

TABLE_NAME:          Table name
DEF_RETENTION_DAYS:  Default number of retention days
USER_RETENTION_DAYS: Retention days specified explicitly
OLDEST_DATA_DAYS:    Oldest data in table (days)
SIZE_MB:             Table size (MB)

  • No labels