How can transactional lock waits be optimized?
Optimization approaches for
Record lock :-
Check from an application and / or scheduling perspective if you can reduce the amount of concurrent changes of the same records by different transactions.
Check from application side if you can reduce the critical time frame between DML operation and next COMMIT (lock is always held until next COMMIT is executed).
Manually terminate the lock holding transaction if it is responsible for a critical current problem.
Make sure that critical DDL operations (e.g. offline repartitioning) are executed at times with minimum concurrent workload.
Check if you can reduce the amount of critical DDL operations (e.g. by using online operations).
Sign up for STechies
Ask Question From Our Experts
All the site contents are Copyright © www.stechies.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.stechies.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
The content on this site may not be reproduced or redistributed without the express written permission of
www.stechies.com or the content authors.