Re: ORA-01555 error

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Tue, 06 Dec 2005 02:45:55 GMT
Message-ID: <Xns9723BF0515FB2SunnySD@70.168.83.30>

bdbafh_at_gmail.com wrote in
news:1133810219.639911.191790_at_z14g2000cwz.googlegroups.com:

> Automatic undo management is not without bugs, even in 10.1.0.4.
> Just last Friday, I saw a case of a single user system with 593 undo
> segments online.

So what inherent badness results from 593 undo segments? Please quantify with a reproducable test case.

What is a "reasonable" number of undo segments? Please quantify with a reproducable test case. Received on Mon Dec 05 2005 - 20:45:55 CST