PDF (US Ltr) - 0.7Mb
Lists the Transactions configuration metrics and provides a brief description of each.
Table 7.37 Transactions Configuration Metrics
|The autocommit mode. If set to 1, all changes to a table take effect immediately. If set to 0, you must use COMMIT to accept a transaction or ROLLBACK to cancel it.
|Affects transactions that begin with START TRANSACTION or BEGIN and end with COMMIT or ROLLBACK. Sets whether the server starts a new transaction immediately after a COMMIT/ROLLBACK (by setting to CHAIN), or disconnect after completing a COMMIT/ROLLBACK (by setting to RELEASE), otherwise do not implicitly start a new transaction (by setting to NO_CHAIN, the default).
|The default transaction isolation level.
|Read Only Enabled
|The default transaction access mode. The value can be OFF (read/write, the default) or ON (read only).