HOL 18c 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.

Index

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 2.23 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:

@/home/oracle/scripts/snap.sql

Please NOTE down the snapshot number.

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 green Load option.
This will populate the script window with the driver script:

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:

@/home/oracle/scripts/capture_cc.sql

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 green Run icon:

Then Click on the red Monitoring Pencil 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

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

@/home/oracle/scripts/snap.sql

Please NOTE down the snapshot number.

Additional Information

You can modify the standard parameters in either the GUI tool or as defaults in config.xml located in:
/home/oracle/HammerDB-2.23


===> NEXT: Capture and Preserve SQL