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
RE: Load Testing Script
Hey Robert, Are you going from Oracle to Oracle? Peter -Original Message- From: Robert Hicks [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 07, 2007 7:52 AM To: dbi-users@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.
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
RE: Load Testing Script
>From a flat file? Peter -Original Message- From: Robert Hicks [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 07, 2007 9:47 AM To: dbi-users@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.
RE: Load Testing Script
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
Re: Load Testing Script
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:[EMAIL PROTECTED] Sent: Tuesday, August 07, 2007 9:47 AM To: dbi-users@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.
Re: Load Testing Script
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: 5 inserts in: 39 wallclock secs ( 8.60 usr + 1.23 sys = 9.83 CPU) 5 selects in: 76 wallclock secs (48.34 usr + 8.08 sys = 56.42 CPU) Robert
Re: DBD::Oracle in 64 bit Linux
Hello Jim, There is indeed an option r=build64. However, when I used this option, DBD::Oracle doesnt compline properly, I got something like lclntsh file not found (if I remember it correctly). Hi Craig, I edited the Makefile and replaced it with lib64 path, in fact without this change, it wont even compile. However, I have 32-bit perl. So I am wondering, if this could the reason. Do I need to have 64 bit perl to compile DBD::Oracle in 64 bit machine?. Thanks, Arya --- Jim Brandt <[EMAIL PROTECTED]> wrote: > We just did 32-bit, so I'm not sure about 64-bit. I > was editing my > Makefile as well until someone on the list pointed > out that: > > perl Makefile.PL -r=build32 > > generated the correct Makefile for 32-bit. Maybe > there is a similar flag > for 64? Although it was my impression that 64 was > now the default WRT to > the Oracle client libraries since they are 'lib' and > the 32-bit are 'lib32'. > > The last bit that we're still looking into, and that > caused quite a bit > of confusion for us, is that it appears Oracle > patched the permissions > repair script (changePerm.sh) between version > 10.2.0.1 and 10.2.0.3 to > fix some bugs. The original version, which we had on > one machine, > relaxed permissions on rdbms/lib32, but on another > machine that was > patched, it didn't. So I could get things running on > one machine, but > not another. We ended up modifying permissions > manually while we looking > into these issues with Oracle. > > Jim > > Craig Metzer wrote: > > > > I had a similar problem installing DBD::ODBC and > DBD::Oracle on > > 64-bit RedHat. My Perl build was a 64-bit. I > received the same > > error as you did. In my case Makefile.PL was > writing the path to my > > 32-bit libraries to my makefile. I had to edit it > replacing the > > ../lib/.. paths with ../lib64/.. After that, it > built and tested > > just fine. > > > > > > Best of luck, Craig > > > > > > > > > >> Date: Fri, 3 Aug 2007 16:01:58 -0700 From: > [EMAIL PROTECTED] > >> Subject: Re: DBD::Oracle in 64 bit Linux To: > [EMAIL PROTECTED] > >> CC: dbi-users@perl.org > >> > >> Hello Jim, Thank you very much for the > information. Actually, I was > >> unaware of this permission issue. Is the > permission issue a > >> general issue or specific to 64 bit installation? > Because I did > >> compile and installed DBD::Oracle for oracle 10 > client in 32 bit > >> Linux machine, which looks ok (so far). Though I > know, some people > >> having issue with it. Do you know if > DBD::Oralce was tested for > >> 64 bit machine? and if it was, then what was the > out come? Thank > >> you, Partha Dhar > >> > >> --- Jim Brandt wrote: > >> > >>> We've recently been debugging an issue with the > Oracle 10g client > >>> install that basically relates back to > permissions on the client > >>> libraries. In a nutshell, we found that our > normal procedure of: > >>> > >>> > >>> * run client install * run oracle permissions > repair script > >>> > >>> didn't actually fully repair the permissions. > We're still looking > >>> into the details, but the solution was to make > sure the user > >>> trying to run the DBD::Oracle install has > permission to read all > >>> of the client libraries. We did all (or nearly > all) files because > >>> it was too difficult to narrow down exactly > which ones were > >>> wrong on a case by case basis. > >>> > >>> > >>> a_arya2000 wrote: > The oracle client version is 10 Thank you, Arya > --- Jim Brandt > wrote: > > > What version of the Oracle client do you have > installed? > > > > > > a_arya2000 wrote: > >> Hi, I am trying to install DBD::Oracle in a > >>> Linux > > 64 > >> bit machine but facing problem and not sure > what > >>> i > > am > >> doing wrong or if something wrong with oracle > > client > >> installation. make looks ok, but when I run > make > > test > >> I get this. --- > >> t/01baseFailed to load Oracle > extension > >> and/or shared libraries: > install_driver(Oracle) failed: > >> Can't load > >> > >> > '/usr/perl/src/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' > >> > >> for module DBD::Oracle: > >> > >> > /usr/Linux/perl/src/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so: > >> > >> cannot open shared object file: No such file > or directory > >> at > >> > >> > /usr/perl/perl-5.8.3/lib/5.8.3/i386-linux-thread-multi/DynaLoader.pm > >> > >> line 229. at (eval 3) line 3 Compilation > failed in require > >> at (eval 3) line > >>> 3. > >> Perhaps a required shared library or dll > isn't installed > >> where expected . . > >> - > >> > >> For rest of the tests I get almost same > output. > > Also I > >> checked, Oracle.so in that give director
More info on DashProfiler
I just wanted to add that DashProfiler can be a little tricky to wrap your head around, especially as the version on CPAN has very little docs. I'm working on a new version, with much better docs, which I hope to release this week. Meanwhile, I've just written a first draft of a user guide that tries to put all the pieces into context: http://dashprofiler.googlecode.com/svn/trunk/lib/DashProfiler/UserGuide.pm Tim. p.s. This is a little off-topic. On the other hand DashProfiler is built on DBI::Profile, so that's my excuse. I'll announce the next CPAN release here but no more after that (unless there's a good reason :) - Forwarded message from [EMAIL PROTECTED] - Date: Fri, 03 Aug 2007 02:04:05 + From: [EMAIL PROTECTED] Subject: [use Perl] Stories for 2007-08-03 To: [EMAIL PROTECTED] X-Bulkmail: 2.051 use Perl Daily Newsletter In this issue: * OSCON 2007 Perl Lightning Talks on YouTube * Perl-IL Meeting on 14 August 2007 ++ | OSCON 2007 Perl Lightning Talks on YouTube | | posted by pudge on Thursday August 02, @14:21 (Events) | | http://use.perl.org/article.pl?sid=07/08/02/182239 | ++ [0]Mike Schilli writes "I've taped some of the Perl Lightning Talks at OSCON and put them on YouTube: * [1] Andy Lester on "ack" and why scripts should be called programs * [2] Tim Bunce on DBD::Gofer * [3] Tim Bunce on DashProfiler * [4] Ask Bjorn Hansen on qpsmtpd * [5] Julian Cash on MoveMyData * [6] Michael Schwern on brewing tea * [7] Vani Raja on YUI CSS * [8] Pudge with the "Perl in a Nutshell" Song Enjoy!" Discuss this story at: http://use.perl.org/comments.pl?sid=07/08/02/182239 Links: 0. http://perlmeister.com/ 1. http://youtube.com/watch?v=G1ynTV_E-5s 2. http://youtube.com/watch?v=_kxVBnzf8_8 3. http://youtube.com/watch?v=_8T-NPa6ES8 4. http://youtube.com/watch?v=oLTAs1pun5k 5. http://youtube.com/watch?v=9qyVPUcKmiQ 6. http://youtube.com/watch?v=9smvof85xOc 7. http://youtube.com/watch?v=UJxQw94Yr9I 8. http://youtube.com/watch?v=UUOArynwzz8 ++ | Perl-IL Meeting on 14 August 2007 | | posted by brian_d_foy on Thursday August 02, @15:23 (User Groups)| | http://use.perl.org/article.pl?sid=07/08/02/194243 | ++ [0]The Israeli Perl Mongers will hold [1]their monthly meeting on Tuesday, 14 August 2007 at 18:30, in the offices of F5 at 24 HaBarzel St. in Ramat HaXayal in Tel Aviv. The meeting agenda includes a presentation by [2]Gabor Szabo on "How Test Automation is Done in Various Open-Source Projects", and the second part of the presentation by Yuval Ya'ari on the internals of Perl's regular expression engine. Discuss this story at: http://use.perl.org/comments.pl?sid=07/08/02/194243 Links: 0. http://www.perl.org.il/ 1. http://www.perl.org.il/meetings/2007/20070814.html 2. http://www.szabgab.com/ Copyright 1997-2006 pudge. All rights reserved. == You have received this message because you subscribed to it on use Perl. To stop receiving this and other messages from use Perl, or to add more messages or change your preferences, please go to your user page. http://use.perl.org/my/messages You can log in and change your preferences from there. - End forwarded message - - End forwarded message -