Re: Negative numbers in undo advisor

Chuck wrote:
> Anyone else seen this or have a fix for it? In the 10g Grid Control
> (10.2.0.1) when connecting to a 9.2 database, I am seeing negative
> numbers in the undo advisor. Click link below if you want to see the
> actual image.
>
> http://mysite.verizon.net/hampal/charts.gif
>
> Also tried to use the 9i EM console and the undo advisor there is not
> even showing the "maximum undo rate" line, presumably because it too is
> trying to display a negative # but the 9i undo advisor doesn't go below 0.

Are you in archivelog mode? I've noticed my test db which is in noarchivelog mode doesn't show the maximum or current lines, while my prod db does. The testdb shows about -200M /minute for maximum rate (I've been testing some ETL in it), retention set for 3 hours. I'm using 9i EM standalone.

jg

--
@home.com is bogus.
http://www.monkeychops.karoo.net/mistertweakathon.html