OracleTransactionPriority Enumeration

OracleTransactionPriority enumerated values specifies the Priority Transaction level. Low priority transactions whose row locks block higher priority transactions can force those lower ones to roll back so that the higher ones can proceed and commit. Table 6-250 lists all the enumeration values with a description of each enumerated value.

Table 250 OracleTransactionPriority Enumeration Values

Member Name Description
High High Priority Transactions never roll back to release a row lock for another transaction. This is the default value.
Medium Medium Priority Transactions roll back when holding a row lock required by high priority transactions that have been paused for as long as the wait target setting.
Low Low Priority Transactions roll back when holding a row lock required by high and medium priority transactions that have been paused for as long as the wait target setting(s).

Requirements

Provider ODP.NET, Managed Driver ODP.NET Core
Assembly Oracle.ManagedDataAccess.dll Oracle.ManagedDataAccess.dll
Namespace Oracle.ManagedDataAccess.Client Oracle.ManagedDataAccess.Client
.NET Framework See System Requirements -
.NET (Core) - See System Requirements

See Also: