Oracle table statistics are Stale(locked) for many of the tables in Oracle 19c.
Oracle table statistics are Stale(locked) for many of the tables in Oracle 19c.
As a temporary solution , unlocked all table stats & ran gather table stats for all the stats unlocked tables.
Please let me know the reason for this behaviour . Due to this, gather table stats are not happening, it will indirectly impacts DB performance.