Re: dbms_stats for schema and all tables

On 28 Mar, 12:33, "sybrandb" <sybra..._at_gmail.com> wrote:
> On Mar 28, 12:04 pm, "Andrea" <netsecur..._at_tiscali.it> wrote:
>
>
>
> > hi,
> > i use dbms_stats for retrieve statisctics information for all tables
> > of my 9i db, but when i use this command:
>
> > EXEC
> > DBMS_STATS.GATHER_schema_STATS(ownname=>'TIV',CASCADE=>TRUE,options=>'GATHE­R
> > STALE')
>
> > i don't find statistics in dba_tables (the field LAST_ANALYZED is
> > empty).
> > What i can do for have statistics of all tables of database?
>
> > thanks very much.
>
> > bye
> > Andrea
>
> Did you ever run a 'normal' GATHER? GATHER STALE will work only if
> a) monitoring has been enabled on the affected tables (alter table
> <blah> monitoring)
> b) there are statistics present
>

ops.. thanks! Received on Wed Mar 28 2007 - 07:50:52 CDT