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).
