Home » RDBMS Server » Performance Tuning » difference between locking and disabling statistics (oracle10g)
difference between locking and disabling statistics [message #277353] Mon, 29 October 2007 13:37 Go to next message
Messages: 54
Registered: September 2005

can anyone brief me the difference between disabling the automatic statistics collection and locking the statistics.

Scenario 1:
Imagine I disabled the automatic statistics gathering for whole db and consider now I am collecting the statistics for the table manually. After collecting the statistics if I am not locking the statistics. Will it keep updating, eventhough I disabled the auto stats gathering?

Why I am asking is document says, statistics will keep updated if we are not locking the stats gathering, is it?

With Regards

Re: difference between locking and disabling statistics [message #277357 is a reply to message #277353] Mon, 29 October 2007 14:47 Go to previous message
Michel Cadot
Messages: 65143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you disable auto gathering, statistics are not automatically updated.
If you lock statistics, they are no more auto gathered.

Previous Topic: How to place many datafile on large tablespace?
Next Topic: Fragmented Tables
Goto Forum:

Current Time: Sat Aug 19 00:44:22 CDT 2017

Total time taken to generate the page: 0.20566 seconds