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 .
Regards
Bala
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 http://berx.at/
>
Other related posts:
