Hey Jeremiah, add in something to the last paragraph about how using
LMTs will obviate the problem in truncating tables with lots of extents
:)
There really is NO reason to worry about large numbers of extents these
days. I mean, I wouldn't want to really test the "unlimited" ability
but other than that, there is no problem.
- Jeremiah Wilton <jwilton_at_speakeasy.net> wrote:
> 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).
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
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).
Received on Fri Jan 18 2002 - 08:05:15 CST
