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_at_optusnet.com.au
----------------------------------------------------------------
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 Fri Jun 11 2004 - 04:35:42 CDT
