Monitoring Users and Activity Logs

You can see information about any users who are currently signed to your service and troubleshoot report queries from the Manage Session page.

Topics:

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

  1. Click Console.
  2. Click Sessions and Query Cache.

    The Sessions section at the top of the page shows how many users are currently signed in (Total Number of Sessions).

    The table provides details about the users who are signed in:

    Field Description

    User ID

    The name that the user entered when they signed in.

    Session ID

    A unique identifier assigned by Oracle BI Cloud Service 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.

  3. To monitor a particular user, select Filter Cursors by Session.

    Information for this user displays in the Cursor Cache table. See Analyzing SQL Queries and Logs.

    Click Clear Filter to show information for all users.

  4. To change how messages are logged for a particular user, select a Log Level from the list.

    By default, logging is disabled.

Analyzing SQL Queries and Logs

Administrators can examine the underlying SQL query requests that are executed as people use the service.

  1. Click Console.
  2. Click Sessions and Query Cache.

    The Cursor Cache section enables you to monitor and troubleshoot activity logs for users currently signed in to the service.

    Field Description

    ID

    A unique internal identifier that is assigned to each entry.

    User

    The name of the user who ran the analysis and last placed it into the cache.

    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.

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

    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

    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.

    Last Accessed

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

    Statement

    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.

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

  3. Optionally, click Close All Cursors to removes information in the Cursor Cache table.
  4. Optionally, click Cancel Running Requests to cancel all requests that are running for analyses.