how to find dbms_stats progress in 11g ?
From: Prem <premj_at_rediffmail.com>
Date: 29 Mar 2011 10:57:27 -0000
Message-ID: <20110329105727.56284.qmail_at_f4mail201.rediffmail.com>
Friends ,
Date: 29 Mar 2011 10:57:27 -0000
Message-ID: <20110329105727.56284.qmail_at_f4mail201.rediffmail.com>
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 ~
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 29 2011 - 05:57:27 CDT