KeepTool Blog - Current

More Efficiency and Security with KeepTool 15

06 Dec 2021

KeepTool 15 introduces enhanced performance, compatibility, and security for Oracle databases. With full support for Windows 11 and Oracle 21c, new XML DB features, direct TCP/IP encryption, and visual object flagging, this release streamlines daily work for developers and DBAs. Experience faster workflows, better integration, and modern security — all in a single, intuitive tool.

Visualize Oracle Schema Dependencies with Ease

19 Apr 2021

KeepTool enables you to explore dependencies between Oracle database schemas through a clear diagram on the Schema page. It highlights upstream and downstream relationships for the current schema—master schemas that it depends on and detail schemas that depend on it. Plus, digging deeper is simple: click any schema to display related objects and their specific dependencies in adjacent tables.

Lightning-Fast Queries with Oracle’s Memoptimized Rowstore

23 Feb 2021

KeepTool now supports Oracle’s Memoptimized Rowstore (introduced in Oracle 18c), enabling blazing-fast lookups on tables primarily accessed by primary key. By activating this feature and populating the in-memory pool, queries bypass traditional I/O and SQL processing to deliver rapid results—perfect for high-frequency workloads like IoT or real-time dashboards.

Ensure Safe Oracle Scripts with Unicode Escaping

07 Dec 2020

KeepTool Hora now enhances your INSERT, UPDATE, and MERGE scripts with an option to escape non-ASCII or control characters using the UNISTR() function. This ensures your SQL remains robust and consistent—regardless of NLS settings or unseen characters—by automatically transforming special characters like ß into their \00DF escaped counterparts.

Track and Re-Execute Past SQL Commands with KeepTool

31 Aug 2020

KeepTool’s SQL Execution History feature logs every SQL statement you run. Quickly view, filter, and re-execute previous commands – no need to retype complex queries. Whether you’re debugging, auditing, or analyzing performance, the history view provides full transparency and control right inside the SQL Editor.

Organize Oracle Connections by Hostname in KeepTool

08 Mar 2020

KeepTool makes managing multiple Oracle databases easier than ever. Connections are now automatically grouped by hostname and service name, giving DBAs and developers a clear overview of all servers and environments. Find and connect to your databases faster — whether through SQL*Net or direct TCP/IP.

Smarter ER Diagram Creation with KeepTool

16 Dec 2019

KeepTool’s ER Diagrammer automatically creates professional, easy-to-read ER diagrams from your Oracle database. Generate focused sub-diagrams, link them with HTML documentation, and gain a clearer view of complex schemas. Perfect for developers, DBAs, and analysts who want to model, explore, and document Oracle databases faster and smarter.

Supercharge Your Schema Backups with KeepTool

08 Oct 2019

KeepTool’s Reverse Database Engineer lets you script both the structure and data of Oracle schemas with ease. Choose which objects or tables to include, add filters, and generate INSERT or MERGE statements instantly. Ideal for migrating databases, creating backups, or documenting schema changes — all with the flexibility and control that Oracle developers and DBAs need.

Quickly Resolve Oracle Blocking Sessions with KeepTool Hora

26 Apr 2019

KeepTool Hora makes identifying and resolving Oracle blocking sessions fast and easy. The Lock Wait Graph visually maps dependencies between sessions, showing which processes are blocked or blocking others. See exactly which rows are locked, end problematic sessions if necessary, and restore smooth database operation — all from one intuitive interface.

Elevate Excel Integration with KeepTool

01 Feb 2019

KeepTool enhances how you work with Excel and Oracle. Export grouped and aggregated data from Hora directly into Excel — complete with formulas and structure — or import Excel sheets into Oracle tables in seconds. KeepTool even creates new tables automatically when needed, making your Excel-based data management faster, smoother, and smarter.