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;