You use the Sessions window to view and manage user sessions and user requests for anEssbase Server instance, an application, or a database.
If you have Administrator permissions, the window displays information for all users. If you have Application Manager permissions, the window displays information for all users who are connected to the applications for which you have Application Manager permissions.
You can modify the window:
To move a column, drag it to another location.
To resize a column, drag the boundary of the column heading.
For users with permissions equal to or lower than your own, you can disconnect active sessions from Essbase Server and terminate requests.
In the First box, you select “Log off” or Kill:
If you select “Log off,” the user is disconnected from the specified object, and the session is terminated. Other sessions running for the user and sessions running for other users are unaffected.
If you select Kill, the user remains connected to Essbase Server, but, when a safe termination point is reached, the users's request is terminated. The user can continue the session and issue a new request.
The options available in the Second and Third boxes vary, depending on whether you selected “Log off” or Kill. For a list of all possible ways to use the “Log off” and Kill options, see Session and Request Termination Options.
The following columns display various kinds of information:
User—All users currently connected to Essbase Server. If you are not an administrator, only users connected to applications for which you have Application Manager permissions are listed.
Session—Session ID
Login Time—How long (in hours:minutes:seconds) each user has been connected toEssbase Server
Application—Name of each application that each user is accessing. For users who are connected to the server but who have not started an application, no application name is displayed. Once an application name is displayed, it remains displayed until the application is explicitly shut down.
Database—Name of the database that each user is accessing. For users who are connected to the server but who have not started a database, no database name is displayed. Once a database name is displayed, it remains displayed until the database is explicitly shut down.
Db Connect Time—How long (in hours:minutes:seconds) each user has been connected to the database that is specified in the Application/Database column
Request—Type of request made by the user; for example, a calculation, database restructure, dimension build, or query.
Request Time—How long (in hours:minutes:seconds) the request has been processing.
Request State—Whether the request is in progress, terminating, or terminated
Connection Source—Name of the user's computer.
Connection Ip—IP address of the user's computer
To terminate a session that is processing a request, as indicated in the Request column, select the Use Force option.
To disconnect the selected session or request, click Apply.
display session (MaxL) in the Oracle Essbase Technical Reference
alter system (MaxL) in the Oracle Essbase Technical Reference