You can see information about any users who are currently signed to your service and troubleshoot report queries from the Manage Session page.
Monitor Users Who Are Signed In
You can see how many users are signed in to your service and view detailed information about each user from the Manage Session page.
- User ID: Name that the user entered when they signed in.
- Session ID: Unique identifier assigned to the user for each user session.
- Browser Info: Information about the browser used to sign in.
- Logged On: Time when the user signed in.
- Last Access: Time stamp for the last activity for this user. This can be any kind of activity, such as switching from one page to another.
- Click Console.
- Click Session and Query Cache.
- Locate the Sessions sections.
The Sessions section at the top of the page shows how many users are currently signed in (Total Number of Sessions) and detailed information about these users.
- To monitor a particular user, select Filter Cursors by Session.
Information for this user displays in the Cursor Cache table.
Click Clear Filter to show information for all users.
- To change how messages are logged for a particular user, select a Log Level from the list.
By default, logging is disabled.
Analyze SQL Queries and Logs
Administrators can examine the underlying SQL query requests that are executed as people use the service.
- Click Console.
- Click Sessions and Query Cache.
- Locate the Cursor Cache section.
The Cursor Cache section enables you to monitor and troubleshoot activity logs for users currently signed in to the service.
A unique internal identifier that is assigned to each entry.
The name of the user who ran the analysis and last placed it into the cache.
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 data to be returned 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 occurred 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.
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 log of a query executed for this analysis.
Diagnostic — Displays an HTML page of diagnostic information that you can share with Oracle Customer Support.
The time stamp of the last time the cache entry for this analysis was used to satisfy an analysis.
The logical 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, what analysis contained the query).
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).
- Optionally, click Close All Cursors to removes information in the Cursor Cache table.
- Optionally, click Cancel Running Requests to cancel all requests that are running for analyses.