3.4 Configuring Usage Tracking

The Oracle BI Server supports the collection of usage tracking data. When usage tracking is enabled, the BI Server collects usage tracking data for each query. The statistics are then written to a usage tracking log file or are inserted directly in to a database table. After you complete migrating and configuring the 12c system, you must enable usage tracking in the NQSConfig.INI file.

To configure usage tracking:
  1. Open the repository in online mode.
  2. Import the S_NQ_ACCT and the S_NQ_DB_ACCT table from the RCU schema.
  3. In the NQSConfig.INI file, set USAGE_TRACKING=YES and update the PHYSICAL_TABLE_NAME and the CONNECTION_POOL.
  4. Import the following tables to track query statistics related to the initialization block execution and the summary advisor feature:
  5. To enable initialization block logging, update the INIT_BLOCK_TABLE_NAMEand INIT_BLOCK_CONNECTION_POOL in the NQSConfig.INI file.
  6. To enable summary advisor logging, set SUMMARY_STATISTICS_LOGGING=YES and update the SUMMARY_ADVISOR_TABLE_NAME in the NQSConfig.INI file.
  7. Restart the BI Server.
For more information about usage tracking, see Managing Usage Tracking in System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.


Ensure that the queries of the BI Server are being tracked in the table by view data.