Oracle 7.3 - Oracle 21c Windows 11 compatible Version

KeepTool Blog - Current

Flag your database objects

18 Feb 2022

Flag your database objects! KeepTool 15 Tools for Oracle databases has been released for more than a month now. In this blog article we will introduce one of various new features and you should not underestimate it. We will show you how you can flag your personal subset of database objects by assigning an appropriate […]

Overview KeepTool Hora - Handy tools for Oracle datases

KeepTool 15 new features and improvements

06 Dec 2021

KeepTool 15 new features and improvements KeepTool products are valued by application developers, database administators and application users for their intuitive GUI, steep learning curve and rich features. Customers are using our tools for more than 20 years now and we try hard to improve with every new release. In conjunction with the release of Microsoft’s […]

Oracle schema dependencies screenshot

Oracle schema dependencies

19 Apr 2021

Oracle schema dependencies is the topic of our newsletter. We are defining them by the following decree:

Two database schemas

Backup SPFile to PFile dialog

Memoptimized Rowstore – Fast Oracle data access

23 Feb 2021

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 […]

Escape Unicode characters in SQL script

Escape Unicode characters in SQL and Filter expression editor

07 Dec 2020

In this post we introduce two new features of KeepTool 14.2.0. INSERT scripts generated by Hora now may escape Unicode characters in SQL. Furthermore, we want to show the new filter expression editor that allows you to easily formulate complex client-side filter expressions. Escape Unicode characters in SQL Unicode characters cannot be represented in the […]

Oracle SQL execution history

SQL execution history – retrieve and re-execute

31 Aug 2020

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 […]

Recent Oracle connections grouped by host name

Database by hostname grouping

08 Mar 2020

Database by hostname grouping is a new feature introduces in KeepTool 14.1.4. Each of our tools comes up with a connect dialog that displays most recent connections. Each connection may be either an Oracle SQL*Net connection, or a Direct TCP/IP connection. This list can be organized by History, i.e. most recently usage Database, i.e. either […]

ER Diagram creation improved again in version 14.1

16 Dec 2019

ER Diagram creation for Oracle databases can be automized by our KeepTool ER Diagrammer that 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 [...]

Reverse Database Engineer – New features introduced in version 14.1

08 Oct 2019

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

26 Apr 2019

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 […]