enq: tx - contention on selects

From: stephen O'D <stephen.odonnell_at_gmail.com>
Date: Tue, 16 Sep 2008 04:19:17 -0700 (PDT)
Message-ID: <bc76ed46-3497-4942-b07a-a10b81cf8d0b@d77g2000hsb.googlegroups.com>

Oracle 10G R2 on HPUX 64 bit.

I see a lot of occurrences in our application waiting on the event enq: TX - contention.

What is puzzling me, is that these waits are all generally on select statements (at least accoring to TK Prof). If I grep through the trace file I see waits like the one below for instance:

WAIT #33: nam='enq: TX - contention' ela= 619813 name|mode=1415053316 usn<<16 | slot=5832740 sequence=570213 obj#=33133100 tim=6991129188755

Could any one offer me any advice on what each of the numbers in this line mean, ie how do I decode name|mode, slot, sequence, obj# into something meaningful so I can get to the bottom of what is causing these waits?


Stephen. Received on Tue Sep 16 2008 - 06:19:17 CDT

Original text of this message