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
Select Oracle. Select default options for collection of Oracle database-wide performance statistics. Review the following for additional information:
|Perform Statspack snapshot during each iteration||
Select to use Oracle’s “Stats Pack” utility to collect statistics.
|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:
|Perform AWR snapshot during each iteration||
Select to use Oracle AWR to collect statistics.
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.