16.10 - Using Memory Effectively - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
Release Date
April 2018
Content Type
Publication ID
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.