Determines the amount of cache (in megabytes) allocated for DBQL Data Dictionary tables that have LOB columns. This field also determines the size of the express message used to flush this cache.
2 through 16 MB
Changes Take Effect
After the next Teradata Database restart.
Increasing the cache size allows larger requests to be captured by DBQL, and reduces the number of cache flushes. However, it will increase the express request message size when flushing the cache.
|For more information on…||See…|
|BEGIN QUERY LOGGING, END QUERY LOGGING, and FLUSH QUERY LOGGING statements||SQL Data Definition Language.|
|tracking processing behavior with the DBQL||Database Administration.|