Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Active transaction and inactive session

571482Apr 9 2007 — edited Apr 9 2007

I found that sometimes I see a transaction in v$transaction, but when I look at the session that the transaction is connected to (in v$session), I see that the session is in fact inactive.

What does it mean when a session is inactive but still has an open transaction? Wouldn't an open transaction indicate activity?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 7 2007

Added on Apr 9 2007

#general-database-discussions

2 comments

2,325 views