[Orca-users] no data displayed
Regee, Ashish
aregee at seic.com
Wed Nov 30 14:33:44 PST 2005
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
==============================================================================
More information about the Orca-users
mailing list