Undo definitely takes bigger space. Maybe its because of our application. Add disk space and forget about it seems to be the mantra. regards srinivasan.v -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jonathan Lewis Sent: Wednesday, May 19, 2004 8:13 PM To: oracle-l@xxxxxxxxxxxxx Subject: UNDO poll - was undo segments vs. rbs I'd be interested in a quick poll. Your case is the first time I've heard of undo space being less than rollback space. Every other comment I've heard has been along the lines of why has my 1GB rbs t/s grown to 12GB when I switched to undo t/s. So - out of three options: Undo much bigger Undo much smaller No significant change noticed Would people like to contribute. I've changed the subject heading to isolate the poll. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated May 1st ----- Original Message ----- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Cc: <Paula_Stankus@xxxxxxxxxxxxxxx> Sent: Wednesday, May 19, 2004 1:05 PM Subject: RE: undo segments vs. rbs Paula, In our warehouse, we had a RBS tablespace of 25Gig. After conversion to Undo, the Undo Tablespace was reduced to 6 Gig - and I personally think it could be much smaller. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------