[rrd-users] Re: Integrating Oracle with RRDTOOL

[Marcus Vinicius Ferreira]

Hi guys,

I would like to share some points regarding Oracle and rrds. These points are
mostly important in my particular scenario and may not be apropriate for you,
but even so here they are:


1) Storage
   I keep Oracle monitoring data in the rrds because it is less storage to use
at the database. I save work from keeping track another group of tables or
tablespaces, doing clean-up, etc.
   Because of rrd nature -- the "round robin" feature -- I can previously know
how much disk space my graph data will use. I keep them on /var, out of my disk
array and without interfering on my database I/O balance.

2) Average
   Averaging is automated by the tool. I do not need complex reports on my
database monitoring so my data collection is straight enough to feed RRDTool
only.

3) Security/Access
   Data access for the database is very simple. I use a simple account with
SELECT_CATALOG_ROLE and CONNECT privileges to run the scripts. No schemas, no
quota at tablespaces, no consumer groups.

4) Overhead
   It is argueable how much a monitoring task interferes with overall system
performance -- there is always interference -- but at least I try to make it
minimal keeping (here I go again....) storage out of Oracle datafiles and use
mainly v$ views at my scripts.

5) Simplicity
   Putting all these together, it is simpler to setup and monitor any other
database that comes into play. If I am not the DBA to that new database I can
argue with the team responsible that all I need is a simple account with a well
known Oracle role and a directory somewhere out of the way to generate the
graphs.


So that's it. I hope some of these ideas may help somebody.


Regards,

Marcus Vinicius Ferreira
DBA/SysAdmin


--- "Kempf, Reed" <rkempf at rightnow.com> wrote:
> I agree with Thomas on his points.  The only thing I would have to add
> is that if you have many data sources in a temporary RRD or tons of rows
> in your oracle DB, then you may have some performance impacts when
> creating this on the fly.  
> 
> I chose to keep data in both because I do custom reporting off the
> oracle db and display trend graphs from the RRD databases.  My oracle DB
> has over 150 million rows in it and to pull that info out and create an
> RRD on the fly and then query from that would take my server down no
> matter how good my summary tables are set up since I need data for
> daily, weekly, monthly and yearly time periods.
> 
> I guess it depends on how much data you have and the frequency you need
> it.
> 
> HTH
> 
> ReedK
> 
>  
> 
> -----Original Message-----
> From: Thomas Erskine [mailto:thomas.erskine at sympatico.ca] 
> Sent: Thursday, July 03, 2003 7:28 AM
> To: Lozovsky, Daniel; rrd-users at list.ee.ethz.ch
> Subject: [rrd-users] Re: Integrating Oracle with RRDTOOL
> 
> 
> At 23:49 2003-07-02, Lozovsky, Daniel wrote:
>  >Thanks Reed for your reply.
>  >Let me clerify what I am asking.  I am trying to query the oracle
> database  >on the fly and create graphs based on the selected data using
> rrdtool.  I am  >trying to find out how to setup rrdtool to accomplish
> this task.  I do not  >want to keep redundant data in rrdtool but point
> the tool to generate graphs  >directly from the data in the Oracle
> database.  >  >Is this possible? If so, how?
> 
> No.  You would have to create a temporary RRD, populate it with the 
> information of interest and generate the graph off that rrd.  It can be 
> done on the fly; I've done it.  You really want to make sure you clean
> up 
> those temp rrds, or you can run out of disk space really quickly with 
> significant data sets.
> 
>  >--
>  >Unsubscribe
> mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
>  >Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
>  >Archive     http://www.ee.ethz.ch/~slist/rrd-users
>  >WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi
> 
> Thomas Erskine <thomas.erskine at sympatico.ca> +1.613.591.8490 
> 
> 
> --
> Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
> Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
> Archive     http://www.ee.ethz.ch/~slist/rrd-users
> WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi
> 
> --
> Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
> Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
> Archive     http://www.ee.ethz.ch/~slist/rrd-users
> WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi
> 

--
Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/rrd-users
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi