I think I asked this before - but I'll try again anyway!

I am collecting Oracle tablespace data, and create an RRD for each tablespace.  I currently have the following entry in my hobbitgraph.cfg file...

  [oracle] FNPATTERN oracle(.*).TOTAL.rrd TITLE Database Size YAXIS Bytes DEF:p at RRDIDX@T=@RRDFN@:total:AVERAGE DEF:p at RRDIDX@U=@RRDFN@:used:AVERAGE CDEF:p at RRDIDX@F=p at RRDIDX@T,p at RRDIDX@U,- -l 0 AREA:p at RRDIDX@U#@COLOR@:Used STACK:p at RRDIDX@F#00FF00:Total\n GPRINT:p at RRDIDX@U:LAST:Used  \: %5.2lf%s (cur) GPRINT:p at RRDIDX@U:MAX: \: %5.2lf%s (max) GPRINT:p at RRDIDX@U:MIN: \: %5.2lf%s (min) GPRINT:p at RRDIDX@U:AVERAGE: \: %5.2lf%s (avg)\n GPRINT:p at RRDIDX@T:LAST:Total \: %5.2lf%s (cur) GPRINT:p at RRDIDX@T:MAX: \: %5.2lf%s (max) GPRINT:p at RRDIDX@T:MIN: \: %5.2lf%s (min) GPRINT:p at RRDIDX@T:AVERAGE: \: %5.2lf%s (avg)\n

...so I just get one graph for the total size (I only have one DB per server at the moment).  As you can see, the graph is a stack that shows the total size with the "percent filled" in blue.

If I change TOTAL in the FNPATTERN definition so that it scans *all* of the RRD files, the graph breaks.  I'm guessing this is because it can't really stack multiple tablespaces on one graph like it can for a single percentage (a-la disk etc).

Does anybody know of an RRD flag I can add to the hobbitgraph.cfg definition to force rrdtool to create one graph for each file rather than trying to combine them?

TIA, Andy.

#####################################################################################

This email is intended for the person to whom it is addressed only. If you are not the intended recipient, do not read, copy or use the contents in any way. The opinions expressed may not necessarily reflect those of ZESPRI Group of Companies ('ZESPRI').

While every effort has been made to verify the information contained herein, ZESPRI does not make any representations as to the accuracy of the information or to the performance of any data, information or the products mentioned herein. ZESPRI will not accept liability for any losses, damage or consequence, however, resulting directly or indirectly from the use of this e-mail/attachments. #####################################################################################

Henrik Stoerner wrote on 03/06/2005 17:42:07:

On Fri, Jun 03, 2005 at 05:08:40PM +1200, Andy France wrote:

...

  [oracle] FNPATTERN oracle(.*).TOTAL.rrd

Does anybody know of an RRD flag I can add to the hobbitgraph.cfg definition to force rrdtool to create one graph for each file rather

than

...

trying to combine them?

Try changing the GRAPHS setting in hobbitserver.cfg, so you have an "oracle::1" in there.

(And yes, this is one of those not very well documented things).

Henrik

This still doesn't work for me.  I have made the change in combination with dropping '.TOTAL' from the FNPATTERN but still get just one broken graph.

I see that a similar setting is used for disk (disk:disk_part:5).  What does the second field signify?  Is it something I need to set as well?

Thanks, Andy.

#####################################################################################

This email is intended for the person to whom it is addressed only. If you are not the intended recipient, do not read, copy or use the contents in any way. The opinions expressed may not necessarily reflect those of ZESPRI Group of Companies ('ZESPRI').

While every effort has been made to verify the information contained herein, ZESPRI does not make any representations as to the accuracy of the information or to the performance of any data, information or the products mentioned herein. ZESPRI will not accept liability for any losses, damage or consequence, however, resulting directly or indirectly from the use of this e-mail/attachments. #####################################################################################