Query Execution Time
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Query Execution Time

  1. #1
    Join Date
    Feb 2001
    Posts
    290

    Question

    Can anybody let me know , how to find out the estimated time to execution a query , without running it actually. Is there any way ???

    Thanks in advance
    Madhu



  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    NO WAY.
    Best wishes!
    Dmitri

  3. #3
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    You can use EXPLAIN PLAN to optimaze your query.
    Best wishes!
    Dmitri

  4. #4
    Join Date
    Feb 2001
    Posts
    290
    Yeah, I think the excution will also depends on the number of rows it is going to fetch from the base tables. so we cant determine the execution time,

    Thanks a lot KGB,
    Madhu

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well there is no way to estimate execution time without running it but you can use a dirty trick in 8i... run the query for over 6 seconds then cut the query and look v$session_longops, there will be an estimate time. Pretty accurate, works pretty well for me

  6. #6
    Join Date
    Aug 2001
    Posts
    64
    pando,
    what unit is the time in, seconds or milli-seconds? Thanks.

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    it's in the docs...

    SID
    NUMBER
    Session identifier

    SERIAL#
    NUMBER
    Session serial number

    OPNAME
    VARCHAR2(64)
    Brief description of the operation

    TARGET
    VARCHAR2(64)
    The object on which the operation is carried out

    TARGET_DESC
    VARCHAR2(32)
    Description of the target

    SOFAR
    NUMBER
    The units of work done so far

    TOTALWORK
    NUMBER
    The total units of work

    UNITS
    VARCHAR2(32)
    The units of measurement

    START_TIME
    DATE
    The starting time of operation

    LAST_UPDATE_TIME
    DATE
    Time when statistics last updated

    TIME_REMAINING
    NUMBER
    Estimate (in seconds) of time remaining for the operation to complete.

    ELAPSED_SECONDS
    NUMBER
    The number of elapsed seconds from the start of operations

    CONTEXT
    NUMBER
    Context

    MESSAGE
    VARCHAR2(512)
    Statistics summary message

    USERNAME
    VARCHAR2(30)
    User ID of the user performing the operation.

    SQL_ADDRESS
    RAW(4)
    Used with the value of the SQL_HASH_VALUE column to identify the SQL statement associated with the operation.

    SQL_HASH_VALUE
    NUMER
    Used with the value of the SQL_ADDRESS column to identify the SQL statement associated with the operation.

    QCSID
    NUMBER
    Session identifier of the parallel coordinator.


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