AMPs use a DBQL cache called DBQL Performance Stats (DPS) cache. This cache holds DBQL request and step data for active requests. The default size of the DPS cache is 8192 KB.
The default size of the DPS cache is 8192 KB.
The cache size range is 1024 KB - 16384 KB. The cache holds approximately 2,500 entries per 1024 KB. When the cache is full, DBQL AMP data is not captured. Space in the cache is dynamically reused, but the memory for the cache is not released until the database is restarted. The recommended range is 4096 KB - 10240 KB.
You rarely have to adjust these values because the default value of 8192 is optimal for DBQL data collection to handle all types of workload.