HOL 19c Load


In this part you’ll generate application load on the UPGR database before upgrade. In a later stage we’ll compare statements and overall performance before/after upgrade.


Generate Application Load

In this part of the Hands-On Lab we will generate some application load on the UPGR database. We’ll use an external load tool, HammerDB. The lab has version 3.3 installed. Documentation for HammerDB can be found here. You can use your own load scripts as well when you run the lab by yourself.

1. Generate an AWR snapshot

Open an xtermdouble-click on the TERMINAL icon:

Then switch the environment to . upgr, change to /home/oracle/scripts and start SQL*Plus:

. upgr
cd /home/oracle/scripts

sqlplus / as sysdba

Execute snap.sql which generates an AWR snapshot:


Please NOTE down the snapshot number (e.g.: 110)

Don’t exit from the xterm. Leave SQL*Plus open.

2. Start HammerDB

Double-Click on the HammerDB icon on the desktop:

3. Load Driver Script and start Virtual Users

Click on the triangle “TPC-C“:


Open the Driver Script setup with a Click:


Then Double-Click on the Load option.

This will populate the script window with the driver script (ignore the error messages in the script window):


Click on Virtual Users:


Now Double-Click on Create – you should see then 3 Virtual Users being started below the script window:

4. Capture SQL from Cursor Cache

Please start the following script in your SQL*plus window. With this script you’ll capture now all SQL Statements directly from cursor cache while HammerDB is running and generating load on your database:


The capture is scheduled for 240 seconds. It polls the cache every 10 seconds.

5. Start TPC-C Load Test and Monitor the progress

Double-Click on the Run icon:


Then Click on the Graph / Transaction Counter icon in the top menu icon bar:

You’ll see that the script window changes now waiting for data.
It takes a few seconds, then you’ll see the performance charts and the transactions-per-minute (tpm):


The load run usually takes 2-3 minutes until it completes:


Note the Complete=1 per Virtual User underneath the graph.

We will use this load only to generate some statements.

6. Close HammerDB

Finally Exit HammerDB:


7. Generate another AWR snapshot

Please WAIT until the capture_cc.sql scripts returns control back to you – DON’T CTRL-C it!

In the existing sqlplus create another AWR snapshot once the command prompt is visible:


Please NOTE down the snapshot number (e.g. 111).

Additional Information

You can modify the standard parameters in either the GUI tool or as defaults in config.xml located in:

Share this: