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" <jonathan_at_jlcomp.demon.co.uk> wrote in message
news:1020584466.4135.0.nnrp-08.9e984b29_at_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 - 05:54:03 CDT
