5 Replies Latest reply: Jan 8, 2009 7:43 AM by 591186 RSS

    Oracle 10g - lock statistics

    458312
      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.