What are the different situations in which Oracle will lock existing table/index statistics automatically?
As per my undrstanding to lock the statistics we must use "dbms_stats" package with lock_table_stats/lock_schema_stats procedures. I dont see any other situation where Oracle automatically locks the statistics.
I dont see any other situation where Oracle automatically locks the statistics.
Oracle never locks the statistics on its own. Oracle has only given methods so that one can decide whether to collect the statistics for volatile/static tables; so that the execution plans do not change drastically.
I have a situation where table statistics are locked but I am not sure how and who has locked it? If we assume that there is no way oracle can lock the statistics automatically, is there any way to find who has locked the statistics and when?