Re: Can you monitor ANALYZE table?

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Thu, 29 Jul 2004 17:12:03 -0700 (PDT)
Message-ID: <20040730001203.24312.qmail@web20421.mail.yahoo.com>

"Yen, Eric" <EYen_at_sonypictures.com> 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;

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org 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
-----------------------------------------------------------------

Received on Thu Jul 29 2004 - 19:08:31 CDT