Home » RDBMS Server » Performance Tuning » Regarding load testing
icon5.gif  Regarding load testing [message #127913] Thu, 14 July 2005 02:17 Go to next message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
hi experts,
I have created a procedure that will insert data into 9 tables.I have tested the proceduer for 4000 records insert into these tables.All tables will have 4000 records insertion.

My test only includes the time taken by the procedure to complete the task,by using dbms_utility.get_time().

My question is how can i test this in a parallel way.that means 3 or more instances of my testing.so that i can test the load of my procedure.

Pls. explain if you have some idea.

Thanks
Dinesh
Re: Regarding load testing [message #127986 is a reply to message #127913] Thu, 14 July 2005 08:29 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
One option is to use dbms_jobs or the 10g scheduler to submit several calls to your insert procedure at the same time. So say you have a procedure that does the work you want to test. Submit the same procedure to execute like 5 times all at once to run immediately. Then when you issue a commit, it fires the jobs all at the same time.

Also there are various load testing tools on the market you can buy. Could also try doing something where you open up several sqlplus sessions and then hit return on your procedure call all at the same time. So several options.

And good for you to think of testing this. If only a single person would be using the database at the same time we'd all be using MS Access. But databases are meant to be used by many people at the same time, and it is important to test this behavior to make sure nothing unexpected happens.
Re: Regarding load testing [message #128001 is a reply to message #127986] Thu, 14 July 2005 09:34 Go to previous messageGo to next message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
Thanks Smartin,
I have got your point.I test it using dbms_job. I got the logic what you are telling.

Thanks again
Dinesh
Re: Regarding load testing [message #130221 is a reply to message #127913] Thu, 28 July 2005 19:13 Go to previous messageGo to next message
rkl1
Messages: 97
Registered: June 2005
Member
If you are testing from the window, you may create the batch file test1.bat, test2.bat, test3.bat etc

test1.bat contains

start /high sqlplus test1/test1@instance1 @proc1.sql

test2.bat contains

start/high sqlplus test2/test2@instance2 @proc1.sql

After that you can put in window task scheduler and run them at same time at certain intervals.you may attach a logfile to accumulate time factors or any error message.

thanks.
Re: Regarding load testing [message #130355 is a reply to message #130221] Fri, 29 July 2005 08:35 Go to previous messageGo to next message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
hi rk1,
Can u explain this pls.

start/high sqlplus test2/test2@instance2 @proc1.sql

i got it from sqlplus but before it i could not get.i.t. start/high what it will do.

thanks
dinesh
Re: Regarding load testing [message #130360 is a reply to message #127913] Fri, 29 July 2005 09:07 Go to previous messageGo to next message
rkl1
Messages: 97
Registered: June 2005
Member
start /high is telling the window to use this job with high priority. You can get this info from window command prompt

c:>start /?

and it will tell you the options.

thanks.
Re: Regarding load testing [message #131342 is a reply to message #130360] Fri, 05 August 2005 07:23 Go to previous message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
Thanks

Regds
Dinesh
Previous Topic: ORA-04045: errors during recompilation/revalidation of HPQ_IF.java/lang/String
Next Topic: UNION QUERY OPTIMIZE
Goto Forum:
  


Current Time: Fri May 27 16:44:54 CDT 2022