Re: how to find dbms_stats progress in 11g ?
From: Gleb Otochkin <gleb.otochkin_at_gmail.com>
Date: Tue, 29 Mar 2011 07:01:11 -0400
Message-Id: <1E47E99D-5220-4B39-9485-8E711D900D1A_at_gmail.com>
Check v$session_longops
Date: Tue, 29 Mar 2011 07:01:11 -0400
Message-Id: <1E47E99D-5220-4B39-9485-8E711D900D1A_at_gmail.com>
Check v$session_longops
Cheers,
Gleb
On 2011-03-29, at 6:57 AM, Prem wrote:
> 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 - 06:01:11 CDT