Skip Headers
Oracle® Business Intelligence Enterprise Edition Help
11g Release 1 (11.1.1)
  Go To Table Of Contents

Administration: Manage Sessions page

Use this page to view information about active sessions and about the cache for each analysis. See System Administrator's Guide for Oracle Business Intelligence Enterprise Edition for information on active sessions.


Sessions area

Displays the total number of active sessions. Also displays a table that includes the following information about sessions that have been created for users who have logged in:

Field Description

User ID

The name that the user entered when logging in.

Host Address

The name or IP address of the computer that initiated the HTTP connection to the Web server. This could be a user's PC, a handheld device, a firewall, and so on.

Session ID

A unique identifier assigned by Presentation Services for each client session.

Browser Info

Information about the browser from which the user logged on.

Logged On

The time stamp on which the user logged on.

Last Access

The time stamp of the last activity for this user on Presentation Services. This can be any kind of activity on the system, such as switching from one dashboard page to another.

Filter Cursors by Session

Select the option in the row for the session by which you want to filter the Cursor Cache table. The Cursor Cache table shows only cursors related to that session and that user.

Log Level

Select the level for logging messages for each session. By default, logging is disabled for each session.

Clear Filter

Use this button to remove any filters that you enabled in the Filter Cursors by Session field.

Cursor Cache area

Displays a table that includes the following information about each analysis:

Field Description


The unique internal cache identifier for this entry.


The name of the user who ran the analysis and last placed it into the cache. If two IDs are shown, then the second ID is impersonating the first. For example, the entry lhurley/administrator means that the Administrator account logged on and impersonated lhurley. This can happen when Oracle BI Scheduler starts an agent on someone's behalf. Oracle BI Scheduler logs on and impersonates that user so security and content filters still apply.


The number of references to this entry since it was placed into the cache.


The status of the analysis that is using this cache entry:

  • Starting — The analysis is starting to run.

  • Waiting on Parent — A view in the analysis is waiting for the BI Server to finish returning the data for the query.

  • Running — The analysis is currently running.

  • Finished — The analysis has finished.

  • Queued — The system is waiting for a thread to become available so the analysis can be processed.

  • Canceling — The application is in the process of canceling the analysis.

  • Error — An error was encountered during the processing or running of the analysis. Look in the Statement column for information about the error.


The time taken to process and run the analysis, displayed in one-second increments. A value of 0s (zero seconds) indicates that the analysis took under 1 second to complete.


The following links that you can click to affect the analysis:

  • Cancel — Terminates the analysis. Is displayed for in-progress analyses. The user running the analysis receives an informational message indicating that the analysis was canceled by an administrator.

  • Close — Clears the cache entry associated with this analysis. Is displayed for completed analyses.

  • View Log — Displays the entry in the nQQuery.log file for this analysis (if logging is turned on for this user). This file logs query activity on the system at the individual user level.

    Query logging is turned off by default. It can be enabled for individual users at different logging levels. The administrator can use the Identity Manager to enable logging for a user.

    You can also view the nQQuery.log file (located by default in the Log directory in the Oracle Business Intelligence installation directory) using a text editor such as Windows Notepad. The administrator determines the maximum size of the nQQuery.log file by setting the USER_LOG_FILE_SIZE parameter in the NQSConfig.INI file.

  • Diagnostic — Displays an HTML page of diagnostic information that you can share with Oracle Customer Support.

Last Accessed

The time stamp of the last time the cache entry for this analysis was used to satisfy an analysis.


The SQL statement that was issued for the analysis; or if the analysis resulted in an error, information about the nature of the error.


Usage tracking information (for example, the name of the analysis that contains the query). Even if the Oracle BI system has been localized, catalog object names are displayed using the raw catalog path (for example, /shared/TeamA/brand_analysis).


The number of records in the result set that have been seen (for example, 50+ to indicate that 50 records have been seen but there are additional records to be fetched or 75 to indicate that 75 records have been seen and there are no more records to be fetched).


Use this button to export the entries in the table to a CSV file that you can store on a computer and share with others.

Cancel Running Requests

Use this button to cancel all requests that are running for analyses.

Close All Cursors

Use this button to close all cursors, which removes all information in the Cursor Cache table.

Sort By

Select the appropriate value to sort the entries by creation time, last accessed time, or user name. Sort the entries to find the ones in which you are interested more quickly.


Use the arrow button beside each column heading to sort the table by that value.