Salesforce

Is there a parameter for TXE commit lock skip limit ?

« Go Back

Information

 
TitleIs there a parameter for TXE commit lock skip limit ?
URL Name000036355
Article Number000159631
EnvironmentProduct: OpenEdge
Version: 10.1B and later
OS: All supported platforms
Question/Problem Description
Can the TXE commit lock skip limit be set at database start up time ?
Is there a parameter for TXE commit lock skip limit ?
Steps to Reproduce
Clarifying Information
Error Message
Defect NumberEnhancement OE00132416 / PSC00178127
Enhancement Number
Cause
Resolution
In Progress 9.1E04, OpenEdge 10.0B03 and later, the TXE algorithm was changed in an effort to ensure that TXE Commit Locks will not be starved.  For further information refer to Article P121754, How to change the Commit Lock Skip Limit for the TXE in promon?   

Upgrade to OpenEdge 10.1B or later where a database startup parameter -TXESkipLimit to set the TXE commit lock skip limit was introduced.  
  • Default value is 10000, to set the maximum SHARE/UPDATE locks that can skip the queued COMMIT locks,
  • The commit lock skip limit ranges is: (0 to 100000)
  • The value needs to be changed in a large scale. For example, by changing it from 10000 to 10001 
    should not make any difference if it is indeed this TXE latch contention causing the performant issue
  • Setting it to 0 (zero) will restore to the old TXE locking algorithm to favour COMMIT locks.
Workaround
Notes
Keyword Phrase
Last Modified Date4/21/2016 8:55 AM

Powered by