undo tablespace

From: Ehresmann, David <David.Ehresmann_at_ps.net>
Date: Thu, 22 Jul 2004 17:04:45 -0500
Message-ID: <27C3FCA54F61C34389325FD99A0D60CC080D85@pscdalpexch50.perotsystems.net>

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

---

Received on Thu Jul 22 2004 - 17:02:54 CDT