Re: Question about V$SYSMETRIC *FUTURE* dated rows
Date: Wed, 7 Jan 2009 21:05:23 +0100
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.
On Wed, Jan 7, 2009 at 8:39 PM, Taylor, Chris David
> 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_at_ingrambarge.com