Message-ID: <3D7CFFB1.D02C00AC@exesolutions.com> From: Daniel Morgan X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Rollback tablespace size References: <3d7cee7f.5017214@news.hccnet.nl> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 19 Date: Mon, 09 Sep 2002 20:08:59 GMT NNTP-Posting-Host: 156.74.250.7 X-Complaints-To: yvonne.tracy@ci.seattle.wa.us X-Trace: news-west.eli.net 1031602139 156.74.250.7 (Mon, 09 Sep 2002 14:08:59 MDT) NNTP-Posting-Date: Mon, 09 Sep 2002 14:08:59 MDT Organization: City of Seattle NewsReader Service 76434.1353@compuserve.com wrote: > What should be the size of the rollback tablespace datafile? > Is there a relation between the size of the rollback and the user > tablespace and or rollback segments? There is no simple answer to your question. One answer would be that it should be large enough to handle every simultaneously connected user running the largest SQL statement simultaneously such that each and every rollback segment becomes large enough to hold the transaction. Without knowing a lot of very specific information about the system it is impossible to say. My answer would be to ask if any problems currently exist. Daniel Morgan