Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Capture or report transactions/queries per second
Hi Jared
The link you provided for YAPPPACK is not correct I presume?
On 8/2/06, Jared Still <jkstill_at_gmail.com> wrote:
>
> 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-lReceived on Wed Aug 02 2006 - 16:39:19 CDT
![]() |
![]() |