How to get approximate execution time before running a query
Posted on 2009-02-11
We have some reports where the queries are built dynamically.Sometimes if the filter criteria and the columns that needs to be displayed are huge then the query takes more time.So, we thought of sending the reports to the users via email.But, users say that if the report o/p can be displayed before 2min they want to see immediately instead of emailing the report to them.
For this they want to see a screen after submitting the report within 10sec which says if it will be sent through email or will be shown immediately.
So we need to know the execution time of the query before 10sec.
Even approximate time should workout for us.
Do we have any data dictionary tables in oracle which gives us approximate time for exectuing a query??