Administration: Manage Sessions page

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.

ID

The unique internal cache identifier for this entry.

User

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.

Refs

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

Status

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

• Starting — The analysis is starting to run.

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

Time

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.

Action

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.

Last Accessed

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

Statement

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

Information

Usage tracking information (for example, what analysis contained the query).

Records

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