Skip to end of metadata
Go to start of metadata

HANA_SQL_SQLCache_Overview_Rev70+

 

Display SQL cache information including evictions. Can be used if investing SQL plan cache issues.

Input Parameters

HOST
PORT

Output Parameters

HOST:               Host name
PORT:               Port
CONF_GB:            Configured SQL cache size (GB)
USED_GB:            Used SQL cache size (GB)
USED_PCT:           Used compared to configured SQL cache size (%)
ABAP_REC_GB:        SQL cache size recommendation for ABAP environments as per SAP Note 2040002 (GB)
NON_ABAP_REC_GB:    SQL cache size recommendation for ABAP environments as per SAP Note 2040002 (GB)
CACHED_SQLS:        Number of currently cached plans
AVG_SIZE_KB:        Average size of a currently cached plan (KB)
HIT_PCT:            SQL cache hit ratio (%)
EVICT_PER_H:        Number of evictions per hour
TIME_TO_EVICT_H:    Average time between load and eviction (h)
EVICT_OVERHEAD_PCT: Response time overhead due to evictions (%)
CONNECTIONS:        Number of existing connections

  • No labels