Can Table Stats be Stale even after locking its statistics?

Few day back i was asked by one of my friends, does the stats gets stale even after its locked? To put it in another words, after locking the table stats using LOCK_TABLE_STATS, does oracle mark the stats as STALE after heavy DML is done the particular table? SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- … Continue reading Can Table Stats be Stale even after locking its statistics?