Any one have another approach for above scenario?
Thanks Anil Gaur ________________________________ From: Yngvi ??r Sigurj?nsson <blitzk...@gmail.com> Sent: Thursday, April 12, 2018 1:48 PM To: JMeter Users List Subject: Re: DB Stored Procedure Performance Help Hi Few years back I had to test some Oracle stored procedures, What you need to consider is that databases are sometimes lazy and don't actually do anything until they need to. So if the procedures are returning cursors/ResultSets you will need to exhaust the ResultSet to get the real execution time of the procedure. I had to do some scripting to loop over the ResultSet to make sure all execution time was accounted for. I actually had to make make a patch for jmeter at the time to add the Handle ResultSet option so that you could specify that Result Sets are stored as Objects, and not as String, so that you can use it in your script. I also added the Count Records option to loop through result set, but I believe someone changed it so that it does not actually iterate the result set but rather calls last() on it and that method is not implemented on Oracle JDBC at least. I still have the config I used back home but I don't really know when I have the time to check it. But possibly it was all done on a clients system. Regards Yngvi On Thu, Apr 12, 2018 at 12:33 PM Anil Gaur <anilg...@live.com> wrote: > Hi All, > > I want to do performance testing for DB stored procedures using Jmeter. As > per requirement I have multiple DB stored procedures and need to identify > the performance of all these. > > Can someone help me that how can I achieve this . > Also what different type of test I can do using Jmeter for these stored > procedures. > > > > Thanks > Anil > >