RE: Stop defragmenting and start ...
- From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 10 Jun 2004 13:52:35 -0400
To shed a bit more light on the timing of the papers, here is the abstract
from the second version:
ABSTRACT
Fragmentation is an issue of great concern to database administrators.
Oracle has a multitude of commands, options, views,
and statistics that address various aspects of fragmentation, but it is not
obvious how these capabilities should be used on a
day-to-day basis. There is also a great deal of partial information,
obsolete information, and misinformation that has been
published on this subject that can confuse and frustrate administrators.
Most of this material was written before Oracle7
release 7.3 became available and commonly used. New functionality in Oracle7
release 7.3 reduces fragmentation issues and
allows different techniques to be used that are both simpler and more
effective. This paper describes Oracle's capabilities
related to fragmentation and gives concrete and specific advise on how these
capabilities should be applied.
This paper is targeted at an audience of experienced database
administrators. It is based on Oracle7 release 7.3 and also
covers new features introduced in Oracle8 version 8.0.
HTH,
Ruth
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Robyn
Sent: Thursday, June 10, 2004 1:38 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Stop defragmenting and start ...
Thank you everyone. I figured the concept had been around a while before I
heard of it, although I still remember the 'Eureka' moment when I stumbled
across the paper several years ago.
I'm negotiating to get uniform LMT's implemented at my current gig, but
converting the other dba's is more work than converting the objects. Today
I'm working on document explaining this 'radical' new idea, and needed
some evidence that it's been around for a while now.
Robyn
On Thu, 10 Jun 2004, Lex de Haan wrote:
> Robyn,
>
> I quickly checked my courseware archives,
> and for sure Cary Millsap talked about uniform extent sizes in 1996.
> to be more precise: he probably talked about this even before 1996,
> but my private collection does not contain any hard evidence :-)
>
> Kind regards,
> Lex.
>
> ---------------------------------------------
> visit my website at http://www.naturaljoin.nl
> ---------------------------------------------
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Robyn
> Sent: Thursday, June 10, 2004 16:02
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
