Hi,
Here's the exact behavior I'm experiencing, so hopefully you or someone else can shed some lights without understand much about the nature of my setup/app.
session 17 is blocking session 28
session 17 is blocking session 31
session 17 is inactive and the wait event is "SQL*Net message from client"
session 28 is active and the wait event is "enq: TM - contention"
session 31 is active and the wait event is "enq: TM - contention"
session 17 current SQL is none but previous is "select ..."
session 28 current SQL is "insert into ..."
session 31 current SQL is "delete from ..."
The question is who/what causes session 17 blocked i.e. what causes "SQL*Net message from client"? Why does the server process wait for a message from the client process to arrive? What message?
Reference:
2676548