Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Storage parameters
"Maxim Demenko" <mdemenko_at_gmail.com> wrote in message
news:d5ge8r$6nq$03$1_at_news.t-online.com...
> Hi,
> basically, the advantage of LMT is not only elimination of fragmentation
> , but much more efficient resource management - i.e. information of free
> /used extents is no more keeped in the datadictionary ( basically tables
> in sys schema ), but in the bitmap, so all changes can be processed
> more quicker... From the extent size point of view it does not matter -
> you set it manually ( but always, by every segment ) to 64K extent size
> (DMT) or let it do the database (LMT with uniform size ) - i would
> prefer the job to be done by the database of course ;-)
>
> Exp/imp inherit the extent size and recalculate it to the appropriate
> amount of uniform extents ( if compress=y as per default, then you get
> initial equal to current size of your segment), and it takes effect by
> creation of tables through imp (if you not use precreated tables) , the
> further allocation will be influenced by tablespace extent size
> (whatever , system or uniform ).
>
> But all that staff is excellent given in the Tom Kyte's Effective Oracle
> by Design pp 221 - 226 , exactly the things you are asking about,
> so , i would highly recommend.
>
> Best regards
> Maxim
Maxim, thank you very much for clarifying that for me. That helps me out a great deal.
It would seem that I need to buy another one of Tom's books.
Regards,
Randy Harris
Received on Fri May 06 2005 - 14:19:03 CDT