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. #####################################################################################