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@(protected) >
>To: <oracle-l@(protected) >
>Cc: <Paula_Stankus@(protected) >
>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@(protected)
>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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
