Isolation levels determine how Essbase commits data to disk. When data is committed, it is taken from server memory and written to the database on disk. Essbase automatically commits data to disk. There are no explicit commands that users perform to commit data blocks. However, setting the isolation level for a database defines how Essbase automatically commits data blocks.
Essbase offers two isolation levels for transactions—committed access and uncommitted access (the default). You can optimize data integrity by using committed access.
For an explanation of access types, see Committed Access and Uncommitted Access.
Setting the isolation level to committed access may increase memory and time requirements for database restructure. |