Mladen Gogala
This is my first ever home page so please, don't judge it too harshly. This page will, of course, be permanently under construction. I decided to create a home page on the advice of my publisher, Mr. Don Burleson of Rampant Books in 2006. I wrote a book about Oracle and PHP and it was published on Friday, August the 4th, 2006. More information about the book is available at Rampant Press website: Easy Oracle PHP. More recently, I also helped write another book, this time as a co-author: Pro PHP Programming. The second book was published on August the 15th, 2011 by Apress Publishing. The book covers very interesting topics like mobile computing, agile development, XML and unit testing. I sincerely hope that you will find it enjoyable and useful.
I am a long time Oracle DBA who started to work with Oracle RDBMS in 1989. At that time, I was introduced to Oracle version 4, on PC/XT. It is very hard to believe that Oracle instance used to fit in only 512 KB of memory. I worked with every major version of oracle RDBMS since then. During my lengthy career I performed all kinds of jobs, from COBOL programmer, VAX/VMS administrator and trainer to Unix system administrator. As a DBA, I have an ample opportunity to use various scripting languages like shell, Perl, PHP and awk.
On this page, I made available DBA_Helper, a small collection of PHP5 scripts organized in a convenient DBA tool for performing routine DBA functions. Initially, it was modeled after Andy Duncan's Orac_DBA tool written in Perl, but I decided not to create a single, monolithic script for ease of maintenance. Each line item in the tool is a separate script. That makes it easy to debug and extend the script as needed. DBA_Helper is released under GPL and you are welcome to extend it or modify in any way you find useful. If you have any modifications that you find useful and would like sharing them with others, please don't hesitate to send them to me and I'll publish them on this site. This site also contains two articles that I wrote for NYOUG and some "general purpose" articles written in response to the questions on the Oracle-L mailing list.
23-JAN-2009
- Ton of small changes and fixes added.
- Adding data files is now possible for the "normal" tablespaces.
- Searching archived logs by thread and sequence is now possible.
- The "time model" is replaced with the "session metric". Basic
performance indicators are shown for the session.
- Log files are now shown from V$LOG instead of GV$LOG
- Additional searching criteria enabled for both DBA jobs and
scheduler jobs.
- Fixed bug with the title of "Re-Create User" page.
- Select * from V$DATABASE added into the instance_info.php
- Invalid objects can now be searched by type, on only by the
owner.
- Version change to 1.0.26
16-MAY-2009
- Several major features added.
- Oracle TRCANLZR package can now be used to analyze the trace files.
It's a web version of TKPROF.
- Menu to manage groups has been added.
- Added the OS CPU load monitoring to the instance menu. It's querying
the GV$OSSTAT table. CPU load per instance is calculated as BUSY_TIME/
IDLE_TIME and displayed below the stats listing.`
- Added monitoring deltas from V$SESSMETRIC. V$SESSMETRIC table contains
the session indicators for a period of 1500 milliseconds. This is
extremely useful for monitoring sessions that is being the most active
right now.
- The items that were rarely used were removed from the Session Info mask.
- Session info mask now shows the session ID on top of the page to avoid
confusion when looking at 2 or more sessions.
- ER diagram is now shown and saved as a PNG image, not SVG. That should
make the output easier to handle, save and display.
- Added a rudimentary "Latches" screen to the lock menu. I used it to
to find out the latch referenced in V$SESSION_WAIT (by address).
- Version change to 1.0.27
25-JUN-2009
- Perl script that draws ER diagram for the given schema is added to
the website. It also uses GraphViz module and is convenient when
there is no need for the full blown GUI interface. This is,
essentially, a perl version of the PHP script which exists in the
DBA_Helper for some time now.
07-NOV-2009
- This is the first update since june. I returned back to the US on
30-Sep-2009 and was busy.
- LOB segment details are now shown in the "Segments" mask under the
"Free Space" report
- Scheduler jobs can now be enabled or disabled
- A nasty bug in "Grant Role" form was fixed. When no roles were present,
the "Revoke" screen was falling apart.
- Version change to 1.0.28
29-AUG-2011
- This is the first update since November 2009. The book I was writing is now
complete, this update is a long overdue.
- There are many functional changes and bug fixes.
- TRCANLZR no longer works, will fix it in the next few days. File name is not correctly generated.
- Version change to 1.0.29
- Also updated is dump2csv script. I also added dump2xml script, very similar in nature.
31-AUG-2011
- Added a paper with my experiences with PostgreSQL. I had an ambitions porting project which was eventually canceled. This is a summary of what I learned during the course of the project.
- Added PostgreSQL version of the famous SCOTT/TIGER tables.
06-12-2011
- Removed obsolete resume. Will update later.
The tool is a web based tool utilizing Apache web server and PHP5 to perform DBA functions on Oracle databases. PHP4 can not be used because the tool uses exceptions to handle errors and PHP4 does not support exceptions. The tool supports database version 9 and newer. It was tested with Oracle v9.2 and 10g. Prerequisites and screenshots are below.
Email: gogala.mladen@gmail.com
