ANALYZE TABLE <TABLENAME> DELETE STATISTICS
-----Original Message-----
From: Vipin Jain [mailto:vipin.[Email Address Removed] Thursday, October 31, 2002 6:50 AM
To: LazyDBA.com Discussion
Subject: RE: Clear compute statistics
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 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