Display Session

View active login sessions on the current server, application, or database, including:

The user that owns each session
A session ID for each session
How long the sessions have been active
Information about outstanding requests (description, time started, name of computer originating the request, and status).

Syntax

You can display login and request information in the following ways using display session.

Keyword	Description
all	Display information about all current user sessions and active requests.
<session-id>	Display information about a particular user session, indicated by the numeric session ID.
by user	Display information about all current sessions by a particular user.
by user on application	Display information about all current sessions by a particular user on the specified application.
by user on database	Display information about all current sessions by a particular user on the specified database.
on application	Display information about all current sessions on the specified application.
on database	Display information about all current sessions on the specified database.

Example

display session;
display session on database sample.basic;