Benchmark Factory for Database 9.0 - User Guide

Configure RAC Load Testing

Oracle uses clustering to allow one database to span multiple resources. Benchmark Factory can simulate user activity on these systems.

Performing Oracle RAC testing in Benchmark Factory requires the following steps:

• Setting up the tnsnames.ora file
• Creating the Benchmark Factory cluster profile

Setting up the tnsnames.ora file

1. Navigate to the tnsnames.ora file located in the Oracle directory. Transparent Network Substrate (TNS) is Oracle's networking architecture. TNS provides a standard application interface that enables network applications to transparently access underlying network protocols.  
2. Open the file in a text editor. Edit the tnsnames.ora file to set up clustering connections.
   1. For the first entry, the Net Service Name (in this example MyTNS) is used to define the root Net Service Name. The root Net Service Name is not used when running a test.

   2. The remaining Net Service Names must be named with the root and a number. In this example, MyTNS is the root and MyTNS1, MyTNS2, and MyTNS3 will be used when the test is run. The "MyTNS" and "MyTNS1" connections are duplicates and are required for Benchmark Factory to perform load testing. “MyTNS2” and “MyTNS3” are for the other two machines in the cluster.

      The following provides an example of a tnsnames.ora file set up for a three node cluster.

               

Creating the Benchmark Factory clustering connection

1. Click New Connection in the main toolbar.
2. Select Oracle from the drop-down list.

3. Enter the connection information. See Create Oracle Connection for more information.

   Note: The Net Service Name reflects the same entry as the first entry in the tnsnames.ora file.

4. After entering the connection information, select the Clustering tab.
5. Select the Enable Clustering checkbox. The number of default nodes displayed is 2.
6. Enter the desired number of nodes in the Number of Nodes. For this example, we have 3 nodes. The following provides the mapping structure from the Benchmark Factory nodes to the tnsnames.ora file.
   • Node 1 = MyTNS1
   • Node 2 = MyTNS2
   • Node 3 = MyTNS3
7. Next, you need to set up the percentage of users that will hit a particular node. Click inside the Percentage Column for each node and enter the desired percentage of users that will hit that particular node.
8. Click OK to save your changes. The Oracle RAC Clustering has been set up and is ready to run.

Related Topics

Create Oracle Connection

Create and Edit Tests and Jobs

Jobs View Pane

The Jobs View pane displays the list of jobs. After you create and save a job, the job is displayed in the Jobs View pane. You can also use the Jobs View pane to identify the jobs that are currently running and the jobs that are scheduled to run.

Use the Jobs View pane to do the following:

• Run a job
• View job status
• View real-time test results
• Edit a job

Run and Edit Jobs

To run a job

• Select the job in the Jobs View pane and click .

To edit an existing job

• To edit an existing job, select the job in the Jobs View pane and click . The Edit Job Wizard opens. To learn more about the Job Wizard, see The Job Wizards.

Test Results

To view test results

• To view a job's test results, select a job in the Jobs View pane. Test results display in the right pane. See Benchmark Factory Console for an overview of the Benchmark Factory console.
• To compare two or more run results for a test, select the Compare Results tab. Use Ctrl+click to select multiple test runs. A comparison of the results for the various runs displays.

Job Status

From the Jobs View pane, you can view job status.

The following job states are identified:

• Scheduled: All jobs currently waiting to run or scheduled to run at a future time.
• Running: Job currently running.
• Completed: All completed jobs.

Jobs View Toolbar

The Jobs View toolbar provides user functionality to save or delete jobs.

	Move the selected test up in the list.
	Move the selected test down in the list.
	Delete the selected item from the Jobs View.
	Toggles tree-view on and off.

Note: To save a job as a Benchmark Factory script, select the job and click Save in the Benchmark Factory toolbar or select File | Save.

Job Wizards

The Job Wizards allow you to create a new job or edit an existing job. The New Job Wizard and the Edit Job Wizard are similar and provide nearly the same functionality.

New Job Wizard

• To create a new job, click in the main toolbar, or select File | New. The New Job Wizard opens.

The New Job Wizard allows you to select a database to test and then define a workload. After specifying options for the workload and selecting an agent (agents), you can save the job, run the job, or schedule the job. See Quickstart: Create a New Job for more information.

Your saved jobs are displayed in the Jobs View pane. See Jobs View for more information.

Edit Job Wizard

• To edit an existing job, select the job in the Jobs View pane and then click , or right-click the job and select Edit Job. The Edit Job Wizard opens.

The Edit Job Wizard allows you to edit an existing job. Use this wizard to modify test options, for example, to add or delete transactions, modify the user load for the test, change the benchmark scale factor, or change transaction latency.

To learn how to modify a specific test option, see the instructions for creating that type of test. For example, see one of the following:

• Quickstart: Create a New Job
• Create Industry Standard Benchmark Test
• Capture and Replay Oracle Workload
• Capture and Replay SQL Server Workload
• Create Mix Test
• Create SQL Scalability Test