Anurag Varma wrote:
>
> This is strange. So according to you the active extents showed up as
> 1M
> and oracle returns an out of space error?
> Is this a RAC instance?
> How is undo tablespace created? LMT or DMT?
> Are the datafiles in undo tablespace set to autoextend?
> What was the transaction running? A big insert/update/delete?
>
> It just seems like a bug that you find active undo segments using
> only 1M of space in a 7G tablespace and get an out of space error?
>
> Try checking metalink for bugs related to AUM in 9i.
>
> Anurag
>
Not RAC - single instance. I am thinking it's a bug too. Especially
after seeing in the alert log that the ora-1555 that appeared a while
later says the query duration was over 37 years.
Received on Thu Mar 08 2007 - 09:24:03 CST
