changes

用perl写的Oracle管理工具

makes sense. This one had me stumped for a long time. Thanks
again to Tommy Wareing for the patch.

   1.01 Mar 31, 2000

** Important ** 
As of 1.00, a config file is required! See entry for v1.00.

Any environmental variable you need to set can now be put in
the oracletool.ini file, not just the ones that are there by default.
Some of you (Thanks, Christoph Karl) may need to set additional
variables like ORA_NLS33, or NLS_LANG, for example. These 
variables can be placed anywhere in the config file, and should
follow the same standard as the other parameters.
...
Example: NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
Would set $ENV{'NLS_LANG'} = 'AMERICAN_AMERICA.WE8ISO8859P1';
Simple as that. No quotes, no $'s, just "PARAMETER = VALUE"

Fixed bug in user DDL generation when setting default roles.

Fixed bug in table DDL for foreign key constraint generation.
Thanks to Stefan Sautter.

Rollback segment screen now shows all transactions on all
segments. Before you had to choose a segment.

Table display now shows the columns that each index spans.

Enhanced constraint displays on table page to include status, 
columns, referenced table, owner, and constraint name.

Enhanced sequence display page. No longer have to click on a 
sequence to get all information.

On table row display, Rows which return space characters will 
display properly now.

Added global session summary to OPS specific page. Note that
the OPS menu item does not show up for non OPS instances.

Added session menu, with "Top sessions" selection. Top sessions
shows all sessions in an instance and has an " auto-refresh"
button. You can sort on any column by clicking on the column
heading. You can display all sessions for a given user by clicking
on the username. You can display an individual session in more 
detail by clicking on the SID.  You may set AUTO_REFRESH in the 
oracletool.ini to a value, in seconds, to override the default of 10.
Note: Sorting on the "SID" column does not work in Oracle 8.1.5
databases. This is an Oracle bug, not an Oracletool bug.

Oracle8 only: Schema list will highlight in red any accounts 
which do not have a status of "OPEN".

User info screen will now show account status in Oracle8.

Added tablespace name column to objects shown in "Recent events"
section.

Working on cleaning up any warnings that should occur for you
diehard "perl -w" users. Many, but not all are gone. Sorry, I 
should have done this from the beginning... :(

   1.00 Feb 10, 2000

** Important ** This config file is required now!

Oracletool now comes with a config file. The reason for this
is so you don't have to set variables at the top of the script
each time you install a new version. The config file is called
"oracletool.sam", and should be renamed to oracletool.ini. The
parameters you need to set have not changed.

Fixed bug in DDL generation from 0.98 which prevented proper 
display with Netscape.

DDL can now be saved to your local disk, and can no longer be
saved to the web server disk. Removed safemode ($safemode).

In individual tablespace display page, tablespace_name is now
a hyperlink which will display DDL for recreating tablespace.

In individual rollback segment display page, segment is now
a hyperlink which will display DDL for recreating segment.

Added rather extensive facility for setting database auditing
options. This facility is under "DB Admin", and will not display
if you do not have auditing enabled. (parameter audit_trail = 'FALSE")
This facility is not perfect yet, so if any of you are auditing, 
please give me some feedback.

You may now browse audit trail records. You can get to this under 
"Security", or under the main auditing menu.

When compiling an invalid object, if the compile is unsuccessful, 
the errors will now be shown. 

Search box will search for usernames and tablespaces that match
your entry, as well as object names, "like" object_names, and 
numeric object ID's.

Removed "Explanation" box at top right of every screen. I don't
think anyone used it, and it's a pain to maintain. I don't expect
that anyone will miss it.

Fixed a couple of partitioned table/index display bugs.

   0.99   Skipped

   0.98   Jan 16, 2000

Fixed bug in explain plan query. Thanks to Mark J. Scheller.
Mark, you're an excellent exterminator, thank you.

Fixed shading problem when displaying some HTML tables with
multiple columns.

Added "Recent events" section. This shows all users, roles 
and datafiles added within the last 30 days. Shows objects
that have been created or altered within the last 24 hours.
Shows # of redo log switches in the last 24 hours.

Rollback segments section now checks for any transactions in
the instance that are in an active rollback. Also shows information
about all transactions occupying the rollbacks of the instance you
are connected to.

DDL generation will now generate "alter table" statements for tables
which have foreign keys referencing the table(s) you are generating
DDL for. So, if you do a "Drop table foobar cascade constraints", this
will ensure that all referential integrity constraints for that table
are put in place when it is recreated, including those that reference
that table.

DDL generation will now extract table and column comments.

DDL generation now checks for CACHE attribute on Oracle8 tables. Thanks
to Duc Nguyen. Cache attribute is now shown under table info screen as
well.

Added "$safemode" variable, which disables writing files to the OS for
DDL generation. Output still goes to screen.

When a shema is selected, if the schema has invalid objects, a button
will show up at the bottom of the screen showing the number of invalid
objects. Pressing the button will take you to a display of the objects
where they can be marked for recompile.

Hyperlinks will now only show up on the entity name they pertain to, 
not across the whole row of values. Suggested by Hirosi Taguti.

Added "DB Admin" menu item. This is a work in progress, and more will
be added in the future.. Thanks for the suggestions, keep them coming.

   These menus will activate only if the user logged into the tool has
   the proper privileges to perform the actions.

   User administration:
      Reset user passwords.
      Create users.
      Create users "like" other user. New user will inherit quotas, 
          profile, default TS, temp TS, roles, and system privileges 
          as selected user.
      Drop users.
   Session Administration: 
      Sessions may be marked for kill and killed in batch. Yeah! :) 
   Object administration
      Displays a list of invalid objects, which can be marked for recompile.
   Reverse engineer tables:
      Multiple table names may be entered for reverse engineering of
      DDL. An output filename may be entered to send commands to hardcopy.
      Output will still go to screen as well. Separate section for selecting
      a particular schema. All tables for the schema will be displayed, and
      can be marked for erverse engineering.
   
   0.97   Dec 08, 1999

Many changes in version 0.97, so let me know if you have
problems, and I'll get to them as quick as possible. In
particular, I did some work with the cookies, so let me know 
if you see anything strange with that.

Nifty new look to Oracletool thanks to a suggestion and code 
example from David P. Fannin. Thanks David, looks great! I
think it is safe to say that I took your idea and ran with it!

Oracletool now has color themes which can be chosen interactively,
and the theme you choose will be used each time you use the tool.
Because your theme is stored as a cookie on your browser, each
user of the tool can choose their own theme. Themes can be created
very easily, and there is an explanation in the "doTheme" subroutine,
so if you create a cool theme please send me the values, and I'll
add it to the public version. Most of mine are pretty lame... :(
The themes can be displayed via a button at the bottom of the 
"properties" screen.

A "properties" button has been added. This allows you to set 
defaults that will override the themes. For instance, if you 
like the "Default1" theme, but the font is too small, you can
select a larger font in the properties area. If you have a 
suggestion for something that should be added to the properties
area, let me know. 

Font is much more consistent throughout the tool.

Continuing down the non read-only path, the session listings
will now show a button to kill the session if it is active.
This button will only appear if the user running the tool 
has "ALTER SYSTEM" privilege.  Also, explain plan button 
will show up only if there is SQL to run against.

Session listing layout has changed to save browser space.

Changed the datafile fragmentation display again. Took away the 
hyperlinks. It was too slow, too much bandwidth etc. It's now 
just a display again, and still without GD.pm.

Fixed a bug where a tablespace would not show up in the allocation 
graph if it was 100% full. Thanks to Mark J. Scheller for fix.

Now use more updated DBD::Oracle way to fetch LONGS. Thanks to 
John Williams for fix.

Changed tablespace information listings slightly for Oracle8 and 8i.

Added more detailed tablespace listing to rollback segment area 
showing info about all tablespaces containing rollback segments.
Also added optimal size to display.

Added hyperlink on individual user toplevel page. Username is now
a hyperlink which will generate SQL for recreating the user, setting
defaults, adding grants etc.

If a package / procedure / view etc. is invalid, when selected an error
report will display.

Added "Refresh" button to several screens. This can be added to other
screens very easily as well. Let me know if you want it in other areas.

Many future additions to Oracletool will be non read-only, but the 
options will show up for use only if the user connected has the authority 
to do the action, if possible. Having said this, I'm looking for enhancement
suggestions. What do you want it to do?

Thanks to Alexey Vekshin and Stephane Faroult for suggestions 
pertaining to this release, and several releases before.

   0.96   Nov 15, 1999

The GD.pm module for creating images is no longer used or required.
Because of the copyright problems with the GIF format, there are
two GD.pm versions; One that outputs GIF, and one that outputs PNG.
The one that outputs PNG can be a hassle to install, so I decided
to let it go for the time being. I may look at it again in the future. 

Added (rewrote) EXPLAIN PLAN functionality. Now you can run an
explain plan on any sql shown in the sessions lists, or run
an explain plan from scratch. The main tool window will connect
as the owner of the SQL (password is required), while the menu
will remember who the actual user of the tool is. The username
and password of the explain plan user will not be stored as a cookie
on the client side, as the user running the tool is. This means you
will need to enter a password for each explain plan that you run.
For those of you that found the hidden explain plan facility before,
hopefully you will like this one better. Please let me know of any 
improvements that should be made to this facility.

NOTE: I cannot claim that Oracletool is a 100% READ-ONLY application
any longer, because during an explain plan..

1) If a PLAN_TABLE does not exist for the user executing the SQL,
   Oracletool will create it on the fly (and display a message to
   that effect).
2) During an explain plan, records will (obviously) be added to the
   PLAN_TABLE. These records will have a unique identifier, and will
   be deleted immediately following the explain plan. The PLAN_TABLE
   will not be removed. 

Changed tablespace / datafile fragmentation displays. No longer is 
an image created using GD. Instead, an HTML display is generated, and
each occupied block can be clicked on to display the object which
resides in that block. This may not look as good as it did with the
GD image, but is more functional.

Added top CPU users to Perf / memory section. Requires 
TIMED_STATISTICS = true (which does not produce nearly as much overhead
as many DBA's would have you think).

Fixed SQL worksheet describe command. Was showing columns for
all table names that matched, not just one schema.

Updated / added help screens. I doubt anyone ever looks at them 
anyway.