| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: UNDO poll - was undo segments vs. rbs
Jonathan,
Our other databases have similar results. Undo is using much less space than RBS. Our retention times are set to 3600 in the warehouse and 10800 in other databases.
Good idea about this poll. I'd be interested in other comments.
thanks
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Jonathan Lewis [mailto:jonathan_at_jlcomp.demon.co.uk]
Sent: Wednesday, May 19, 2004 8:13 AM
To: oracle-l_at_freelists.org
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/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
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.
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |