|
-
A session is a connection to the database. It could be that a single user could have several sessions at a time. (This would especially be the case if an application has its own user ID.) When you look at the V$SESSION view you will see the background processes as well although I am not sure they count as "sessions".
A transaction is a set of SQL commands and ends with a COMMIT, a ROLLBACK or a LOGOFF (or a session abort).
I guess that technically you could say that every session is in a transaction at any given moment. On the other hand if you look at the V$TRANSACTION view it will show you the number of transactions that are actually making a demand on rollback segments. This is probably what you are interested in in the first place.
I suggest you check the counts in V$TRANSACTION in your own environment to get a feel for the ratio of sessions to transactions. I would expect the number of transactions to be very much less than the number of sessions.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|