RE: extent allocation

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 23 Jun 2004 10:32:26 -0700
Message-ID: <B5C5F99D765BB744B54FFDF35F60262109F8791B@irvmbxw02>

Mr. Rogers, I agree with most of what you say, but this statement of yours seems to me to be something that has often been disputed on this list, with some people opining that number of extents doesn't matter, and in a multi-user system the IO system will be serving multiple disk requests anyway.

-----Original Message-----

Ron Rogers

On the other hand if the tablespace extent size is small and the table extents are large and numerous there most likely will be a lot of disk thrashing to get the data as the extents could be all over the disk and not contiguous.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Wed Jun 23 2004 - 12:29:12 CDT