Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_stats for schema and all tables
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=>'GATHER
> 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
-- Sybrand Bakker Senior Oracle DBAReceived on Wed Mar 28 2007 - 05:33:47 CDT