Re: Performance Statistics collection in Oracle

From: Ethan Post <Blah_at_Blah.com>
Date: Thu, 18 Oct 2001 07:29:29 GMT
Message-ID: <txvz7.1145$SF4.142387@news1.rdc1.sdca.home.com>

Swing on over to Steve Adam's site and download the response_time_breakdown script.

www.ixora.com.au

• Ethan

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:3BCE03CA.DB1_at_yahoo.com...
> Eugene Zhang wrote:
> >
> > Hi,
> >
> > I am trying to generate a report for our application on the DB Server
> > performance.
> >
> > The report will be something like this:
> >
> > Avg
> > Actual Target
> > Parameter % Utilization % Utilization
> > ---------------- ------------- -------------
> > BUFFER BUSY 0 5%
> > CPU UTILIZATION 22 70%
> > DISK I/O 32 70%
> > ENQUEUE WAITS 0 5%
> > LATCH CONTENTION 0 10%
> >
> > Average Maximum
> > ------------ ------- -------
> > DB PROCESSES 163 170
> > DB SESSIONS 70 81
> >
> > Does any one know whether these server statistics information are stored
in
> > any of the tables?
> >
> > Thank you for you help in Advance!
> >
> > Best Regards,
> > Eugene

>

> Check out statspack - a lot of the work is done for you...Other than
> that, look the V$ views for info, for example,

>


> v$sysstat

> v$resource_limit
> v$system_event

>

> et al.

>

> hth
> connor
> --
> ==============================
> Connor McDonald

>

> http://www.oracledba.co.uk

>
> "Some days you're the pigeon, some days you're the statue..."
Received on Thu Oct 18 2001 - 02:29:29 CDT