[Orca-users] no data displayed
Normandin, Mike
mike.normandin at csfb.com
Thu Dec 1 06:58:29 PST 2005
rrd does roll-up the data and you lose granularity I'm not sure what the roll-up will be for the 1 hour interval you are using. A couple options for looking back.
I sometimes use the RRD explorer tool - packages/rrdtool-1.0.50/contrib/rrdexplorer and graph the rrd files dynamincally at the interval you need. Still lose some graularity but better than looking at monthly quarterly orca graphs.
Use the rotate graphs facility. contrib/rotate_orca_graphs - this eats-up disk space.
Keep the raw input files in gz format on disk or archive to tape - I use a couple cheap SATA drives & keep 1 years worth. You can use orcallator_column to mine specific dates and times.
Mike
-----Original Message-----
From: Regee, Ashish [mailto:aregee at seic.com]
Sent: Wednesday, November 30, 2005 5:34 PM
To: Normandin, Mike; orca-users at orcaware.com
Subject: RE: [Orca-users] no data displayed
Thanks Mike that worked. A secondary question, if we need to drill down to the hourly grain of data for a week back, is there any option through orca/rrd. Does rrd loose the hourly grain on the following day ?
-----Original Message-----
From: Normandin, Mike [mailto:mike.normandin at csfb.com]
Sent: Wed 11/30/2005 4:02 PM
To: Regee, Ashish; orca-users at orcaware.com
Cc: Lewis, Daniel
Subject: RE: [Orca-users] no data displayed
What does the group entry in the orcallator.cfg have ? Specifically make sure the interval matches whats in the raw file - it should be 3600 for 1 hour samples.
mike
-----Original Message-----
From: orca-users-bounces+mike.normandin=csfb.com at orcaware.com
[mailto:orca-users-bounces+mike.normandin=csfb.com at orcaware.com]On
Behalf Of Regee, Ashish
Sent: Wednesday, November 30, 2005 11:34 AM
To: orca-users at orcaware.com
Cc: Lewis, Daniel
Subject: [Orca-users] no data displayed
Standard (out of the box) orca graphs on this Sun Server are working
A secondary effort to extract oracle stats stored in OEM repository and display this via orca is not.
These custom plots are showing no data, though all the output files seem to be created
here is the raw file created in /apps/orca/var/orcallator/dgwmppe1.seic.com
timestamp locltime timespan logonsps logonspt
1133308800 00:00:00 3600 0.45 1.39
1133312400 01:00:00 3600 0.45 4.30
1133316000 02:00:00 3600 0.45 4.54
1133319600 03:00:00 3600 0.44 4.93
1133323200 04:00:00 3600 0.45 5.51
1133326800 05:00:00 3600 0.44 5.84
1133330400 06:00:00 3600 0.44 5.32
1133334000 07:00:00 3600 0.45 4.88
1133337600 08:00:00 3600 0.45 4.87
1133341200 09:00:00 3600 0.45 5.24
Here is the entry from the orcallator.cfg
plot {
title %g Logons Count
source orcallator
data logonspt
data logonsps
legend Logons / tran
legend Logons / sec
line_type area
line_type line2
y_legend Count
data_min 0
plot_min 0
}
the following files exists in
/apps/orca/var/html/orcallator/dgwmppe1.seic.com
o_dgwmppe1.seic.com_gauge_logonspt,__logonsps-daily.png
o_dgwmppe1.seic.com_gauge_logonspt,__logonsps-daily.png.meta
o_dgwmppe1.seic.com_gauge_logonspt,__logonsps-hourly.png
o_dgwmppe1.seic.com_gauge_logonspt,__logonsps-hourly.png.meta
o_dgwmppe1.seic.com_gauge_logonspt,__logonsps-monthly.png
o_dgwmppe1.seic.com_gauge_logonspt,__logonsps-monthly.png.meta
o_dgwmppe1.seic.com_gauge_logonspt,__logonsps-quarterly.png
o_dgwmppe1.seic.com_gauge_logonspt,__logonsps-quarterly.png.meta
o_dgwmppe1.seic.com_gauge_logonspt,__logonsps-weekly.png
o_dgwmppe1.seic.com_gauge_logonspt,__logonsps-weekly.png.meta
o_dgwmppe1.seic.com_gauge_logonspt,__logonsps-yearly.png
o_dgwmppe1.seic.com_gauge_logonspt,__logonsps-yearly.png.meta
the following files exists in
/apps/orca/var/rrd/orcallator/o_dgwmppe1.seic.com
gauge_logonsps.rrd
gauge_logonspt.rrd
The orcallator_column output works and is as follows
orcallator_column -c logonspt -c logonsps /apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 00:00:00 5.04 0.45
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 01:00:00 4.89 0.45
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 02:00:00 4.60 0.45
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 03:00:00 5.31 0.44
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 04:00:00 4.86 0.45
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 05:00:00 4.60 0.45
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 06:00:00 4.25 0.45
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 07:00:00 4.07 0.44
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 08:00:00 4.56 0.45
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 09:00:00 4.93 0.45
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 10:00:00 4.92 0.45
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 11:00:00 5.32 0.45
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 12:00:00 4.49 0.45
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 13:00:00 4.80 0.45
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 14:00:00 5.08 0.45
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 15:00:00 4.55 0.45
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 16:00:00 4.68 0.45
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 18:00:00 5.46 0.45
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 19:00:00 3.99 0.45
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 20:00:00 1.91 0.45
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 21:00:00 4.55 0.45
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 22:00:00 3.80 0.44
/apps/orca/var/orcallator/dgwmppe1.seic.com/orcallator-2005-11-29-000 23:00:00 2.59 0.45
Machine locltime logonspt logonsps
The rrd output is, and shows no data
/var/tmp/orca-snapshot-r497/packages/rrdtool-1.0.50/src/rrdtool dump /apps/orca/var/rrd/orcallator/o_dgwmppe1.seic.com/gauge_logonsps.rrd | head -50
<!-- Round Robin Database Dump -->
<rrd>
<version> 0001 </version>
<step> 300 </step> <!-- Seconds -->
<lastupdate> 1133341200 </lastupdate> <!-- 2005-11-30 04:00:00 EST -->
<ds>
<name> Orca19990222 </name>
<type> GAUGE </type>
<minimal_heartbeat> 600 </minimal_heartbeat>
<min> 0.0000000000e+00 </min>
<max> NaN </max>
<!-- PDP Status -->
<last_ds> UNKN </last_ds>
<value> 0.0000000000e+00 </value>
<unknown_sec> 0 </unknown_sec>
</ds>
<!-- Round Robin Archives -->
<rra>
<cf> AVERAGE </cf>
<pdp_per_row> 1 </pdp_per_row> <!-- 300 seconds -->
<xff> 5.0000000000e-01 </xff>
<cdp_prep>
<ds><value> NaN </value> <unknown_datapoints> 0 </unknown_datapoints></ds>
</cdp_prep>
<database>
<!-- 2005-11-21 20:05:00 EST / 1132621500 --> <row><v> NaN </v></row>
<!-- 2005-11-21 20:10:00 EST / 1132621800 --> <row><v> NaN </v></row>
<!-- 2005-11-21 20:15:00 EST / 1132622100 --> <row><v> NaN </v></row>
<!-- 2005-11-21 20:20:00 EST / 1132622400 --> <row><v> NaN </v></row>
<!-- 2005-11-21 20:25:00 EST / 1132622700 --> <row><v> NaN </v></row>
<!-- 2005-11-21 20:30:00 EST / 1132623000 --> <row><v> NaN </v></row>
<!-- 2005-11-21 20:35:00 EST / 1132623300 --> <row><v> NaN </v></row>
<!-- 2005-11-21 20:40:00 EST / 1132623600 --> <row><v> NaN </v></row>
<!-- 2005-11-21 20:45:00 EST / 1132623900 --> <row><v> NaN </v></row>
<!-- 2005-11-21 20:50:00 EST / 1132624200 --> <row><v> NaN </v></row>
<!-- 2005-11-21 20:55:00 EST / 1132624500 --> <row><v> NaN </v></row>
<!-- 2005-11-21 21:00:00 EST / 1132624800 --> <row><v> NaN </v></row>
<!-- 2005-11-21 21:05:00 EST / 1132625100 --> <row><v> NaN </v></row>
<!-- 2005-11-21 21:10:00 EST / 1132625400 --> <row><v> NaN </v></row>
<!-- 2005-11-21 21:15:00 EST / 1132625700 --> <row><v> NaN </v></row>
<!-- 2005-11-21 21:20:00 EST / 1132626000 --> <row><v> NaN </v></row>
<!-- 2005-11-21 21:25:00 EST / 1132626300 --> <row><v> NaN </v></row>
<!-- 2005-11-21 21:30:00 EST / 1132626600 --> <row><v> NaN </v></row>
<!-- 2005-11-21 21:35:00 EST / 1132626900 --> <row><v> NaN </v></row>
<!-- 2005-11-21 21:40:00 EST / 1132627200 --> <row><v> NaN </v></row>
<!-- 2005-11-21 21:45:00 EST / 1132627500 --> <row><v> NaN </v></row>
_______________________________________________
Orca-users mailing list
Orca-users at orcaware.com
http://www.orcaware.com/mailman/listinfo/orca-users
==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.csfb.com/legal_terms/disclaimer_external_email.shtml
==============================================================================
==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.csfb.com/legal_terms/disclaimer_external_email.shtml
==============================================================================
More information about the Orca-users
mailing list