Re: UNDO poll - was undo segments vs. rbs
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 19 May 2004 22:50:35 +0800
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@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
>-----------------------------------------------------------------
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://web.singnet.com.sg/~hkchital
----------------------------------------------------------------
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:
