RE: multiple extents are OK, dagnabbit!

Search Tom Kytes
asktom.oracle.com and there is also paper at hotsos.com.  Also check out <A
href="http://www.speakeasy.org/~jwilton/oracle/lots-of-extents.html">http://www.speakeasy.org/~jwilton/oracle/lots-of-extents.html. 
<FONT

face="Courier New"> 
-
Ethan
<SPAN

class=470355622-17012002> 
<SPAN

class=470355622-17012002> -----Original Message-----From: Cunningham, Gerald [mailto:Gerald.Cunningham_at_usi.net]Sent: Thursday, January 17, 2002 3:46 PMTo: Multiple recipients of list ORACLE-LSubject: multiple extents are OK, dagnabbit!
Hi there -

<FONT face=Arial

size=2> 
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.
<FONT face=Arial

size=2> 
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.
<FONT face=Arial

size=2> 
I'm about to open a
vein.
<FONT face=Arial

size=2> 
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).
<FONT face=Arial

size=2> 
<FONT face=Arial

size=2> 
<FONT face=Arial

size=2>Thanks!
<FONT face=Arial

size=2> 
-
Jerry Received on Thu Jan 17 2002 - 17:47:41 CST