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 -> avg_row_len=0 non-stale tables and partitions seen as stale

avg_row_len=0 non-stale tables and partitions seen as stale

From: <bdurrettccci_at_yahoo.com>
Date: 5 Jan 2007 11:45:04 -0800
Message-ID: <1168026303.950248.45710@11g2000cwr.googlegroups.com> 





This is probably just a bug but I thought I'd run it by you.



Have you ever seen avg_row_len come out 0 from a table with a bunch of
data in it?  The real row length is about 300.  Also, Oracle's
automatic stats job (we are on 10.1.0.4) keeps gathering stats on this
table over and over again every night even though it isn't stale.  I.e.
if you do a list stale it doesn't show up that way.



I have a ticket in with Oracle but I thought I'd put it out there.  I
appreciate any help.




Received on Fri Jan 05 2007 - 13:45:04 CST












Original text of this message













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