Bookshelf v10.1.3.2: Server Session Management

Server Session Management

The Session Manager is used in online mode to monitor activity. The Session Manager shows all users logged into the session, all current query requests for each user, and variables and their values for a selected session. Additionally, the Oracle BI Administrator can disconnect any users and kill any query requests with the Session Manager.

How often the Session Manager data refreshes depends on the amount of activity on the system. To refresh the display at any time, click Refresh.

Using the Session Manager

The Session Manager contains an upper and a lower pane:

The top window, the Session window, shows users currently logged into the Oracle BI Server. To control the update speed, from the Update Speed drop-down list, choose Normal, High, or Low. Select Pause to keep the display from being refreshed.

The bottom window contains two tabs.

The Request tab shows active query requests for the user selected in the Session window.
The Variables tab shows variables and their values for a selected session. You can click the column headers to sort the data.
NOTE: Only 7.7 Oracle BI Server return information about variables. If the Administration Tool connects to an older-version server online, only the Requests tab will be visible in the Session Manager dialog box.

Table 25 and Table 26 describe the columns in the Session Manager windows.

Table 25. Fields in the Session Window
Column Name	Description
Client Type	The type of client connected to the server.
Last Active Time	The timestamp of the last activity on the session.
Logon Time	The timestamp that shows when the session initially connected to the Oracle BI Server.
Repository	The logical name of the repository to which the session is connected.
Session ID	The unique internal identifier that the Oracle BI Server assigns each session when the session is initiated.
User	The name of the user connected.

Table 26. Some Fields in the Request Tab
Column Name	Description
Last Active Time	The timestamp of the last activity on the query.
Request ID	The unique internal identifier that the Oracle BI Server assigns each query when the query is initiated.
Session ID	The unique internal identifier that the Oracle BI Server assigns each session when the session is initiated.
Start Time	The time of the individual query request.

To view the variables for a session

In the Administration Tool, open a repository in online mode and choose Manage > Sessions.

Select a session and click the Variables tab.

For more information about variables, refer to Using Variables in the Oracle BI Repository.

To refresh the view, click Refresh.

To close Session Manager, click close.

To disconnect a user from a session

In the Administration Tool, open a repository in online mode and choose Manage > Sessions.

Select the user in the Session Manager top window.

Click Disconnect.

The user session receives a message indicating that the session was terminated by the Oracle BI Administrator. Any currently running queries are immediately terminated, and any outstanding queries to underlying databases are canceled.

To close Session Manager, click close.

To kill an active query

In the Administration Tool, open a repository in online mode and choose Manage > Sessions.

Select the user session that initiated the query in the top window of the Session Manager.

After the user is highlighted, any active query requests from that user are displayed in the bottom window.

Select the request you want to kill.

Click Kill Request to terminate the highlighted request.

The user receives a message indicating that the query was terminated by the Oracle BI Administrator. The query is immediately terminated, and any outstanding queries to underlying databases are canceled.

Repeat this process to kill any other requests.

To close Session Manager, click close.