RE: Defragmenting paper

From: Tran, Chieu Minh <tranc_at_recralab.com>
Date: 4 May 2000 09:43:00 -0400
Message-Id: <10487.104925@fatcity.com>

May I have it.
TIA -----Original Message-----

From: 	ORACLE-L_at_fatcity.com [mailto:ORACLE-L_at_fatcity.com]
Sent:	Tuesday, May 02, 2000 3:01 PM
To:	Multiple recipients of list ORACLE-L
Cc:	tranc_at_recralab.com
Subject:	Defragmenting paper

Scott Shafer sent me an Adobe file with the paper 'How to Stop Defragmentin= g
and Start Living: The Definitive Word on Fragmentation' and I will be glad to forward same to anyone who wants it.

Ruth B. Gramolini
ORACLE DBA
VT Dept. of Taxes
ph# 802.828.5708
fax# 802.828..3754
rgramolini_at_tax.state.vt.us

--
Author: Ruth Gramolini
INET: rgramolini_at_tax.state.vt.us

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).

=3D=3D=3D=3D=3D Internet Headers: Start =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D

Received: from 63.74.90.24

          by recralab.com;
          TUE, 2 May 2000 15:01:55 -0400
Received: from newsfeed.cts.com ([209.68.192.199]) by mail.bee.net
          (Post.Office MTA v3.5.3 release 223 ID# 0-52106U5000L500S0V35)
          with ESMTP id net for <tranc_at_recralab.com>;
          Tue, 2 May 2000 15:09:19 -0400
Received: from fatcity.UUCP (uucp_at_localhost)
	by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id LAA87685;
	Tue, 2 May 2000 11:59:49 -0700 (PDT)

Received: by fatcity.com (02-Mar-2000/v1.0f-b68/bab) via UUCP id 00156420; = Tue, 02 May 2000 11:30:47 -0800
Message-ID: <F001.00156420.20000502113047_at_fatcity.com> Date: Tue, 02 May 2000 11:30:47 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> X-Comment: Oracle RDBMS Community Forum
X-Sender: "Ruth Gramolini" <rgramolini_at_tax.state.vt.us> Sender: root_at_fatcity.com
Reply-To: ORACLE-L_at_fatcity.com
Errors-To: ML-ERRORS_at_fatcity.com
From: "Ruth Gramolini" <rgramolini_at_tax.state.vt.us> Subject: Defragmenting paper
Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0f, build 68; ListGuru (c) 1996-2000 Bruce A. Bergman Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset=3D"iso-8859-1" Content-Transfer-Encoding: 7bit

=3D=3D=3D=3D=3D Internet Headers: End =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

From: "Ruth Gramolini" <rgramolini_at_tax.state.vt.us> Date: Thu, 4 May 2000 10:12:56 -0400
Subject: 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

Received on Thu May 04 2000 - 08:43:00 CDT