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:

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.
Posted by SMC at 2:12 AM

8 comments:

  1. Software Development CompanyMay 30, 2017 at 12:40 PM

    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



    ReplyDelete
  2. eddyshaw9272711June 17, 2018 at 7:11 PM

    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

    ReplyDelete
  3. chanduMarch 14, 2019 at 9:34 PM

    This is a very basic information on how to connect to Oracle database.
    Can you please let me know how to call a stored procedure using LR_DB functions ?

    ReplyDelete
  4. swaroopJuly 19, 2019 at 4:10 PM

    when we execute the script in controller , the response time for running the query is close to 0sec( 0.001sec),, any idea y?

    ReplyDelete
    Replies
    1. AnonymousAugust 9, 2019 at 8:30 AM

      That means your query was super fast. Good Job~

      Delete
  5. AnonymousAugust 9, 2019 at 8:31 AM

    Is that any way as until now the Vugen version already stable at v12.52, the sql query run in HTTP protocol?

    ReplyDelete
  6. A Simple GuyJanuary 17, 2020 at 9:39 PM

    Great post... i am able to get the value from DB in Vugen but script fails in Performance Centre at the setp of Connecting DB. I have theOracle client installed on the Load Generator machines but still it fails. Any idea WHY?

    ReplyDelete
  7. Vagdevi KJune 30, 2021 at 7:31 PM

    Hi,

    Thanks for the post. Can you please specify what is the datasource and what can be the value for it. Because we have custom JDBC Urls to connect to the database and I am not able to find the value for datasource attribute

    Thanks in advance

    ReplyDelete

Subscribe to: Post Comments (Atom)