Hi,

This script will generate an analyze command :

select 'Analyze table ' || owner || '.' || SUBSTR(SEGMENT_NAME,1,40)
|| ' estimate statistics ; '
from DBA_SEGMENTS
where segment_type = 'TABLE' and owner = 'XXXX'
order by segment_name;

Noraldino.

quigleyd wrote:

>I need to run statics on a bunch of tables, what is the best way to do it?
>unfortunally this is a windows env.
>
>Also what is the command to run from the command line.
>
>
>
>----------------------------------------------------------------
>This message was sent using IMP, the Internet Messaging Program.
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
>
>



Oracle LazyDBA home page