Re: separate data/inidex

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 5 May 2002 08:41:09 +0100
Message-ID: <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_at_news.optusnet.com.au>...


>In article <37fab3ab.0205041701.508e934e_at_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.

>

Received on Sun May 05 2002 - 02:41:09 CDT