Version 10

<< Click to Display Table of Contents >>

Navigation:  Getting Started > KeepTool Release Notes >

Version 10

Previous pageReturn to chapter overviewNext page

Version 10.1.4 (2014-02-27)

Compatibility for Oracle 11.2.0.


Version 10.1.3 (2014-01-09)

Our new setup prodedure includes also HoraLight.

Compatibility update for Microsoft Microsoft Security Advisory (2896666) to circumvent „Invalid Operation in GDI+ (Code 1)”  error on some older Windows versions.


Version 10.1.2 (2013-08-22)

Kill-Session menu item has been enabled for mutli-select.

Significant performance enhancement on session|overview and SGA|sql area pages.

Enabled for Oracle 12c and Windows 8.


Version 10.1.1 (2013-04-08)

Hora's "Create table from import source" command now has been enabled to process CSV files besides MS-Excel and MS-Access sources.

Unusable indexes are highlighted using red font.

When exiting Hora while a transaction is still active you will be asked weather to commit or roll back.


Version 10.1.0 (2010-07-12)

The new AWR button on the database page gives you an interface to Oracle’s Automatic Workload Repository. Please be aware of the fact that only users that licensed Oracle Enterprise Manager Diagnostic Pack are entitled to use  AWR. The first tab lists AWR snapshots grouped by database instance. The context menu allows you to add a new snapshot manually or create and show an AWR report.


Version 10.0.3 (2012-04-25)

The create insert script command now temporarily disables self-referencing foreign keys.

Rev/DDL's compile schema option is now checked by default and adds code to recompile invalid views.

The file search dialog on the SQL page is now available on SQL scratchpad as seen on file explorer.

The tree view on data contents now implements foreign key lookup same way as the grid view.

Improved formatting of Low Value and High Value on both Tables|columns and Tables|Statistics grids.


Version 10.0.2 (2012-02-21)

The data grid build-in filters now work case insensitive. A new checkbox on the “Behavior” settings page allows you to get back to  case sensitive filtering.

Rev/DDL has got two new main menu items to save and restore a configuration to an XML file.

The filter tab-set below the Tables | Overview grid changed from “All |Tables | Views” to “Tables | Views | Tables and Views”, i.e. “All” became “Tables and Views”  because the small “All” tab could be overlooked easily.

Both the “open table” button on the data contents browser and the “open other table” tab on the data contents detail view show the “Open table” dialog. It allows you to select a table name from a combo box and enter an optional filter condition. The filter combo box now shows a couple of filter templates. They are based on columns of the selected table such as COLUMN_NAME = '?' and can be changed. If you are on the data contents details view, references to the master table such as DETAIL_COLUMN = :MASTER_ID are added as well. It allows you to display your data in a master-detail relationship, even if there is no foreign key reference.

A new checkbox option allows you to change between multi-column and single-column record view layout.

The new menu item "Schema | Search all tables in schema for string ..." allows you to search the entire database schema for a string sample.The dialog shows table names, column names and the number of matches.


Version 10.0.1 (2011-12-12)

The MS-Excel export button now creates XLSX file format without the limitation of 65536 lines related to XLS file format.

The Explain Plan context menu item auto-selects the SQL statement at cursor position similar to the Execute SQL command (Ctrl+E).

The Scheduler page has been enabled for users with standard privileges.

Schema page uses DBA-Views instead of ALL-Views when accessible.

The Show DDL menu item is now enabled for multi-selection on the Tables, PL/SQL and Sequences page.

An asterisk shows up in the Statusbar to indicate the editor contains unsaved text.

Version 10.0.0 (2011-11-28)

The Tablespace fragmentation tab is now a detail view below the datafiles grid view and replaces the former free space subview. It gives you a better overview of used and free space.

Significant less memory consumption when creating an Insert or Update script from data contents view.

The generated Insert or Update script now contains an ALTER SESSION SET CURSOR_SHARING=FORCE statement for faster execution of big scripts.

The Index | Index Statistics - Validate Structure context menu item now shows results from INDEX_HISTOGRAM as diagram view and INDEX_STATS as data view.

Dialogs for gathering system, database, schema, table and index statistics show more options matching dbms_stats procedure parameters.

Added new context menu items to lock, unlock and restore schema and table statistics.

A new tab sheet on the database page shows dbms_stats system statistics. The context menu allows you to update statistics by calling dbms_stats.gather_system_stats.

Added a new column group to the tables | columns view. It uses optimizer statistics to show how frequently the column has been used in different WHERE predicates and a timestamp of last usage in a WHERE predicate. You can use the information to decide wether indexing the column would make sense.

oYou need either HORA_USER or SELECT ANY DICTIONARY role or SELECT privileges ON sys.col_usage$,  sys.col$, sys.obj$ and sys.user$. If you are lacking privileges, the appropriate columns keep null.

Tables | columns view now shows also the filter row known from the overview grids.

Support for compound triggers.

New tables | statistics view shows information about table and column statistics, histograms, statistic history and preferences.

On Windows 7 Hora 10 provides a Jumplist for the Windows Taskbar showing the most recent connections.

New wrapped columnar layout for record view.

The record view is now printable.

Both grid and record view can show a popup calculator for non-indexed numeric columns.

Both grid and record view now implement active tooltip hints that provide context sensitive lookup information from the database and the dictionary:

oFor the indicator column in the very left of the data content and SQL result set grids you will be shown a comma separated list of row values that is called instant record view. There is a setting that toggles prefixing each value with column name.

oFor  column headers you can see the SQL datatype of the underlying table column, the column comment and information about constraints.

oFor data content cell values that reference another table by a foreign key relation you will see a list of lookup values from the referenced master table. There is a setting to switch it all off for slow database connections.

Added a slider to the chart view to adjust the number of categories (i.e. x-axis values) shown per page.

Offline datafiles are displayed grayed, those needing recovery use red font.

SQL Scratchpad remembers last used tree node for each connection.

The SQL editor now sports a check list box showing an item for each SQL file in the current folder. You can batch execute a selected subset of files and it will consecutively load a file in the editor and execute it.

The new Pivot view on both data contents and sql query result set view is very powerful. You can drag-drop one or more fields to the filter, column, row and data sections of the cross table grid. After that, the pivot view shows data including column and row totals.

A chart view below shows the same data. You can select a smaller region of cells to reduce the amount of data show in the chart.

DDL creation for profiles.

Omit datafile name from DLL if db_create_file_dest parameter is set.

Roles granted to a user are now displayed hierarchically using a tree view. Object and system privileges can be shown in the context of the user or any role from the hierarchy. A checkbox allows you to include privileges granted to subordinate roles as well.

Roles granted to roles are displayed on the Database page similarly.

Explain plan dialog shows costs with decimal separators.

The Database|Undo (Rollback) segments page shows recommendations for undo tablespace size and undo retention time based on v$undosta

Show DDL menu item enabled for multi-selection on Synonyms page. This is especially useful for reverse engineering a bunch of public synonyms.

The dropdown list of the current schema selection box in the lower left of the main form now shows your login schema, CTXSYS, SYS and PUBLIC using bold text font.

The database | NLS parameters page shows NLS_LANG client settings from the Windows registry, environment variable and resulting NLS_LANG.

The Tables | Create table from import source dialog has been redesigned.

The new menu items File | Write to Oracle | Alert log, Trace File, Both allow administrators to leave a message in the Oracle trace file, alert log file, or both.

New page Data Pump shows information about Oracle datapump export and import.

The foreign key lookup dialog of the data contents grid now works in the filter row as well as in data rows. Press Return key to apply selected filter value.

Using the new File | Open File menu item, the corresponding toolbar button or Ctrl+O you can open an existing SQL file without navigating the file explorer on the SQL page. It will open in the PL/SQL editor similar to the "Open in separate editor" context menu item.

Another new menu item File | New File and the corresponding toolbar button open the PL/SQL editor with an empty file.

The "Describe" context submenu item has been moved from "Query" to a new menu item "Selected Object" right below "Query". There are three additional submenu items that allow you to expand a selected table name to a full SELECT, INSERT or UPDATE statement similar to the copy to clipboard commands on the Tables page. Another new submenu item "Show data" opens the result grid window showing the data of the selected table or view.

New tab sheet „Feature Usage“ on database page shows statistics about usage of Oracle features.

There has been a change in the information that is displayed in the free space column on the tablespace overview grid. The change is only related to temporary tablespaces. Up to Version 9 Hora calculated the free space information as the difference of the maximum temporary tablespace size and the overall size of allocated temp segments. Because Oracle doesn’t free temp segments this information doesn’t really give you a clue how much temp space is available to Oracle sessions. Now, Hora displays the real size that is available as temp space and includes both unused segments and not yet allocated space.