how to find the exact time taken by a query?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: how to find the exact time taken by a query?

Hybrid View

  1. #1
    Join Date
    Dec 2001
    Posts
    120
    Hi all,


    how can i know the exact time taken by a query to fetch data? I can very well set the timing on at the SQL prompt and check for the time after the select statement ran through, but that doesn't show the fetch time , it shows the fetch + display time together. Can anyone pls help me in this matter?

    Thanks

    Parijat Paul

  2. #2
    Join Date
    Jan 2002
    Posts
    78

    TKPROF UTILITY

    Hi paul,

    Use the TKPROF Utility to find Exect time to know how much you query have took to fetch that record set.

    Refer Oracle Tunning Utilities Documentation guide for further information




    Originally posted by parijat67
    Hi all,


    how can i know the exact time taken by a query to fetch data? I can very well set the timing on at the SQL prompt and check for the time after the select statement ran through, but that doesn't show the fetch time , it shows the fetch + display time together. Can anyone pls help me in this matter?

    Thanks

    Parijat Paul

  3. #3
    Join Date
    Dec 2001
    Posts
    120
    hi,

    when i ran the
    execute dbms_system.set_sql_trace_in_session(78,25435,true); then the following error is occuring. Pls let me know how to get rid of this error?

    PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared

    thanks

    Parijat

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Run as SYS prvtutil.plb script. You will find it in $ORACLE_HOME/rdbms/admin/

    Then, still as SYS:

    Code:
    SVRMGR> GRANT EXECUTE ON DBMS_SYSTEM TO USER_NAME;
    Then, as USER_NAME, create a synonym:

    Code:
    SVRMGR> CREATE SYNONYM DBMS_SYSTEM FOR SYS.DBMS_SYSTEM;
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

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