OraFAQ Forum: Performance Tuning » Help interpreting a trace

Home » RDBMS Server » Performance Tuning » Help interpreting a trace

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Help interpreting a trace [message #171919]

Fri, 12 May 2006 05:08

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