Why not use dbms_stat procedure?? What version of Oracle is this??

D

-----Original Message-----
From: Noraldino Mourão Pedrosa [mailto:oracledba-ezmlmshield-x84881223.[Email address protected]
Sent: 31 August 2006 17:08
To: LazyDBA Discussion
Subject: Re: running statics

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
>
>
>
>
>
>
>




---------------------------------------------------------------------
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







This e-mail (and any attachments) contains information, which is confidential and intended solely for the attention and use of the named addressee(s). If you are not the intended recipient you must not copy, distribute or use it for any purpose or disclose the contents to any person. If you have received this e-mail in error, please notify us immediately at [Email address protected] The information contained in this e-mail (and any attachments) is supplied in good faith, but the sender shall not be under any liability in damages or otherwise for any reliance that may be placed upon it by the recipient. Any comments or opinions expressed are those of the originator not of NTT Europe Ltd unless otherwise expressly stated.

Oracle LazyDBA home page