15.00 - DictionaryCacheSize - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

DictionaryCacheSize

Purpose  

Defines the size in kilobytes of the dictionary cache for each PE on the system.

Field Group

Performance

Valid Range

64 KB through 32768 KB

Note: If the value of “DictionaryCacheSegmentSize” is 0, or “NoDot0Backdown” is FALSE, the value of DictionaryCacheSize should not exceed 16384 KB.

Default

3072 KB on SLES 10 systems

8192 KB on SLES 11 systems

Changes Take Effect

After the next Teradata Database restart.

Usage Notes  

The value of DictionaryCacheSize should be a multiple of the value of “DictionaryCacheSegmentSize”.

Performance Implications

The default value allows more caching of table header information and reduces the number of I/Os required. It is especially effective for workloads that access many tables (more than 200) and for those that generate many dictionary seeks.

Increase the size of the dictionary cache to allow the parser to cache additional data dictionary and table header information.

For tactical and Online Complex Processing (OLCP) type workloads, maintaining a consistently short, few-second response time is important. These workloads may benefit from a larger dictionary cache, particularly when their query plans have not been cached in the request cache. A larger dictionary cache will allow more dictionary detail, needed for parsing and optimizing, to remain in memory for a longer period of time. For query workloads with a response time of more than one minute, there may be no measurable difference when this field is set to a higher value.

Related Topics

 

For more information on…

See…

DictionaryCacheSegmentSize

“DictionaryCacheSegmentSize” on page 304.

NoDot0Backdown

“NoDot0Backdown” on page 396.