15.00 - Session Limits - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Session Limits

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 Utilities for details.

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

1,200 maximum certified.

The default is 600.

Maximum number of active request result spool files 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 channels required for various parallel step operations.

The value per request is determined as follows:

 

  • Primary index request with an equality constraint.
  • 0 channels

  • Requests that do not involve row distribution.
  • 2 channels

  • Requests that involves redistribution of rows to other AMPs, such as a join or an INSERT … SELECT operation.
  • 4 channels

    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 stored procedure Diagnostic Areas that can be active per session.

    1