Managing Requests

Use the information in the Sessions window to manage active requests.

The Sessions window lists active user sessions and requests for the 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 end all requests, end all requests for a user, or end a specific request.

To end requests:

In System View, click
In Enterprise View, right-click an application, and then select Sessions.

The Sessions window displays a list of active sessions and requests. If you have Administrator permissions, the window lists active user sessions for all users on the 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 log off a user or users, under Options, from the Action dropdown, select Log Off, and then do one of the following tasks:
- From Entity, select selected user, and select the user you want to log off. Then click Apply to log the user off.
- From Entity, select all users, and then do one of the following tasks:
  - From Source, select on selected server to log off all users on the selected server. Then click Apply.
  - From Source, select on selected application to log off all users on the selected application. Then click Apply.
  - From Source, select on selected database to log off all users on the selected database. Then click Apply.
- From Entity, select all instances of user, and then do one of the following tasks:
  - From Source, select on selected server, and select the user instances you want to log off. Click Apply to log off all instances of the user from the server.
  - From Source, select on selected application, and select the user instances you want to log off. Click Apply to log off all instances of the user from the application.
  - From Source, select on selected database , and select the user instances you want to log off. Click Apply to log off all instances of the user from the database.
To end a request or requests, under Options, from the Action dropdown, select Kill, and then do one of the following tasks:
- From Entity, select selected request, and select the request you want to end from the list of sessions. Then click Apply to end the selected request.
- From Entity, select all requests, and then do one of the following tasks:
  - From Source, select on selected server to end all requests from all users on the selected server. Then click Apply.
  - From Source, select on selected application to end all requests from all users on the selected application. Then click Apply.
  - From Source, select on selected database to end all requests from all users on the selected database. Then click Apply.
- From Entity, select all requests from user, and then do one of the following tasks:
  - From Source, select on selected server, and select a user's request from the list of sessions. Click Apply to end all requests from this user on the server.
  - From Source, select on selected application, and select a user's request from the list of sessions. Click Apply to end all requests from this user on the application.
  - From Source, select on selected database , and select a user's request from the list of sessions. Click Apply to end all requests from this user on the database.
To display and hide columns, select View and then Columns. Do any of the following:
- Select Show All to display all columns. By default, all columns are displayed except for the Connection Source column.
- Select Manage Columns to move columns between Hidden Columns and Visible Columns lists.
To reorder the columns, select View and then Reorder Columns. In the Reorder Columns dialog, use the up and down arrow keys to reorder the columns as you would like.
To sort the list of sessions by column:
- To sort a column in ascending order, click the column header, or click the Up arrow beside 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, or click the Down arrow beside 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 refresh the list of sessions, click Refresh. For example, if you end a session that shows in process, and then click Refresh, the session list shows that the session is no longer in process.
To export sessions data to a Microsoft Excel spreadsheet, click the Export button, either open or save the file, and click OK.