SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Check stale table and run gather stats in loop

curious_mindMay 11 2020 — edited May 11 2020

Hi All,

I have a requirement where i need to check before our nightly batch begins to check all the stale table and run a loop to run gather stats on all of those stale tables. Could you please help me with the same.

Database version we are using is 12c.

This post has been answered by BEDE on May 11 2020

Jump to Answer

Added on May 11 2020

2 comments

1,277 views