MallocLimit
Purpose
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)
Default
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 Topics
For more information on the Teradata C-library functions, see SQL External Routine Programming.