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

KeepTool 9.0.1

18 Jan 2010

  • 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
    • Checkbox for Default table compression
    • Undo tablespace retention
    • Checkbox “Big file”
    • Predicate Evaluation (Host/Storage)
    • Checkbox “Encrypted”
    • Compress 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.

See how it works!

Explore possibilities of KeepTool.