Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: fragmentation

Re: fragmentation

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 25 Nov 2004 20:48:19 +0100
Message-ID: <41a63605$1$27308$626a14ce@news.free.fr>

"vertigo" <ax178_at_wp.pl> a écrit dans le message de news:co5bp9$cjo$2_at_atlantis.news.tpi.pl...
> Hello
>
> How can i check what is maximal size of extent which i can put into
> specified tablespace ? (i create table with stotage initial values).
>
> Are there any perespectives which 'shows' me fragmentation level ?
> How can i correct fragmentation ?
>
> Thanx
> Michal
>

Use LMT (Locally Managed Tablespace) and don't bother with table fragmentation.

-- 
Regards
Michel Cadot
Received on Thu Nov 25 2004 - 13:48:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US