Session Limits | Database Design | Teradata Vantage - Session Limits - Advanced SQL Engine - Teradata Database

Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1093
lifecycle
previous
Product Category
Teradata Vantage™

The session specifications in the following table apply to a single session:

Parameter Value

Maximum number of sessions per PE.

120

Maximum number of sessions per gateway vproc.

See Teradata Vantage™ - Database Utilities , B035-1102 for details.

Tunable: 1 - 2,147,483,647.

1,200 maximum certified.

The default is 600.

Maximum number of active request result spools per session.

16

Maximum number of parallel steps per request.

Parallel steps can be used to process a request submitted within a transaction (which can be either explicit or implicit).

20

Maximum number of materialized global temporary tables that can be materialized simultaneously per session.

2,000

Maximum number of volatile tables that can be instantiated simultaneously per session.

1,000

Maximum number of SQL procedure diagnostic areas that can be active per session.

1