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 -> find tables/indexes with locked stats

find tables/indexes with locked stats

From: Ben <balvey_at_comcast.net>
Date: Tue, 20 Nov 2007 08:06:24 -0800 (PST)
Message-ID: <a8e26e50-42c7-4a9c-999d-b418e9663df7@v4g2000hsf.googlegroups.com> 





10.2.0.2 Ent Ed AIX5L



Can someone direct me to a sql statement to use in finding tables with
locked stats? I'm aware of dba_tab_statistics.stattype_locked but I'm
not real sure what it is telling me.



I just queried a table that I thought was locked and it showed 'null',
then I gathered stats on that table and now queried again and it shows
'ALL'.

Received on Tue Nov 20 2007 - 10:06:24 CST












Original text of this message













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