Tales From A Lazy Fat DBA

Hi Everyone,

With Oracle 23ai, the ‘auto transaction rollback‘ feature has undergone some parameter renaming. For more details on this feature, please refer to my previous blog post – Link

The parameter “TXN_AUTO_ROLLBACK_HIGH_PRIORITY_WAIT_TARGET”, which specifies the maximum number of seconds a HIGH priority transaction will wait for a row lock before the Priority Transactions feature rolls back a lower priority transaction holding the lock, is now renamed to “PRIORITY_TXNS_HIGH_WAIT_TARGET“.

Similarly, “TXN_AUTO_ROLLBACK_MEDIUM_PRIORITY_WAIT_TARGET“, which specifies the maximum number of seconds a MEDIUM priority transaction will wait for a row lock before the Priority Transactions feature rolls back a lower priority transaction holding the lock, is now renamed to “PRIORITY_TXNS_MEDIUM_WAIT_TARGET“.

Finally, “TXN_AUTO_ROLLBACK_MODE“, which specifies the mode for Priority Transactions (ROLLBACK or TRACK), is now renamed to “PRIORITY_TXNS_MODE“.

Hope It Helped.
Prashant Dixit