Example of Specifying Isolation Level Settings with ESSCMD

  To specify isolation level settings using ESSCMD, enter SETDBSTATEITEM 18 in ESSCMD and either follow the prompts or supply the required values on the command line.

Choose 1 (committed access) or 2 (uncommitted access, the default). Depending on which you specify, ESSCMD prompts you for other parameters (or you can supply the values on the command line).

If you choose 1 (committed access), ESSCMD prompts for the following information:

  • Pre-image access; Y (Yes) or N (No, the default). Pre-image access provides users read-only access to data blocks that are locked for the duration of a transaction. Users see the last committed data values for the locked data blocks.

  • Wait (in the Database Settings dialog box) or timeout (in ESSCMD): -1, 0, or n.

    • -1 is indefinite wait.

    • 0 is immediate access, or no wait.

    • n is the number of seconds that you specify.

If you choose 2 (uncommitted access), ESSCMD prompts for the following values. See Uncommitted Access for explanations of these options.

  • Number of blocks modified before internal commit

  • Number of rows to data load before internal commit

You can also specify isolation level parameters (pre-image access and so on) by specifying parameters 19–22 on SETDBSTATEITEM. Enter SETDBSTATEITEM with no parameters; ESSCMD displays a list that includes each parameter by number, with a description.

Here is an example of using SETDBSTATEITEM to set an isolation level. This example enables committed access and pre-image access and specifies indefinite wait time.

SETDBSTATEITEM 18 "SAMPLE" "BASIC" "1" "Y" "-1"

See the Oracle Essbase Technical Reference.