How to get approximate execution time before running a query

Posted on 2009-02-11
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


    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Hello All, In previous article we used Hortonworks sandbox to work with Hadoop. Now, lets think to create own single node Hadoop on Linux. Here we Install and Configure Apache Hadoop on UI based Oracle Linux. I assume, you have VMware installeā€¦
    Note: You must have administrative privileges in order to create/edit Roles. ( (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales and markeā€¦
    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.
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now