Re: Stop defragmenting and start ...

  • From: Nuno Souto <dbvision@xxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 11 Jun 2004 19:38:53 +1000

Mladen Gogala allegedly said,on my timestamp of 11/06/2004 2:35 PM:

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.

And of course some were talking about this long before GH. http://tinyurl.com/2anl3 But let's not consider the Usenet a source of good info, by all means.


-- Cheers Nuno Souto in sunny Sydney, Australia dbvision@xxxxxxxxxxxxxxx ---------------------------------------------------------------- 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 http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------

Other related posts: