Oracle 7.3 - Oracle 23c 20+ years of experience Version (Released: )
28 Nov 2011
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.
You 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:
For 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.
For column headers you can see the SQL datatype of the underlying table column, the column comment and information about constraints.
For 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.