Re: Simulation of 600 connections on Oracle 8.0.5

From: Kelly Burkhart <kburk_at_sky.net>
Date: 12 Oct 1999 21:48:39 -0500
Message-ID: <m3puykm0vs.fsf@speedy.sky.net>

nietzel_at_my-deja.com writes:

> Hello all,
>
> I am new to Oracle and I need to run a test that will open 600
> connections. The connections donīt have to do anything just open and
> wait until all 600 connections are open and then close. The platform is
> Unixware 7.1.0.
>
> Before I venture out and write a program to do this I thought Iīd check
> to see if anyone has accomplished this first!
>
> Thanks for any info..
>
> Earle
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

I have written a C++ class library encapsulating OCI. If you have a relatively standards complient C++ compiler you should be able to get it to work. Take a look at this site for details:

http://www.sky.net/~kburk/libdbc/libdbc.html

Here is a program using Dbc which creates 600 connections:

#include <iostream>
#include <stdexcept>
#include <dbcenv.h>

int
main()
{

    try {

        DbcEnv *env = DbcEnv::init( DbcEnv::eOCI );

	// Create 600 connections.  Don't bother keeping track of the
	// pointers.
	//
	for( int idx=0; idx<600; idx++ )
	    DbcSession *session = env->session( "server", "user", "password" );

	// deleting env will cause all sessions to be destroyed as well
	//
        delete env;

    }
    catch( exception &e ) {

        cout << "exception: " << e.what() << endl;     }
}

--
Kelly R. Burkhart
kburk_at_sky.net

Just enjoy the Ozzy and keep your mouth shut

• George Plimpton (on SNL)

Received on Tue Oct 12 1999 - 21:48:39 CDT