UNDO poll - was undo segments vs. rbs
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 May 2004 13:12:58 +0100
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
-----------------------------------------------------------------
Other related posts: