Re: how to find dbms_stats progress in 11g ?
- From: Gleb Otochkin <gleb.otochkin@xxxxxxxxx>
- To: premj@xxxxxxxxxxxxxx
- Date: Tue, 29 Mar 2011 07:01:11 -0400
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 ~
>
>
Other related posts:
