Re: find tables/indexes with locked stats
Date: Tue, 4 Dec 2007 12:55:40 -0800 (PST)
Message-ID: <a2980bc2-f8c2-4032-aa7a-529e611d6734@r60g2000hsc.googlegroups.com>
On Dec 4, 3:17 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> On Nov 20, 11:06 am, Ben <bal..._at_comcast.net> wrote:
>
> > 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'.
>
> Did you think about patching to 10.2.0.3 .... there are a ton of
> things whacko with 10.2.0.2.
>
> We are running 10.2.0.3 on all systems currently ... and hoping to see
> 10.2.0.4 soon.
I wanted to go straight to 10.2.0.3 but we are bound by JDE/PeopleSoft/ Oracle ERP compatibility. Received on Tue Dec 04 2007 - 14:55:40 CST