RE: extent allocation

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 22 Jun 2004 18:20:18 -0700
Message-ID: <B5C5F99D765BB744B54FFDF35F60262119FC2C@irvmbxw02>

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_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 Tue Jun 22 2004 - 20:17:12 CDT