Andy France wrote on 10/05/2005 12:22:48:
Hi All,
I am adding a custom graph to track Oracle tablespace usage. I currently have an "oracle" test which shows the overall green/yellow/red status of tablespaces based on percent full thresholds.
I want to append graphs showing each tablespace's size/used stats for a better view of historical growth, but I don't want the raw data showing in the HTML page.
I seem to recall using a <data> type tag in the message text but can't find a good example. I'm comfortable with post-processing the message to generate the actual RRDs and graphs but would appreciate some help on the message side!
TIA, Andy.
I have made some headway on this - what I was looking for was a simple set of HTML comment tags <!-- Comment -->
So now I have my data embedded in the message thus:
<!--DATA oracle.ZP1.psapbtabd.rrd:134696864:2010520:1.49 oracle.ZP1.psapbtabi.rrd:95354800:1822184:1.91 oracle.ZP1.psapuser1i.rrd:2585600:282128:10.91 oracle.ZP1.psapstabd.rrd:14479360:1598952:11.04 oracle.ZP1.psapstabi.rrd:14520304:1872960:12.90 oracle.ZP1.dbtotsize.rrd:317055808:46472960:14.66 oracle.ZP1.psapes40bd.rrd:6184960:1728248:27.94 oracle.ZP1.system.rrd:307200:108216:35.23 oracle.ZP1.psapes40bi.rrd:2068480:799904:38.67 oracle.ZP1.psapuser1d.rrd:2068480:887688:42.92 oracle.ZP1.psapel40bd.rrd:2068480:1025088:49.56 oracle.ZP1.psapddicd.rrd:512000:258168:50.42 oracle.ZP1.psapclud.rrd:10342400:5982072:57.84 oracle.ZP1.psapdocud.rrd:71680:44984:62.76 oracle.ZP1.psappoold.rrd:4136960:2726784:65.91 oracle.ZP1.psapdocui.rrd:71680:51568:71.94 oracle.ZP1.psapddici.rrd:512000:380504:74.32 oracle.ZP1.psappooli.rrd:4136960:3139896:75.90 oracle.ZP1.psapsourcei.rrd:307200:243096:79.13 oracle.ZP1.psapclui.rrd:2068480:1771992:85.67 oracle.ZP1.psapsourced.rrd:307200:264672:86.16 oracle.ZP1.psapproti.rrd:1024000:888880:86.81 oracle.ZP1.psapprotd.rrd:4136960:3735416:90.29 oracle.ZP1.psapel40bi.rrd:409600:373160:91.10 oracle.ZP1.psaproll.rrd:8273920:8065888:97.49 oracle.ZP1.psaploadd.rrd:102400:102288:99.89 oracle.ZP1.psaploadi.rrd:102400:102288:99.89 oracle.ZP1.psaptemp.rrd:6205440:6205416:100.00 -->
It doesn't show up on the web page, and I can happily parse it with my custom rrd handler script (I really must get to grips with moving it to C...).
But now I'm having trouble with the hobbitgraph.cfg entry. What I want is a series of stacked graphs, one for each rrd file, showing used space over total space. But I can't figure out how to specify multiple sources with FNPATTERN, but ask rrdgraph to create a unique graph per file rather than trying to combine them like disk etc.
I can't see any useful switches in the rrdgraph man page. Can anyone help with this?
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. #####################################################################################