Originally posted by abhaysk
then that transaction would be belonging to some other session.. join with v$session to see the details.


Abhay.
There's only one row in v$transaction