The Sessions window lists active user sessions for an Essbase Server, application, or database. To view or disconnect sessions or to terminate requests made during sessions, you must have Administrator permissions for Essbase Server or Application Manager permissions for the application. You can view and terminate sessions or requests only for users with permissions equal to or lower than your own.
A session is the time between login and logout for a user connected to Essbase Server at the server, application, or database level. A user can have more than one session open at any time. For example, a user may be logged in to different databases. If you have appropriate permissions, you can log off sessions based on any criteria that you choose; for example, you can log off a user from all databases or from one database.
A request is a query sent to Essbase Server by a user or by another process. For example, a default calculation of a database and a restructuring of the database outline are requests. A session can process only one request at a time. If a user loses connection with an Essbase Server during a request (such as a calculation), the abandoned request may cause the application to stop responding to further requests. You can terminate the abandoned request without disconnecting the user. The user can continue the session and issue new requests. When terminating a request, Essbase allows the request to process to a point at which it is safe to terminate.
To disconnect a session or terminate a request:
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 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.
From the drop-down lists, select one or more user sessions from the grid to disconnect users or terminate requests.
To view a table that lists the combinations available to you as you select options, see Sessions and Request Termination Options. The log off options are for terminating a user session. The kill options are for terminating specific requests within a session, without logging the user off the entire session.
Click Apply to execute the operations indicated by your selections.
To update your view with current session and request activity, click Refresh.
Note: | To terminate your own current request, click Cancel. |
display session (MaxL) in the Oracle Essbase Technical Reference
alter system (MaxL) in the Oracle Essbase Technical Reference
logoutuser (ESSCMD) in the Oracle Essbase Technical Reference
logoutuser (Essbase Agent) in the Oracle Essbase Technical Reference