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.
Received on Tue Dec 04 2007 - 14:17:16 CST
