Re: ORACLE stress test

From: Stanley Fung <sfung_at_mdsi.bc.ca>
Date: Mon, 01 Jun 1998 11:57:15 -0700
Message-ID: <3572F98B.2A47@mdsi.bc.ca>

I did a test to do 500,000 insertion by using a PL/SQL block. You may try to run 4 or 5 sessions.

Hope this help!

maurice segers wrote:
>
> Hi,
> I want to do a stress test of an oracle database. Does anyone have
> sugestions whatthe best way is to do such a test
>
> I was planed to do insert's update's delete's on some tables with several
> connections to the database.
>
> Maurice

Stanley Fung                 | Software Analyst
Mobile Data Solutions Inc.   | Direct Line: (604)207-6290
Suite 135                    | Tel:         (604)270-9939
10551 Shellbridge Way,       | Fax:         (604)270-1310
Richmond, B.C.               | E-Mail:      sfung_at_mdsi.bc.ca
Canada V6X-2W9               | http://www.mdsi-advantex.com

------------------------------------------------------------

Received on Mon Jun 01 1998 - 13:57:15 CDT