Server Session Management in OBIEE

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.

 To open session manager go to Administrator Tool -> Manage -> Session.

The Session Manager contains an upper and a lower pane :

1. 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. 

In my case, two users were logged in, so Session window showing two users with different Session IDs.

2. 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.

  The Oracle BI Administrator can disconnect any users and kill any query requests with the Session Manager.

Find more info about disconnect Users on http://jaga-obiee.blogspot.in/2012/02/disconnect-user-from-session.html

Find more info about Kill Activwe Query  on http://jaga-obiee.blogspot.in/2012/02/obiee-kill-active-query.html

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.

 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.