AW: how to find dbms_stats progress in 11g ?

From: Petr Novak <Petr.Novak_at_trivadis.com>
Date: Tue, 29 Mar 2011 11:48:31 +0000
Message-ID: <09011014EB621E4CBC2536B62A1B640702F57F_at_smxc002.trivadis.com>

You can also check last_analyzed column in dba_tables,dba_indexes, dba_tab_col_statistics..

Best Regards,
Petr

---

Von: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org]&quot; im Auftrag von &quot;Gleb Otochkin [gleb.otochkin_at_gmail.com] Gesendet: Dienstag, 29. März 2011 13:01
Bis: premj_at_rediffmail.com
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_at_Middle]<http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline.htm@Middle?>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 29 2011 - 06:48:31 CDT