Message-ID: <F001.004DC5E9.20020930062831@fatcity.com>
Date: Mon, 30 Sep 2002 06:28:31 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: Rachel Carmichael <wisernet100@yahoo.com>
Subject: RE: datafile sizing question
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I haven't seen any papers.. I was told this (4096 is the exact number)
in an Internals class.

However, there are lots of papers out there saying multiple extents are
not a problem, and you should be able to find them on the web.


--- "Jamadagni, Rajendra" <Rajendra.Jamadagni@espn.com> wrote:
> Rachel,
> 
> Are there any studies or papers that test and explain this new magic
> 4000
> extents number? My manager is excited about LMT, but no so excited
> about
> number of extents. So, if there is a good paper, I can make him feel
> happy
> about this ...
> 
> Thanks in advance
> Raj
> ______________________________________________________
> Rajendra Jamadagni		MIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't reflect that of
> ESPN Inc.
> 
> QOTD: Any clod can have facts, but having an opinion is an art!
> 
> 
> -----Original Message-----
> Sent: Monday, September 30, 2002 7:03 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> with evenly sized extents, there is no such thing as fragmentation
> anymore
> and Oracle can deal with objects with numbers of extents up to about
> 4000
> before it starts to slow down a bit.
> >
*********************************************************************This
> e-mail message is confidential, intended only for the named
> recipient(s) above and may contain information that is privileged,
> attorney work product or exempt from disclosure under applicable law.
> If you have received this message in error, or are not the named
> recipient(s), please immediately notify corporate MIS at (860)
> 766-2000 and delete this e-mail message from your computer, Thank
>
you.*********************************************************************1
> 


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: wisernet100@yahoo.com

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: ListGuru@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).