DMV_SESSIONSUM_BYLOGIN

Session summary by login name

ROWID

(login_name)

Columns

Name Data Type Description
login_name string(260) Login name
session_count long Number of sessions
active_session_count long Number of sessions in the running state
xact_count long Number of open transactions over all sessions
inactive_xact_count long Number of open transactions over all inactive sessions
memory_bytes double Memory usage, in bytes, over all sessions

Requirements

Attributes: DMV
Minimum database version: 11.0