Testing for concurrency .. How to simulate multiple concurrent sessions?
751195Feb 3 2010 — edited Feb 3 2010All,
I was going through Tom Kyte's Expert Oracle one on one and he explains how we can test the scalability of queries by running them concurrently for multiple sessions.
My (rather naive) question is how do you simulate those five concurrent sqlplus sessions?
a). Do you just do an alt + tab to each session and run the same procedure?
(I did this for two sessions and was able to see the wait times etc.. but for more sessions (5.or more.) ,the approach doesn't look right..By the time I go to the 5th session and execute it, the first one is way under progress. Also, It is clearly evident they are not all concurrent sessions.
b) Schedule 5 different jobs to run the same procedure at the same time..?
Any other approach...?
Thanks for your time in advance!
John.