16.10 - Using Memory Effectively - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

Regardless of the amount of available memory on your system, you need to use it effectively. To determine if your system is using memory effectively:

  1. Start with a value for FSG Cache percent. See Managing FSG Cache.
  2. Adjust the value based on available free memory requirements. See Reserving Additional Free Memory for Applications and About Managing Free Memory.
  3. Consider adjusting other memory-related settings to optimize database function.
    • DBSCacheThr
    • DictionaryCacheSize
    • HTMemAlloc
    • IdCol Batch Size
    • PPICacheThrP
    • RedistBufSize
    • SyncScanCacheThr

For information on how to adjust DBS Control memory settings, see Utilities.