Oracle-L: Re: query progress meter

From: Justin Cave <jcave_at_cableone.net>
Date: Fri, 01 Nov 2002 21:38:48 -0800
Message-ID: <F001.004FA99D.20021101213848@fatcity.com>

At 05:49 AM 11/1/2002, you wrote:
>I've just been asked if Oracle has an API which allows you to query the
>progress of a query, say, as a percentage of the whole time taken. I'm
>guessing that it would be an extremely complex algorithm to implement, if
>at all possible. Does anyone know if something like this exists?

The 9.2 DBA Studio has a nice little progress bar for long-running operations-- presumably based on queries against the tables other folks have mentioned. Go to the list of sessions, open a particular session, and go to the "long operations" tab. Obviously, this is more useful if you want to watch the progress of a query than if you want to do some serious reporting.

Justin Cave
Justin Cave
Distributed Database Consulting

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Justin Cave
  INET: jcave_at_cableone.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Nov 01 2002 - 23:38:48 CST