Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Warning: Built in 10g Stats gather is broken

Warning: Built in 10g Stats gather is broken

From: <mccmx_at_hotmail.com>
Date: 12 Oct 2006 01:06:51 -0700
Message-ID: <1160640411.450052.252320@b28g2000cwb.googlegroups.com> 





It looks as though Oracle's built in Stats gather process doesn't work.



The table change information that should be written to
USER_TAB_MODIFICATIONS isn't being updated correctly.  So when the
nightly job comes along to analyze the tables, it will miss some tables
because they don't appear in this view.  Beware.



Check out Bug 5557078 on Metalink.



It has been filed against 10.1 but we are having the same problem on
10.2.



How the hell did this test this functionality....!



Matt
Received on Thu Oct 12 2006 - 03:06:51 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US