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" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > Sent: Thursday, July 03, 2003 7:28 AM > To: Lozovsky, Daniel; rrd-users@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:[EMAIL PROTECTED] > >Help mailto:[EMAIL PROTECTED] > >Archive http://www.ee.ethz.ch/~slist/rrd-users > >WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi > > Thomas Erskine <[EMAIL PROTECTED]> +1.613.591.8490 > > > -- > Unsubscribe mailto:[EMAIL PROTECTED] > Help mailto:[EMAIL PROTECTED] > Archive http://www.ee.ethz.ch/~slist/rrd-users > WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi > > -- > Unsubscribe mailto:[EMAIL PROTECTED] > Help mailto:[EMAIL PROTECTED] > Archive http://www.ee.ethz.ch/~slist/rrd-users > WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi > -- Unsubscribe mailto:[EMAIL PROTECTED] Help mailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi