Re: Whitepaper on Extents

Steve,
What is your opinion of their advice to move tables which go to more that 1024 extents into their own tablespace. I have only one table which is this big on our production database.

Thanks as always for any advice,
Ruth
----- Original Message -----
From: Steve Adams <steve.adams_at_ixora.com.au> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, May 04, 2000 8:05 AM
Subject: RE: Whitepaper on Extents

> Hi All,
>
> In my opinion, the "How to stop defragmenting ..." paper goes too far in
> its rejection of the single extent myth. There are several reasons why
> hundreds of extents are bad news. Have a look at my web tip on "Planning
> Extents" for details.
>
> Regards,
> Steve Adams
> http://www.ixora.com.au/
> http://www.oreilly.com/catalog/orinternals/
> http://www.christianity.net.au/
>
>
> -----Original Message-----
> From: Walter K. [SMTP:alden14004_at_yahoo.com]
> Sent: Tuesday, May 02, 2000 5:26 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Whitepaper on Extents
>
> Does anyone know where I can get the whitepaper that discusses the issue
of
> whether or not having multiple extents is a good or bad thing? I saw a
post
> from November that said where to find it but the document is not there.
>
> Thanks.
> -w
> << File: ATT00002.htm >>
> --
> Author: Steve Adams
> INET: steve.adams_at_ixora.com.au
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu May 04 2000 - 09:12:56 CDT