oracle 0829
Fri Aug 29 13:23:59 UTC 2008
Fri Aug 29 13:23:59 UTC 2008
SQL> select object_name, count(*) from dba_procedures
where owner='SYS' and object_name like 'DBMS%'
group by object_name
order by object_name
SQL> exec dbms_stats.gather_table_stats( ownname varchar2, tabname varchar2, partname varchar2, estimate_percent number);
mado