Display Session
The MaxL display session statement helps you view active login sessions on the current Essbase server, application, or database.
The information this statement displays about active login sessions includes:
-
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
Description of the illustration dispsess.gif
You can display login and request information in the following ways using display session.
Keywords
- 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.
Table 3-3 Display Session: Output Columns
| Column | Description | Example |
|---|---|---|
|
user |
Logged in user name |
powerusr |
|
session |
Numeric session id |
865075202 |
|
login_time |
Number of seconds ago the session began |
192 |
|
application |
Name of active application |
Sample |
|
database |
Name of active database |
Basic |
|
db_connect_time |
Number of seconds ago the database was set active |
11879 |
|
request |
Type of active request in progress; for example, calculation, data load, or restructure. This information can help you get details about what is occurring during lengthy sessions. |
BuildDimXml : Index Only |
|
request_time |
Number of milliseconds the active request has been running |
1503869494621 |
|
connection_source |
Host name of the connected service |
example.com |
|
connection_ip |
IP address of the connected service |
192.0.2.123 |
|
request_state |
The status of the active request |
in_progress |
Example
display session;display session on database sample.basic;