Skip to Main Content
Oracle and Open Source
book

Oracle and Open Source

by Andy Duncan, Sean Hull
April 2001
Intermediate to advanced content levelIntermediate to advanced
432 pages
13h 2m
English
O'Reilly Media, Inc.
Content preview from Oracle and Open Source

Oracletool

Oracletool is a serious piece of weaponry in our Oracle and open source armory. This program is an excellent tool for maintaining Oracle databases. You can use it to help with performance tuning and to perform a variety of database administration functions. Oracletool provides a simple web-based interface to many of the day-to-day maintenance tasks a DBA needs to carry out in order to keep a typical database in good working order. And for those developers who can pluck a SELECT ANY TABLE privilege from the tight clutches of their DBA (good luck!), Oracletool is also a highly useful development utility.

Adam vonNieda first started work on Oracletool in 1997, and it had its first major release in March of 1999. Oracletool enjoys regular releases and maintains independence from any web server-specific modules. Written in Perl, it is completely CGI-driven and makes use of a number of great Perl modules, including Perl DBI and DBD::Oracle. Oracletool is a very straightforward program; its entire wealth of functionality is contained in a single CGI script. This implementation makes Oracletool easy to install and configure.

Oracletool provides a reasonable degree of security as a default, but it also gives you the ability to configure more rigorous security. You can choose your level of security based on your own site’s requirements. The faint of heart will be glad to hear that Oracletool does not modify your database. You can create a user with the SELECT ANY TABLE privilege ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Procure-to-Pay Guide

Oracle Procure-to-Pay Guide

Melanie Cameron
Expert Oracle Exadata

Expert Oracle Exadata

Kerry Osborne, Randy Johnson, Tanel Pöder
Expert PL/SQL Practices for Oracle Developers and DBAs

Expert PL/SQL Practices for Oracle Developers and DBAs

John Beresniewicz, Adrian Billington, Martin Büchi, Melanie Caffrey, Ron Crisco, Lewis Cunningham, Dominic Delmolino, Sue Harper, Torben Holm, Connor McDonald, Arup Nanda, Stephan Petit, Michael Rosenblum, Robyn Sands, Riyaj Shamsudeen
Achieving Extreme Performance with Oracle Exadata

Achieving Extreme Performance with Oracle Exadata

Rick Greenwald, Robert Stackowiak, Maqsood Alam, Mans Bhuller

Publisher Resources

ISBN: 0596000189Catalog PageErrata