How to set sap hana parameters to terminate sessions automatically?
It is a self locks destruction configuration
Sap hana has got different lock managment levels. Certain type of locks will be automatically terminated depending of idle time configuration. It is an important issue as a perfect configuration will keep you system up and running without too much performance hiccups.
Idle Opened cursors and active SQL statements are automatically terminated after a while depending of the following parameter :
indexserver.ini -> [transaction] -> idle_cursor_lifetime
Old and active update transactions will be killed after a while depending of the following parameter :
indexserver.ini -> [transaction] -> uncommitted_write_transaction_lifetime