Advanced Query Functionality

[Custom24]

Hi
This is just a general question -
I'm using .net, and in one of the applications I'm doing I'd like to
1. Inform the user of how long it will take to complete a given query.
2. Inform them of progress.
3. Allow them to cancel the query, and free the server from executing it.

With the exception of maybe the last one, I don't think this is possible using the way I connect to the database (using the MS dot net provider for Oracle).

Has anyone any ideas? This is an asp.net app, which presents more challenges, but even for a windows app, I'd be interested. What about other things apart from .net?

Thanks for any input.

Mark

 

[SantaMufasa]

Mark,

That would be a wonderful piece of information that would be most useful to Oracle Tuning Specialists. Unfortunately Oracle hasn't built their "CrystalBall" function yet.

You, however, could approximate such a result by storing in a table the historical execution times of previous identical queries (provided that no bind variables change the complexion of the query). That way, if your users are selecting query choices from a menu, you could, before query execution, display "The most recent execution of that query took nn seconds. (Average execution nn seconds.)", and then give them the option to continue or not.

Sorry to bear disappointing news,

Dave
Sandy, Utah, USA @ 18:31 GMT, 11:31 Mountain Time

 

[Custom24]

Thanks for that.
I thought it might be possible because Oracle Discoverer for the web does it. Anyway, it's not a key requirement, so I'll just profile the account to make sure it cannot do queries which take far too long, and distract the users with an animation or something.



Mark