Session Limits | Database Design | Teradata Vantage - Session Limits - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
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