Re: simulate multiple connections to Oracle

From: <ctcgag_at_hotmail.com>
Date: 29 Jul 2004 18:12:04 GMT
Message-ID: <20040729141204.799$3M@newsreader.com>

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&

etc.

Then source that file from the comand line.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB

Received on Thu Jul 29 2004 - 13:12:04 CDT