Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: free space
> Is there any way Oracle can be steered to use the smallest free extent that
> is available and large enough for a new extent when one is needed? In
> stead of picking the largest one available?
Your question makes no sense to me. The size of a object's initial extent and next extent are either set in that object's storage clause or it uses the default values for the tablespace. Speaking as a DBA no one should ever build a table or index without an explicit storage clause. And you are usually better with larger extents as the performance degradation caused by large numbers of extents is very substantial.
Daniel A. Morgan Received on Wed Nov 11 1998 - 13:25:22 CST