changes

用perl写的Oracle管理工具

   1.2.0

   The change list for 1.2.0 is quite lengthy, but there
are several important points throughout, so please take
a moment to read through.

 News
=====

   Sorry folks, but a new oracletool.ini file needs to 
be installed for this version. I've added a few fields
to it.

   As of 1.2.0, I believe I need to set a firm line on
the lowest Oracle version that will be "supported" by
Oracletool. This version will be 7.3.3. Why? There are
some changes in the Oracle data dictionary between 7.1
and 7.3 that have been causing problems for some users, 
although they have been slight. I just don't have access
to Oracle versions < 7.3 anymore, which means I can't 
test on them.

   Encryption is here! As of 1.2.0 cookies can be encrypted
before they are saved to your PC. I'd like to thank Richard
Chen for pushing me to do this, and for providing some
code to make it easier. Please read the SECURITY file
for more information, and a security advisory which was 
also provided by Richard Chen.


 Bug fixes
==========

In recent events section, log switch count was inaccurate,
and is now fixed. Thanks to Alan Sparks for the fix.

Rollback segment screen now checks for rollbacks which are
not online. Previously these were not shown. Thanks to 
Pascal Lengard for the info.

Now check DBA_CONS_COLUMNS for primary key constraint
column names rather than DBA_IND_COLS, as Oracle8 does
not require a primary key to be created with an index. 
If a suitable index exists, it will be used. Thanks to
Klaus-Martin Hansche for the fix. Hope I got your name
right.. ;)

Fixed a couple of bugs pertaining to foreign keys in table
DDL generation. Thanks to Hirose Masaaki for the info.


 Enhancements: Encryption - Thanks again to Richard Chen
========================================================

   Usernames and passwords for the database instances you
access can now be encrypted before they are sent to your
PC as a cookie. These were being written in plain text
prior to 1.2.0. There are 3 different levels of security
available in Oracletool now. These levels will be enabled
automatically depending on which Perl modules you have 
installed. To find out what level you are at, click on the
"About" menu item after installing v1.2.0. Here are the 
differences between the different levels, and the dependencies
for each...

Level 0: 
      This is the level that Oracletool is at prior to v1.2.0.
   If you are at level 0 then there is no encryption of any
   kind taking place. If you do not have any of the modules 
   discussed below installed, this will be your level. The
   cookie which stores the username and password for the
   databases you access will be stored in plain text on your PC. 

Level 1: 
      This level uses the MIME::Base64 method of encoding. With
   this level, the username, password, and encryption string are
   encoded into a single string. The encryption string is set in
   the oracletool.ini, and is MD5 encoded before being added to
   the string. This level requires the following Perl modules... 
   These modules are available at
   CPAN (http://www.cpan.org) and 
   Activestate (http://www.activestate.com)

1) Digest-MD5
2) Mime-Base64

Level 2: 
      This level uses the cipher block chaining mode with
   the IDEA block cipher, and is extremely secure. It encodes
   the username and password into a single encrypted string 
   based on a keyword stored in the oracletool.ini. This level
   requires the following Perl modules... These modules are 
   available at CPAN (http://www.cpan.org), but not all are
   on the Activestate site when I checked prior to this release.
   This is the only reason that Level 1 encryption exists at all.

1) Digest-MD5
2) Crypt-IDEA
3) Crypt-CBC

   If you choose to use these security features, simply install
the required Perl modules. Oracletool will see the modules and 
start using them for each subsequent cookie that is created. 
See your browser documentation if you want to remove the cookies 
currently on your hard drive.

 Enhancements: General
======================

On tablespace / datafile fragmentation report, an 
"ALTER TABLESPACE tablespace_name COALESCE" statement
will be printed out after the report for any tablespace
containing at least one datafile with more than 1000
fragments. This can be cut and pasted into a worksheet. I
would not recommend using the Oracletool SQL worksheet for
coalesces, as they can be long running. CGI scripts can 
time out.

On tablespace information screen, a listing of the different
extent sizes, and count of each different size of extent
is listed.

Under the DB Admin menu item, the menu has been split into
two parts, one for DB Admin type stuff, and one for reports.

Changed extent report under DB Admin to check for objects
approaching max extents, and also checks each tablespace 
for objects which cannot allocate a next extent. Thanks to
Eric Indiogine for idea.

Added a theme called "Printing", which is a black and white
theme which is good for pages you might want to send to a
printer. Thanks to David Polansky for the theme. I added a
few of my own as well, although I don't recommend them.. :).
Anybody else? Let's see some nice themes!

Added four keywords to each theme definition. You can now
set a background image for the main page, and a different 
one for the menu bar, and you can make the table heading
a different font and color than the cell font.

Explain plan is formatted a bit nicer now, and with more 
information. Thanks to Lefty Kreouzis for suggestion and
code change.

Added global object lock information to OPS section.

Added open cursor information to session statistics screen.
An alert will be shown if the session you are displaying
has the maximum allowed cursors open (OPEN_CURSORS parameter).

Added additional menu under Performance / memory menu item. This
has an entry for the display that already existed, and an additional 
display to show information from the shared SQL area in the SGA. More
to come later, I think.

Added enhancements to the RMAN section, particularly information
obtained from the controlfiles pertaining to backups. RMAN menu
item will show up if your database has been backed up using RMAN,
or contains one or more RMAN catalogs. The most recent backup info
can be displayed, and any datafiles added but not yet backed up 
can be displayed. This section still needs much work. Oracle8 only, 
More to come later.

Added rollback segment administration to the DB admin menu, for 
taking segments online, offline, or shrinking.

The Oracle Statistics Package is a new addition to Oracle with 8.1.6
which is much more powerful than the utlbstat and utlestat scripts.
I will be adding screens to analyze statspack data in the future. For
now, I'm checking for the existence of the PERFSTAT.STATSPACK package
for Oracle 8i databases. A menu item will appear if found. A statspack
snapshot can be taken via point and click. Like the RMAN section, this
section still needs much work. More to come later.

Added datafile autoextend info on full datafile listing and listing
within the individual tablespace screen for Oracle8/8i.

Any object which matches your search via the search box can now be
marked to display the objects which it depends on and the objects 
which depend on it. Quite handy, I've found.

Added menu under rollback segment section. One item for showing RBS info,
one for active or rolling back transaction info. Also enhanced the querys
which display active and rolling back transactions.


   1.04 Apr 26, 2000

 Bug fixes
==========

Fixed bug where Oracletool selects an invalid column from
V$INSTANCE on Oracle7 databases.

   1.03 Apr 25, 2000

 Bug fixes
==========

Fixed bug (again) in Top sessions screen which I had not quite
fixed in 1.02. oops.

Fixed text contained in tables to show HTML characters correctly
instead of interpreting them. <FOO> will show correctly now, for
example, instead of being interpreted as a tag. Thanks to Tommy
Wareing.

Fixed a couple of bugs pertaining to partitioned table / index
displays.

 Enhancements
=============

Added variable for config file, in case you don't want to name it 
"oracletool.ini", requested by Adrian Blakey. Several mod_perl
fixes from Adrian as well.

Added sort area info to performance section. Thanks _again_ to
Tommy Wareing.

OPS page now sorts global sessions by username, and instance names
are hyperlinks which will connect you to that instance.

Added sortable space report by user option to DBA tasks menu.

Added sortable space report by tablespace / user option to DBA 
tasks menu.

Added sortable datafile fragmentation report to DBA tasks menu.
Shows which tablespaces need to be coalesced / reorged.

Added object extent report to DBA tasks menu. You can check for
objects with a number of extents >= the value you enter.

Added screen for object type "CLUSTER".

On table, view, and source object displays, now check for synonyms 
pointing to the object.

Started adding screens for databases which have a RMAN recovery
catalog in them. RMAN button will show up if true. More to come
later on this. Not much to look at now.

On schema table listing, table types are now split up into sections
for partitioned , Index Organized, and standard.

On schema index listing, index types are now split up into sections
for bitmapped, partitioned, Index Organized, and standard.

When you select a role name under the security section, it now also
shows the users which are granted the role, and the roles which are 
granted the role.

Added a button for validating an index after one is selected, which 
will display detailed statistics after the validation. This button
will only show up if you have the "ANALYZE ANY" privilege. This 
utilizes the "VALIDATE INDEX" command.

When a table is selected for display, an "Extent mapping" button will 
show up beside the "Generate DDL" button. This will generate a 
fragmentation map similar to the tablespace / datafile frag maps,
but it will only highlight the extents which belong to the table
you have selected. This is a nice way to get a visual idea of how badly
a table is fragmented. The extents are shown in alternating blue /
white, so you can see where each starts and finishes. If the schema
that you are running the tool as has permission, it will also run
DBMS_SPACE.UNUSED_SPACE to gather real-time space statistics. Extent
mapping is not yet supported for partitioned or Index Organized Tables.

Added optional LIMIT_SEARCH parameter to config file, as suggested
by Mark J. Scheller. Setting this parameter will make the search 
function skip the part where it checks to see if the matched objects
are being accessed by any connected sessions. This part of the search
can be very intensive on instances with many (thousands) of 
simultaneous connections.

On the main page after you select a schema, the object type 
"PUBLIC SYNONYMS" will be displayed with the object types owned by the 
schema. This link will display all public synonyms which point to objects
owned by the schema you have selected. This will only show up if there 
are PUBLIC synonyms pointing to the schema. As suggested by Richard
Chen.

   1.02 Apr 03, 2000   Released without announcement.

Fixed rows which return zeros to show zeros instead of blanks.
Nulls will still show as blank values. Thanks to Hirosi Taguti 
for suggestion.

Top sessions screen had a bug in 1.01 which was giving Netscape
users problems. Fixed, thanks to Tommy Wareing for patch.

On redo log screen, log switch graph now sorts in a way that