RE: making graphical reports from oracle metrics
Date: Tue, 2 Dec 2008 12:57:16 -0000
Message-ID: <0AE344C9CA9A4746BE1FE8F9FEBA30DF2BE4B0@ELON17P32001A.csfb.cs-group.com>
Prem,
I used Orca to produce an Oracle performance recording tool ( http://www.hoopoes.com/cs/orca/ ). Orca does all the heavy lifting; my piece extracts data from Statspack/AWR into the space-separated format needed. This is all Open Source, so you are free to re-use for your situation.
RRDTool is at the heart of Orca, and is great if you are satisfied with the long-term diminuition of precision necessary to keep datasets to a fixed size. It does allow you to keep long term trend records whilst disposing of old data from your database in a sensible fashion.
If the data is something you expect to keep in an Oracle database, then Perl's DBI would be my tool of choice, but that's because I already know how to use it :-).
Cheers,
Duncan.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Prem Khanna J
Sent: 02 December 2008 10:32
To: tanel_at_poderc.com; oracle-l_at_freelists.org
Subject: Re: making graphical reports from oracle metrics
Guys ,
Thanks a ton for all your valuable replies . I was surprised to see no
one using rrdtool .
I thought it is widely used by oracle community . Would like to know if
anyone is using RRDTOOL ?!!!
Hi Tanel , Many thanks for that excel . Let me try that too .
- prem -
Explore your hobbies and interests. Go to
http://in.promos.yahoo.com/groups/
--
http://www.freelists.org/webpage/oracle-l
Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 02 2008 - 06:57:16 CST