16.10 - DBQLLOBCacheSize - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

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.

Teradata recommends leaving this field set to the default value.

Field Group

Performance

Valid Range

2 through 16 MB

Default

2 MB

Changes Take Effect

After the next Teradata Database restart.

Usage Notes

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.

Related Topics

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.