D.24 HS_FDS_TRANSACTION_ISOLATION

HS_FDS_TRANSACTION_ISOLATION initialization parameter for Oracle Database Gateway for SQL Server.

Property	Description
Default Value	READ_COMMITTED
Range of Values	{READ_UNCOMMITTED | READ_COMMITTED | REPEATABLE_READ | SERIALIZABLE}
Syntax	HS_FDS_ISOLATION_LEVEL={{READ_UNCOMMITTED|READ_COMMITTED|REPEATABLE_READ|SERIALIZABLE}

HS_FDS_TRANSACTION_ISOLATION specifies the isolation level that is used for the transaction that the gateway opens on the non-Oracle database.

The isolation levels of READ_UNCOMMITTED, READ_COMMITTED, REPEATABLE_READ, and SERIALIZABLE are the four isolation levels defined in the SQL standard and adopted by both ANSI and ISO/IEC. For additional information regarding them, see Oracle Database Concepts.

Use caution when specifying an isolation level lower than the Oracle transaction isolation level being used, as the gateway transaction will have different Preventable Read Phenomena from what will occur in the Oracle database transaction.