Home » RDBMS Server » Performance Tuning » Help interpreting a trace
icon9.gif  Help interpreting a trace [message #171919] Fri, 12 May 2006 05:08 Go to next message
ozmartin
Messages: 7
Registered: March 2006
Location: MILANO
Junior Member
Hi,
I am using oracle 9i Enterprise Edition Rel 9.2.0.7.0 - Production.

I have every day (when the system is very stressed) a TX transaction deadlock during UPDATE on PT_ANOMPR00T table .

This table have 15 columns,1 pkey , 2 ix, and 2000 rows(50 mb).

How can i see where is the enqueue problem ?

Thanks in advance.
OZmartin Smile)

  • Attachment: 2006.doc
    (Size: 33.50KB, Downloaded 1571 times)
Re: Help interpreting a trace [message #171930 is a reply to message #171919] Fri, 12 May 2006 06:25 Go to previous message
sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata
Senior Member

Convert your trace file using the commad TKPROF
follow the link for convertion
http://www.adp-gmbh.ch/ora/tuning/tkprof/index.html
Previous Topic: Comparing statistics of two queries
Next Topic: For Faster Delete statement
Goto Forum:
  


Current Time: Thu Mar 28 09:52:01 CDT 2024