HOL 19c Load

« PREVIOUS «
MAIN INDEX 19C HOL » CAPTURE SQL »

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

HOL 19c Load

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:

startup
@/home/oracle/scripts/snap.sql

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:

HOL 19c Load

3. Load Driver Script and start Virtual Users

Click on the triangle “TPC-C“:

HOL 19c Load

 

Open the Driver Script setup with a Click:

HOL 19c Load

 

Then Double-Click on the Load option.

HOL 19c Load
This will populate the script window with the driver script (ignore the error messages in the script window):

HOL 19c Load

 

Click on Virtual Users:

HOL 19c Load

 

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

HOL 19c Load

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

HOL 19c Load

 

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

HOL 19c Load

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

HOL 19c Load

 

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

HOL 19c Load

 

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:

HOL 19c Load

 

7. Generate another AWR snapshot

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

HOL 19c Load

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 (e.g. 111).

Additional Information

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


« PREVIOUS «
MAIN INDEX 19C HOL » CAPTURE SQL »
Share this: