Re: Fragmented vs. Contiguous vs. Single-extent segments

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Sat, 14 Apr 2001 11:53:15 GMT
Message-ID: <3ad83759.4426325@news-server>

On Sat, 14 Apr 2001 10:39:04 +0100, millerp_at_sql.org.uk (Paul Miller) wrote:

>
>Your comments are welcome.
>

Doesn't surprise me at all. I've been saying that defragging a database is completely useless since V7. And in V6, it wasn't really necessary provided the correct init.ora parameters were set.

But I'll let all the industrious dbas out there who defrag daily religiously continue to do their thing. It looks good in the resumes.

BTW, congratulations on your effort. Looks like you did a good job of pointing out the real problem that may be caused by fragmentation.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Sat Apr 14 2001 - 06:53:15 CDT