Check It Out: Top100 Version 1.3.0 shareware tool has been released!

Hello!

The new versions 1.3.0 of Top100 has been released:

Version 1.3.0 - 09-DEC-2000

IMPROVED PRE-PROCESSING OF SQL STATEMENTS:
- During the analysis of the SQL area in the Oracle

   instance the system now also automatically loads    the complete SQL statement and additionally    analyzes and retrieves the execution plan of each    statement.
- This makes sure that all SQL state in the table

   can be shown and analyzed. In older versions the    system might have reported, that the statement is    no longer available in the sga and therefore cannot    be analyzed.
- The preprocessing of the SQL statements slows

   down a little the refreshing of the statement list    but being highly optimized the total time of    processing if still acceptable.
- The execution plan now observes the optimizer goal

   set for each individual statement.

NEW INFORMATION IN THE TABLE:
- The columns Cost and FTS have been added to the

   table and offer a very interesting overview of the    pre-analyzed statements.
- The column cost is retrieved from the execution plan

   for each statement and represents the cost of each    statement.
- The column FTS (Full Table Scan) is the number

   of full table scans needed for each statement    and is a very good indicator for SQL statements    that might need special attention or missing    indices for the statement.
- Booth fields are only available when processing

   SQL statements that can be analyzed. (SELECT, INSERT,    UPDATE and DELETE)

IMPROVEMENTS IN THE TABLE LAYOUT:
- The table layout (visibility, width and order

   of the columns) can be changed.
- You can sort the table by any column by clicking

   the column header. The current sort settings will be    indicated in the column header with a small arrow.    The sort order changes each time you click on a column.
- A new tab in the properties dialog allows to see

   the current table layout and also to hide one    or more columns. Additionally you can restore the    default table layout by pressing the default button.
- All the information of the table layout will be

   automatically stored/retrieved when leaving/starting    the application.
- Changing the order of the columns can be done by

   dragging the columns to its new position.
- Improved table appearance using auto select row feature

   and flat scrollbars.

GENERAL IMPROVEMENTS:
- The applications now checks the availability and

   versions of all needed system components before    starting and reports any missing components.
- A small help file named (Top100.hlp) has been added

   to explain the usage of Top100.
- The application now supports online help and

   opens the Top100.hlp file when help is requested.
- It is now possible to unregister the application

   using the Unregister item in the Help menu.
- It is now (also) possible to access the Top100

   web page using the Visit Web Page item in the Help    menu.

Go to my web page and download the newest revisions of Top100!

Regards

email: doberkofler_at_usa.net
web: http://www.geocities.com/doberkofler Received on Sun Dec 10 2000 - 19:56:57 CET