Re: Capture or report transactions/queries per second

1. Setup Statspack
2. Install YAPPPACK
3. Patch YAPPPACK
4. Install Perl, DBI, DBD::Oracle, DBI::Chart
5. Pull data from statspack and create charts

YAPPPACK and patches are at http://miracleas.dk/index.asp?sprog=2

Click on "Events and Education', then on 'Technical Information'

YAPPPACK and that patches for it are near the bottom.

This file offers some info on setting up with DBI::Chart http://jaredstill.com/downloads/yappp_chart/README.chart

This file contains some additions to the YAPP pool for creating charts. http://jaredstill.com/downloads/yappp_chart/yapp_chart.tar

The Perl script that creates the chart:
http://jaredstill.com/downloads/yappp_chart/yc2.pl

An example chart:
http://jaredstill.com/downloads/yappp_chart/response_time.png

Once setup, you just need to manipulate which data appears in the chart via the YAPP_EVENT table.

Jared

On 8/2/06, Collier,Joshua W - JDDO-6 <jwcollier_at_bpa.gov> wrote:
>
> My friends,
> So they've asked me to provide a graph. On the Y axis is number of
> connections on the X axis is either queries or transactions per second. I
> plan on digging into the statspack tables, in the mean time I thought I'd
> ask the ya'll if you have any easy methods or other such interesting
> feedback.
>
> Thanks!
>
> Josh C.
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l