Re: Can you monitor ANALYZE table?

  • From: Paul Drake <discgolfdba@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 29 Jul 2004 17:12:03 -0700 (PDT)

--- "Yen, Eric" <EYen@xxxxxxxxxxxxxxxx> wrote:

> Does anyone know of a way to see the progress of
> analyze table?
> 

same place as for any other large sort or scan
operation:

v$session_longops.

select * From v$session_longops where
time_remaining>0;

Pd
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: