Chat now with support
Chat with Support

Benchmark Factory for Database 7.6 - User Guide

Getting Started Overview of Benchmark Factory Benchmark Factory Components Agents Connections Create and Edit Tests and Jobs Test Results and Run Reports Troubleshooting Licensing REST API

Oracle Settings

You can use the Oracle page of the Settings dialog to specify default settings for tests run against an Oracle database. Use this page to select the performance collection and reporting method.

Note: If you modify the default settings in the Settings dialog, the changes apply to new jobs only, not to existing jobs.

To specify Oracle settings

  1. Select Edit | Settings. The Settings dialog opens.
  2. Select Oracle. Select default options for collection of Oracle database-wide performance statistics. Review the following for additional information:

    Statspack Options  
    Perform Statspack snapshot during each iteration

    Select to use Oracle’s “Stats Pack” utility to collect statistics.

    • Number of snapshots—Specify the number of snapshots.
    AWR and ADDM Options

     

    Perform AWR snapshot at the start and end of each test iteration

    Select to use the optional Oracle Enterprise Manager (OEM) “Diagnostic Pack” Automatic Workload Repository (AWR) to collect statistics.

    Then select the type of report to generate:

    • Generate AWR report
    • Generate ADDM report
    Perform AWR snapshot during each iteration

    Select to use Oracle AWR to collect statistics.

    • Number of snapshots—Specify the number of snapshots.

    Note: A valid license is required to use the optional Oracle Enterprise Manager (OEM) Diagnostics Pack.

 

Tip: You can also specify performance collection and reporting methods for each Oracle connection. See Oracle Statistics Tab (Connections) for more information.

Related Documents