AW: how to find dbms_stats progress in 11g ?
- From: Petr Novak <Petr.Novak@xxxxxxxxxxxx>
- To: "gleb.otochkin@xxxxxxxxx" <gleb.otochkin@xxxxxxxxx>, "premj@xxxxxxxxxxxxxx" <premj@xxxxxxxxxxxxxx>
- Date: Tue, 29 Mar 2011 11:48:31 +0000
You can also check last_analyzed column in dba_tables,dba_indexes,
dba_tab_col_statistics..
Best Regards,
Petr
________________________________________
Von: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx]" im
Auftrag von "Gleb Otochkin [gleb.otochkin@xxxxxxxxx]
Gesendet: Dienstag, 29. März 2011 13:01
Bis: premj@xxxxxxxxxxxxxx
Cc: oracle_l
Betreff: Re: how to find dbms_stats progress in 11g ?
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://sigads.rediff.com/RealMedia/ads/adstream_nx.ads/www.rediffmail.com/signatureline.htm@Middle]<http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline.htm@Middle?>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » AW: how to find dbms_stats progress in 11g ? - Petr Novak
