17.10 - MallocLimit - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

Specifies the upper limit (in bytes) on the amount of memory that an external routine (UDF, UDM, or external stored procedure) can allocate using the Teradata C library function FNC_malloc.

Valid Range

0 to 18446744073709551615 bytes (hex FFFF FFFF FFFF FFFF)


33554432 bytes (32MB)

Usage Notes

For performance reasons, a function should allocate only as much memory as absolutely required. UDFs execute in parallel on the database. An all-AMP query that includes a UDF which allocates 10MB of memory can use up to 1GB for all instances on a 100 AMP system for just the one transaction.

Related Information

For more information on the Teradata C-library functions, see Teradata Vantage™ - SQL External Routine Programming, B035-1147.