Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 









Oracle Database Tips by Donald Burleson

Tour of the Source Code

Since this book is about PHP and Oracle, how are all those screens above written? Here is the first look at the directory containing the tool:

$ ls
access.php          RCS                        sql.html
alter_parameter.php  init.php               resource_limit.php   sql_info.php
csr2html.php              instance.html      schema_filter.php   
dba_helper.php         kill_session.php   security.php            
dba_helper.sql          lock_holders.php  session_info.php    
db_files.php              locks.html            sessions_cpu.php    
event_info.php          lock_waiters.php  sessions.php            
expensive_sql.php    login_form.php    sessions_reads.php   user_info.php
files.html                   main_menu.html  sessions_wait.php    
filestat.php                parameters.php    sessions_writes.php 
frames.html               plan_info.php       sga_stat.php

The tool is written as a bunch of HTML files, mostly menus, and PHP5 scripts.  Wherever it is possible, a single menu item corresponds to a single script. This architecture makes it easy to write new scripts or extend the old ones, if needed. What are the prerequisites to get this tool to work?  DBA_Helper depends on the following PHP modules:

  • PEAR HTML_Table

  • PEAR HTML Form

  • ADOdb

These three modules have to be installed if the tool is to function.  Because the ADOdb module can be installed in different places, there is a file called which contains only four rows:


This file has to be modified to reflect the place where ADOdb is installed.  It also turns off the time limitations for all scripts included in the DBA_Helper tool. PHP5 has a parameter, turned on by default, which limits the execution time of any script. This parameter is called max_execution_timeand defaults to 30 seconds. This value can be modified or completely eliminated for each script by using the set_time_limit function. This function, together with the accompanying php.ini parameter is further discussed in Chapter 8.

This feature is very useful because it ensures that there are no runaway scripts.  Whenever the limit is turned off, it must be done with full awareness of the possible consequences. If you want to limit the time allotted for a big database query, you can do so by modifying the set_time_limit line in  The argument is in seconds.  Occasionally, I modify this to 60 seconds.

See code depot for complete scripts

This is an excerpt from the book Easy Oracle PHP.  You can get it for more than 30% by buying it directly from the publisher and get instant HTML-DB scripts from the code depot:

Easy Oracle PHP
Create Dynamic Web Pages with Oracle Data

Includes online HTML-DB code depot

Buy it now for 30% off - Only $19.95

HTML-DB support:

For HTML-DB development support just call to gat an Oracle Certified professional for all HTML-DB development projects.



Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.