Re: Windows defrag with 10g

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 22 Aug 2007 21:37:33 +0200
Message-ID: <fai39j$41s$1@news2.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Adam Sandler wrote:
> Hello,
>
> Someone asked a question the other day for which we didn't necessarily
> have an answer. Someone was concerned about low level OS processes
> 10g can execute and if a defrag was run on the drive hosting the
> database (using Windows Server 2003 R2), would that interfere in any
> way with what Oracle is doing. What's your take?
>
> Thanks!
>

Don't!
- - defragmentation is hyped.
- - defragmentation only works when files get fragmented. Files only get fragmented when size changes a lot. Upon creation of a datafile, oracle writes one contiguous file. Only with autoextending files, fragmentation would be possible.

Even when fragmented, the internal references know where to locate the data.

I doubt you can come up with measurable results after defragmentation.

-- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGzJB9Lw8L4IAs830RAna/AKCKWFWVaACM6TREqIVg6rcT8Dd9YgCeOW+E lSM/ivKch0GbxR4+/jkSZ9c=
=ouLf
-----END PGP SIGNATURE----- Received on Wed Aug 22 2007 - 14:37:33 CDT