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@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Jonathan Lewis
Sent: Wednesday, May 19, 2004 8:13 PM
To: oracle-l@(protected)
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@(protected) >
To: <oracle-l@(protected) >
Cc: <Paula_Stankus@(protected) >
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@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
