Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: undo tablespace
David,
I would start with 11gb as my undo tablespace size. You may be over/under allocated, but that can be adjusted as time goes by. You can use multiple datafiles for the undo tablespace. The syntax is the same as the multiple file tablespace.
A word of warning, automatic undo is not a good choice for a high volume oltp system. What is the highest # of concurrent transactions and the average transaction duration & change (in bytes) for this db?
Regards,
Daniel Fink
"Ehresmann, David" wrote:
> I have a rollback segment tablespace that is 11Gb composed of 11 datafiles
> spread over 3 filesystems on hp in 8i. I am building a new 9i db for this
> instance and want to use an undo tablespace. I have created 9i dbs before
> with undo tbs. I have used/read about the retention period and size. But
> never anything of this size. I am taking this over from a previous dba. My
> question is if I have an 11Gb rbs tablespace what does that translate to in
> an undo tablespace? This is a claims processing database. Can you use
> multiple datafiles in an undo tablespace? I have never seen examples
> referenceed with multiple datafiles in an undo tablespace.
>
> thanks,
>
> David Ehresmann
>
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
-- 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 Thu Jul 22 2004 - 17:54:43 CDT
![]() |
![]() |