KeepTool Blog - Current

Our Oracle tools add support for the memoptimized rowstore feature introduced by Oracle 18c. The memoptimized rowstore provides the capability of fast data lookup for tables that are mainly queried based on primary key columns. The option provides a very, fast latency-reduced, data access for high on demand access rates, as needed for example for […]

After some strenuous development work and extensive tests we released a new major release KeepTool 14.2. We added support for the upcoming new Oracle version 20c as well as Oracle 18/19c features such as Memoptimized rowstore Shadow lost write protection See our Release notes for further details. INSERT-Scripts created by Hora now allow you to […]

Besides other new features, KeepTool 14.1.6 comes with a new main menu item “Extras|SQL execution history” to retrieve SQL from execution history.  It opens a dialog that allows you to retrieve SQL commands from execution history and optionally, copy a selected statement to the Windows clipboard. The new dialog is much more powerful than its […]

Each of our tools comes up with a connect dialog that displays most recent connections. This list can be organized by History, i.e. most recently usage Database, i.e. either TNS alias or hostname:port/servicename for direct TCP/IP connections User, i.e. database user Custom category, i.e. your own predicate you can assign to each session In the […]

The ER Diagrammer is part of the KeepTool Enterprise edition. In an instant, the tool creates a properly arranged Entity-Relationship Diagram by reverse engineering your database. This is very useful for data modelling, understanding an unknown legacy database, and for documentation purpose. The new ER Diagrammer comes up more flexible with a customizable diagram subset [...]

Reverse Database Engineer is part of both KeepTool Professional and KeepTool Enterprise editions. Since all our tools benefit from our continual improvement strategy, version 14.1 comes with an important new feature. Reverse DB allows you to create a DDL script for an existing Oracle database schema or any subset of selected objects. That is a […]

Oracle blocking session analysis is a most common task in many database systems having a high concurrency between Oracle sessions and update contention. If a database session blocks a record for an extended period of time, this can have highly negative consequences – even affecting a productive system in the worst case. It is therefore […]

Over the last years, KeepTool has developed powerful import and export functions to make the use of Excel files in combination with Oracle databases as convenient as possible. In the latest edition, version 14, these features have been enhanced through additional useful functions. KeepTool thereby offers comprehensive functionality when working with Excel files. Excel exports […]

Oracle master detail data browsing has been available on Hora’s Tables | data content page for years now, but the multi–table data content browser left you behind with a single table view. ‍The good news is, in KeepTool 14 you have a master/detail view for each page of the data browser. In the details view, […]

The data content browser shows data of the COMPANY table within the HR schema. To enable enhanced grouping capabilities, we activated the “in-memory grid mode” by clicking the appropriate checkbox in the top-right of the data content frame. Data is grouped by CITY by dragging the appropriate column header into the group-by box in the […]