Re: how to find dbms_stats progress in 11g ?

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Fri, 1 Apr 2011 13:40:55 +0800
Message-ID: <AANLkTikOORAW5Sdyq01Qw21pHV=MsNU_sWRjjsBsf1bk_at_mail.gmail.com>

On Thu, Mar 31, 2011 at 6:37 PM, Prem <premj_at_rediffmail.com> 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://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline.htm_at_Middle?>

dbms_sqltune.report_.... is a great way of monitoring any long running sql (part of tuning pack license I think)

-- 
Connor McDonald
===========================
email: connor_mcdonald_at_yahoo.com
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

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

Received on Fri Apr 01 2011 - 00:40:55 CDT