oracle

KeepTool Hora analyses session blockades at dataset level

26 Apr 2019

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