KeepTool 16.0.0

Published 18. September 2023

User Interface Modernization

The overall visual design has been modernized to reduce clutter and improve clarity.
New Light Style rendering option:
- Displays controls without thick borders, extra outlines, or visual noise.
- Adds extra padding for cells and headers and uses lightweight borders.
- When disabled (Extras → Settings → Behavior), grids look denser and can display more data at once.

The Connect dialog now supports multiple secure connection types:

A new dedicated ORDS page is available under the Additional tab, featuring:

Last file change timestamp displayed in the header (right of file name).
Recently changed SQL files highlighted in green (fading back to white in steps over time).
- Controlled by Settings → Other → Highlight recently changed database objects and SQL files.
Tree view: icon for the selected item now shows a pen overlay.
Execute Script: For large SQL files (>10k lines), you can disable visual feedback and dbms_output logging to boost performance.

New submenu: Copy to clipboard → Truncate statement creates a TRUNCATE statement template.
Truncate Table dialog now includes a CASCADE option.
Constraints tab: “Enable constraint” and “Disable constraint” support multi-select.
Indexes tab: Two new multi-select options:
- Make Unusable (recommended before mass inserts).
- Rebuild Online (restores usability).

INSERT script generation:
- Creates bulk INSERT ALL statements.
- Bulk size configurable in Settings (set to 1 for traditional non-bulk).
- Scripts split into multiple files if they exceed the configured size.
- Optional direct path inserts (adds /*+append*/ and COMMIT after each).
- Improved file writing performance using buffered streaming.
Flat Detail Data Browser (new):
- Opens a tree view showing the current table and all related detail tables via foreign keys.
- Supports flat display of all sub-detail data, bypassing grouping by master.
- Ideal for generating INSERT scripts for master-detail hierarchies.
Data type icons are now shown next to field captions in:
- Data Content grid,
- SQL Query Result grid,
- Record views.

Procedure and function names are displayed in mixed case (as in source code), rather than all uppercase from ALL_ARGUMENTS.
Option can be disabled via Settings → Behavior → Mixed case procedure names in PL/SQL call interface.

Properties dialog now offers more space for data entry.
Added button next to the password field to copy username → password (not recommended for security reasons).

New Flags tab in Settings:
- Allows customizing captions of color tags.
- Tags can be assigned to multiple database objects via the image combo box in overview grids.

Datafile grids now display percentile usage of the auto-extensible range.
Detail grids for free space fragmentation and segments are now displayed below the main grid (with slider), improving performance.
Queries on DBA_FREESPACE and DBA_EXTENTS may still be slow on some databases—purging the recycle bin can help.
Add Datafile dialog:
- Filename defaults to current datafile + “_new.”
- Initial/Next sizes derived from the selected datafile.
- Max size defaults to unlimited.
- Sizes displayed in GB when applicable.
DDL for tablespace creation now includes MAXSIZE UNLIMITED if supported by the DB.
Quota display unified across:
- Tablespaces → Utilization by User,
- Users → Tablespace Utilization,
- Schema → Summary.
- Quotas and usage shown together; unlimited quota shown as UNLIMITED.
- Checkbox indicates if UNLIMITED TABLESPACE privilege is granted.
Schema Summary now displays tablespaces without explicit quotas if unlimited privilege applies.

New option: Open PDB in restricted mode.
Create PDB dialog gains two optional parameters:
- PDB max size,
- Path prefix.

Displays time zone file version from V$TIMESTAMP_FILE.
Helps prevent ORA-39405 errors during Data Pump imports between mismatched TSTZ versions.