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

KeepTool Blog - Current

Backup SPFile to PFile dialog

Memoptimized Rowstore – Fast Oracle data access

23 Feb 2021

The memoptimized rowstore provides the capability of fast data lookup for tables that are mainly queried based on primary key columns. We show you how to use with KeepTool.
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. [...]

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 very powerful option for any database developer, because you can run the script later on another machine to re-create the database structure, or simply retain the script as part of your backup strategy. [...]

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

Oracle Excel grouping retained in export and computed totals

30 Sep 2018

Data grouping withing Oracle Excel export now can be retained. As you may rememeber, column groupings are available both in Hora’s data content browser and SQL result set view. [...]