1. Database Reference
  2. Initialization Parameters
  3. Initialization Parameters
  4. PRIORITY_TXNS_MEDIUM_WAIT_TARGET

2.313 PRIORITY_TXNS_MEDIUM_WAIT_TARGET

PRIORITY_TXNS_MEDIUM_WAIT_TARGET specifies the maximum number of seconds that a MEDIUM priority transaction will wait for a row lock before the Priority Transactions feature rolls back a lower priority transaction holding the lock.

Property Description

Parameter type

Integer

Default value

2147483647

Modifiable

ALTER SYSTEM

Modifiable in a PDB

Yes

Range of values

1 to 2147483647

Basic

No

Oracle RAC

Different instances can use different values.

The Priority Transactions feature automatically rolls back low-priority transactions that are blocking higher priority transactions from obtaining row locks.

This parameter is one of four initialization parameters that enable you to configure Priority Transactions. The other parameters are:

  • TXN_PRIORITY - Specifies a priority (HIGH, MEDIUM, or LOW) for all transactions in a user session

  • PRIORITY_TXNS_HIGH_WAIT_TARGET - Specifies the maximum number of seconds that a HIGH priority transaction will wait for a row lock

  • PRIORITY_TXNS_MODE - Specifies whether to enable Priority Transactions or test Priority Transactions by running in tracking mode

Note:

This parameter is available starting with Oracle Database 23ai.

See Also: