Path: news.easynews.com!easynews!cyclone.swbell.net!cyclone-sf.pbi.net!216.218.192.242!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: "Sybrand Bakker" Newsgroups: comp.databases.oracle.server Subject: Re: separate data/inidex Date: Sun, 5 May 2002 12:54:03 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: "Sybrand Bakker" 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> <1020584466.4135.0.nnrp-08.9e984b29@news.demon.co.uk> X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 X-Complaints-To: newsabuse@supernews.com Lines: 59 Xref: easynews comp.databases.oracle.server:145923 X-Received-Date: Sun, 05 May 2002 04:16:20 MST (news.easynews.com) And if you routinely set all your datafiles to autoextend? (Not that I think that is a good idea) Regards -- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail address "Jonathan Lewis" wrote in message news:1020584466.4135.0.nnrp-08.9e984b29@news.demon.co.uk... > > 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. > > > > >