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
