Saturday, October 8, 2016

Oracle database load testing

In this blog, I’ll tell you how to load test the oracle database using loadrunner. There are different ways to achieve it and one simple way is writing SQL queries in vugen script.

In this blog I’m going to tell how to connect to database, how to execute query and how to disconnect. I will be using lr_db functions to achieve this. Loadrunner help is very useful with details about lr_db functions.

Connect to Oracle database:

        "ConnectionString=Provider=OraOLEDB.Oracle; dbq=10.xx.xx.xx:1540; Data Source=XXXX; Persist Security Info=True; User ID=username; Password=password",

SQL statement:
                "ConnectionName= OracleDB",
                "SQLStatement=SELECT * FROM \"TableName\" ",
                LAST );

Disconnect from database:

                 "ConnectionName= OracleDB", LAST );

Oracle Client need to be installed in load generator machine and TNS entry should be there for data source.
Use web services protocol for loadrunner vugen script.


  1. Hello,
    The Article on Oracle database load testing, gives detailed information about it. Thanks for Sharing the information about oracle Load Testing. For More information check the detail on the load testing here Mobile App Testing

  2. An impressive share, I simply given this onto a colleague who was doing a little bit analysis on this. And he the truth is bought me breakfast because I found it for him.. smile. So let me reword that: Thnx for the deal with! However yeah Thnkx for spending the time to discuss this, I really feel strongly about it and love studying more on this topic. If doable, as you change into experience, would you thoughts updating your weblog with extra details? It's highly helpful for me. Big thumb up for this blog publish! gsn casino games