Re: Oracle Performance Graph
Date: Wed, 7 Oct 2009 08:32:04 +0200
Message-ID: <cd8f74560910062332m582a1de0r86b0a1a7b8185dbc_at_mail.gmail.com>
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_at_gmail.com> 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_at_gmail.com Lederergasse 27/2/14 +43 660 660 83306 1080 Wien http://berx.at/ -- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 07 2009 - 01:32:04 CDT