Path: imp.nntpserver.com!newsfeed-west.nntpserver.com!newsfeed-east.nntpserver.com!nntpserver.com!213.73.101.75!eusc.inter.net!fu-berlin.de!uni-berlin.de!not-for-mail From: Marc Blum Newsgroups: comp.databases.oracle.server Subject: Re: avoiding tablespace fragmentation Date: Sun, 06 Jun 2004 15:46:35 +0200 Lines: 25 Message-ID: References: Reply-To: blum@marcblum.de Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: news.uni-berlin.de TRxcLw6BrLpVVuTx4kLDvQ6gvWs0U2rF7Vl3JexcWxkYkwVbCX X-Newsreader: Forte Agent 1.93/32.576 English (American) Xref: newsfeed-west.nntpserver.com comp.databases.oracle.server:220065 On 6 Jun 2004 05:26:14 -0700, yls177@hotmail.com (yls177) wrote: >is it true that as long as i dont drop/truncate tables, then there >will be no tablespace fragmentation provided that i set my storage >parameters at tablespace level as the below > >1) initial extent=next extent >2) pctincrease 0 > >thanks 1) RTFM everything about Locally Managed Tablespaces 2) check this newsgroup and http://asktom.oracle.com regarding LMTs, fragmentation, uniform size etc. 2) use LMTs in your databases 3) stop worrying about fragmentation -- Marc Blum mailto:blumNOSPAM@marcblum.de http://www.marcblum.de