Re: Tough Question: Optimizing Oracle8i(8.1.6) on Nt server

If you are really keen on defrag tools, you need only defrag the discs once before creating the database files. Oracle database files are pre-created, so not subject to subsequent filesystem fragmentation effects.

(Unless you have autoextend files, of course, but then you have much bigger problems than a simple defrag performance hit).

Also, any disc which holds Oracle datafiles really ought to be dedicated to Oracle datafiles, which is another reason why fragmentation is irrelevant.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Darrell Cooley wrote in message <39BD336B.8D2FA48D_at_med.unc.edu>...


>What is the best way to keep check on fragmented

>files and to defrag hard disk with Oracle8i

>(8.1.6) on

>NT 4.0 server?  Also, is there any problems with

>using a

>NT defrag software such as Norton Speed Disk or

>Diskeeper 5.0?