Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    9

    Unanswered: SQL Timer Question

    All ,

    The SQL file i use is given below
    set timing on
    set heading off
    set termout off
    spool Rank.log
    set autotrace on exp stat

    prompt query 1
    SELECT ....... ;
    Quit;

    I am wondering whether the Elapsed time for the above SQL is purely execution time for this query or it includes the time taken to send the results back to the console .

    Is there anyway i can instruct ORACLE not to send the results to me as i am only interested in Execution time for this Query.
    Last edited by Loga; 11-21-05 at 16:11. Reason: Changes

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    set autotrace traceonly

  3. #3
    Join Date
    Jun 2004
    Posts
    9
    Quote Originally Posted by SkyWriter
    set autotrace traceonly

    traceonly is not going to execute the query isn't it ? It will just prepare the plan , what i want is bit different , i am talking about preparing the plan and executing it with out sending the results back .

    Correct me if i am wrong .

  4. #4
    Join Date
    Jan 2004
    Posts
    370
    Quote Originally Posted by Loga
    traceonly is not going to execute the query isn't it ? It will just prepare the plan , what i want is bit different , i am talking about preparing the plan and executing it with out sending the results back .

    Correct me if i am wrong .
    SET AUTOTRACE TRACEONLY
    Like SET AUTOTRACE ON, but suppresses the printing of the user's query output, if any. If STATISTICS is enabled, query data is still fetched, but not printed.

    http://download-uk.oracle.com/docs/c...htm#sthref1507

    .

Posting Permissions

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