Friday, March 18, 2011

Running the Hammerora TPC-C workload for Oracle 11gR2

After the completing of the creation of the schema, we will see a screen similar to below.



Next click on the "clear screen button" and the "Destroy virtual users" button. This will create an empty screen under the Script Editor tab, and will destroy the users that created the schema. So the screen will be something like this.



Next, we will the Benchmark from the drop down menu -> TPC-C -> TPC-C Schema Options. This time we will focus on the circled portion of the screen. As seen below I selected the "Standard Driver Script" to generate the load. This script is mainly good if you want to use it for stressing the system.  If you are interested in performance numbers, you should go with the "AWR Snapshot Driver Script". I select 10000 per user for my test. Then clicked OK.



Next, go to the drop down menu Benchmark again. This time select TPC-C -> TPC-C Driver Script.
This will generate the driver script.


Below you seen the script that was created to generate the TPC-C load.



Next we'll need Virtual users to drive the load generation script. So we'll create them by clicking on the Virtual Users drop down menu. In the pop-up screen I entered 10 for virtual users, and decided to go with 5 iterations. Then followed that by clicking OK.



Next I clicked on the "Create Virtual Users" button.  This generated the 10 virtual users, and created a file under /tmp for the logs.



Next, I clicked on the "Run Hammerora TPC-C" button(circled in red) to run the workload. Below is the screen shot of the workload running.




There we go. The Hammerora TPC-C load is running. To see the Transaction information click on TX_Counter drop down menu, enter the connect string information, and click OK.


After that I clicked on the Transaction button(it has something like a pencil on it). This will give you the graph and transaction per minute information.





No comments: