Session Details View | Teradata Unity - Session Details View - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Continuous Availability
Teradata Unity
Release Number
September 2020
English (United States)
Last Update
Product Category
Analytical Ecosystem
The Session Details view contains the following overview for each session.
Field Description
State State of session.
Idle Time Timestamp when session started waiting.
Endpoint name Timestamp when session connected.
Routing Name Name of routing rule.
Error List Name Name of Error List.
Root Blocker Cause of session blocking.
Blocking Any sessions that are blocked by this session.
The Session info for each session includes the connection information.
Field Description
User name User associated with session.
Database Database associated with session.
Client IP Address Location of session.
Client Host Name Location of client host.
Connect Time Timestamp when session connected.
Logon Source User logon location.
The Session Details view also contains Teradata Sessions.
Field Description
Session ID Generated Session identification where the query is running.
System Name System name where the query is running.
State Icon Icon showing state of session.
In State Time query has been in current state.
REQ CPU Number of seconds CPU has been used for query.
Workload Workload where the query is running.
CPU Number of CPU seconds query has used in the last minute.
I/O Number of disk input/outputs the query has performed in the last minute.

The Session Details view contains Locks information.

Field Description
Lock Name Lock name.
Status Status of lock.
Lock Type Type of lock.
Row Hash Row hash associated with session lock.
Lock Mode Lock Modes include the following: Exclusive, Access, Write, and Read.
Lock ID Generated Lock identification.