Oracle database 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\" ", &q