OraFAQ Forum: Server Administration » Delete stats gather stats

Home » RDBMS Server » Server Administration » Delete stats gather stats (11.1.0.7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Delete stats gather stats [message #566232]

Tue, 11 September 2012 21:13

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

Report message to a moderator

Re: Delete stats gather stats [message #566233 is a reply to message #566232]

Tue, 11 September 2012 22:06

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/

Report message to a moderator

Re: Delete stats gather stats [message #566239 is a reply to message #566232]

Tue, 11 September 2012 23:51

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

Report message to a moderator

Re: Delete stats gather stats [message #566529 is a reply to message #566239]

Mon, 17 September 2012 02:08

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.

Report message to a moderator

Re: Delete stats gather stats [message #566530 is a reply to message #566529]

Mon, 17 September 2012 02:09

sathik123
Messages: 37
Registered: December 2010
Location: chennai

Member

Thanks for your valuable time

Report message to a moderator

Re: Delete stats gather stats [message #566873 is a reply to message #566530]

Thu, 20 September 2012 09:39

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

Report message to a moderator

Previous Topic:	sqlplus.exe accidentally deleted
Next Topic:	ASM DISKGROUP RESIZE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

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