This discussion is archived
5 Replies Latest reply: Jan 8, 2009 5:43 AM by 591186 RSS

Oracle 10g - lock statistics

458312 Newbie
Currently Being Moderated
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.

Please share your experience.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points