Re: how to find dbms_stats progress in 11g ?

From: Jonathan Lewis <>
Date: Fri, 1 Apr 2011 12:03:50 +0100
Message-ID: <29324B43713C46F2B62EF1968632F65C_at_Primary>

It doesn't quite apply to this case (250 indexes on one table), but I started scribbling a note last night (probably publish it tonight) about using the "LIST" options with dbms_stats.gather_schema_stats() to see how far the corresponding "GATHER" option has got. Not sure if it could be warped to do the same for a single "gather_table_stats" - but an easy option would be to "select index_name, last_analyzed" for the table where the last_analyzed is earlier than the start of job.


Jonathan Lewis

  • Original Message ----- From: "Connor McDonald" <> To: "oracle_l" <> Sent: Friday, April 01, 2011 6:40 AM Subject: Re: how to find dbms_stats progress in 11g ?

> On Thu, Mar 31, 2011 at 6:37 PM, 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 ~
>> <>
> dbms_sqltune.report_.... is a great way of monitoring any long running sql
> (part of tuning pack license I think)

Received on Fri Apr 01 2011 - 06:03:50 CDT

Original text of this message