This document enumerates new features and known problems of the different versions. Version 1.7.0 ============= New features ------------ - sql plan baselines in top sql info - main menu changes when connected to ASM instance - ASM related menus and windows - QT 4.7 - Qwt5.2.1 - Archive generated now also calculates the size of archive generated - Extensive coverage of v$active_session_history (in Performance menu) - Extensive coverage of dba_hist_active_sess_history (ASH in AWR) - DBA_objects info: Full dependency tree (up and down) - User defined SQL: From the list there are menu options 'New' and 'execute' - Recycle bin overview in database overview - Recycle bin in 'all objects' and 'user objects' windows (with sql scripts) - For packages, procedures, functions: Argument list and describe - For packages: Sub program list - In tools menu: Possibility to request description of PLSQL objects - Instance overview: dba jobs/scheduler job running is now joined with more info - AWR analysis Load profile: Split into load profile and time model - AWR analysis Load profile: 1 tab per metric - List of jobs: Possibility to generate SQL to manage the jobs (submit, ...) - List of scheduler jobs: SQL to manager jobs (enable, drop ,stop...) - Only SQLs in versions 9.2 and higher are still maintained Solved problems --------------- - some SQL corrected in dbacomp.10.1.sql - AWR reports window titles corrected - dba_objects info: SQL for dependency now correct - Charts no longer crash when there is no data - Audit menu now under 'Database' (was 'instance') - Empty bind vars no longer lead to crash under windows - Title of trigger info window no longer states "Function info..." - newline no longer stripped from data - Copydialog now correctly shows newlines - in the grid type lists multi-line data is shown as scrolled to indicate that there is more New problems ------------ - locktree: The indicated objects may be wrong in certain cases Version 1.6.0 ============= New features ------------ - File/new is now calling the command found in dbacomp.ini - Add redo log member SQL generation - For 10G only: Plan displayed with dbms_xplan (SGA and top sql) - AWR and SP SQL: double-click to see old plan and complete SQL text - Old hash value integrated in point size test - Today button for AWR/Statspack dialogs - AWRRPT and AWRSQRPT integrated into AWR module - Improved performance for current SQL plan (e.g. from top SQL) - SQL Plan now handle correctly multiple plans - multiple possibilities to view the SQL plans - ADHOC SQL can be saved in user.sql or other file - user sql can now be opened in adhoc - user sql contains shpool* SQL which allows to investigate ORA-4031 errors due to shared pool fragmentation - awr/sp IO now includes average write time - awr/sp IO now includes redo IO - Show SQL dialog now also displays formatted sql and allows to open it in Adhoc or Editor - Show SQL dialog now also shows bind vars - Statpack/AWR: wait times are now compared to db time - Statpack/AWR: db times (cpu, wait and total) are now included in wait statistics - 'no initial query' mode can be toggled with ctrl-i - SP/AWR: cpu consumption has now PCT column (PCT of whole server) - AWR SQL is RAC aware now (shows data of current instance only) - Detects if RAC DB (shows instance name in title) - Compiles and works with 11g (but not all SQL validated against 11g) - Adhoc awr reports and report diffs - Cache not renewed at reconnect to same version - AWR settings window and snapshot errors - SP settings window - Full table scan SQL corrected and enriched with CPU and elapsed time - Indexed columns and functions tabs in table info and full table scan info - Possibility to generate SQL tuning tasks from awr SQL and top SQL - Possibility to generate SQL access advisor tasks (Quick tune) from awr SQL and top SQL - Advisors (sql tuning, addm, undo, segment): - view runs and reports or findings - generate SQL for advisor runs - w_awr_sql_info no longer crashes under windows - all bind vars separated by space in sql files - advisor overview - SQL tuning sets (view, generate from different sources, generate sql tuning advisor task) - SQL workload (view, generate from different sources, generate sql access advisor task) - sql profiles Solved problems --------------- - AWR SQL no longer gives ORA-1476 (division by 0) - No more missing SQL names in 'Show SQL' dialog - bind var dialog now also correctly works in tabs - Maximized user information screen has no more problems with menus for the 'Objects' tab - Statspack SQL stats is no longer shifted by one point compared to other statspack stats New problems ------------ - 'group by' in sub queries can confuse DBAComp parsing - subsequent bind vars not separated by space are considered as one in 'Show SQL' Version 1.5.0 ============= New features ------------ - possiblity to have a chart representation of the data of each window (based on Qwt; see README for more information) - statspack analysis tool with graphical representation possibility (menu 'Performance/Statspack analysis'; see README for more information) - Archival history information (menu 'Performance/Archive generated') - Tested with 10G up until release 2 - activate different types of session tracing using events or dbms_support - trigger and index creation scripts now use dbms_metadata - List of full table scan plans currently in shared pool (under Performance menu) and possiblity to double click to see corresponding SQLs - The contents of the 3 buffer pools can be seen from the 'Instance/SGA' menu - Capstat module - CPU time and Elapsed time columns for top_sql - 10G specific features: - scheduler jobs, - add new cols to session window - session wait history - v$sga_dynamic_components, v$sga_resize_ops tabs in SGA window - sysaux occupants in DB overview - add all columns of v$sqlarea to top_sql (and full text with dbl click) - pct elapsed and cpu in sp_sql - osstat - awr (menu 'Performance/AWR analysis; see README for more information) - addm - view number of entries in DBAComp SQL cache Solved problems --------------- - 'group by' clause now correctly handled when adding other where clauses - Bind variable dialog no longer opens when clicking on column headers - Copy dialog no longer appears when clicking on package body info - Trigger generation SQL now contains the trigger owner - sort/filter dialogs now add new text at end when the expression field has no focus - Tbs size and free space report no longer shows several rows to temp tablespaces with several temp files - 'watch' icon cursor now displayed when clicking on column header to sort - timestamp and interval datatype now correctly displayed New problems ------------ - The column 'dba_triggers.description' is used for the trigger SQL generation but it is missing spaces and therefor the generated SQL does not work (even with dbms_metadata). - Buffer pools window ('Instance/SGA' menu) cannot filter - Empty dialog fields may cause crash under windows (e.g. empty password field, empty snap_id in awr or statspack) - Statspack SQL report chart is shifted by one point to the left compared to other statspack reports (only graphically, data is still correct) - Chart representation may crash when too many series (due to memory constraints) - Statspack and AWR reports have not been tested with multiple DBIDs or INSTANCE_NUMBERs (e.g. RAC) - Point size is currently not implemented for Statspack (with the exception of 'point size test' menu) Version 1.4.0 ============= New features ------------ - User defined sql now allows use of bind variables. When there are bind variables in the sql then a dialog will appear requesting the values to be provided. This also works for adhoc sql and for standard pages when more bind variables exist than parameters are passed in the program. This last situation is of course a bug but using the dialog you can provide the missing parameters and thus still get the results. - Data Block Address (DBA) search tool (in Tools menu) to find the segment corresponding to a specified DBA. The user needs to specify the file id and the DBA (Data Block Address). - Instance parameters and hidden parameters in Instance/Parameters menu. Hidden parameters only works when connected 'AS SYSDBA'. - V$ menu (new style) now recognizes existence of sql in the dbacomp.*.sql file related to the current v$ view and uses that sql instead of the standard 'select * from' sql. - Dba_objects info now has 2 tabs to show dependencies involving the current object. - Connections 'AS SYSDBA' and 'AS SYSOPER' (local and remote) are now supported in all connection scenarios (logon dialog, command line logon, sqlplus invocation and script execution). Simply specify 'sys as sysdba' for the username. - Object recompilation now also recompiles JAVA CLASS objects - A new copy dialog available on each window (from the 'Action/Copy...') allows to get access to the window content in editable fields so that you can copy the column name or content to a different application. - You can now click on the column header in each list window to sort by that column. When you click a 2nd time the sort is descending. Only single column sorting is possible in this way. - The Oracle interface oraconnect now supports CLOBS (up to 64k) and Universal ROWID. - For Oracle dbs of versions 9i and above the table creation is now generated with dbms_metadata. This means that the syntax will always be correct and that generation for partitioned tables no longer crashes. - For Oracle dbs of versions 9i and above the tablespace creation is now also generated using dbms_metadata. This means that the syntax will always be correct for all types of tablespaces. - SQL script generations for redo log group drop and create - Segment statistics tab in segment, table and index info page - 'Registry' tab in 'Database overview' window. - Top SQL and the 'Shared SQL' tab in the SGA window allow to drill down (double-click) to the SQL Plan - 10G is now also supported (no extensive testing done yet) Solved problems --------------- - Status text 'no initial query' now correctly stays after reconnection. - SQL for the locktree in 9.2 has been changed to use RULE hint to make it useable again (in choose it was very slow in Oracle9i 9.2) - SQL for dba_jobs_running has been changed to use RULE hint to make it useable again (in choose it was very slow in Oracle9i 9.2) - SQL generation for temp file resizing no longer crashes - SQL generation for adding temp files no longer crashes - In Adhoc SQL you can now have SQL with carriage returns. Before this crashed DBAComp (Windows) or generated an ORA-2108 (Unix). - View text is now word wrapped if source does not contain carriage returns - Performance indicator screen no longer generates 'ORA-01722' under windows - In the sort and filter dialog, in the 'Expression' field text selection and insertion now works as expected (replaces selected text instead of writing at the end). - Menu shortcuts have been reviewed to be unique under all circumstances. - Synonym creation script now correctly handles public synonyms - All data file related SQL has been generalised to include 'temp files' as well New problems ------------ Version 1.3.0 ============= New features ------------ - Top SQL in performance menu - Log mode - No initial query mode - One dbacomp.sql file per Oracle version to have same performance for all versions - Redesign of the v$ menu (complete list of v$ views and dynamically managed by the dbacomp.ini file) - Switch schema in compiling invalid objects - Account lock/unlock script - Temp files are now shown in the data file lists and considered in tbs reports - Compiles and runs against QT 3.1 and 3.2 beta 2 Solved problems --------------- - Privilege granting script now correctly works for directory objects - Constraint creation script now correctly generates columns for multi-column constraints - formdatadisplay no longer increases col lists with every retrieve - Bug correction in the MLEDataDisplay::retrieve method New problems ------------ - No initial query mode is ignored by privs tab in packages info window - sys as sydba connections are not possible - SQL script generation may lead to crashes if done on empty lists Version 1.2.0 ============= New features ------------ - Works with Oracle9i Release 2 (9.2) - Compilable under Qt3 - Lobs now integrated - Tablespace size and free space reports are now dbl-clickable windows and have a 'Generate SQL' menu - Sandhour icon mouse pointer and message in status bar while connecting - package info now has sub tabs for header and body - functions, procedures and packages now have an error tab - dbacomp.sql now has a section for Oracle9 and 9.2 - Grant given on functions,procedures and packages in info screen - dba_jobs_running in instance overview - v$sort_usage, v$tablespace, v$subcache, v$object_dependency, v$obsolete_paramter, v$reserved_words, v$rowcache_parent, v$rowcache_subordinate, v$tempfile - limit the number of lines for extents left report to 10 (8i only) - 'drop user' sql generation - Shared pool reserved tab in SGA window - Buffer cache tab in SGA window - v$buffer_pool - sort segment and sort usage tabs in tbs info - fragmentation column in free space and tablespace size reports - dba_objects can now be double clicked and has and access tab - v$session info now has an access tab - Datafile scripts: offline, online, rename, autoextend (on/off) - extents left report now has initial and next extent columns - max_rows entry in dbacomp.ini limiting rows in tables and views - unicode support - v$instance_recovery - extents left report has now tbs column - sys.props$ tab added to db overview - Visual indication when filtered - Timer - Icons in the menus to better relate to the icons in the toolbar - Tablespace creation script now supports locally managed tablespaces - Free space report allows drill-down - find/replace in sql editor - adhoc SQL: new icon to execute SQL and change of menu item 'Test SQL' to 'Execute SQL' - v$latch - tabs can now add specific sub-menus to the action menu (e.g. procedure info/ Source (text) tab has a find/replace sub menu) Solved problems --------------- - The prefetch=0 workaround has been introduced to allow Oracle9i connections (from 8i environment) - oraconnect.pc has been changed so that there are no more duplicated int i declarations (Windows and HP compilers complained about this) - RAW columns are now correctly handled - v$shared_pool_reserved is no also available for version 7 and 8.0 - All message boxes now have a default button - enhancement of the cluster creation script - datatype 'raw mlslabel' no longer generates ora-932. This datatype is used in the audit trail of 7.3. and 8.0. This has simplified the SQL for the screens accessing the audit trail - Line 113 of gensql.cpp is no longer comparing long to QString - permanent/temporary keywords now generated for create tablespace script generation - Index and table size calculations now return the correct size - table creation script generation no longer contains 'cluster' when table is not part of a cluster - free space deficit report now displays rows even for tablespaces where the free space is 0 - free space and tablespace size reports now display tablespaces even if the free space is 0 - platcom.conf now contains correct compiler/linker flags for hpux-aCC - partition tab for tables now works also for version 8.0 - removed 'Printer setup...' menu which was not implemented anyway - main.cpp no longer has double int i declarations - Caption of DBA_SEGMENTS window is no correct - On Windows: No longer crashes when going to user information screen objects tab (the calculate menu now also correctly appears) - Changed title of Adhoc SQL window to 'Adhoc SQL' - Corrected ora-932 for audit screens (due to raw mlslabel datatype) New problems ------------ - SQL generation for cluster is not correct (contains empty storage clause params) - For tabs in tabs when looking at the SQL text the sql name is empty - Printing under windows does not work correctly Version 1.1.0 ============= New features ------------ - A locktree window showing locking conflicts in a tree display. - Maximum SQL size is now 2k - Script generation to add a datafile to a tablespace - Script generation to resize a datafile - SQL changed for tablespace size and free space reports - In tables info screen: new tab giving the tables that have a foreigh key pointing to the current table - v$controlfile_record_section, v$shared_pool_reserved - Extents left report now has a column for percentage - Renamed entry 'Adhoc SQL' in tools menu - SQL Generation Editor has been extended: Save, Save as, Open, New, Execute, Execute with other credentials. This means that you now can execute a generated SQL directly from DBAComp. - SQL Generation Editor added to tools menu - SQL script generation for user creation - SQL script generation now has option to specify spool and echo - Outlines added to object types - Enhanced v$sesstat screen - dba_obj_audit_opts, all_def_audit_opts screens - Added number of fragments in tablespace and storage params (for the segment) to free space deficit report - Script generation to become a user - Forms background is now same as list background - audit sqls now have a sort clause on timestamp - recompile objects script now also considers object type TYPE - datafiles are now sorted by tablespace name - outline script generation: rename, category change Solved problems --------------- - dblink generation now omits 'using' clause when there is no host data - generating a trigger no longer says: "No such column: trigger_event" - platcom.conf now correctly says aCC instead of acc - crdbs config generation, tbs and rbs generation now replace empty max_extents with 'unlimited'. - crdbs config generation now recognises audit tablespace - The user role privs sql script now correctly says 'with admin option' for roles instead of 'with grant option'. - default user.sql has been cleaned up. - error in sql for dblink script generation corrected - free_space_deficit sql corrected - v$session window no longer gives ORA-1801 on some systems. The SQL has been changed: to_char(LOGON_TIME) LOGON_TIME - In SQL generations changed inittrans to initrans - Constraint create no longer attaches the 'tablespace' clause and the tablespace name - Configure now also looks for Qt 2.3 libraries - Configure now correctly works on HP (looks for *.sl instead of *.so) - Configure now correctly sets the paths in dbacomp.ini New problems ------------ + On Windows: The calculate menus appears for the dba_users window. Version 1.0.1 ============= New features ------------ Solved problems --------------- - No longer crashes when a SQL error occurs. New problems ------------ Version 1.0.0 ============= New features ------------ - Compiled and tested against Qt 2.2.2. - Possibility to launch a new instance of DBAComp using File/New menu. - Comment added to sort/filter dialogs. - New report: Invalid objects with the possibility to generate a compilation script. - Reordering of the columns of the v$parameter screen. The name column now is the first column. This way you can type a letter in that screen to immediately scroll to the parameter starting with that letter. - It is now possible to drill down from the tables info/constraint tab to constraints info. - WaitCursors are now shown when appropriate. - Tables and indexes have tabs for partitions and subpartitions. - Section order in default dbacomp.ini is now 8.1, 8.0 and 7.3 to improve performance for Oracle8 (which is probably used by most). - Better documentation. - Cleanup of code. - Compiler directives that influence the compilation: DESTRACE to be able to trace the destruction sequence and SQLTRACE trace to be able to see what SQL is executed by DBAComp. To use them you have to set either or both of the following environment variables: SQLTRACE=-DSQLTRACE, DESTRACE=-DDESTRACE. Now 'make clean' and 'make' from the top dbacomp directory. - Tested with Qt 2.1.0-2.2.2. - New DataDisplay descendant: MLEDataDisplay. It allows to display the result a query as text in a MultiLineEdit. It has the same functionality as the other DataDisplays (retrieve, print, save, sort, filter, show SQL). Moreover it offers all the editor like functionality you can find in a multilineedit. - MLEDataDisplay is now used to display the source code of procedures, packages, functions, triggers and views. This gives a cleaner presentation and is much more natural for this kind of data. - The session detail screen contains a process tab. - DBAComp registers itself in the v$session view using dbms_application_info.set_client_info Solved problems --------------- - Index creation script generation no longer gives message: "no such column: TBS_TRANS". - DBLink creation script now has quotes around the tns alias. - Printing of grids no longer enters an endless loop when there is a column that is larger than the page width. - The 'value' column is no longer right aligned in the v$parameter screen. - 'Kill session' and 'enable tracing' script generation for multiple sessions now get serial# correctly. - The SQLs in certain tabs (performance indicators.other, tbs info.space and database overview.structure) are no longer executed twice. - Another occurrence of 'QMenuData::removeItem: Index -1 out of range' has been solved. - All icons are now transparent. - In the 'user defined SQL' window the print menu option and toolbar icon now only appear once and work. - Looking at the source code of stored PL/SQL code (stored procedures ,...) the indentation is no longer stripped. - All decimal numbers are now right-aligned. - The script generation dialog now correctly handles the 'file already exists' cases. - Table generation (with and without constraints) no longer generates 'no such column cluster' error. - Database creation script: redolog file size is now correct, the redolog file definitions are now separated by a comma, syntax correction for the tablespace creation. - The object tab is now the first tab in the dba_users detail screen. - The 'table with constraint' script generation with all objects can now be stopped using cntrl-C. - The dialog for 'database creation' and 'CRDBS config' script generation no longer offers an object choice radio button. - CRDBS config script generation now correctly generates the TEMP tablespace type destination. - CRDBS config script generation now correctly generates the archive destination. - A correction of the cell::setContent() method as suggested by Aubrey. - No longer crashes on Linux when going to the Structure tab of the database overview. - No longer gives an ORA-1801 when trying to generate table creation SQL. - No more debugging messages. - Displaying of generated SQL is much faster now (no longer uses insertLine()). - Closing one window will now correctly bring up the window that was active before the one just closed. This is only true if you use Qt 2.2 or higher. - Double-clicking on window in upper left corner now closes the window. This is only true if you use Qt 2.2 or higher. - The SQL text is no longer retrieved with a leading space. - The last line of dbacomp.sql and user.sql does no longer have to be empty if the last sql is one with a continuation sign (\). - Removed the objects tab from the constraints info window. New problems ------------ + Potentially crashes when a SQL error occurs. Version 0.3.0 ============= New features ------------ - Comments allowed everywhere in dbacomp.sql (# beginning of line) - Saving of window content - Printing of window content - Requires Qt 2.1.1 - Much easier installation procedure based on autoconf (configure) - In the Database overview screen: New 'Structure' tab to have a quick look at the database structure (tbs, rbs, redo logs, size, users) - More drill-down screens: roles, rollback segments, datafiles, redologs, sessions - More v$... views: v$archived_log - More reports: extents left, free space, free space deficit - More complete drill-down screens: views (columns, privs, comment) - More SQL script generations: session (kill, trace), table (create, drop, truncate, create with constraints, deallocate), constraint (create, disable, enable, drop), function (compile, drop, create), procedure (compile, drop, create), package (compile, drop, create), synonyms (create, drop), db links (drop, create), index (create, drop, rebuild) , Sequences (create, drop), Triggers (create, drop, compile, enable, disable), crdbs config, Roles (create, drop, grants, privs), Database creation, Tablespace (create, drop, online, offline), Rollback segment (create, drop, online, offline, shrink) - Tested against Oracle 8.1.6 Solved problems --------------- - No more ora-1002 when compiling against 8.1.X and running against 8.0.X database. - Command line logon for remote OPS$ login now possible (dbacomp /@tnsalias) - You will no longer get the 'QMenuData::removeItem: Index -1 out of range' and its associated crash. - DBAComp will no longer crash when database goes down. New problems ------------ - Generated SQL scripts do not fully use 8.1 syntax + Current version does not work with Qt 2.2 because of a behaviour change of Qt + Printing: If you have column that is larger then the page size DBAComp will enter in an endless loop - Printing of form style windows (as opposed to list style windows) does not handle page overflow. + When printing of form style windows right aligned numbers may exceed their frame. + In Qt 2.1.1 there is bug that has the effect of randomly adding empty lines to the generated SQL scripts. This only shows in the window displaying the SQL it does not show up in the file containing the SQL. TrollTech has acknowlegded this bug and suggests the following solution: "Remove the lines if ( WORD_WRAP && s.length() > 0 && s.find( " " ) < 0 ) s.append( "\n" ); in qmultilineedit.cpp." The also say the problem is solved in Qt 2.2 (haven't tested yet) + The dialog used for the generation of a 'create database' script is not adequate but it does work. + If in the SQL generation dialog you specify an existing file for which you don't have any privileges the SQL generation will silently fail. It will give you any empty window. The workaround is to specify a different file name. + Normally number are right aligned but for the moment decimal and negative number are not recognised as such. Version 0.2.0 ============= New features ------------ - Show the SQL of the current window - At logon there is the 'alter_session' SQL executed. The SQL can of course be found in the dbacomp.sql file. The default SQL only changes the date format so that it shows the time portion. But you can modify it so that it does what you want (e.g. enable tracing). - Many more v$... views - Many new menus and all the existing ones are now implemented: backup, recovery, all objects, instance, performance, reports. - Nicer oraconnect test program - Less compiler warnings - Use of MDI. I know that there is always a big discussion about its use. But in the case of DBAComp it is absolutely necessary. When you start DBAComp more than once and open a number of windows, then you have no way of distinguishing which window belongs to what instance of DBAComp. With the MDI you will only have 2 windows (each being perfectly identifiable) with a number of windows inside. - less debug messages - SQL statements file is now called dbacomp.sql by default - LIBS list in the makefiles is now much smaller (Thanks to Phil) also executable is smaller now - Number data is now right aligned in lists - Sheets say 'row retrieved' when only 1 row - Needs Qt2.1 - Tab windows now remember sort/filter expressions - Better logon dialog. It now remembers that last connection and has a combobox with all of databases that you have ever connected to using DBAComp. - Better error checking at startup for initialisation files. - User-defined SQL. You can now define your own SQL and call them from DBAComp (see the README for more info) - Launch SQL*Plus from DBAComp - Assistant to generate entries for dbacomp.sql or user.sql - Enhanced initialisation file look up. Whenever it has problems finding a file it will look in the local directory. Solved problems --------------- - Works now with Qt 2.1. Actually is even a requirement now. I use Qt 2.1.1. - There are less debugging messages showing up on the terminal. - The oraconnect test program has been enhanced. - SQLs in dbacomp.sql file are now specific to each version. New problems (+ means already solved in a later version, check above) ------------ + This one is not new but I forgot to mention it for the last version. When you compile with Oracle8.1.5 and try to connect to an 8.0 database you get 'ORA-01002: fetch out of sequence'. This is a known Oracle bug. The workaround is to compile against Oracle 8.0. - Using several times the same bind var in one sql (used in map) does not work. + If db goes down during dbacomp session, next action will crash app - Running dbacomp in a Oracle7 env. causes ORA-12705: invalid or unknown NLS parameter value specified - Due to a feature change in QT2.1 clicking on the header of a column to sort had to be disabled. According to Troll this will be undone in a future release + When more than 2 windows are open, closing one (using the X in the upper right corner or using the Close item in the Action menu) will bring the lowest window to front. This is a problem with Qt and will change in a future release of Qt. The workaround is to use to use the Close item in the menu in upper left corner of every window. + Double-clicking on sheet on upper left corner does not close sheet (Qt problem) - In Linux: You get ora-1801 when you have a select containing a long and a date column. This must be an Oracle bug. The workaround is to use to_char on the date column (see dba_constraints SQL in dbacomp.sql for an example). - Looking at the rows of a table containing nested tables or references produces a seg fault + the last line of dbacomp.sql and user.sql files must be an empty line if the last sql is one with a continuation sign (\) + Occasionally you may get a message 'QMenuData::removeItem: Index -1 out of range' on the terminal and then you crash when you switch from one window to another. I cannot reproduce for the moment. Version 0.1.0 ============= New features ------------ This is the first version I publish. So everything is new. Known problems (+ means already solved in a later version, check above) -------------- + Even though DBAComp compiles with QT 2.1 it has not been tested with it. Just doing a very basic test already showed a problem with the sort order in the list screens. For later versions I will perform a thorough testing of DBAComp with QT 2.1 and then I'll solve all the problems I'll find. So for now I recommend the use of QT 2.0.2 which is the version I develop with. I am myself very keen on using QT2.1 as soon as possible as I want to use the workspace feature of it. + Lots of debugging messages are appearing when you run the program. You can get rid of them by redirecting stderr to /dev/null (i.e. dbacomp 2> /dev/null) - This version has not been checked for memory leaks (and I'm sure there are some). + The SQLs in the sqlstmts.sql have been developed on a 8.0 database and then simply copied to the 7.3 and 8.1 section. Some of these SQLs may not work correctly on 7.3 or 8.1. I will adapt them later. If you encounter such a SQL you can easily change it yourself. + The test program for the oraconnect driver is pretty ugly. This will be enhanced in a future release.