Niall and Nuno, Excellent responses! So, I can add filesystems to the list of reasons (i.e. memory restrictions, lack of CPUs, etc) to stay away from Windows... :-) Thanks! -Tim on 2/10/04 3:13 AM, Nuno Souto at dbvision@xxxxxxxxxxxxxxx wrote: > ----- Original Message ----- > From: "Niall Litchfield" <n-litchfield@xxxxxxxxxxxxxxxxxxxxxxx> >> >> Yes, NTFS is most definitely susceptible to fragmentation - in the sense > th= >> at a single datafile may get split into multiple pieces all over the shop. > = >> If you have an NT based laptop take a look at the disk using the disk > defra= >> gmenter in administrative tools (you can just run an analyze and not > actual= >> ly do any defragmenting).=20 > > > And these things, like most others in NTFS, are fully configurable. > For those interested, I do recommend reading the FULL description > of the "fsutil" command. New in XP, I believe it was there > in W2K Pro and ES but undocumented. It allows you to trim/control/configure > most of these file system parameters. > > Some are VERY relevant to Oracle. > > This is an interesting tech note in the M$ website: > http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol > /winntas/maintain/optimize/instant.asp > > watch out for wrapping, try this if all else fails: > http://tinyurl.com/27sgv > > And of course, don't forget: > http://tinyurl.com/elct > if you REALLY want to bump up those DFMBR read sizes for FTS! > This last one also has a bearing on the minimal portion/fragment > that a file can be split into at create time, although I've only > seen that described outside of M$ (undoco?). > > > Don't forget one very important thing: BY DEFAULT, NTFS is configured > to provide optimal "file server" functionality. > That's HEAPS of SMALL files, in the Queen's language. > > Nothing could be more removed from the reality of Oracle db files: > FEW, VERY LARGE files. > > So, be prepared for heaps of tuning/configuring. And for Pete's sake > (or any other of Pete's drinks that turn you on), do NOT create Oracle > database files in anything other than a freshly formatted NTFS > partition!!!!! > > To their credit, M$ nowadays provides incredible amounts of doco of good > to very good quality in their site. That was not always the case... > > > > > Or, take the easy way out: install 10g, give it unformatted (raw) > partition(s) to manage and be done with all these problems. > (and if you believe that, you're really brave...) > :D > > Cheers > Nuno Souto > in sunny Sydney, Australia > dbvision@xxxxxxxxxxxxxxx > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------