Paul,
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,
ep
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 <[EMAIL PROTECTED]>
> 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
(
http://whatis.techtarget.com/WhatIs_Search_Results_Exact/1,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: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
