Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Undo retention and tablespace size

Undo retention and tablespace size

From: Keysan <dont_at_mailme.com>
Date: Thu, 27 Oct 2005 01:12:50 +0200
Message-ID: <43600d2a$0$29554$4fafbaef@reader1.news.tin.it> 





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. 
Received on Wed Oct 26 2005 - 18:12:50 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US