Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Follwoing korn shell is used to move files from source folder to destination folder and gzip it in destination folder. mv_iotto.ksh Linux/Unix
  • cif crons Linux/Unix
  • For Search and replace unix command. Linux/Unix
  • Vivek Tuning for Row Locks. Oracle
  • Good link for LIO in Oracle ( Logical IOs) Oracle
  • Creating never expiring DB user accounts in Oracle Oracle
  • dbms_job.submit example Oracle
  • Settting up get_vmstat.sh for colletinf CPU Usage. Oracle
  • How to choose Driver table in SQL statement Oracle
  • Distributed Transaction Troubleshooting. Oracle
  • create user with unlimited quota Oracle
  • Oracle 10g Installation/Applying Patches Tips Oracle
  • VIvek Encryption Package and Its Usage Oracle
  • useful dg links Oracle
  • Implementing Listener Security Oracle

Load testing on Oracle 19C RAC with HammerDB

Posted on 18-Jan-202418-Jan-2024 By Admin No Comments on 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.

Oracle

Post navigation

Previous Post: Add new columns in dataframe
Next Post: Transfer SQL Profiles from One database to other database.

Related Posts

  • Facts about SCN and Rollback Segment Oracle
  • Optimizer SORT Operations Oracle
  • Oracle 10g Wait Model Oracle
  • cache buffer chain latch Oracle
  • myfile Oracle
  • Multiple listeners Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AMC10 (0)
  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (150)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (151)
  • SQL scripts (349)
  • SQL Server (6)
  • Uncategorized (9)
  • Videos (0)

Recent Posts

  • Tutornet.US — Source of excellent learning14-Oct-2026
  • OCI Infrastructure Patching14-Oct-2026
  • Free API credits for AI models14-Oct-2026
  • AMC1020-Sep-2026
  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sh23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1 Oracle
  • plan10g.sql good Oracle
  • AWR license Oracle
  • SQLPLUS COPY command Precautions. Oracle
  • Renaming Global Name GLOBAL_NAME Oracle
  • Rename Tablespace Oracle
  • Sort with ASCII order and Numeric Order Linux/Unix
  • T-SQL Vs PL/SQL Syntax SQL Server

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme