Re: How to estimate the time that a query takes to complete?

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Wed, 28 Jul 1999 08:55:22 -0700
Message-ID: <379F27EA.F1B67445@us.oracle.com>

Miguel

What tool are you using to do the querying? Discoverer does this automatically for you (not sure how). Alternatively, if you're on 8.1 there may be something you can do with v$longops.

HTH Pete

Miguel Figueiredo wrote:

> Hello.
>
> I’m developing a Data Warehouse system (Oracle 8) where a single query
> can take from less than one second to several days to complete. I’d
> like to find a way of telling the users how long before expecting
> results.
>
> I checked the Oracle documentation but I didn’t find anything about
> it.
>
> How can I implement this facility? Any Idea?
>
> Thank you very much.
>
> Miguel

--
Regards

Pete

Received on Wed Jul 28 1999 - 10:55:22 CDT