how to find dbms_stats progress in 11g ?
From: Prem <premj_at_rediffmail.com>
Date: 29 Mar 2011 10:56:05 -0000
Message-ID: <20110329105605.54341.qmail_at_f4mail-234-124.rediffmail.com>
Friends ,
Date: 29 Mar 2011 10:56:05 -0000
Message-ID: <20110329105605.54341.qmail_at_f4mail-234-124.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:56:05 CDT