From Ethan.Post@ps.net Thu, 17 Jan 2002 15:47:41 -0800 From: "Post, Ethan" Date: Thu, 17 Jan 2002 15:47:41 -0800 Subject: RE: multiple extents are OK, dagnabbit! Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: Message Search Tom Kytes asktom.oracle.com and there is also paper at hotsos.com.  Also check out http://www.speakeasy.org/~jwilton/oracle/lots-of-extents.html.    - Ethan    -----Original Message-----From: Cunningham, Gerald [mailto:Gerald.Cunningham@usi.net]Sent: Thursday, January 17, 2002 3:46 PMTo: Multiple recipients of list ORACLE-LSubject: multiple extents are OK, dagnabbit! Hi there -   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).     Thanks!   - Jerry