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 (Advanced System Settings page).

1. Sign in to your service.
2. Click Console.
3. Click Advanced System Settings.
4. Click Usage Tracking.
5. Enable usage tracking for your system. Ensure Enable Usage Tracking is switched on.
6. 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.

7. Click Apply.

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