on 06-10-2009 7:17 AM
Hi
The current number of lock enteries is 8867. For our application requirement we have to increase the size to approx. 30000.
We would like to get answers of following questions,
1. What parameters should be changed?
2. What would be the impact on the system and it's performance when we increase the number of locks entries?
3. Any pre-requsite before making changes like buffer, memory etc?
Regards
Dharmendra
Hi,
The parameter "enque/table_size" governs the size of the Lock table in SAP system.
You can view the fill level of the lock tables using the statistics functions of lock management (transaction SM12 -> Extras ->Statistics).
The default value of this parameter is 4096 (4 MB) and this parameter can be extended upto 102,400 (100 MB).
Please set this parameter in the instance profile of your CI system.
With Regards,
Saurabh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
we can increase number of lock entries in MONITOR_LOCK and LOCKLISTSTATISTICS tables
and check the below SAP note
Note 65946 - Lock escalations
Regards,
Srinu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
http://help.sap.com/saphelp_nw04/helpdata/EN/37/a2e3ab344411d3acb00000e83539c3/content.htm
should help you in anwering your question.
Thanks,Prasanna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.