Home » RDBMS Server » Performance Tuning » How long each commit took?
How long each commit took? [message #64779] Wed, 28 January 2004 06:04 Go to next message
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 #64780 is a reply to message #64779] Wed, 28 January 2004 16:43 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Hi,
you could trace the session and see how long it took to process the commit. Let me know if you need information regarding tracing a session.

-Thiru
Re: How long each commit took? [message #64782 is a reply to message #64780] Thu, 29 January 2004 05:44 Go to previous messageGo to next message
Devyani
Messages: 7
Registered: January 2004
Junior Member
Yes can you please provide me the information
Re: How long each commit took? [message #64783 is a reply to message #64782] Thu, 29 January 2004 07:38 Go to previous messageGo to next message
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

Re: How long each commit took? [message #64784 is a reply to message #64783] Thu, 29 January 2004 08:01 Go to previous message
Devyani
Messages: 7
Registered: January 2004
Junior Member
Thanks
Previous Topic: control tracefiles for other sessions
Next Topic: How to improve performance ?
Goto Forum:
  


Current Time: Thu Oct 01 02:05:02 CDT 2020