Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ora-1652 on *undo* tablespace?
Chuck wrote:
> Anurag Varma wrote:
> > > 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.
Mea culpa. That was a different ora-1555 error. The next one after the ora-1652 says that the query ran for only 10 seconds. I find that very hard to believe given the retention period configured (3h) and the amount of unexpired undo extents at the time (2.5g). I think I am probably hitting one of those v9.2 undo bugs that someone else mentioned. Received on Thu Mar 08 2007 - 10:18:54 CST