inactive sessions in v$transaction
Hi,
I am confused about what I am seeing in v$transaction view. Session which ran some select queries and became inactive also appearing in v$transaction.
How the select is considered as a transaction. ?
Why the inactive sessions showing up in v$transaction ?
Can you please clear these quetions. I appreciate your suggetions.
Thanks