You can terminate the blocking session manually if you need to resolve the situation immediately.Ĥ. Consider changing the schedule or parameterization of the application modifying those database objects and thereby blocking those transactions.ģ. Check the application logic of the currently blocking session to see if the application logic can be changed to avoid the blocking situation.Ģ. ![]() To resolve the blocking situation, the following actions can be taken.ġ. When transactions are blocked, identify the session that blocks other transactions from (“Performance -> Sessions”)or (“Performance -> Blocked Transactions”). ![]() What are the types of SAP HANA DB Locks and how we can resolve if we get any issuesĬheck the Alerts Monitor in HANA Studio for alerts indicating lock situations, which may serve as a starting point for the following investigations:Ĭheck for blocked transactions (“Performance -> Load”, “Performance -> Blocked Transactions”, “Performance -> Threads”) to determine the number of blocked transactions. Here i am explaining about SAP HANA DB Locks.
0 Comments
Leave a Reply. |