Check It Out: New version of my shareware tool Top100!

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 Received on Sun Dec 10 2000 - 13:17:09 CST