Re: Question about V$SYSMETRIC *FUTURE* dated rows

  • From: "Edgar Chupit" <chupit@xxxxxxxxx>
  • To: Chris.Taylor@xxxxxxxxxxxxxxx
  • Date: Wed, 7 Jan 2009 21:05:23 +0100

Hi Chris,

We had same issue with Oracle 10.2.0.2 RAC on Windows, more than a
year ago. The only solution that worked for some time was restarting
an instance. Unfortunately, Oracle was not able to come up with proper
solution in timely manner and in the end we've just decided not to use
GC for this database.

I've opened TAR and it was confirmed to be a bug 6612959 or similar,
like 5880921 and I belive, that they are not fixed completely even to
this day.

If you will be able to find solution to this nasty issue, could you be
so kind to share it.

Best regards,
 Edgar Chupit
 callto://edgar.chupit



On Wed, Jan 7, 2009 at 8:39 PM, Taylor, Chris David
<Chris.Taylor@xxxxxxxxxxxxxxx> wrote:
> Any of you guys ever run into the problem with 10.2.0.x databases having the
> V$SYSMETRIC tables future dated??   This causes Grid Control no problem of
>
> Just curious if any of you have found a way to clear the V$SYSMETRIC tables
> without restarting the DB.

> Chris Taylor
> Sr. Oracle DBA
> Ingram Barge Company
> Nashville, TN 37205
> Office: 615-517-3355
> Cell: 615-354-4799
> Email: chris.taylor@xxxxxxxxxxxxxxx
>
--
//www.freelists.org/webpage/oracle-l


Other related posts: