For example, you execute:
SQL> EXECUTE dbms_stats.gather_dictionary_stats;
PL/SQL procedure successfully completed.
Check progress with:
SQL> select sofar, totalwork,units,start_time,time_remaining,message
from v$session_longops
where opname = 'Gather Dictionary Schema Statistics';
SOFAR TOTALWORK UNITS START_TIM TIME_REMAINING MESSAGE
---------- ---------- -------------------- --------- -------------- ------------------------------------------------
423 423 Objects 03-JUN-14 0 Gather Dictionary Schema Statistics: Dictionary Schema : 423 out of 423 Objects done
No comments:
Post a Comment