Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!luth.se!newsfeed1.bredband.com!bredband!diablo.netcom.net.uk!netcom.net.uk!194.159.246.34.MISMATCH!kibo.news.demon.net!news.demon.co.uk!demon!jlcomp.demon.co.uk!not-for-mail From: "Jonathan Lewis" Newsgroups: comp.databases.oracle.server Subject: Re: separate data/inidex Date: Sun, 5 May 2002 08:41:09 +0100 Message-ID: <1020584466.4135.0.nnrp-08.9e984b29@news.demon.co.uk> References: <3cbf2607$0$15182$626a54ce@news.free.fr> <1391a36e.0204210411.c3a275@posting.google.com> <37fab3ab.0205041701.508e934e@posting.google.com> <3cd49058$0$15474$afc38c87@news.optusnet.com.au> NNTP-Posting-Host: jlcomp.demon.co.uk X-NNTP-Posting-Host: jlcomp.demon.co.uk:158.152.75.41 X-Trace: news.demon.co.uk 1020584466 nnrp-08:4135 NO-IDENT jlcomp.demon.co.uk:158.152.75.41 X-Complaints-To: abuse@demon.net X-Newsreader: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Lines: 41 Xref: easynews comp.databases.oracle.server:145918 X-Received-Date: Sun, 05 May 2002 00:39:49 MST (news.easynews.com) Can either of you explain your comment about defragmenting discs. Since a typical Oracle installation creates its data file just once and never deleted, moves or extends/shrinks them, your comment tends to suggest that NT updates a block within a file by copying it do a different location on the disc and redirecting the directory map. Surely that can't be true ! -- Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Nuno Souto wrote in message <3cd49058$0$15474$afc38c87@news.optusnet.com.au>... >In article <37fab3ab.0205041701.508e934e@posting.google.com>, you said > >> I also suggest on systmes that allow it, but especially NT, disks be >> defragmented on a frequent basis for heavily updated disks. However, >> RAID should not require this. > >Yes, most definitely. But this has to do with NT itself, not Oracle. >