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
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.
|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 9i, the ALTER SESSION privilege is required. 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.