Re: Oracle Performance Graph

  • From: Balakrishna Y <krishna000@xxxxxxxxx>
  • To: Martin Berger <martin.a.berger@xxxxxxxxx>
  • Date: Wed, 7 Oct 2009 12:12:53 +0530

Thanks Martin .. i know what you said .you are exactly right.

There are few benefits behind this ..

1. You can easily point out where the problem is .
2. You can easily highlight the numbers which is very high and low.
3. Through sql every thing can be achived but ..few people should have a
very good idea how to point which is bad or good.
4. My Management needs in graph format for better understanding .

I want to write on my own .. but i have never tried .. i just wanted to know
if people give me some basic idea . so that i can learn and customize
according to our requirements.

Thank you very much for your time Martin. Can you please glow some light on
this .



On Wed, Oct 7, 2009 at 12:02 PM, Martin Berger <martin.a.berger@xxxxxxxxx>wrote:

> Bala,
> unfortunately I cannot tell you any tool, as I'm pretty sure, your
> question is wrong. (and I'll try to show, why):
> Databases does not have a quality of 'performance'. They have others
> like 'datafile size', 'SGA size', 'recoverability' or something like
> that. But per se they are either 'fast' nor 'slow' and do not have any
> 'performance'.
> Applications (and derived from them, statements) can have qualities
> like 'expected response-time', 'expected throughput' or also 'expected
> Cost ($$$) to maintain'.
> Based on these expectations, you can trace or sample the real numbers
> and compare them to the expectations.
> After this is done, you can say anything about 'fast' or 'slow', but
> not regarding the database (or Instance) but Application or
> SQL-statement.
> Basically I suggest to colelct this timing-information in the
> application side; if this is not done (no instrumentation) ASH/AWR can
> help under some circumstances to _collect_ some data, in other cases
> you have to sue other tools or write your own.
> visualisation of these numbers is only the last step and often can be
> done with excel or some other client-based multi purpose graphing
> tool.
> sorry for not providing an easy answer,
>  Martin
> On Wed, Oct 7, 2009 at 07:48, Balakrishna Y <krishna000@xxxxxxxxx> wrote:
> > Hi All,
> >
> >
> > Can any one guide me for the tools available for graphing the Oracle DB
> > performance which you might be using already. This is will be great help
> for
> > me to understand the performance in pictorial format.
> >
> > Regards
> >
> > Bala
> >
> --
> Martin Berger           martin.a.berger@xxxxxxxxx
> Lederergasse 27/2/14           +43 660 660 83306
> 1080 Wien                             

Other related posts: