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

Teradata Vantageā„¢ - Database Design

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
User Guide
Publication ID
B035-1094-171K
Language
English (United States)

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