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, and it writes statistics to a usage tracking log file or inserts them 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:
- Open the repository in online mode.
- Import the S_NQ_ACCT and the S_NQ_DB_ACCT table from the RCU schema.
- In the NQSConfig.INI file, set
USAGE_TRACKING=YES and update the PHYSICAL_TABLE_NAME and the CONNECTION_POOL.
- Import the following tables to track query statistics related to the initialization block execution and the summary advisor feature:
- S_NQ_INITBLOCK
- S_NQ_SUMMARY_ADVISOR
- To enable initialization block logging, update the
INIT_BLOCK_TABLE_NAMEand INIT_BLOCK_CONNECTION_POOL in the NQSConfig.INI file.
- To enable summary advisor logging, set
SUMMARY_STATISTICS_LOGGING=YES and update the SUMMARY_ADVISOR_TABLE_NAME in the NQSConfig.INI file.
- 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.
