Chat now with support
Chat with Support

Benchmark Factory for Database 8.1 - User Guide

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

Oracle Settings

You can use the Oracle page of the Settings dialog to specify default settings for testing against an Oracle database. Use this page to select the performance collection and reporting methods and the data cache clearing options.

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 | Oracle.
  2. 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.

    Database Flush  
    Flush data buffer caches at start of each test iteration

    Select to clear data buffer caches between iterations.

    Note: To perform this action, the Oracle database account must have certain privileges. In Oracle 10g or later, the ALTER SYSTEM privilege is required.

    Flush shared pool at start of each test iteration

    Select to clear shared pool between iterations.

    Note: To perform this action, the Oracle database account must have the ALTER SYSTEM privilege.

    Note: Cached data can improve performance, so selecting one or both of these options can prevent cached data from affecting subsequent iterations.

 

Tip: You can specify these same Oracle settings for each individual Oracle connection. See Create Oracle Connection and Oracle Statistics Tab (Connections) for more information.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating