Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: OT: Is there a simple perl utility or program similar to Oracle's

Re: OT: Is there a simple perl utility or program similar to Oracle's

From: Tim Bunce <Tim.Bunce_at_pobox.com>
Date: Tue, 03 Jun 2003 14:24:52 -0800
Message-ID: <F001.005A9549.20030603142452@fatcity.com>


Yeap...

On Tue, Jun 03, 2003 at 01:19:51PM -0800, Alex wrote:
> If you're asking for a profiler of your perl code you can try dprof

That's for your perl, at: http://search.cpan.org/author/JHI/perl-5.8.0/ext/Devel/DProf/DProf.pm

> and dbiprof.

That's for your DBI, at: http://search.cpan.org/author/TIMB/DBI-1.37/lib/DBI/Profile.pm

For DBI profiling it's as simple as setting the DBI_PROFILE env var before running the program. Try setting it to values like 1, 2, 6, and -6. Then read the docs to see what you're actually doing :)

Tim.

>
> On Tue, 3 Jun 2003, gmei wrote:
>
> > Hi:
> >
> > I have a perl program which calls lots of subroutines, and plus it calls
> > sqls through DBI/DBD. I am wondering if there are some utilities or programs
> > similar to Oracle's dbms_profiler that I could use to identify parts that
> > are heavy-hitters?
> >
> > TIA.
> >
> > Guang
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: gmei
> > INET: gmei_at_incyte.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Alex
> INET: axs_at_m-net.arbornet.org
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Bunce
  INET: Tim.Bunce_at_pobox.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Jun 03 2003 - 17:24:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US