Message-ID: <F001.005D9B0B.20031212082433@fatcity.com>
Date: Fri, 12 Dec 2003 08:24:33 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: ml-errors@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: Barbara Baker <barbarabbaker@yahoo.com>
Subject: RE: rebuilding indexes - sure to cause a ruckus
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

You probably think you're joking.
Unfortunately . . .

We've been fighting with Oracle for several months
about SEVERE performance degradation on an OpenVMS
application after we upgraded the database to 8.1.7.4

One of Oracle's recommendations taken directly from
our TAR just 2 weeks ago:

o Ensure tables and indexes have as few extents as
possible.

sigh...

Barb


--- "Bobak, Mark" <Mark.Bobak@il.proquest.com> wrote:
> I think this subject has been done to death.  We
> should talk about less contentious issues such as:
> 
>  - The buffer cache hit ratio, your friend in expert
> Oracle tuning!
>  - Rebuild your tables regularly to reduce the
> number of extents and improve performance!
>  - Disk access is at least 10,000x slower than
> memory, to tune your database, eliminate physical
> I/O!
> 
> Anyone else got and good ones? ;-)
> 
> -Mark
> 
> -----Original Message-----
> Sent: Wednesday, December 10, 2003 5:24 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> > BTW, does anyone know what a rocket scientist
> refers to when 
> > they say "Hey,
> > this is all quite easy, it sure ain't ?????" ?
> > 
> > Cheers ;)
> > 
> > Richard
> 
> Surely the Rocket Scientist version must be "Hey,
> this is all quite easy, it sure ain't index
> rebuilding"
> 
> <very evil grin>
> 
> Ciao
> Fuzzy
> :-)
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Grant Allen
>   INET: Grant.Allen@towersoft.com.au
> 
> Fat City Network Services    -- 858-538-5051
> http://www.fatcity.com
> San Diego, California        -- Mailing list and web
> hosting services
>
---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru@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).
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Bobak, Mark
>   INET: Mark.Bobak@il.proquest.com
> 
> Fat City Network Services    -- 858-538-5051
> http://www.fatcity.com
> San Diego, California        -- Mailing list and web
> hosting services
>
---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru@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!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Barbara Baker
  INET: barbarabbaker@yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@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).