yes, if you have your extends all over your tablespace (and maybe even over
several datafiles -whether or not on the same disk device), then your should
defragment your tables. Consider your OS I/O buffer (I believe on NT it is
64 Kb), your db_block_size and db_file_multiblock_read_count. With your
degree of fragmentation you can get an idea about the extra number of I/O
needed in fragmented tables vs. defragmented tables
Bill Buchan wrote in message <7osb59$ss0$1_at_phys-ma.sol.co.uk>...
>Hi,
>
>I have an Oracle 8.0.4 database on WinNT. The datafiles are all on RAID-5.
>Some of my segments have got seriously fragmented with dozens of extents
all
>over their tablespace. Is it still worth defragmenting these given that
the
>hardware will stripe this data all over the place anyway?
>
>I have a lot of queries that do full scans of the fragmented segments.
>
>Any advice would be much appreciated.
>
>Thanks,
>
>- Bill.
>
>
>
Received on Thu Aug 12 1999 - 06:37:47 CDT
