Oracle 7.3 - Oracle 23ai 20+ years of experience Version (Released: )

KeepTool Blog - Current

Flag your database objects

18 Feb 2022

We will show you how you can flag your personal subset of database objects by assigning an appropriate icon: - How to flag database objects - Keeping organized - Sample use case
Overview KeepTool Hora - Handy tools for Oracle datases

KeepTool 15 new features and improvements

06 Dec 2021

This blog introduces new key features of KeepTool 15 such as: - MS Windows 11 and Oracle 21c database support - XML DB improvements - Flagging database objects - Data encryption with direct TCP/IP
Oracle schema dependencies screenshot

Oracle schema dependencies

19 Apr 2021

Oracle schema dependencies is the topic of our newsletter: - Oracle schema dependencies explained - Oracle schema dependencies diagram - Drilling-down object dependencies
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: - Escape Unicode characters in SQL - Filter expression editor
Oracle SQL execution history

SQL execution history – retrieve and re-execute

31 Aug 2020

Today we show you how to display a list of most recently executed SQL commands and how retrieve a statement for re-execution. Furthermore, the blog introduces some new features of KeepTool 14.1.6.
Recent Oracle connections grouped by host name

Database grouping by hostname

08 Mar 2020

Database grouping by hostname is a new feature introduces in KeepTool 14.1.4. [...]

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

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 very important to quickly identify the cause behind such blocks. [...]

Oracle Excel export/import enhancements

01 Feb 2019

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. [...]
Oracle master detail data view

KeepTool 14 new features and enhancements

25 Jun 2018

KeepTool is considered a Swiss Army knife for administrative and programming tasks related to Oracle databases. The software supports all Oracle features, and its use is self-explanatory and incredibly simple. “Time and time again, our users confirm that they find their bearings immediately and are able to use all functions straight away, even without a manual,” says Rolf Grünewald, Managing Partner of KeepTool GmbH. Another strength is that customer requirements from daily practice are captured and implemented in a short period of time. KeepTool has therefore been expanded with over 40 new functions in Version 14 and given a new design that further improves user-friendliness: “The version released on 25 June 2018 is already proving to be extremely popular.” [...]