KeepTool Blog - Current

KeepTool lets you flag your database objects—assign icons like colored bullets, stars, or warning signs directly within your object overview. Once flagged, items remain visually marked across all KeepTool components—from the query builder to ER diagrams—making it fast and easy to keep track of the tables, packages, or sequences you're focused on managing.

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.

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.

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.

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.

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.

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.

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.

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.

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.