Re: Performance graphs
- From: Q A I S E R <qrasheed@xxxxxxxxx>
- To: jack@xxxxxxxxxxxx
- Date: Thu, 8 Nov 2012 09:12:54 -0600
Ram,
You have atleast couple of options to plot graphs based on metrics,
gathered from different components. We are currently using graphite.
<http://graphite.wikidot.com/screen-shots>It gathers metrics from various
stacks (OS, Database, Application), and then plots graph for us. Another
tool that offers something similar is collectd <https://collectd.org>. The
graphs are good to show resource usage trends for capacity planning
purposes.
Hope this helps.
Thanks,
--Qaiser
On Tue, Nov 6, 2012 at 3:52 PM, Jack van Zanen <jack@xxxxxxxxxxxx> wrote:
> Hi
> If management wants to see graphs from several locations/systems than
> surely someone must be kicking of a project to come up with a uniform way
> (tool) to display all these graphs.
> There are many products out there that do this.
>
> If not you can even pull in AWR data into excel and generate your own. Just
> make sure you keep months worth of AWR data (could be quite large)
> You could consider statspack for this purpose also with a central
> repository to store the data, at least you can run reports from one
> location and maybe stick APEX on top for displaying the graphs.
> I have tinkered with APEX a bit and with a bit of rtfm I managed to create
> a page that displayed a graph for a database picked from a pull down menu,
> so it is not hard.
>
> I have not used statspack with central repository so can't help you there
> but I am sure it has been done...
>
>
>
> Jack van Zanen
>
> -------------------------
> This e-mail and any attachments may contain confidential material for the
> sole use of the intended recipient. If you are not the intended recipient,
> please be aware that any disclosure, copying, distribution or use of this
> e-mail or any attachment is prohibited. If you have received this e-mail in
> error, please contact the sender and delete all copies.
> Thank you for your cooperation
>
>
> On Wed, Nov 7, 2012 at 6:01 AM, Ram K <lambu999@xxxxxxxxx> wrote:
>
> > All
> > Our management has decided to put together statistics from various
> > resources including OS, network, san etc into a central location and plot
> > things in the form of a graph. The purpose is to track the trends in
> growth
> > and utilization patterns in the resource usage.
> >
> > We can use awr to track database related information. Is there anyway to
> > see data in the form a graph; upper management is interested in graphical
> > outputs.
> >
> > --
> > Thanks,
> > Ram.
> >
> >
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
