The SET ISOLATION statement supports complete-connection level settings. This means that values in the local session environment at the time of connection are propagated to all new or resumed transactions. These can include the following types of transactions:
If you change the isolation level within a transaction, the new value is propagated back to the local environment and also to all subsequent new or resumed transactions.
The following definitions explain the critical characteristics of each isolation level, from the lowest level of isolation to the highest.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]