Re: Stop defragmenting and start ...

On 06/10/2004 09:44:47 PM, Connor McDonald wrote:
> I've got a newsgroup exchange saved from Tom Kyte around 1995/1996 suggesting lots of equally
> sized extents, the only caveat being to make them quite large since 'maxextents unlimited' did not
> exist yet.

There was such a recommendation in the first edition of Guy Harrison's book, back there in 1998. Harrison took the whole thing a bit further and suggested separate tablespaces for small, medium, large, XL and XXL objects, thus separating objects by size, rather then functionally. This recommendation is still basically sound, except in the RAC environment, where you want related objects accessed from the same node and being in the same tablespace, to minimize handling of tablespace headers.

-- 
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
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
-----------------------------------------------------------------