Estimating Administrative TEMP Space Requirements - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Allocate the TEMP space required by the applications that support your enterprise to user SysAdmin.

Like PERM space, TEMP space is allocated from the available space of the owning user. Make an estimate of temporary space requirements.

With the TEMPORARY=n clause in the CREATE DATABASE and CREATE USER statements, you can specify the number of bytes to allocate to a database or user for creating global temporary tables. Temporary space is reserved before spool space for any user defined to have this attribute.

Disk usage for materialized global temporary tables is charged to the temporary space allocation of the user who referenced the table.

Global temporary tables also require a minimum of 512 bytes from the PERM space of the containing database or user. This space is used for the GTT table header.

If no temporary space is defined for a user, then the space allocated for any global temporary tables referenced by that user is set to the maximum temporary space allocated for the immediate owner.