Keysan wrote:
> Situation:
>
> Oracle 9.2.0.1 with undo_retention=10800 but with a 2GB size limit for the
> undo tablespace with no autoextend.
>
> As far as i know, with 10800 the undo tablespace could grown to around 10GB
> but i'm not sure. I need to know if this is clearly a wrong setup (imho it
> is) or could be an acceptable situation in some scenarios.
>
> Thanks heap in advance.
What is more important to you? 8GB of disk or an undo retention time
sufficient to avoid problems?
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Oct 26 2005 - 19:20:05 CDT
