Re: Oracle Performance Graph

From: Martin Berger <>
Date: Wed, 7 Oct 2009 08:32:04 +0200
Message-ID: <>


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
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,

On Wed, Oct 7, 2009 at 07:48, Balakrishna Y <> 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 
Lederergasse 27/2/14           +43 660 660 83306
1080 Wien                             
Received on Wed Oct 07 2009 - 01:32:04 CDT

Original text of this message