[Last Call] Learn how to a build a cloud-first strategyRegister Now


How to get approximate execution time before running a query

Posted on 2009-02-11
Medium Priority
Last Modified: 2012-05-06
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??
Question by:vkchaitu82
1 Comment
LVL 18

Accepted Solution

sventhan earned 1500 total points
ID: 23658979

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses
Course of the Month18 days, 3 hours left to enroll

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question