Shades of Channel Point :-)
If this is one of the Sams books, they are notoriously
inaccurate. A decent burial is the only answer.
- Jared.Still_at_radisys.com wrote:
> <RANT>
>
> I've just spent 30 minutes with our SAP
> administrator trying to
> convince her that we really don't need to reorganize
> the tables
> in our production SAP database.
>
> Due to some misinformation in an Oracle Press book,
> 'Oracle Unleashed'
> I think, she is equating number of extents with
> fragmentation.
>
> The text she referred me to is in fact discussing
> 'migrated rows' though
> that term is never used. She has become convinced
> that if the
> extents allocated for tables are not all in
> contigous space, some
> very nasty fragmentation will occur.
>
> I tried taking it down to disk and explaining that
> an OLTP system with
> hundreds of users won't really see much benefit from
> this, but she
> wasn't really ready for that. :)
>
> Her concern is that there are 29000 extents in an
> index tablespace.
> This might have something to do with there being
> 3400 indexes in
> said tablespace.
>
> Total 'wasted' ( honeycomb ) space in this 250 gig
> DB is < 20 meg. Not
> much to gain there.
>
> The text of the book states that you should expect a
> '10 to 20 percent
> performance increase' by reorganizing the
> tables/indexes. No data to
> back it up of course.
>
> This is on a database that performs very well most
> of the time, outside
> of a couple of custom reports that run too long. No
> complaints from
> users about slowness.
>
> Arrghhh!
>
> I just had to vent to the list, cuz there's no one
> here that understands.
>
> <\RANT>
>
> Jared
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: Jared.Still_at_radisys.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).
Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne_at_regence.com
Yahoo! - We Remember
Received on Tue Sep 10 2002 - 17:00:01 CDT