Home » SQL & PL/SQL » SQL & PL/SQL » How to track which transaction is taking, much time in oracle 9i (oracle9i)
How to track which transaction is taking, much time in oracle 9i [message #394171] Wed, 25 March 2009 23:21 Go to next message
tapaskmanna
Messages: 98
Registered: January 2007
Location: Cyprus,Nicosia
Member
Hi,

How to track which transaction is taking, much time in oracle 9i?

Re: How to track which transaction is taking, much time in oracle 9i [message #394172 is a reply to message #394171] Wed, 25 March 2009 23:23 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SQL> ALTER SESSION SET SQL_TRACE=TRUE
Re: How to track which transaction is taking, much time in oracle 9i [message #394177 is a reply to message #394172] Wed, 25 March 2009 23:37 Go to previous messageGo to next message
tapaskmanna
Messages: 98
Registered: January 2007
Location: Cyprus,Nicosia
Member
Hi,

If its on Production, Do we have to execute the SQL_TRACE at Session level?After executing, how to track which transaction is taking more time?
Re: How to track which transaction is taking, much time in oracle 9i [message #394178 is a reply to message #394171] Wed, 25 March 2009 23:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>If its on Production, Do we have to execute the SQL_TRACE at Session level?
Either at session level or at DB level.

>After executing, how to track which transaction is taking more time?
Process with TKPROF, & see elapsed time.
Re: How to track which transaction is taking, much time in oracle 9i [message #394179 is a reply to message #394178] Wed, 25 March 2009 23:46 Go to previous messageGo to next message
tapaskmanna
Messages: 98
Registered: January 2007
Location: Cyprus,Nicosia
Member
Hi,

Thanks for your prompt response.
Re: How to track which transaction is taking, much time in oracle 9i [message #394230 is a reply to message #394171] Thu, 26 March 2009 04:13 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Alternatively, you can install StatsPack
This is a set of oracle supplied packages and scripts that allow you to monitor the activity on the database over a specified time period
It will provide you (amont other things) a list of the most expensive queries that are being run on the system
Previous Topic: Returning an Array from a Function
Next Topic: Vertical Pivot query (merged 3)
Goto Forum:
  


Current Time: Sat Nov 09 14:03:01 CST 2024