Benchmark Factory for Database 8.1 - User Guide

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.