Re: separate data/inidex

"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.
> >

It will create the datafile in pieces all over the disk, not as a contiguous area. Any subsequent extensions will be created in a similar manner. Afraid we are back to the old VMS as far as NT (gee...since many of the VMS staff worked on NT do you thing there is a parallel?) defrag to improve performance. An example is that on my laptop I had been merrily going along adding, deleteing, creating datafiles, dropping them...then I defragged...it took seven runs through the defrag routine befor it was defragmented...even in areas where supposedly nothing had been written. Performance for all applicaitons including Oracle improved. Afraid it has reached that point once again, the drive light stays on more than the CPU activity light.

Yes, if you system is defragmented when you create the tablespaces and nothing is done to the disk to cause additional fragmentation, then it shouldn't be required, I will add to my comment, monitor and defrag the disks as needed.

Mike Received on Sun May 05 2002 - 10:25:40 CDT