RE: rebuilding indexes - sure to cause a ruckus

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Fri, 12 Dec 2003 09:09:28 -0800
Message-ID: <F001.005D9B18.20031212090928@fatcity.com>

Ouch.....

Suddenly, it seems not so funny....

-----Original Message-----
Sent: Friday, December 12, 2003 11:25 AM To: Multiple recipients of list ORACLE-L

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_at_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_at_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_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).
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.net
  > --
  > Author: Bobak, Mark
  > INET: Mark.Bobak_at_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_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!?
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_at_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_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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bobak, Mark
  INET: Mark.Bobak_at_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_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 Dec 12 2003 - 11:09:28 CST