44.1 Usage Tracking Reports

Usage Tracking Reports are Oracle-supplied reports that are available with Oracle Business Intelligence Publisher (BI Publisher), the primary reporting system that provides a single, Web-based platform for authoring, managing, and delivering interactive reports and all types of highly formatted documents. The procedures detailed in this chapter assume that you have already integrated BI Publisher into Enterprise Manager.

There are two Usage Tracking Reports:

  • Database Usage Tracking Summary Report is a high level summary of the Database Version, Edition, licensable Options and Enterprise Management Pack usage.

    This report can be run and viewed online. The output report can be exported to PDF, RTF, Excel formats.

  • Database Usage Tracking Report provides the above usage data in an exportable (csv) format. The exported data can be sent to Oracle License Management Services for further analysis to determine licensing requirements. Please contact the License Management Services representative at http://www.oracle.com/us/corporate/license-management-services/index.html to initiate an engagement.

    This report cannot be run online and can only be scheduled. A single file for each database instance will be generated each time the report is scheduled to run. The format of the output files is comma separated values (CSV).

Creating Usage Tracking Reports consists of the following high-level tasks:

  1. Setting up Database Usage Tracking credentials. (Required for both Database Usage Tracking Summary Report and Database Usage Tracking Report.)

  2. Enabling the metric collection (via monitoring templates. (Required for both Database Usage Tracking Summary Report and Database Usage Tracking Report.)

  3. Configuring the FTP Server (where reports are to be generated) in BI Publisher. (Not required for the Database Usage Tracking Summary Report.)

  4. Generating the Usage Tracking Reports.