1. Administering Oracle Analytics Server
  2. Resolve Issues
  3. Track Usage
  4. Set Usage Tracking Parameters

Set Usage Tracking Parameters

To start recording usage information, you must specify connection details for the database you want to use and names for the database tables used to track usage. You set these parameters through the Console (System Settings page).

Note:

In Oracle BI Enterprise Edition 12c, you set options in configuration files to configure usage tracking. If you upgrade from Oracle BI Enterprise Edition 12c to Oracle Analytics Server, usage tracking settings are preserved and usage tracking continues to work but no values are displayed on the System Settings page, that is, they appear blank. You don't have to re-enter your usage tracking details through System Settings but, for clarity, you might decide to do so.

  1. Click Console.
  2. Click System Settings.
  3. Click Usage Tracking.
  4. Enable usage tracking for your system. Ensure Enable Usage Tracking is switched on.
  5. Set the following properties:
    • Usage Tracking Connection Pool

      Name of the connection pool that you created for your usage tracking database in the format, <database name>.<connection pool name>. For example, UsageTracking.UTConnectionPool.

    • Usage Tracking Initialization Block Table

      Name of the database table you want to use to store information about initialization blocks in the format, <database name>.<catalog name>.<schema name>.<table name> or <database name>.<schema name>.<table name>. For example, UsageTracking.UT_Schema.InitBlockInfo.

    • Usage Tracking Physical Query Logging Table

      Name of the database table you want to use to store physical query details in the format, <database name>.<catalog name>.<schema name>.<table name> or <database name>.<schema name>.<table name>. For example, UsageTracking.UT_Schema.PhysicalQueries.

    • Usage Tracking Logical Query Logging Table

      Name of the database table you want to use to store logical query details in the format, <database name>.<catalog name>.<schema name>.<table name> or <database name>.<schema name>.<table name>. For example, UsageTracking.UT_Schema.LogicalQueries.

    • Usage Tracking Max Rows

      Maximum number of rows that you want in the usage tracking tables. Minimum value is 1, maximum is 100,000, and 0 means unlimited. If the row count exceeds the maximum number of rows, then the usage tracking process deletes the excess rows based on the oldest timestamp.

  6. Click Apply.

Oracle Analytics creates the usage tracking tables and starts to log user queries.