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 AI Database 26ai.

See Also:

• “TXN_PRIORITY”

• “PRIORITY_TXNS_HIGH_WAIT_TARGET”

• “PRIORITY_TXNS_MODE”

• Oracle AI Database Administrator’s Guide for more information about Priority Transactions