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
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