Re: multiple extents are OK, dagnabbit!

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: jwilton_at_speakeasy.net

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: ListGuru_at_fatcity.com (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).