Version 9

<< Click to Display Table of Contents >>

Navigation:  Getting Started > KeepTool Release Notes >

Version 9

Previous pageReturn to chapter overviewNext page

Version 9.1.5 (2011-08-01)

The Clear Schema procedure now drops jobs and triggers prior to other database objects.

Version 9.1.4 (2011-03-21)

Added a checkbox above the DBA|Users|Roles grid that includes object privileges implicitly granted by role. They are marked '~' to distinguish them from privileges granted to the user (lower case 'x') directly and those besides grantable (upper case 'X').

On the Sessions | Locks page is a new checkbox "is user" that indicates wether the lock type takes part in the mechanism of locking sessions against each other. No-user locks are displayed in gray font. In accordance to this change the overview page now counts only user locks held and requested.

Temporary Tablespace | Temp/Sort Segment Usage is shown in detail grid.

Version 9.1.3 (2010-11-08)

Using XMLSERIALIZE the data contents grid now shows XMLTYPE columns as CLOB in read-only mode.

Please remember, you get full read/write support for XMLTYPE columns when connected with an Oracle client.

The maximum number of dropdown list values for grid column filters is limited to save grid performance. This limit now can be customized using the Extras|Settings|Behavior|FilterMaxValueListCount spin edit control. You can change the value to zero for unlimited dropdown list size but this may result in poor grid performance for large result sets.

Version 9.1.2 (2010-09-02)

The Show DDL command for a selection of multiple users now generates a common block with distinct ROLE and TABLESPACE create statements for the selected users.

Network licensing compatibility improvements for less privileged OS users.

The tablespace overview grid now shows a checkbox that is checked for the default permanent and temporary tablespace. The context menu allows you to set a tablespace as default.

This requires Oracle 9i for temporary and 10g for permanent default tablespaces.

The users overview grid has got a new column that shows the number of objects owned by the user. It keeps blank for users without objects. This allows you to filter by not null values to show all database objects owners.

There is a new button on the Schema | PL/SQL errors page that allows you to edit the PL/SQL object and show the error. This is similar to the existing "edit in a new window" button on the PL/SQL overview page.

Minor improvements for handling temporary tables.

Array fetch size for overview grids is now configurable by settings.

Performance enhancement on tables page.

Load/save template button on data export wizard

A new check box option has been added: Behavior - Disable in-memory mode for tabbed data grids. It is recommended to check only if there are tens of thousands of tables in one schema. This will speed up data grid performance and disable some enhanced grid options. The setting does not influence data contents and SQL scratch pad pages since both always come up without in-memory grid mode.

Version 9.1.1 (2010-07-27)

Office 2010 compatible skins

New Windows Service Application that keeps network licensing grace period charged on Windows Vista and later (see installation instructions)

Version 9.1.0 (2010-07-02)

Data export and import dialogs replaced.

Added Granularity and Degree options to the analyze schema, table and index dialoges (dbms_stats interface), especially for partitioned tables.

Added V$SESSION.SERVER column on sessions page.

Setup routine with improved Windows 7 support

Version 9.0.3 (2010-03-04)

The modal dialog for analyzing table using dbms_stats now allows you to enter a estimate percent value. By default it keeps blank as before. Furthermore, if the table is partitioned, you can select a partition from the combo box. If you keep the box empty the entire table will be analyzed as before.

A new context menu item for tables | partitions has been added to give access to the dialog from the context of a table partition.

Added support for creating users identified globally (LDAP/AD/OID). The appropriate column EXTERNAL_NAME is shown on the users page. DDL generation has been changed as well. (10 or higher).

A couple of minor enhancements of create/alter user dialog

Version 9.0.2 (2010-02-27)

New commands Schema | Statistics | Gather Data Dictionary Statistics, Delete Data Dictionary Statistics, Gather Fixed Objects Statistics, Delete Fixed Objects Statistics accessible for SYS as SYSDBA covering dbms_stats package calls.

The connection dialog now shows two OCI DLL settings for global and individual Oracle home selection:

oThe default OCI DLL is used whenever no other OCI DLL is defined in the complementary box.

oThe complementary OCI DLL overrides the default setting for the current SQL*Net_service.

Both Create Insert Script and Create Update Script menu actions now allow you to change the file encoding between ASCII, Unicode, etc. in the file save dialog.

If the file editor detects a non-ASCII character such as a German umlaut it suggests switching to Unicode encoding. You can follow or decline the suggestion. Furthermore, a checkbox allows you to suppress further prompting. You can get back to being  prompted by checking the box "Ask for change to Unicode" at Extras|Settings|SQL page.

BTW, you can switch file encoding anytime using the file editor context menu.

Inplace bar diagrams on explain plan tree view for better overview of costs.

Multi-select option enabled in data grids. Now you can copy the tab-delimited content of selected data rows (excluding invisible columns) into the clipboard by pressing Ctrl+C. Clipboard content fits nicely into MS Excel spreadsheets.

A new option Others | Query GV$-Views on Sessions page (Enable RAC support) introduces limited RAC support for Oracle 10g and later. If checked, the sessions  page queries GV$-views instead of V$-views. As a result, it shows information from other instances as well.

Modal context menu dialogs now come with full look and feel support for the Office 11 visual style.

Both data contents browser and Hora's tables overview remember the last used table name separately from the last used view name. When switching from tables to views and back to tables, you will find the last used table name selected again. When switching to views, you will find the last used view name selected.

Chart view in data contents view and on SQL page now allows you to show up to 5 instead of 2 series.

Powerful privileges such as DBA, UNLIMITED TABLESPACE, BECOME USER, RESTRICTED SESSION, %ANY%, %P_FULL_DATABASE are highlighted red in appropriate detail grid views of both Users and Roles page.

Version 9.0.1 (2010-01-18)

UniCode support (UTF-16)

New filter row in data contents, SQL query result set, Overview  grids and connect dialog grid allows fast filtering

New Diagram View page for Data Contents and SQL Result allows you to show different chart views of your data.

New Tree View page for Data Contents and SQL Result allows you to show hierarchical data as tree view.

Connect dialog remembers OCI.DLL for each server and connection.

Reverse/DDL allows you to select the schema to being reverse engineered

Checkbox on DB object browser (editor component) to change between alphabetic and logical column order.

Table or column comment for selected node is shown in a new text box below the tree view.

Users page shows a checkbox column that unveils DBA privilege.

Users with DBA privilege are listed in red font, locked user accounts in gray.

New Oracle 11g related information on Users page:

Default password (such as tiger for scott) according to dba_users_with_defpwd  dictionary view

Checkbox for SYS_ASM login privilege

Password versions shows security rules for database users that have been migrated from 10g to 11g

New Oracle 10g and 11g related information on Tablespace page

oCheckbox for Default table compression

oUndo tablespace retention

oCheckbox "Big file"

oPredicate Evaluation (Host/Storage)

oCheckbox "Encrypted"

oCompress for (by default for what kind of operations)

For Oracle 11g database the triggers list on the tables page shows a new detail grid with firing order definitions.

You can now tab-switch between session and system parameters on the Database-Parameters page. The context dialog to change parameters shows valid parameters in a combo box from v$parameter_valid_values as far as it is accessible regarding database version and privileges.

Support for read only constraints on views added.

Show DDL command for policies on schema page

PLSQL type dependency view similar to PLSQL package/procedure dependency sheet.

Error messages from import wizard dialog are dumped to dbms_output window. This allows an unlimited number of errors to be read.

Show DDL and Drop Role context menu operations are now available to a selection of multiple grid rows.

Tablespaces | Segements page shows pie diagram view of tablespace utilization by user.

Performance|Disk I/O view now includes tempfiles

Connect dialog shows new custom category for grouping by such as server location, project name, etc.

Schema | Disabled Constraints page renamed to Not Validated Constraints. It shows both disabled and not validated constraints. A new column Enabled allows you to filter either of them

New page Schema | Dependencies shows relations with and dependencies from other schemes.

The HTML documentation generator now makes use of the modal connect dialog.

Enhanced data grid printing dialog including optional PDF export.

Columns that display information about database jobs on sessions page are hidden by default. A checkbox click makes them visible. This results in significant performance enhancement on later database versions due to eliminating access to DBA_JOBS dictionary view.