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: IMP/EXP accross platforms: What will be missing?

Re: IMP/EXP accross platforms: What will be missing?

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: Fri, 7 Nov 2003 18:24:28 +1100
Message-ID: <3fab489e$1$9221$afc38c87@news.optusnet.com.au>


"Rick Denoire" <100.17706_at_germanynet.de> wrote in message news:asilqvcdabpit7hi62nsaib5d9pkelhqgk_at_4ax.com...

> Unix-like operating systems usually do not need defragmentation
> software (as long as the filesystem won't be used in heavy write
> operations at a persistent high capacity level of over 90%).

Know why? Because they use the same bitmap allocation scheme that Oracle now uses in LMT. And they have done so for nearly 30 years. There is a lesson to be learned there for LMT in Oracle.

> issuing write operations, they try to find a chunk of free space that
> still accomodates data, while Windows for example chooses the first
> pieces it finds regardless of their size.

Not quite true. NTFS does not choose the first piece it finds. It's a lot more elaborate than that. Get hold of Helen's book, it explains how all that works in NTFS in detail. Some of it has not been implemented by M$, but most is there in the Enterprise Server versions of Windoze. Which are COMPLETELY different from consumer Windows in terms of how they handle data.

> concerned. After all, one can defragment a vfat partion (perhaps a
> NTFS one too) by just moving all files out and back, *one by one*.

Oh no you cannot. Not NTFS. Try it. Not even with the consumer version.

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
Received on Fri Nov 07 2003 - 01:24:28 CST

Original text of this message

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