Online Tutorials & Training Materials | STechies.com
Register Login

Any Script to Check the Status of Gather stats of a Table/Schema in Percentage (%).

|| || 3

Any Script to Check the Status of Gather stats of a Table/Schema in Percentage (%).
Stechies

Hello Experts,

Please update me if anybody have any script to check the status of gather stats of a table/schema in percentage (%).

Kindly share your valuable views as soon as possible. This is very urgent.

Thanks in advance.


Comments

  • 07 Sep 2015 5:51 pm Helpful Answer

    I am aware of a script called COE_STATS.sql which generates a dynamic script called COE_FIX_STATS.sql which has a list of tables which require statistics to be refreshed. We can check this script before gathering the stats to get an idea of the number of tables requiring stats refresh. Following this post.

  • 07 Sep 2015 5:53 pm Helpful Answer

     EXEC DBMS_STATS.GATHER_SCHEMA_STATS('username');

  • 07 Sep 2015 5:54 pm

    Will it give the already running status of Gather Stats in % that how much it completes.