RE: dbms_stats

From: Jesse, Rich <Rich.Jesse_at_qtiworld.com>
Date: Thu, 04 Dec 2003 07:34:42 -0800
Message-ID: <F001.005D8CB2.20031204073442@fatcity.com>

Yes. At least I was before reverting back to ANALYZE. For our little 30GB DB, there's little penalty for non-parallel stats gathering on Saturdays. Then again, one could ANALYZE multiple tables at once to regain some parallelism in stats gathering...

Rich

Rich Jesse                           System/Database Administrator
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

-----Original Message-----
Sent: Wednesday, December 03, 2003 10:19 PM To: Multiple recipients of list ORACLE-L

Rich, I went thru the archives. Are you using the option 'cascade=>true' for gather_table_stats?

-----Original Message-----
Jesse, Rich
Sent: Wednesday, December 03, 2003 4:21 PM To: Multiple recipients of list ORACLE-L

Yes -- same platform and version. If you look on the list archives
(fatcity.com, for example) for a subject of "Burned by DBMS_STATS **AGAIN**"
back in April 2003, you may get some insight.

There are also known bugs in GATHER_SCHEMA_STATS in 8i. The recommendation is to iteratively call GATHER_TABLE_STATS.

GL!

Rich

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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 Thu Dec 04 2003 - 09:34:42 CST