If a database session blocks a dataset for an extended period of time, this can have highly negative consequences – even affecting a productive system in the worst case. It is therefore very important to quickly identify the cause behind such a blockade.
With Hora, KeepTool’s most important Oracle tool, it has always been possible to make queries through the session page, such as:
It has also already been possible to display the current SQL statement last executed by the session.
New in version 14.0.6
Version 14.0.6 comes with a new feature: if a session has a lock, it is even possible to receive information on which dataset is locked. This makes it possible to remedy blockades even faster.
Back to the overview