Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: (Fwd) TAR# 1280667.996:Can NT/Win2k server OS defrag uti

RE: RE: (Fwd) TAR# 1280667.996:Can NT/Win2k server OS defrag uti

From: Eric D. Pierce <>
Date: Mon, 12 Mar 2001 19:09:57 -0800
Message-ID: <>


I believe you, which helps, because I wasn't inclined to take Oracle tech support's word for it without them providing a more in depth explanation. I would guess that getting a more in depth explanation from them would be a bit of a wild goose chase.

1Gb data file sizes sounds good. Also, does it really make much difference one way of the other -performance wise- if you use huge cluster/allocation-unit sizes on the volume that contains the 1Gb db files?

I hope this last question isn't too painful, but how, if at all, does your defrag analysis change for NT (hardware) RAID?

profuse thanks,

On 12 Mar 2001, at 14:17, Paul Drake scribbled with alacrity and cogency:

Date sent:              Mon, 12 Mar 2001 14:17:38 -0800
To:                     Multiple recipients of list ORACLE-L <>

> Okay - before this one dies ... this incorporates my usual NT bias.
> So you have a new box - with newly created NTFS volume - lets assume JBOD

(,282033,,00.html?query=jbod )

> and no hardware RAID.
> They're empty. Completely.
> You create new tablespaces with multple datafiles, each equal to 1 GB so
> that your backup job can compress them without puking. I believe that its a
> safe assumption that these datafiles are on continguous tracks and blocks on
> the physical hard drives - with the actual layout varying depending upon the
> RAID configuration. You can even drop the datafiles from the database - just
> keep the file system files around for use later. (That REUSE switch in the
> datafile creation is quite handy).


> I'll agree that autoextend is convenient if you don't know the storage
> requirements.
> You can't really blame the OS for grabbing sectors that aren't contiguous,
> it its trying to (re)use vacated sections of the logical drive.

Please see the official ORACLE-L FAQ:
Author: Eric D. Pierce

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon Mar 12 2001 - 21:09:57 CST

Original text of this message