how to find the exact time taken by a query?

[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

[Sekhar]

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

[parijat67]

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

[julian]

Run as SYS prvtutil.plb script. You will find it in $ORACLE_HOME/rdbms/admin/

Then, still as SYS:

SVRMGR> GRANT EXECUTE ON DBMS_SYSTEM TO USER_NAME;

Then, as USER_NAME, create a synonym:

SVRMGR> CREATE SYNONYM DBMS_SYSTEM FOR SYS.DBMS_SYSTEM;