how to find dbms_stats progress in 11g ?

  • From: "Prem" <premj@xxxxxxxxxxxxxx>
  • To: "oracle_l " <oracle-l@xxxxxxxxxxxxx>
  • Date: 29 Mar 2011 10:56:05 -0000

 Friends ,

In 11g , is there a way to find the progress of dbms_stats.gather stats job ?

one of my peer has got a siebel table with 250 indexed columns . While 
gathering stats using 
dbms_stats , he would like to know how many columns are complete and how many 
are left 
out ? This stats job usually takes 2~3 hours and he is curious to know the 
progress .

~ jp ~

Other related posts: