APPLICATION=Oracle Information Site (OIS)
V1.37:
22-Sep-2009 - Updated README with EOL informations
- Replaced all remaining PHP shorttags with the long format
- Updated OCI8 class to V0.78
12-Feb-2009 - Added additional field types to Table exporter (CHAR,NCHAR etc.)
21-Apr-2008 - Fixed an uninitialized index warning in Rollback segment overview
when running on 8i
- Added detection for 8i DB in showMemory.php, as 8i doesn't
have the view V$SGA_DYNAMIC_COMPONENTS.
V1.36:
17-Nov-2007 - Table in "Processes & sessions" can be sorted now on every
data cell by clicking on the corresponding table header text.
- "Show database users" now displays the amount of objects from
the view "ALL_OBJECTS" instead of "DBA_SEGMENTS".
- "Lock overview" now displays the user and program, this makes it
a lot easier to identify the sessions who have pending locks.
- Added SID/SERIAL# fields in "Processes & sessions" overview,
this helps to easily recognize a session, i.e. to kill
that session directly.
- Made code safe when running with error reporting level E_ALL, also
the long php tags form is now used in all scripts instead of
the short form.
26-Jul-2007 - Updated OCI8 class to V0.76
- Removed display of fragmented objects, this view will be added as
separate menu entry in the future.
- Query for "Tuning Views->Dictionary Cache" rewritten, now it is
using a GROUP BY to avoid double entries to be shown. Also the
percentage has changed, it shows now the percent value of the
hitrate instead of the missing requests. In addition the counter
for MODIFICATIONS inside the Rowcache has been added.
V1.35:
04-Jan-2007 - Process details now show informations whenever a
long-operation is detected.
- Updated OCI8 class to V0.75
24-Nov-2006 - Updated OCI8 class to V0.73
- Added cursor cache statistics to instance statistics page.
25-Sep-2006 - Added V$SGA_DYNAMIC_COMPONENTS view to Show Memory page.
21-Sep-2006 - Added new page with general instance statistics and an
overview table showing wait stats.
- Added fragmented object overview to Tuning view page.
- Added SGA allocation overview to Memory overview page.
- Added additional statistic to Rollback Segmeent page.
- Added Ratio calculation to Redolog page.
14-Sep-2006 - Added new page showing contents of DBA_LOCK table.
17-Aug-2006 - Fixed again a bug in the schemabrowser detail view for tables,
the indicies details had wrong joins which resulted in double
columns to be shown. This is now fixed.
- Updated OCI8 class to V0.72.
- Fixed a bug in process list when using a 64Bit instance,
the RAW fields where not correctly converted and resulted
in crap being displayed in the process detail view. Now the
RAW fields are converted via RAWTOHEX() and now process list
works as expected.
V1.34:
12-Jan-2006 - Fixed a bug in the table detail view of schema browser, the
index view was broken and did not show all depend fields.
10-Dec-2005 - Submenu added to title, this way it is more useable than
having the navigation tied on bottom of the pages.
25-Nov-2005 - Fixed various small HTML bugs complained by HTML Tidy.
- Updated OCI8 class to V0.62.
26-Jul-2005 - Added list of constraints to table detail view
25-Jul-2005 - Table detail view now lists all existing indexes for that table.
23-Jul-2005 - Removing of exported Datafiles is now possible.
13-Jul-2005 - Schema browser now provides also the possibility to list the DDL
definition for almost every object.
- Table detail page has new button "Show DDL" which lists the
SQL statement to re-create the table in a popup window.
- Added new config option OIS_DATA_DIR which has to be set to
a valid path where all export files are stored. This directory
must have write permissions for the user the webserver is
running under, this is also checked inside OIS. Whenever there
are new files stored in this dir, a new menu entry will be
visible (Manage export files), where one can either download
or delete the exported files. If you do not want to use this
feature simply set OIS_DATA_DIR to an empty string and this
functionality is disabled, but you cannot export tables anymore!
11-Jul-2005 - Exporting of table content is now possible. The exporter is
currently limited to tables without BLOB/LONG/RAW columns,
these types will be supported in a later release. The ASCII
exporter does not require any Oracle tools, it is completly
PHP based, so do not expect high-speed when exporting large
tables with this function!
10-Jul-2005 - Updated OCI8 class to V0.61.
09-Jul-2005 - Added new Config option which allows to disable the TNSPing
calls on the main overview page. Simply set PING=FALSE if you
do not want to TNSPing databases (useful if you have the
InstaClient installed).
- Updated OCI8 class to V0.60.
22-May-2005 - Updated OCI8 class to V0.58.
24-Apr-2005 - Added detailed informations for tables in schema browser.
23-Apr-2005 - Changed general header on all pages, this one hopefully looks
better and also did not take that much vertical space.
- ShowUsers now references schemabrowser.php instead of a non-
existant page "showUserDetails.php".
18-Apr-2005 - The title in the header was not correctly build - fixed.
- Fixed a bug in index.php which shows empty TNS names for local
connections
- Updated OCI8 class to V0.57.
10-Apr-2005 - Updated OCI8 class to V0.55.
- Added support for CVS and phpDocumentor
V1.33:
09-Jan-2005 - Added "Edit Note" and "Delete Note". Simply click on a comment
entry and you can either change the data or remove that comment.
08-Jan-2005 - Added NLS Setup which displays the NLS settings for database,
instance and current session
- Added very simple schema browser. Currently only viewing
of all objects sorted by schemata are possible, more details
will follow in future versions.
03-Jan-2005 - Updated DB class v0.53.
- Added Writing of reports for a given database. This allows
to steadily add new info whenever something has changed on
the database server.
02-Jan-2005 - Added Management system to have a better overview of installed
Oracle databases including Server Informations
- Added metatags for navigation as supported by Opera i.e.
- Added History viewer
- Updated DB class to v0.52.
- Removed Instance Statistics page and merged contents to
All Tablespaces, Show Memory and Show tuning views.
01-Jan-2005 - Removal of SQL Query stats in Tuning Views, as there is now
a separate page (Top 20 Queries) so it makes no sense anymore
to have this added to Tuning views.
- Added TNSPing call to main index page. This way you can see
how fast the connection to the given databases is.
- Cleanup of all PHP code to make it "release able". Fixed minor
HTML bugs and changed all includes to have the .php extension.
V1.32:
03-Dec-2004 - Fixed integer overflows in Show Tablespaces - Our biggest DB is
currently ~80GB in size and PHP ran into trouble and displayed
negative sizes :) Now all number values are treated as FLOAT
which allows sizes up to several TB without an overflow.
- Added new menuentry called Top 20 Queries. This view lists the
top queries sorted by DISK_READS_PER_EXEC. Allows to view the
detailed informations, too.
V1.31:
26-Nov-2004 - Updated DB class to v0.51.
- Added date and time display on DB Jobs page.
- Show Rollback segments now checks first if LATCH is available
(only from 9i upwards) and uses 'N/A' as output if not available.
- Changed index.php to display the list of available databases in
a better view
V1.30:
16-May-2004 - Added Process counter and max. allowed Processes to Process
overview.
28-Apr-2004 - Users page rewritten to use class. Added an icon below every
user entry to view details of that user (how many tables etc.)
Needs to be coded.
26-Apr-2004 - Rollback Segment page rewritten to use class. Also added two
queries to check for Undo Management in Oracle 9i+
25-Apr-2004 - RedoLog display and Tablespaces (+detail page) are rewritten
to use the class.
24-Apr-2004 - Process Infos + Detail page rewritten to use DB-Class.
Enhanced the display of SQL queries by selecting now all pieces
of strings at once instead of showing only the first piece as
previous versions did.
20-Apr-2004 - Complete DBInfo page rewritten to use DB-Class. Also changed all
tables to use css formatting only allowing to adapt the design
l8er.
19-Apr-2004 - Started rewrite to a) use only my oci8 class and b) add much
better GUI control and some other features. Currently only the
index pages are rewritten.
V1.24:
26-Apr-2003 - Complete Code-Cleanup, added error-handling to all OCI related
functions. HTML Code fixed to work correctly with CSS enabled
browsers.
V1.23:
14-May-2002 - Changed style sheets to be fully IE 6.x compliant.
- Removed all global variables during PHP v4.2.0
V1.22:
14-Apr-2002 - Fine-tuned all pages to use include files for common
things like header defs etc.
- Connect Datas are now in a seperate file instead of
including them directly in master include file. This
allows updating of OIS without destroying connect
datas.
- Added Shared Pool Memory usage to Memory overview.
- Added list of highly used queries with huge count
values indicating non-cacheable queries in Tuning
views.
- Added new page called Instance Statistics, this
will give you a very huge list of actual stats
for the current instance, including I/O usage etc.
- Made some cosmetical changes (Title tags, layout)
- Moved infos from All processes to Oracle Server
Informations. Will enhance the actual process
list l8er to try to catch more infos about the
session, SQL query etc.
-----------------------------------------------------------------------------
$Id: CHANGELOG,v 1.15 2009/09/22 20:11:37 siegel Exp $
Documentation generated on Tue, 22 Sep 2009 22:17:09 +0200 by phpDocumentor 1.4.2