> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 30, 2003 12:50 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: RE: Separate Indexes and Data
> 
> 
> the defrag paper was written back in 1998 I believe. Uniform 
> extents were a good solution pre-9i. We use them here on our 

I haven't been following this thread closely, but why are uniform extents no
longer good for 9i?

> 8i databases. I stick with an uniform 5m extent size even 
> though I have tables that can fit into 128k extents, but feel 
> that the overall time savings by using 1 extent size makes up 
> for this.
>
> unfortunately unlike most systems we cannot break up our 
> tables into different tablespaces. We use transportable 
> tablespaces to batch publish data to data marts. New 
> tablespaces mean additional transportable tablespaces and 
> more places for stuff to go wrong. 
> 
> I saw some posts on dejanews recently from some pretty 
> experienced DBAs stating that there may be 'flaws' in 
> auto-allocate leading to poor extent sizes that leads to 

I don't believe it's a flaw, it's by design.  At least according to Tom
Kyte's new book (first chapter's on the web) it is, which is why I can't see
me using it for our DBs.

> fragmentation. I believe Rachel Carmichael made a post on 
> here a few months back with the similiar experience(could be 
> wrong). Due to even the 'small' chance of flaws in 
> auto-allocate, Im thinking of waiting for version 10g before 
> using it. Just to be safe. Not worth risking a defrag on a 
> production system. 

Rich

Rich Jesse                           System/Database Administrator
[EMAIL PROTECTED]                  Quad/Tech Inc, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Reply via email to