Home » RDBMS Server » Server Administration » Delete stats gather stats (11.1.0.7)
Delete stats gather stats [message #566232] Tue, 11 September 2012 21:13 Go to next message
sathik123
Messages: 37
Registered: December 2010
Location: chennai
Member
Hi Team,

During STATS gather running for the table, unknowingly i deleted the old stats using EXEC DBMS_STATS.DELETE_TABLE_STATS. I would like to know will it affect the stats gather job currently running for the table and whether my stats will be gathered successfully.

Thanks
amsathk
Re: Delete stats gather stats [message #566233 is a reply to message #566232] Tue, 11 September 2012 22:06 Go to previous messageGo to next message
BlackSwan
Messages: 26759
Registered: January 2009
Location: SoCal
Senior Member
>whether my stats will be gathered successfully.
Let us know the results after the job completes.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: Delete stats gather stats [message #566239 is a reply to message #566232] Tue, 11 September 2012 23:51 Go to previous messageGo to next message
Michel Cadot
Messages: 67745
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes it will affect and yes they will be gathered but as BlackSwan said the best way to know is to just at them after the job will be (or has been now) executed.
Let us know.

Regards
Michel
Re: Delete stats gather stats [message #566529 is a reply to message #566239] Mon, 17 September 2012 02:08 Go to previous messageGo to next message
sathik123
Messages: 37
Registered: December 2010
Location: chennai
Member
I dont see problem deleting the old stats while current stats run, My stats gather went successful, last_analyzed column updated for the table. and also performance of the query on the table is very much improved. Query time came down to 5 second from 2min.
Re: Delete stats gather stats [message #566530 is a reply to message #566529] Mon, 17 September 2012 02:09 Go to previous messageGo to next message
sathik123
Messages: 37
Registered: December 2010
Location: chennai
Member
Thanks for your valuable time
Re: Delete stats gather stats [message #566873 is a reply to message #566530] Thu, 20 September 2012 09:39 Go to previous message
sathik123
Messages: 37
Registered: December 2010
Location: chennai
Member
As per my recent analysis we deleted the stats gather before oracle update its internal table or temporary tablespace usage. I thing we have deleted stats when oracle collect the sample data from table. Thanks for your valuable time
Previous Topic: sqlplus.exe accidentally deleted
Next Topic: ASM DISKGROUP RESIZE
Goto Forum:
  


Current Time: Mon Mar 01 13:48:20 CST 2021