Hi folks,
Oracletool 1.3.0 is now available for download
at http://www.oracletool.com. Thanks to all who
have contributed and supported!
Regards,
-Adam vonNieda
Changelog follows..
News
====
Oracletool is published! Oracletool was chosen as one of
the many tools covered in the Oreilly & Assoc. book
"Oracle and Open Source" written by Andy Duncan and Sean
Hull, both of which have open source projects of their own.
There are links to these projects from the oracletool.com
website. Support your Open Source developers and buy this book!
No, I don't get any money from it, but I got a free book.. :)
Bug Fixes
==========
Fixed bug where list of usernames with active sessions
was not displaying at all under Netscape when "Session info"
menu item selected.
Fixed bug within session summary with refresh. It was not
displaying sessions which did not have SQL in the V$SQLTEXT
dynamic performance view associated with them.
Added comment end tag to javascript code, submitted by many
people.. Thanks!
Removed references to ORDER_OBJECT_BY_DEPENDENCY view for
Oracle "i" databases, as it does not exist by default anymore.
Thanks to Svante Sormark for suggestion.
Several bug fixes to the explain plan section. Not in the way it
is displayed, but the way it creates the correct PLAN_TABLE based
on the version of the database.
Enhancements
=============
StatsPack:
Added rollback stats to display.
Snapshots can be selected via a range of snapshot ID's.
Table / View / Column comments are now displayed thanks to
a code contribution from Praveen Hombaiah.
Added fragmentation / extent list link to individual tablespace
screen.
Began work on "My Oracletool". This will allow you to store scripts
and information in a centralized repository for easy access. Suggestions
please? Constructive criticism? Let me know!
Many updates to screens pertaining to datafiles, to take TEMPFILES
into consideration. Also, updates pertaining to temporary tablespaces
which use TEMPFILES and are managed locally. Most of these changes are
transparent unless you have been using these features.
Added Multi Threaded Server info screen under Perf / Memory section.
Thanks to Ernesto Hernandez-Novich for the code contribution.
Added DB buffer cache info to the memory stats page.
Added modifiable system parameter admin to the DB admin page. This is
also a handy way to display which system parameters are modifiable "on the fly".
Removed ability to select a temporary or undo tablespace as your default
on the user creation screen. Thanks to Wim Slangewal for suggestion.
Added state information to index display.
The following from code contributions from Thomas Lowery.
Thanks Thomas, sorry it took me so long!
Added state information to individual index display.
Ordered tablespace quotas by tablespace.
Ordered table partitions.
Check for UNUSABLE objects as well as INVALID objects in areas that pertain.
Added CPU usage stat from v$sesstat to Session summary area. This pertains to
Oracle "i" databases only. Thanks to Sergey Rusakov.
You may now choose to display detailed session info for all sessions, only active,
or only not active. Thanks to Sergey Rusakov for suggestion.
Added display for audit trail counts from individual objects. Shows how many times
an object has been selected from, inserted to etc.
More refresh buttons. I like refresh buttons.. :)
Oracle 9.0 specific additions.
Oracletool will run against Oracle9i databases with no
problem. Several enhancements have been made to take advantage
of new 9i features. Surely many more will come. Suggestions?
Segment management type added to tablespace listing.
Updates to Rollback segment areas to take into account "TYPE2 UNDO" objects.
