-
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
-
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
-
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
-
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,12c
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|