Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: simulate multiple connections to Oracle
ltang7_at_yahoo.com (Lisa Tang) wrote:
> Hi,
>
> I am looking for an easy way to simulate multiple connection to oracle
> to test the stability and robutness of external procedure (call to C
> library from oracle).
Why simulate? If want multiple connections, make them.
> Could anyone suggest me any fast and easy way to do?
What do you already know? Nothing is going to be fast and easy if you are starting from scratch.
> I would prefer
> using some tool to do, but I have been able to find any free tool from
> the web.
Try Perl with DBI, DBD::Oracle, and Parallel::ForkManager. Or Java if you into that kind of thing.
> Or would anyone have any sample code that can share with me
> so that I can write some program to do it.
Assuming you have a program named "test_it" that make one connection and does what you want, then you could do something like this on unix.
Make a file named x containing:
test_it& test_it& test_it& test_it& test_it& test_it& test_it& test_it& test_it& test_it& test_it& test_it&
Then source that file from the comand line.
Xho
-- -------------------- http://NewsReader.Com/ -------------------- Usenet Newsgroup Service $9.95/Month 30GBReceived on Thu Jul 29 2004 - 13:12:04 CDT