A script-enabled browser is required for this page to function properly.

Isolation Mode Property

Description

Specifies whether or not transactions in a session will be serializable. If Isolation Mode has the value Serializable, the end user sees a consistent view of the database for the entire length of the transaction, regardless of updates committed by other users from other sessions. If the end user queries and changes a row, and a second user updates and commits the same row from another session, the first user sees Oracle error (ORA-08177: Cannot serialize access.).

Applies to form module

Set Oracle Forms

Usage Notes

Serializable mode is best suited for an implementation where few users are performing a limited number of transactions against a large database; in other words, an implementation where there is a low chance that two concurrent transactions will modify the same row, and where long-running transactions are queries. For transaction-intensive implementations, leave Isolation Mode set to Read Committed (the default). Serializable mode is best used in conjunction with the block-level property Locking Mode set to Delayed.

Default

Read Committed

Required/Optional required


Locking Mode property

Locking

About summary calculation