Transactions Properties
Note:
Transaction properties apply to block storage databases only.
The Transactions tab displays information about the access to the database.
-
Committed access enables transactions to hold read/write locks on all data blocks involved with a transaction until the transaction completes and commits. The following concurrency options may also be pre-configured:
-
Wait (seconds)—Number of seconds that a transaction waits for access to locked data blocks. The default is twenty seconds, but another value, Indefinitely or No wait may also be pre-configured.
-
Pre-image access—Users have read-only access to data blocks that are locked for the duration of another concurrent transaction.
-
-
Uncommitted access enables transactions to hold read/write locks on a block-by-block basis (the default setting). The synchronization point may also be pre-configured in the following areas:
-
Commit blocks—Number of data blocks updated before Oracle Essbase performs a commit
-
Commit rows—Number of rows of a data file processed during a data load before Essbase performs a commit
-