Re: Help with tablespace sizing.

From: Karl R. <kreitsch_at_zdnetonebox.com>
Date: 2000/05/18
Message-ID: <0360959c.bf52f575@usw-ex0105-034.remarq.com>#1/1

My Solution for an Oracle 7.x-Server was an S, M, L, XL -Tablespace for data and index with speicified storage.

For Objects growing over 1G i defined a seperate tablespace for each Object.

In Oracle 8.1.x i the handling of pctincrease hs improved that the increase is not in dirctly in extents but in logical storage units, so fragmentation will have no chance!

Bye

Karl Reitschuster
Senior Consultant CSC Ploenzke AG
Oracle Databases, Implementation, Performance-Tuning <!Jesus is Lord!>
* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free! Received on Thu May 18 2000 - 00:00:00 CDT