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:

lr_db_connect("StepName=Connect",

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

        "ConnectionName=OracleDB",

        "ConnectionType=OLEDB",

LAST );

SQL statement:

lr_db_executeSQLStatement("StepName=PerformQuery",

                "ConnectionName= OracleDB",

                "SQLStatement=SELECT * FROM \"TableName\" ",

                "DatasetName=MyDataset",

                LAST );

Disconnect from database:

                lr_db_disconnect("StepName=Disconnect",

                 "ConnectionName= OracleDB", LAST );

Pre-requisites:

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.