The Sessions window lists active user sessions for an Essbase Server, application, or database. A user can have more than one session open at any given time. For example, one user may have open sessions on two databases.
If you have Administrator or Application Manager permissions, you can disconnect a user session or terminate a specific request made during a session.
To view active user sessions for an Essbase Server:
From Enterprise View or a custom view, select an Essbase Server.
Right-click and select Edit, then Sessions.
The Sessions window displays a list of active sessions. If you have Administrator permissions, the window lists active user sessions for all users on the Essbase Server. If you have Application Manager permissions, the window lists active sessions for all users, including yourself, who are connected to any application for which you have Application Manager permissions.
To sort the list of sessions by column:
To sort a column in ascending order, click the column header.
For example, to sort the User column in alphabetical order, click the column header.
To sort a column in descending order, press Shift and click the column header.
For example, to sort the Login Time column so that the longest login time appears first in the list, press Shift and click the column header.
To manage sessions from the Sessions window, see Disconnecting User Sessions and Requests.
display session (MaxL) in the Oracle Essbase Technical Reference
alter system (MaxL) in the Oracle Essbase Technical Reference