How long each commit took? [message #64779] |
Wed, 28 January 2004 06:04 |
Devyani
Messages: 7 Registered: January 2004
|
Junior Member |
|
|
Is there any way in Oracle to find out how much time each commit took? I would like to know if the commits were bad in which part of the day(may be early morning or afternoon).
|
|
|
|
|
Re: How long each commit took? [message #64783 is a reply to message #64782] |
Thu, 29 January 2004 07:38 |
Thiru
Messages: 1089 Registered: May 2002
|
Senior Member |
|
|
You can look at this for information about tracing your own session/tkprof Tracing/Tkprof
To trace other sessions,there are many ways. One of them is to use dbms_system.set_sql_trace_in_session procedure.
First ,you'll need to identify SID,SERIAL# from v$session corresponding to the user session you want to trace , like this
Select sid,serial# from v$session where username='SCOTT' and machine='machine_name';
To enable tracing of a session whose SID=12 and
SERIAL#=13 (from v$session),
execute dbms_system.set_sql_trace_in_session(12,13,TRUE);
and to disable tracing
execute dbms_system.set_sql_trace_in_session(12,13,FALSE);
Once you get the trace file in USER_DUMP_DEST directory,you can format the tracefile usnig tkprof and analyze the details..
Note that timed_statistics should be enabled in any case.
-Thiru
[Updated on: Fri, 18 February 2005 23:32] Report message to a moderator
|
|
|
|