DMV_SESSIONSUM_BYDB

Session summary by database

ROWID

(db_name)

Columns

Name Data Type Description
db_name string(260) Database 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