Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Stop defragmenting and start ...

Re: Stop defragmenting and start ...

From: Byron Pearce <pearceb_at_tenure.com>
Date: Thu, 10 Jun 2004 11:31:20 -0500
Message-ID: <40C88CD8.7090105@tenure.com>


My memory is a little hazy, but I thought there were two copies of the paper. The initial one talked about implementing uniform extents (128K/4M/128M) on dictionary-managed tablespaces under Oracle 7/8. Then, it was revised for 8i to implement those same uniform extents on LMT's.

DENNIS WILLIAMS wrote:

>Robyn
> I'm not sure what you are asking, so I may not be responding to your
>question. I don't recall the "Stop Defragmenting . . ." paper recommended
>anything other than LMT. After reading that paper, I was wondering which
>variety of LMT to use and I found a page on Oracle's Web site that stated
>that Oracle recommended LMT with uniform extents. Probably long disappeared.
>
>Dennis Williams
>DBA
>Lifetouch, Inc.
>dwilliams_at_lifetouch.com
>
>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Robyn
>Sent: Thursday, June 10, 2004 10:02 AM
>To: oracle-l_at_freelists.org
>Subject: Stop defragmenting and start ...
>
>
>Hello,
>
>Can someone tell me when uniform extent sizing became a recommended
>practice? The 'Stop defragmenting and Start Living' paper has a copyright
>date of 1998, and I remember implementing it on some databases back in
>1999, but I was wondering if it there were earlier references to this
>approach.
>
>Robyn
>
>----------------------------------------------------------------
>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
>-----------------------------------------------------------------
>----------------------------------------------------------------
>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
>-----------------------------------------------------------------
>
>
>
>

-- 
====================================================================
Byron Pearce                         mailto:pearceb_at_tenure.com
Tenure Systems, Inc.                 Dallas/Fort Worth, TX

"It's hard to be a ninja when you wear a beeper."



----------------------------------------------------------------
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 Thu Jun 10 2004 - 11:44:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US