elapsed time [message #50409] |
Thu, 14 March 2002 04:49 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Selvan
Messages: 2 Registered: March 2002
|
Junior Member |
|
|
Hello:
Is it possible to know the elapsed time for
SQL statements from the system tables/data
dictionary views or any system statistics table.
Timed_statistics is set to true.
I am looking something similar to "elapsed time" present in TKPROF output.
Need to measure how long each SQL statement
is being executed. Can not use set time on from sqlplus or any sql tool.
Any help is appreciated
thanks
selvan
|
|
|
Re: elapsed time [message #50423 is a reply to message #50409] |
Thu, 14 March 2002 08:31 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Andrew Lenz
Messages: 16 Registered: August 1999
|
Junior Member |
|
|
from sqlplus
find the SID and SERIAL# for the user you want to trace:
SQL> select sid, serial# from v$session where username = 'username'
Next:
SQL> exec dbms_system.set_sql_trace_in_session(sid,serial#, TRUE);
now you can use TKPROF against the files in USER_DUMP_DEST.
|
|
|