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_at_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_at_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_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).
Received on Mon Sep 30 2002 - 09:28:31 CDT