RE: extent allocation
- From: "Ron Rogers" <RROGERS@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Jun 2004 08:22:03 -0400
I would have to say that extent size does matter but depends on what you
are placing in the tablespace. Why would you want to have 100 M extents
when the tablespace will contain table that are small such as 4 K. When
the tablespace has to increase in size it will consume a lot of space
just for a small table. 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.
I think that it is better to plan the database layout and keep like
sized object in a like sized tablespace as much as possible.
I prefer to use the uniform extent size method as it allows me to plan
the disk layout and future growth capabilities for the disks. With
autoallocate the growth pattern looks logarithmic and increases in size
dramatically as the number of extend increases.
Ron
>>> Jacques.Kilchoer@xxxxxxxxx 06/22/2004 9:20:18 PM >>>
I don't think anyone is going to argue AGAINST uniform extent
allocation. However, some people have argued AGAINST autoallocate.
If you made all tablespace uniform no one would be able to say you
made
the wrong choice.
The next question is, what size should you make your uniform extents?
A: Since number of extents is irrelevant (this also seems to be the
consensus on this list), then I would say that the extent size doesn't
really matter either.
-----Original Message-----
Harvinder Singh
It will be great if you can point me to articles/white papers
explaining
advantages/disadvantages of using autoallocate/uniform extent
allocation
for LMT
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
