Benchmark Factory allows you to import SQL from Oracle Dynamic Performance Views. This allows you to import SQL transactions identified by the Oracle for further testing under a load.
The resulting workload is a mixed workload containing either the most-often executed, the most time-consuming, or the most-recently executed SQL transactions.
To import from the Oracle Dynamic Performance Views
Deselect the Include system activity (SYS USER) option to exclude system activity.
Note: It is not recommended to include system activity. Including it imports Oracle SQL statements routinely run by Oracle for maintenance reasons, and is not required for the load testing process.
Or you can select the Test Options tab to modify all test options. Review the following for additional information:
Tab | Description |
---|---|
Transactions tab |
Modify the transactions and the transaction mix for the test. |
User Load tab | Modify the number of users per test iteration. See Specify User Load for more information. |
Timing tab | Specify sampling, pre-sampling, and user start-up times for the test. See Timing Tab for more information. |
Advanced tab |
Specify Repository options, error handling, and database checkpoints for the test. You can also specify a file to execute at the beginning or end of each iteration. See Advanced Tab for more information. |
After specifying options for this test, you can add another test to the job, configure job setup options, save and close the job, run the job, or schedule the job. For more information about each of these steps, see Quickstart: Create a New Job.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center