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" <[EMAIL PROTECTED]> 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: [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).
