RE: UNDO poll - was undo segments vs. rbs

From: Thomas Jeff <jeff.thomas_at_thomson.net>
Date: Wed, 19 May 2004 08:20:02 -0500
Message-ID: <358728A276824E419580403633AABFD0021F619D@INDYSMAIL03.am.thmulti.com>

The same amount or slightly less in all of our supply chain/BI databases.
>From an admin POV, we're very happy with AUM.

We've yet to convert two big OLTP hitters, both still sitting in 8.1.7.4 due to 3rd-party app constraints. I'm curious as to how well these=20 databases, with typically heavy concurrent transactional activity, will play=20
with AUM, due to the bottleneck of everything funneling through one UNDO

tablespace.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jonathan Lewis Sent: Wednesday, May 19, 2004 7: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

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 -----=20 From: "Mercadante, Thomas F" <thomas.mercadante_at_labor.state.ny.us> To: <oracle-l_at_freelists.org> Cc: <Paula_Stankus_at_doh.state.fl.us> 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_at_freelists.org 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_at_freelists.org
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
-----------------------------------------------------------------

Received on Wed May 19 2004 - 08:17:15 CDT