Re: how to find dbms_stats progress in 11g ?
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: premj@xxxxxxxxxxxxxx
- Date: Fri, 1 Apr 2011 08:38:14 -0600
Would not querying the optstat_ind_hist table give you the answer? That is
where dbms_stats automatically saves the current statistics before overriding
them with new statistics. I haven't checked how that works in 11g when you
gather stats as pending. But if that is different, i.e. the optstat hist tables
get updated when pending statistics are elevated rather than when gathered,
then querying the progress in the pending stats should do the trick - a
variation of the dba_indexes.last_analyzed suggestion.
On 2011-03-31, at 4:37 AM, Prem wrote:
> Niall - my peer is a part of offshore team and has to update the dba team
> sitting in client place regularly .
> People there are more curious about this job's progress (not sure why) and
> keep asking for frequent updates.
> That was the reason he wanted to know it . He was saying there is a view
> (other than session_longops and dba_indexes) which would give all these
> details . I was not aware of it and so posted here .
>
> ~ jp ~
>
>
Other related posts:
