RE: Oracle Performance Graph

From: Herring Dave - dherri <>
Date: Wed, 7 Oct 2009 08:58:20 -0500
Message-ID: <>


Tanel Poder put together an Excel spreadsheet (PerfSheet.xls) that simplifies this kind of effort, where you can just enter your query in one of the tabs and execute it, then the spreadsheet VB code helps build a pivot table and graph on the returned data.

I also believe that you can create a report in SQL Developer which displays the query results as a chart. Or you could check out NetCharts. You can get a trial license to see if it meets your needs.

If you come up with a good solution, be sure to post it!

David C. Herring  | DBA, Acxiom Database Services

630-944-4762 office | 630-430-5988 cell | 630-944-4989 fax 1501 Opus Pl | Downers Grove, IL, 60515 | U.S.A. |

From: [] On Behalf Of Balakrishna Y Sent: Wednesday, October 07, 2009 1:43 AM To: Martin Berger
Subject: Re: Oracle Performance Graph

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

The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally

If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank You.

Received on Wed Oct 07 2009 - 08:58:20 CDT

Original text of this message