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 -> dbms_stats for schema and all tables

dbms_stats for schema and all tables

From: Andrea <netsecurity_at_tiscali.it>
Date: 28 Mar 2007 03:04:41 -0700
Message-ID: <1175076281.082969.136850@n76g2000hsh.googlegroups.com> 





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
Received on Wed Mar 28 2007 - 05:04:41 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US