DictionaryCacheSegmentSize - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

Sets the memory segment size used for the 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 database restart.

Related Information

For more information on… See…
DictionaryCacheSize DictionaryCacheSize.