changes

用perl写的Oracle管理工具

   0.95   Nov 2, 1999

Oracletool now produces DDL! There is now a "Generate DDL" button 
which will display when you are viewing table information. When
you press the button, Oracletool will reverse engineer the create
table statement, the create index statements, the primary key constraint,
the check constraints, the unique constraints, the foreign key 
constraints, and the grants for that table. All of the DDL is produced
in an easy to read format. This is still Beta, so let me know if you 
see any inaccuracies.

Fixed session statistics screen to show Oracle8i long operation
information correctly.

Split object source display into two columns, one with line numbers
for debug purposes, and one without, for cutting to recreate.
Thanks to Dianne Scott.

Updated partitioned table screens to support Oracle8i.

Added OS port info to banner. This shows the hardware and Operating
System the engine is running on. Pretty neat, although not always 
completely accurate.

Began support for advanced replication (Oracle8 only).

Oracletool will not attempt a connect to the instance unless a valid
cookie is found. It will prompt for the username/password, and cut
down on messages in the sqlnet.trc file

Sessions now sorted by status.

   0.94    Oct 10, 1999

Fixed table column display to show proper length and decimal
precision. Thanks to Phillip Chin.

Added global variable "$gd" to user variables at top of script. 
Oracletool will only look for the GD.pm module if this is set.
This is because of the copyright problems going on with libgd.
GD.pm versions 1.19 and below produce gif images, GD.pm versions
> 1.19 produce png images.

Changed Oracletool to work with both gif and png versions of GD.pm,
(hopefully). Please let me know of bugs.
Thanks to Marcos Colpaert for patch.

Added simple displays for the following object types. INDEXTYPE, 
JAVA CLASS, JAVA RESOURCE, LIBRARY, OPERATOR, QUEUE.

Added session I/O display to sesion stats section.

Fixed fragmentation image generation caching problem. Thanks to
Mark J. Scheller.

   0.93   Sep 09, 1999

Emergency release. 0.92 had a bug which prevented proper menu
display. 

Added V$SESSION_WAIT info to session statistics.

   0.92   Sep 08, 1999

Added controlfile section. Detailed information concerning record
storage for Oracl8 databases. Quite boring for oracle7 databases.

Added object access list to session statistics page under the 
"sessions" section.

Added replication section. Buttons will show up only if you are 
using replication. Separate buttons for master (M) and snapshot (S)
sections. Those of you using replication, please let me know what 
needs to be added / enhanced / fixed here. Oracle8 only

All date / time fields now displayed in HH24 format for consistency.

Added enhancement to DisplayTable etc. subroutines to align number
fields to the right. Looks much nicer. Thanks to Peter Speck.

Fixed bug in Session info for Oracle8i. Looks like we are cool for
Oracle8i now. Thanks to Marc Beasley

Added additional information to table and index listing. Thanks 
to Stephane Faroult (http://www.oriolecorp.com)

Added trigger check on detailed table information page. Thanks
to Stephane Faroult

   0.91   Aug 09, 1999

Added security section - Roles, Profiles, Auditing. Auditing info
is beta, and unfinished.

Fixed tablespace allocation query. Tablespace information screen
and allocation graph are both VERY MUCH faster now. This is a very
positive change for those of you who have many tablespaces, as the
query is now very quick.

Added archived redo log information section.

SQL-Worksheet now supports DESCRIBE / DESC, but it does not follow
synonyms as SQL*Plus describe does, or describe packages, procedures
etc. Does anyone even use the SQL-Worksheet?

Added instance startup date/time to banner. Thanks to Virgil Aviles.

Changed the way SELECT ANY TABLE privileges are checked for.

   0.90   Jul 05, 1999

NOTE: Oracletool.pl now requires the GD.pm module for creating GIF
images. This is the first release to require this module. GD.pm is 
a very reliable and easy to install module. It won't take you but
a few minutes to install it if you don't already have it.

Added datafile fragmentation image generator. When you select a 
datafile, an image will be generated in addition to all of the 
information previously displayed. The image will NOT be written to
disk on your web server. If you want to have a similar map generated 
when you select a tablespace, uncomment line 1981. I have this commented
out by default because some databases have such large tablespaces that
it is just not practical to generate that type of image for them. I'll
let you make the call on this one. Thanks to Mark J. Scheller for the 
idea.

You may enter an OBJECT_ID number in the search box instead of a name
if you need to do such a search.

Added sort information to performance section.

Improved process number resolution in session information area.
Thanks to Michael Roever.

Fixed TO_CHAR format error in tablespace information area.

Made users profile name a hyperlink for a display of parameters / values.

Added "$dbh->{LongReadLen} = 2048;" to DisplayTable subroutine to correct
error on tables with LONG columns. Thanks to Mark J. Scheller.

   0.89   May 18, 1999

Added "where clause" text box for when you display 25 rows of a table or view.

Added a checkbox on the database selector for deleting password cookies.

Added an additional text area on the database selector for those who
are running Oracle Names to type in a connection and let it be resolved 
by names.

Changes GetTNS subroutine to not truncate domain names from connection
strings. Many thanks to Dima Dorofeev for the code contribution.

   0.88   May 12, 1999

Added SQL Worksheet. Can be used for both selects, and DML statements.

Added support for partitioned tables and indexes. Oracle8 only, obviously.

Changed the way the script checks for "SELECT ANY TABLE" privilege. This way
should work better.

Added (somewhat poor) POD documentation.

Took out the hardcoded database name from the search function. Oops. Fixed a couple of 
other bugs too.

Added "EXPLAIN PLAN" subroutine. This is beta and commented out by default. Eventually, 
this tool will have a sister tool for users without "SELECT ANY TABLE" privilege. I
will probably leave explain plan out of this one and add it to that. If you would like to
try the explain plan, uncomment out line 3663. I'll listen to any suggestions you have, 
but I'm not sure what I'm gonna do with this one yet.

    0.87   May 05, 1999

Public release to freshmeat.

Made the object list for tablespaces, datafiles, and object search hyperlinks to info screens.

   0.86   May 04, 1999

I've changed the basic look of the tool quite a bit. There's now a persistent menu on the
left side of the screen for all of the major areas (Tablespaces, Users, Rollbacks etc.).

Added button to show all privileges granted to the selected object.

Added "Performance / memory" area with some of the stuff that was previously under
the initialization parameters section, and some new stuff including info from the
V$LIBRARY_CACHE dynamic performance table. If anyone has a performance
or memory related query that they want to share, please do.

Added query to user info section to show the number of objects the user own of each of
the different object types.

Made object list entries for tablespaces and datafiles clickable links to additional information
screens.

Still working on the daemon....

   0.85    April  28, 1999

OK, OK, I heard you! Cookies are here!! No more password file. I just put this in today,
and have not tested extensively, but it seems to work fine for me. Let me know if any
of you run into problems using the new password system. I'll add a variable for setting
the expiration date later.

Updated session info to display sessions whether they are active or inactive. Previously
displayed only active sessions. Also added "command" column. Handy for seeing if a
transaction is rolling back, cause that's kinda tricky in Oracle.

Not much else this time because I'm spending alot of time writing a daemon to accompany
the tool, which will store historical data in the database (disk I/O, growth, session count info
etc.). I'll probably release that (beta) in about a month or so. It will include some nifty line graphs
created using GIFgraph (GD). This daemon will be optional, and the tool will work with or
without it. The added functionality will display automagically if you are running the daemon.
I will also be looking for help porting it to NT. The tool itsself will remain read-only.

   0.84   March 31,1999

Started adding Oracle Parallel Server specific stuff. Very basic yet. These features will
display only if you are running OPS.

Added help for every screen. Also quite basic. The help button shows up in the footer of
each screen.

Fixed ORA-1476 (Divisor is equal to 0) and inaccurate table analyzation information when
a table that has been analyzed but has no rows is selected.

Changed connection to use 'dbi:DriverName:$database_name' instead of 'old-style'. I guess
this makes me an old timer..

Added object search capability. Searches database for "like" objects, displays them, and
sessions currently accessing them. Search box is at the bottom of every page.

Probably a couple of other little things I've forgotten about.

   0.83   March 23,1999

I decided to change the initial screen to use a "submit" button because
someone reminded me that all browsers do not support Javascript. KDE's 
file manager, for example. I doubt it would have worked with BeOS's 
NetPositive browser either.

I also took away the "Back to the page you came from" link on every page. I 
find I use the "Back" button if I want to go back. Instead, I replaced it with
two buttons. One to go to the "toplevel", where the users are listed, and on
to go to the connections screen. (The first page).

Added a report to show all of a users objects split up by the tablespace's
they reside in. It's a button after a users object types list.

Tested under WinNT4, service pack 4, with IIS4. Worked fine. Added some comments
in the script pertaining to Win32 users. Stuff they probably already know anyway.

    0.82   March 22,1999

Fixed initial database list to accept entries with dashes.

Added object lock info for non-contending object locks.

Fixed bug for OCI that crashed on an ORA-01005 (null password). Thanks 
to Kenny Klatt.

Added hyperlink back to the toplevel page for each page.

   0.78 - 0.81   March 20,1999

Fixed tablespace fragmentation query.

Added LAST_DDL_TIME to tablespace object list.

Only display "show active sessions" button if user has active sessions.

User list table now highlights users that are currently connected, and
   puts users with DBA authority in bold and parenthesis.

Fixed password file update to not use `cp`. Still thinking about whether the
password file is a good idea or not.

Fixed primary key and column constraint queries to check for object ownership.

Fixed initial database list to take off  '.world'  and weed out duplicates from
tnsnames.ora and oratab. Thanks to Dmitry Dorofeev.

Added several additional graphs.

Now use well known (except to me) variable ENV{'SCRIPT_NAME'} to get script name
instead of the stupid way I was doing it before. :-)

   0.78   March 17,1999     Public release to DBI mailing list