Load testing on Oracle 19C RAC with HammerDB

When dealing with Oracle 19c Real Application Clusters (RAC), the process of capturing a workload from a source Oracle 19c RAC database and replaying it on a target Oracle 19c RAC database using HammerDB involves some additional considerations. Below are the revised steps:

Capture and Replay Workload from Source to Target Oracle 19c RAC

1. Download and Install HammerDB:

   • Visit HammerDB website and download the latest version.
   • Follow the installation instructions for your operating system.

2. Install Oracle Client:

   • Ensure that you have the Oracle client installed on the machine where HammerDB is running.
   • Set up the necessary Oracle client configurations.

3. Launch HammerDB:

   • Start HammerDB after the installation.

4. Configure Source Database Connection (Source Oracle 19c RAC):

   • Go to the “Session” menu and select “Define Database.”
   • Choose “Oracle” as the database type.
   • For RAC, enter connection details for one of the nodes in the source Oracle 19c RAC cluster:
     • Hostname: <Node 1 hostname>
     • Port: <Oracle port>
     • Service Name: <Source Oracle service name>
     • Username: <Your source Oracle username>
     • Password: <Your source Oracle password>
   • Click “OK.”

5. Capture Workload from Source Database:

   • In the “Session” menu, select “Define Workload.”
   • Choose “Capture Workload.”
   • Specify the capture options and start the capture process.
   • Perform the operations on the source Oracle 19c RAC database that you want to capture for the workload.

6. Save Captured Workload:

   • Save the captured workload to a file. This file will contain the SQL statements and transactions performed during the capture.

7. Configure Target Database Connection (Target Oracle 19c RAC):

   • Go to the “Session” menu and select “Define Database.”
   • Choose “Oracle” as the database type.
   • For RAC, enter connection details for one of the nodes in the target Oracle 19c RAC cluster:
     • Hostname: <Node 1 hostname>
     • Port: <Oracle port>
     • Service Name: <Target Oracle service name>
     • Username: <Your target Oracle username>
     • Password: <Your target Oracle password>
   • Click “OK.”

8. Configure Replay on Target Database:

   • In the “Session” menu, select “Define Workload.”
   • Choose “Replay Workload.”
   • Specify the replay options, load the previously saved captured workload file, and configure the target Oracle 19c RAC database connection.

9. Run Load Test on Target Database:

   • Start the load testing by selecting the “Run Benchmark” option in HammerDB.
   • Monitor the progress of the test, which now replays the captured workload on the target Oracle 19c RAC database.

10. Analyze Results:

• Review the detailed performance metrics and statistics provided by HammerDB after the load test completes.
• Analyze the impact of the replayed workload on the target Oracle 19c RAC database.

These steps are tailored for Oracle 19c RAC. Always refer to the official documentation for accurate and up-to-date information, and ensure that you have the necessary permissions and licenses for performing load testing on both Oracle 19c RAC databases.