Quote Originally Posted by PAVB
interesting theory pareshjavkar but... your theory does not explains why offending session is showing up in v$session as showed on adityaPB's query
Dear PAVB,

The text.log shows us the sql named "active" not the query inside it.

interesting thing will be to find out what it is and what is the status column value for which the user is trying to kill the session.