Re: Effects of framentation

crumedgeon wrote:

> The funny thing is people think of oracle attached to san the same as
> their pc with one drive and M$ disk defrag. Try to explain the SAME SAN
> config to these people (usually management) and the fact that, even with one
> extent on the SAN, you're on many disks with many controllers, and
> your "single scan, one read pass through" is actually hitting several
> different physical platters. It's actually enough to blow their minds.
>
> But, they enjoy the pretty pictures (OEM Tablespace map) of one
> "contiguous" extent. Go figure.
>

And there, perhaps, you have identified one of the factors that makes otherwise good DBAs and developers turn to the dark side ... management. ;-)

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)