Originally posted by simply_dba
There's only one row in v$transaction
Yes but which session that transaction belongs to.. did u check?

are you sure that its the dead sessions transaction?


Abhay.