RE: extent allocation
- From: "Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Jun 2004 10:32:26 -0700
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
