Re: Can you monitor ANALYZE table?

--- "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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: