Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Should I Defragment on RAID?

Should I Defragment on RAID?

From: Bill Buchan <bill.buchan_at_ossian.net>
Date: Wed, 11 Aug 1999 18:16:59 +0100
Message-ID: <7osb59$ss0$1@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,




Received on Wed Aug 11 1999 - 12:16:59 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US