Today we are going to have a look at steps we use for lock/unlock statistics on a table.

In the world of technology, we all love to work with one click. The way we DBAs would like to work in the same tradition as we know sometimes we may not want to analyze a table automatically and want it to analyze later manually where we are thinking data in the table does not change. In that case, we can lock the statistics gathering for a particular table.

means the table is not locked for gathering statistics.

The table status is locked now.

— Let try now to gather statistics on the locked table

— Let’s try now to gather statistics on the index using analyze

— unlock gathering statistics

— Now try to gather table statistics again

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.