Hey Jeremiah, add in something to the last paragraph about how using LMTs will obviate the problem in truncating tables with lots of extents :)
There really is NO reason to worry about large numbers of extents these days. I mean, I wouldn't want to really test the "unlimited" ability but other than that, there is no problem. --- Jeremiah Wilton <[EMAIL PROTECTED]> wrote: > Here's my swing at it: > > http://www.speakeasy.org/~jwilton/oracle/lots-of-extents.html > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > On Thu, 17 Jan 2002, Cunningham, Gerald wrote: > > > I'm trying to convince a client that multiple extents for a table > will not > > hurt their performance. It's a PeopleSoft app, and PeopleSoft is > telling > > them that they need to reorg any object with greater than 10 > extents (even > > indexes). This Oracle 8.1.6. > > > > I've referenced the "How to Stop Defragmenting and Start Living: > The > > Definitive Word on Fragmentation" white paper by Bhaskar > Himatsingka and > > Juan Loaiza of Oracle. That didn't convince them. I tried to > explain that > > Oracle reads BUFFERS and not extents, etc., but that didn't work. > > > > I'm about to open a vein. > > > > Does anybody have any references that they can point me to? > (Something from > > PeopleSoft would be ideal, though I would be suprised if it > existed.) I read > > a rant on somebody's web site a while back that was really good, > but alas I > > cannot remember his name or URL. (I blame my kids for my failing > memory). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jeremiah Wilton > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > 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). __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).