hit
metalink...there are things there....
-----Original Message-----
From: Cunningham, Gerald [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 17, 2002 4:46 PM
To: Multiple recipients of list ORACLE-L
Subject: 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
