DictionaryCacheSegmentSize - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynh1604715438919.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

Sets the memory segment size used for the Teradata Database Data Dictionary cache in multiples of 64 KB.

Field Group

Performance

Valid Range

0 and 1 through 256 (representing 64 KB through 16 MB)

Setting this field to 0 means to use the Teradata default value.

Default

64 (representing 4 MB)

Changes Take Effect

After the next Teradata Database restart.

Related Topics

For more information on… See…
DictionaryCacheSize DictionaryCacheSize.