RE: GC metrics for plugin not rolling up
- From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
- To: "'rjoralist@xxxxxxxxxxxxxxxxxxxxx'" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>, 'Oracle L' <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 25 Aug 2009 10:54:41 -0500
For what its worth, alot of my metrics are 1/1/1900 for my monitored Oracle dbs.
When it comes to creating a plugin, I've never done that, so I wish I could
help :)
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor@xxxxxxxxxxxxxxx
CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and
may also be privileged. If you are not the named recipient, please notify the
sender immediately and delete the contents of this message without disclosing
the contents to anyone, using them for any purpose, or storing or copying the
information on any medium.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Rich Jesse
Sent: Tuesday, August 25, 2009 10:52 AM
To: 'Oracle L'
Subject: RE: GC metrics for plugin not rolling up
Hey Chris,
I think you're on the right track, because LAST_METRIC_LOAD_TIME is NULL and
ROLLUP_TIMESTAMPS are '01/01/1900' for my targets.
These targets are from a homegrown SQL Server plugin (can't justify the Oracle
plugin cost), so it seems likely that the problem's on my end or there's a step
I missed.
Just looking at MGMT$TARGET_METRIC_COLLECTIONS, I see that my collections and
metrics have a 1-1 relationship, whereas the Oracle DB default has many metrics
per collection. I have a sneaking suspicion that I have my metrics defined
incorrectly for GC to properly roll them up. Checking on that...
Thanks much for your help, Chris!
Rich
> I had a similar problem.
>
> Do you have 10.2.0.3 databases you are monitoring? (I couldn't tell
> from your email)
>
> There's a bug in 10.2.0.3 where the Metric Collection Timestamps get
> future dated. Once these roll into GC, the last rollup timestamp gets
> future dated inside GC and no more rollups occur.
>
> Really annoying.
>
> Anyway, query MGMT$TARGET and look at the LAST_METRIC_LOAD_TIME and
> see if you have any future dated rows.
>
> Also check MGMT_TARGET_ROLLUP_TIMES and see if any ROLLUP_TIMESTAMPS
> are > sysdate.
>
> Usually any future dated rows will appear as 2010, or 2011.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
