15.00 - MallocLimit - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

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.