enq: tx - contention on selects

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?

Thanks,

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