| 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
I have seend UNDO growing very quickly when running large jobs with a high
UNDO_RETENTION.
With RBS I could set Optimal, then Shrink and then unset Optimal or,
easier, Offline, Drop and Create.
With Undo and undo_retention of 1 hour, sometimes I have to wait for a day
or so till I find
that I can shrink the Undo Tablespace datafile down [or create a new Undo
TBS, Drop and Create !]
Hemant
At 08:12 PM Wednesday, you wrote:
>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_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
>-----------------------------------------------------------------
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://web.singnet.com.sg/~hkchital
-- 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 - 09:48:41 CDT
 |
 |