Skip to end of metadata
Go to start of metadata


Display SQL cache information including evictions. Check if investigating SQL plan cache issues

Input Parameters


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 (%)
CACHED_SQLS:        Number of currently cached plans
AVG_SIZE_KB:        Average size of a currently cached plan (KB)
EVICT_PER_H:        Number of evictions per hour
EVICT_OVERHEAD_PCT: Response time overhead due to evictions (%)

  • No labels