Check It Out: New version of

Hello!

A new version 1.4.0 of Top100 has been released today and is available at: http://www.materialdreams.com/products.html

FIXED SEVERAL PROBLEMS WHEN ANALYZING STATEMENTS:
- When the application cannot analyze a statement
  the statement fill be skipped and processing continues.
- A new column status shows if and how the statement
  was analyzed or if any error has occurt.   The following information can be found:   "analyzed" ... the statement was process correctly   and all information is available.
  "not analyzed" ... the statement was not analyzed   because it is not a select, update, insert or delete   statement.
  "expired" ... the complete statement cannot be retrieved.   This condition in not an error condition and ac occur   on a heavy loaded system.
  "error" ... an error occurt when analyzing the statement.   The statement was not analyzed but can still be seen.
- The columns "cost" (total cost) and "# FTS" (number
  of needed full table scans) can only be used if the   statement was analyzed correctly and will be null else.

SELECTION OF STATEMENT OWNER:
- The selection of the statements by the user who
  first parsed the statement has been comletely redesigned.   A new Tab (Users) in the Preferences Dialog allow to   select any compination of users from a predefined list   of oracle users using the checkboxes in the list.
- The limitations in seleting the SYS and SYSTEM user
  are no longer needed and have been removed.

IMPROVED THE PROCESSING SPEED:
- All database accesses have been redesigned and optimized
  by using array fetches, no longer sorting in the database   and not performing any joins in the database.   Because of the lack for fast index relational access   to the dynamic performance tables in Oracle the complete   tables will be fetched and then processed locally.
- All static information (users, paarmeter, etc.) will
  be cached locally and used for all refeshes.
- Additionally the application now shows a progress
  message during the process of analyzing the sqlrea   and informs you of the time left to wait. The processing   can also be cancelled at any time.

OTHER IMPROVEMENTS:
- The application now saves and restores the latest
  position of the main application frame.
- A new column has been introduced showing the internal
  statement address.
- The existance of the plan table will be cheked at
  program start.
- Fixed a failed assertion when setting the sort
  order to an invisible column in the preference   Dialog.

Have a look at it!

Please consider joining my mailing list at http://material.dreams.listbot.com.

web: www.materialdreams.com
mail: info_at_materialdreams.com Received on Sat Jan 06 2001 - 17:17:31 CST