modperl_dbd_oracle_ora_explain

This is part of The Pile, a partial archive of some open source mailing lists and newsgroups.



To: Ed Park <epark@athenahealth.com>
From: Tim Bunce <Tim.Bunce@ig.co.uk>
Subject: Re: [ANNOUNCE] new site: scaling mod_perl (+tool:
mod_perl + 
Date: Fri, 8 Dec 2000 11:49:20 +0000

On Fri, Dec 08, 2000 at 05:47:00AM -0500, Ed Park wrote:
> 
> So far, I've written up a basic scaling framework, and I've posted a
> particular development profiling tool that we wrote to capture, time, and
> explain all SQL select queries that occur on a particular page of a mod_perl
> + DBD::Oracle application:
> -http://www.lifespree.com/modperl/explain_dbitracelog.pl

The docs should at least mention the ora_explain tool from Alan
Burlison (a Sun performance guy) that's included in the DBD::Oracle
distribution.

It'll let you and and explain the queries that are _actually_ slow or
expensive, in priority order, rather than drown in the explain plans of
many queries.

===


the rest of The Pile (a partial mailing list archive)

doom@kzsu.stanford.edu