DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Query execution time remaining

  1. #1
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865

    Query execution time remaining

    I want to clear my confusion about how to find the execution time remaining for a SQL query which is still running.

    My understandings are as below. Please correct me if my understanding is wrong.

    P.S - In the current client place where I am working, due to license issues I can not use AWR / ADDM.

    Oracle - 10.2.04
    OS - SUN & HP

    S1 - If the query is executing longtime, showed up in v$session_longops then it will populate the TIME_REMAINING column for that particular operation like table scan, index scan, hash join, or sort etc but not for the whole query.

    S2 - If the query is executing longtime, but not showed up in v$session_longops because of the criteria is not satisfied then we can check the query in v$sqlarea and find ELAPSED_TIME but I didn't find any thing to find how much time remaining.

    Looking for your suggestions to find the actual REMAINING TIME for a given query which is currently running in the database.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    how on earth is the database going to know who long a whole query has left to run

    cannot predict the future

  3. #3
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Thanks Davey.

    I expected like, when oracle is able to predict the TIME_REMAINING for the executions in v$session_longops then it should have some predictions about the whole query based the stats available and the execution plan it generated.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width