 Regarding load testing [message #127913] |
Thu, 14 July 2005 02:17  |
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  |
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 #130221 is a reply to message #127913] |
Thu, 28 July 2005 19:13 |
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 |
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 |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
