How to get approximate execution time before running a query

Hi experts,
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??
Who is Participating?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.