So, did you bend to her wishes? ltiu
[EMAIL PROTECTED] 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: ltiu INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
