Is possible know, how many time will take run statistics on a table?

User_APT8X

Hi all,

Im looking for run a statistics on a big table 300Gb, exist one method to know how many time will take it? i don´t know like EXPLAIN PLAN FOR

regards

JohnWatson2

dbms_stats.gather_% does populate v$session_longops, so if you let it run for a few minutes you will get an idea of how long it will take.

Billy Verreynne

Gravity. According to the Theory of Relativity, gravity curves spacetime and slows down time.

So the bigger the table is, the more disks used, means more mass, increased gravity, and an increase in slowing down of time reading data from this table.

Now excuse me - am looking at my full hot coffee mug loosing mass as it cools down and looses energy. Fascinating...

User_GSQTY

DBA_OPTSTAT_OPERATION_TASKS  should give you that information.