enq: tx - contention on selects
Date: Tue, 16 Sep 2008 04:19:17 -0700 (PDT)
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