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