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

From: Edgar Chupit <>
Date: Wed, 7 Jan 2009 21:05:23 +0100
Message-ID: <>

Hi Chris,

We had same issue with Oracle 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

On Wed, Jan 7, 2009 at 8:39 PM, Taylor, Chris David <> 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:

Received on Wed Jan 07 2009 - 14:05:23 CST

Original text of this message