JUST DELETE ROWS FROM DBA_ANALYZE_OBJECTS related to u'r object.

Thanks & Regards,
Vipin Jain
Good Judgment Comes From Experience. Experiences Comes From Bad Judgment

-----Original Message-----
From: Stan [SMTP:[Email Address Removed] Thursday, October 31, 2002 9:56 AM
To: LazyDBA.com Discussion
Subject: Re: Clear compute statistics

[Email Address Removed] wrote:

>how about "analyze table table_name drop statistics"...
>
>[Email Address Removed] Original Message -----
>From: "Puente Sharma" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Wednesday, October 30, 2002 9:46 PM
>Subject: Clear compute statistics
>
>
>Hi Guys,
>
>Is it possible to clear the statistics of a table. I have generated stat for
>a table by using analyze compute statistics command. Now I want to clear
>this stat.
>
>Thanks,
>Puente
>
>
>
>
>--------
>Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
analyze table table_name delete statistics should work.

--
hope this helps.
Stan




--------
Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page