RE: Defragmenting paper

From: <Zabair.Ahmed_at_natwest.com>
Date: Fri, 5 May 2000 09:22:25 +0100
Message-Id: <10488.105025@fatcity.com>

There are a couple of differences between the two papers:

The recommended extents sizes have changed from 160K, 5120K and 160M to 128K, 4K and 128M respectively.
And "Oracle7 will round all extent sizes to multiple of five blocks" has been taken out of the revised paper.

On the second point i have seen this statement several times in various documentation but haven't found this to be true.

Any thoughts??

Zabair
-----Original Message-----
From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us] Sent: 04 May 2000 17:35
To: Multiple recipients of list ORACLE-L Subject: Re: Defragmenting paper

Here are the original and an updated version altho I don't see much new in the updated one... HTH ruth

Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, May 04, 2000 11:18 AM

May I have it.
TIA -----Original Message-----
Sent: Tuesday, May 02, 2000 3:01 PM
To: Multiple recipients of list ORACLE-L Cc: tranc_at_recralab.com

Scott Shafer sent me an Adobe file with the paper 'How to Stop Defragmenting 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).

Internet Headers: Start =============================================

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
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="iso-8859-1" Content-Transfer-Encoding: 7bit

Internet Headers: End ===============================================

--
Author: Tran, Chieu Minh
  INET: tranc_at_recralab.com

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).
---------------------------------------------------------------------------
The contents of this e-mail may be privileged and are confidential.  It may not be disclosed to or used by anyone other than the addressee(s), nor copied in any way.  If received in error, please advise the sender, then delete it from your system.
National Westminster Bank Plc is regulated by the Personal Investment Authority and IMRO for investment business. A member of the NatWest and Gartmore Marketing Group advising on the life assurance, pensions and unit trust products only of that Marketing Group.
Registered Office: 41 Lothbury London EC2P 2BP
Registered Number: 929027 England

Received on Fri May 05 2000 - 03:22:25 CDT