Perl for Oracle DBAs

Chapter 3. Perl GUI Extensions

In Chapter 2, we looked at standard Perl and its database connectivity module, Perl DBI. The command-line interface available in Perl and Perl DBI has served developers well for many years. But over time, people have become more accustomed to graphical user interfaces (GUIs), and there has been a movement towards GUI facilities for Perl. Oracle DBAs in particular appreciate applications that give them an easy-to-use graphical interface for managing their databases and a way to visually inspect difficult-to-interpret database data. In this chapter we’ll look at Perl/Tk, an extensive GUI-based toolkit, as well as at a number of applications (many of them based on Perl/Tk) that provide Oracle DBAs with the graphical interfaces they find so useful. We’ll cover:

Perl/Tk

A popular toolkit often used to build GUIs in Perl for both Unix and Win32.

OraExplain

A Perl/Tk SQL tuning tool for Oracle that explains SQL execution plans. OraExplain was the first major canned application that combined Perl DBI and Perl/Tk for Oracle. It also inspired many other Perl/Tk applications.

StatsView

A statistics-gathering tool written in Perl/Tk for Oracle DBAs who also perform Unix system administration. This tool collects all kinds of useful statistics and then displays them in enhanced graphical format, courtesy of the gnuplot program.

Orac

A GUI wrapper program built using Perl/Tk that provides a useful way to maintain a repository of configurable SQL scripts for interrogating ...