Benchmark Factory for Database 9.0 - User Guide

Import from Dell Tools Export File

You can create a workload (or add to an existing workload) by importing a file exported by another Quest Software tool.

To import a file exported by another Quest Software tool

1. In the New Job or Edit Job Wizard, click Workload in the left pane.
2. On the workload page, select Capture / Replay Test from the drop-down list.
3. Then select Import from Quest Tools Export File.
4. Click the Import Test button.
5. Browse to and select a file to import. Click Finish.
6. The test is added to the workload and the test Summary page displays.
7. On the Summary page, you can click each of the links to go directly to an option to modify it.

8. 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. See Transactions Tab for more information.
   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.

9. 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.

Capture Oracle Workload - Privileges

To capture an Oracle workload when you are creating a Capture/Replay Oracle Workload test, you must have the required privileges. The required privileges depend on the capture method you select (Oracle Trace Files or FGAC) and on the Oracle database version.

When you attempt to capture an Oracle workload and the account you are using does not have the necessary privileges, Benchmark Factory alerts you and allows you to grant the privileges using a DBA account. Benchmark Factory will create the script to grant the missing privileges. You can review the script from the Apply Privileges page.

To view missing privileges required for Oracle capture

1. When creating a Capture/Replay Oracle Workload test, select a capture method in the Select the Capture Method page. Select one of the following:
   • Capture using Oracle Trace files
   • Capture using Fine-Grained Access
2. If your account does not have the required privileges to do the capture, the Apply Privileges page opens.
3. Enter the credentials of a DBA-type user account that can apply the necessary privileges.

4. To view the missing privileges, click the View/Save Script button. The script to grant the missing (but required) privileges displays.

   

   Example: For a user with minimum privileges attempting a capture on an Oracle 10g database, Benchmark Factory might generate a script similar to the following:

   GRANT SELECT ANY DICTIONARY TO BMF;

   GRANT SELECT ANY TABLE TO BMF;

   GRANT CREATE ANY DIRECTORY TO BMF;

   GRANT DROP ANY DIRECTORY TO BMF;

   GRANT CREATE PUBLIC SYNONYM TO BMF;

   GRANT DROP PUBLIC SYNONYM TO BMF;

   GRANT EXECUTE ON SYS.DBMS_FGA TO BMF;

   GRANT EXECUTE ON SYS.DBMS_SHARED_POOL TO BMF;

   GRANT MERGE ANY VIEW TO BMF;

   GRANT EXECUTE ON SYS.DBMS_CRYPTO TO BMF;

   GRANT EXECUTE ANY PROCEDURE TO BMF;

   GRANT CREATE ANY JOB TO BMF;

   GRANT EXPORT FULL DATABASE TO BMF;

   GRANT IMPORT FULL DATABASE TO BMF;

   GRANT CREATE EXTERNAL JOB TO BMF;

   GRANT CREATE ANY TABLE TO BMF;

   GRANT CREATE SESSION TO BMF;

   GRANT CREATE TABLE TO BMF;

   GRANT CREATE PROCEDURE TO BMF;

   GRANT UNLIMITED TABLESPACE TO BMF;

   GRANT EXP_FULL_DATABASE TO BMF;

   GRANT IMP_FULL_DATABASE TO BMF;

   --Use DBA privilege to apply this grant

   GRANT EXECUTE ON SYS.DBMS_WORKLOAD_REPOSITORY TO BMF;

   --Use DBA privilege to apply this grant

   GRANT EXECUTE ON SYS.UTL_FILE TO BMF;

   ALTER USER BMF DEFAULT ROLE EXP_FULL_DATABASE, IMP_FULL_DATABASE

Related Topics

Capture and Replay Oracle Workload

Artificial Test for Desired Effect

Create Artificial Test for Desired Effects

Benchmark Factory allows you to design a workload based on a mixture of one of the following:

• Industry standard benchmarks
• Database application types (transaction/process types)
• Database transactions (SQL statement types)
• Hardware stressing focal points (database resources)

To create an artificial test for desired effect

1. In the New Job or Edit Job Wizard, click Workload in the left pane.
2. On the workload page, select Artificial Test for Desired Effect from the drop-down list.
3. Select one of the following test types:
   • Based on user selection of one or more industry standard benchmarks—Design a workload by specifying the percentages of industry standard benchmark (TPC-C, TPC-H, TPC-E, etc.) to use for the workload.
   • Based on user selection of one or more database application mixtures—Design a workload based on a mixture of OLTP and Data Warehouse type transactions, specified as percentages.
   • Based on user selection of one or more database transactional mixtures—Design a workload based on a mixture of SELECT, INSERT, UPDATE, and DELETE SQL statements, specified as percentages.
   • Based on user selection of one or more hardware stressing focal points—Design a workload by specifying the percentages of transactions that stress CPU, Memory, Disk IO, and Network.
4. Click the Select Test button at the bottom of the page.
5. Specify a weight and benchmark scale factor for each benchmark, transaction type, SQL type, or database resource.
6. Click Add Test.

7. The tests are added to the workload and the workload Summary page opens.

   • On the Summary page, you can click each of the links to go directly to an option to modify it.

8. You can also select the Test Options tab. Each test/step in the workload may have a different set of options available in its Test Options tab. See the following for more information.

   • Transactions Tab
   • Specify User Load
   • Timing Tab
   • Advanced Tab
   • Benchmark Scale Factor
   • Options Tab (Create Objects Step)
   • Customize SQL for Creating Objects

9. 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.

Related Topics

Artificial Test for Desired Effect - Weights/Percentages