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: Looking for a good way to convert from dictionnary manged TBS to Locally managed ones

Re: Looking for a good way to convert from dictionnary manged TBS to Locally managed ones

From: Tom Barnes <nospam1978_at_yahoo.com>
Date: 20 Mar 2004 08:15:49 -0800
Message-ID: <5af28966.0403200815.1a800e91@posting.google.com>


"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<405a78c3$0$8355$afc38c87_at_news.optusnet.com.au>...
> It's been discussed here quite recently, with Richard Foote posting an
> interesting test demonstrating that autoallocate is extremely difficult to
> fragment, and is extremely smart about the way it allocates space to
> objects. I'm sure you could hunt for it on Google. It would be within the
> last two months.

I believe this is the thread you're referring to: http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=4017cf50.436085858%40news.demon.co.uk&rnum=1&prev=/groups%3Fq%3DSpace%2BUsage%2BQuestion%2Bgroup:comp.databases.oracle.server%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26group%3Dcomp.databases.oracle.server%26selm%3D4017cf50.436085858%2540news.demon.co.uk%26rnum%3D1

(or just search for 'Space Usage Question')

The conclusion however seems to be that using auto-allocate can result in fragmentation so sticking to ULMTs might be best?! Received on Sat Mar 20 2004 - 10:15:49 CST

Original text of this message

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