Re: how to find dbms_stats progress in 11g ?
From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 1 Apr 2011 08:38:14 -0600
Message-Id: <A5F1C646-DBB2-4AA1-ACC6-B8B6D66A3618_at_centrexcc.com>
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.
Date: Fri, 1 Apr 2011 08:38:14 -0600
Message-Id: <A5F1C646-DBB2-4AA1-ACC6-B8B6D66A3618_at_centrexcc.com>
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 ~
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 01 2011 - 09:38:14 CDT