Differences between sessions and transactions in Oracle

A session can start multiple transactions, which are sessions, meaning one connection at a time.

A transaction is a unit of action that either succeeds or fails and has no intermediate state.

Multiple transactions can be completed in a session.

For example:

A session is analogous to connecting a database in an application to perform a connection and then shutting it down, which counts as a session.

Transaction, it is like executing one or more of the operations on the database in the program after you open the session.

The best example of things is the transfer of money from one account to another, two tables of data modification, or all successful, and the door completely changed back to the original.

Conversation See V$session

Affairs See V$transaction

These two views are connected by v$session.taddr= V$transaction.addr,

Transactions are a feature that separates the database from the file system

More Wonderful content: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/