I am having this issue with the database. This blocking session keeps appearing in the database and never ends. I have tried rebooting the server and also bouncing the database, the session appears again. The same SQL Text running, with different sessions ID.
But the strange thing is that is not causing performance issues or any other problem.
I have open a ticket at the application support partner site, i am waiting for their response.
Please any help on how to approach this problem. Or any recommendation or tips handling blocking sessions.