Does anyone have such a beast for Oracle? I am trying to eliminate the
Perl/DBD::Oracle side of the equation for some problems in our app. I
did a looping select 20,000 times and the same for an insert.

I thought that someone might have a better script...

Robert

Hey Robert,

Are you going from Oracle to Oracle?

Peter

-----Original Message-----
From: Robert Hicks [mailto:sigzero [at] gmail.com]
Sent: Tuesday, August 07, 2007 7:52 AM
To: dbi-users [at] perl.org
Subject: Load Testing Script

Does anyone have such a beast for Oracle? I am trying to eliminate the
Perl/DBD::Oracle side of the equation for some problems in our app. I
did a looping select 20,000 times and the same for an insert.

I thought that someone might have a better script...

Robert


This E-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not
the intended recipient, please contact the sender by reply E-mail, and
destroy all copies of the original message.

Loo, Peter # PHX wrote:
> Hey Robert,
>
> Are you going from Oracle to Oracle?
>
> Peter

Yup...I am basically wanting to test against 1 particular Oracle db.

Robert

From a flat file?

Peter

-----Original Message-----
From: Robert Hicks [mailto:sigzero [at] gmail.com]
Sent: Tuesday, August 07, 2007 9:47 AM
To: dbi-users [at] perl.org
Subject: Re: Load Testing Script

Loo, Peter # PHX wrote:
> Hey Robert,
>
> Are you going from Oracle to Oracle?
>
> Peter

Yup...I am basically wanting to test against 1 particular Oracle db.

Robert


This E-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not
the intended recipient, please contact the sender by reply E-mail, and
destroy all copies of the original message.

Robert Hicks wrote:
> Does anyone have such a beast for Oracle? I am trying to eliminate the
> Perl/DBD::Oracle side of the equation for some problems in our app. I
> did a looping select 20,000 times and the same for an insert.
>
> I thought that someone might have a better script...


Have you tried the Benchmark module? It's in the Perl core.

- Philip

It probably doesn't matter. Right now I just have a script that does
inserts and selects. I control the database so I can do pretty much what
I need to do.

Loo, Peter # PHX wrote:
> From a flat file?
>
> Peter
>
> -----Original Message-----
> From: Robert Hicks [mailto:sigzero [at] gmail.com]
> Sent: Tuesday, August 07, 2007 9:47 AM
> To: dbi-users [at] perl.org
> Subject: Re: Load Testing Script
>
> Loo, Peter # PHX wrote:
>> Hey Robert,
>>
>> Are you going from Oracle to Oracle?
>>
>> Peter
>
> Yup...I am basically wanting to test against 1 particular Oracle db.
>
> Robert
>
>
> This E-mail message is for the sole use of the intended recipient(s) and
> may contain confidential and privileged information. Any unauthorized
> review, use, disclosure or distribution is prohibited. If you are not
> the intended recipient, please contact the sender by reply E-mail, and
> destroy all copies of the original message.

Garrett, Philip (MAN-Corporate) wrote:
> Robert Hicks wrote:
>> Does anyone have such a beast for Oracle? I am trying to eliminate the
>> Perl/DBD::Oracle side of the equation for some problems in our app. I
>> did a looping select 20,000 times and the same for an insert.
>>
>> I thought that someone might have a better script...
>
>
> Have you tried the Benchmark module? It's in the Perl core.
>
> - Philip

That really doesn't load test but yes I am using it in my script. I get
something like:

50000 inserts in: 39 wallclock secs ( 8.60 usr + 1.23 sys = 9.83 CPU)
50000 selects in: 76 wallclock secs (48.34 usr + 8.08 sys = 56.42 CPU)

Robert

--0-1285111499-1186674335=:52221
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

have you looked into sqlldr

Robert Hicks <sigzero [at] gmail.com> wrote: Garrett, Philip (MAN-Corporate) wrote:
> Robert Hicks wrote:
>> Does anyone have such a beast for Oracle? I am trying to eliminate the
>> Perl/DBD::Oracle side of the equation for some problems in our app. I
>> did a looping select 20,000 times and the same for an insert.
>>
>> I thought that someone might have a better script...
>
>
> Have you tried the Benchmark module? It's in the Perl core.
>
> - Philip

That really doesn't load test but yes I am using it in my script. I get
something like:

50000 inserts in: 39 wallclock secs ( 8.60 usr + 1.23 sys = 9.83 CPU)
50000 selects in: 76 wallclock secs (48.34 usr + 8.08 sys = 56.42 CPU)

Robert


--0-1285111499-1186674335=:52221--

Robert Hicks wrote:
> Garrett, Philip (MAN-Corporate) wrote:
>> Robert Hicks wrote:
>>> Does anyone have such a beast for Oracle? I am trying to eliminate
>>> the Perl/DBD::Oracle side of the equation for some problems in our
>>> app. I did a looping select 20,000 times and the same for an insert.
>>>
>>> I thought that someone might have a better script...
>>
>> Have you tried the Benchmark module? It's in the Perl core.
>
> That really doesn't load test but yes I am using it in my script. I
> get something like:
>
> 50000 inserts in: 39 wallclock secs ( 8.60 usr + 1.23 sys =3D 9.83
> CPU) 50000 selects in: 76 wallclock secs (48.34 usr + 8.08 sys =3D
> 56.42 CPU)

If you're looking to really load test your database, you can use (gasp!)
JMeter's jdbc sampler. Of course that means you can't use your Perl
modules...

- Philip