Re: Should we stop analyzing?

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Tue, 30 Dec 2003 05:49:27 -0800
Message-ID: <F001.005DB436.20031230054927@fatcity.com>

we are using dbms_stats, "gather auto", "for all indexed columns" and estimate 15%

Now if my other DBA would just show up for work, I can ask him about this. Sometimes being the "early bird" has disadvantages.

I do know that when the analyze is not done, we have performance problems. Or at least the end-users complain about performance. Of course part of the problem is that they can do any sort of requests through the system, which turn into ad-hoc queries which end up returning enormous amounts of data. so they moan the database is too slow.

• Tanel Poder <tanel.poder.003_at_mail.ee> wrote:
  > > however Jonathan's point may well be the reason. This is an
  > > ever-growing database, frequent insert and updates, and sequences
  > are
  > > used throughout.
  > > Analyze is "estimate" at least.
  >
  > Or update HIVAL and DISTCNT and ROWCNT statistics using dbms_stats
  > regularly...
  >
  > Tanel.
  >
  >
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.net
  > --
  > Author: Tanel Poder
  > INET: tanel.poder.003_at_mail.ee
  >
  > 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!?
Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100_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).

Received on Tue Dec 30 2003 - 07:49:27 CST